Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.
What it is: Microsoft’s spreadsheet application used to clean and organize data.
What you'll learn: We start with the basics, showing you the user interface and quick ways to navigate. Once you’re comfortable with the software’s layout, we quickly move on to calculating data with basic formulas and functions. In the Intermediate section, we show you the various tools and ways to sort and filter data in a timely manner. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Advanced training starts with basic functions like the IF function. After that, we explore complex Database functions, provide an introduction to Macros, and show you how to save time by automating common Excel tasks.
- Introduction (0:59)
- Overview of List Design (3:45)
- Formatting Lists as Tables (1:58)
- Filtering Records from Lists or Tables (3:34)
- Removing Duplicates from Lists or Tables (3:21)
- Flash Fill (3:09)
- Single and Multi-Level Sorting (4:36)
- Inserting Automatic Subtotals in Lists (6:08)
- Inserting Data Charts Using Recommended Charts (4:52)
- Formatting and Editing Chart Elements (4:30)
- Creating and Applying Custom Chart Templates (3:39)
- Adding and Removing Data from Charts (2:45)
- Inserting Sparklines (5:28)
- Printing Charts (1:04)
- Inserting Pivot Tables (5:07)
- Filtering Pivot Tables (4:54)
- Using Report Layouts in Pivot Tables (3:06)
- Refreshing and Changing Source Data in Pivot Tables (4:15)
- Inserting Pivot Charts (1:57)
- Data Validation (4:54)
- Applying Built-In Conditional Formatting (3:13)
- Creating Custom Conditional Formats (2:57)
- Linking Data (4:18)
- Comments (2:14)
- Protection (3:45)