Excel Business Course

Unlock the power of Excel in the workplace with this beginner-to-intermediate class, designed specifically for managers and employees to master the essential skills needed for day-to-day tasks. In this video course, you'll learn over 70 practical Excel techniques through hands-on exercises, focusing on tasks like budgeting, data tracking, and project and progress tracking. You’ll gain the skills to efficiently organize and analyze data, create professional reports, and you'll do so with confidence—helping you make smarter, data-driven decisions. As you move through the course, you’ll build a strong foundation of Excel skills, ensuring you’re well-prepared to tackle routine office tasks with ease. From automating repetitive tasks to building charts and managing large datasets, this self-paced class will boost your productivity and help you excel in your role. Become the go-to Excel expert at your workplace today!

The syllabus

5 Chapters · 44 Lessons

1
Chapter 1 Excel Basics
1. (Included in full purchase)
  Welcome
2. (Included in full purchase)
  The Survival Guide Course Workbook
3. (Included in full purchase)
  1. Ribbon basics
4. (Included in full purchase)
  2. Cell reference and cell address
5. (Included in full purchase)
  3. Making it look pretty with formatting
2
Chapter 2 Order Management
1. (Included in full purchase)
  1. Custom number format
2. (Included in full purchase)
  2. Math functions
3. (Included in full purchase)
  3. Data validation drop downs and list
4. (Included in full purchase)
  4. Conditional formatting
5. (Included in full purchase)
  5. Sort and custom sort
6. (Included in full purchase)
  6. Filter
7. (Included in full purchase)
  7. Moving columns and other options
8. (Included in full purchase)
  8. PivotTables
9. (Included in full purchase)
  9. VLOOKUP and XLOOKUP
10. (Included in full purchase)
  10. Tables
11. (Included in full purchase)
  11. Sumif
12. (Included in full purchase)
  12. Join cells
13. (Included in full purchase)
  13. IF, OR, AND statements
14. (Included in full purchase)
  14. Freeze panes
15. (Included in full purchase)
  15. Slicers
16. (Included in full purchase)
  Chapter 2 Supplemental Reading
3
Chapter 3 Budget
1. (Included in full purchase)
  1. Fill right and down
2. (Included in full purchase)
  2. Alignment
3. (Included in full purchase)
  3. Date and number formatting
4. (Included in full purchase)
  4. More math functions
5. (Included in full purchase)
  5. Sparklines
6. (Included in full purchase)
  6. Rounding and decimals
7. (Included in full purchase)
  7. Duplicates
8. (Included in full purchase)
  8. IFERROR
9. (Included in full purchase)
  9. Macros
10. (Included in full purchase)
  Chapter 3 Supplemental Reading
4
Chapter 4 Projects
1. (Included in full purchase)
  1. Checkboxes and countif
2. (Included in full purchase)
  2. Progress bar and COUNTA
3. (Included in full purchase)
  3. Conditional formatting continued
4. (Included in full purchase)
  4. Pie Chart
5. (Included in full purchase)
  5. Charts
6. (Included in full purchase)
  6. Merge and center vs. center across selection
7. (Included in full purchase)
  7. Protect
8. (Included in full purchase)
  8. Removing blank rows
9. (Included in full purchase)
  Chapter 4 Supplemental Reading
5
Chapter 5 Fun Extras for Work
1. (Included in full purchase)
  Work day calendar list
2. (Included in full purchase)
  Excel form
3. (Included in full purchase)
  Chart types
4. (Included in full purchase)
  Excel Survival Guide Final Quiz

Don't feel like you're barely surviving with Excel anymore, thrive instead

The syllabus

Chapter 1 Excel Basics

Chapter 2 Order Management

Chapter 3 Budget

Chapter 4 Projects

Chapter 5 Fun Extras for Work