Excel: You Can Do This

Quickly gain confidence with the most intimidating features in Excel. Unlock the power of VLOOKUP, PivotTables, Flash Fill, Conditional Formatting, and more.

1. Excel: You Can Do This

• Flash Fill: Merge data in different cells
• Linking sheets
• Copying, coloring, and naming tabs
• SUM: Calculating a basic sum
• Freeze panes: See your data while scrolling
• Conditional formatting
• Data validation: Ensure users don't input crazy data
• Create a drop-down list
• Create basic charts from scratch
• Split text in Power Query: Split real-world data fields
• IF statement
• COUNTIFS: Count entries based on conditions
• The #N/A error: What does it mean and what causes it?
• VLOOKUP