How Do You Contact an Excel User??

'u' column

Folks, we bring the jokes and the data tutorials.

JK, this is probably as funny as it gets, but we do cover a lot of different Excel functions so that you can feel real confident in your skills.

Basics

DBD DK Text to Columns Intro.png

Play Button.png

Text to Columns

DBD LA Excel Right Left.png

Play Button.png

Right, Left, and Mid Formulas

DBD LA Excel Pivot Tables.png

Play Button.png

Pivot Tables Basics

DBD LA Excel Today.png

Play Button.png

Today and Now Formulas

DBD LA Excel Trim.png

Play Button.png

Trim Formula

DBD CR Excel Intro.png

Play Button.png

Concatenate Formula

DBD PW Intro Excel Formatting.png

Play Button.png

Conditional Formatting

Excel Paste Special Options Slides.png

Play Button.png

Paste Special Options

Excel Paste Special Options Slides.png

Play Button.png

Freeze Panes

Advanced

Copy of DBD SPSS Outline.png

Play Button.png

Index Match Formulas

DBD CR Vlookup.png

Play Button.png

Vlookup Formula

DBD DK Pivot Intro.png

Play Button.png

Pivot Tables Part 2

_DBD PW Intro.png

Play Button.png

Sumifs Formula

VBA

DBD RF VBA Intro.png

Play Button.png

VBA in Excel - Get Started

DBD LF VBA Record Macros.png

Play Button.png

VBA Record Macros

DBD LF VBA Excel to PPT.png

Play Button.png

VBA Excel to Powerpoint

Now what to do with those spreadsheets... Put them into a visualization tool, like Tableau. Let's do this.