Microsoft Excel Advanced 2019 Online Course
Take your Excel skills to the next level with this comprehensive 9-hour, expert-led video training. This course goes beyond the fundamentals to provide a deep dive into advanced Excel functions, focusing on high-level data consolidation, financial analysis, and reporting techniques.
By the end of the course, you’ll be equipped to create impactful charts and visuals, transforming data and financial records into clear, effective communications. You’ll learn to present data using a variety of formats—including tables, graphs, and PivotTables—enhancing both the clarity and professionalism of your reports.
This advanced training will significantly boost your Excel proficiency and elevate your effectiveness in any data-driven role.
Course Curriculum
1. Excel 2019: Introduction
2. Excel 2019 Beginner: Creating Workbooks
3. Excel 2019 Beginner: Saving Workbooks
4. Excel 2019 Beginner: Navigating Workbooks
5. Excel 2019 Beginner: Page Setup and Print Options
6. Excel 2019 Beginners: Working with Rows, Columns, and Cells
7. Excel 2019 Beginners: Moving Data
8. Excel 2019 Beginners: Formulas and Functions
9. Excel 2019 Beginners: Working with Sheets
10. Excel 2019 Beginners: Formatting Worksheets
11. Excel 2019 Beginners: Charts
12. Excel 2019 Beginners: Working with Names
13. Excel 2019 Beginners: Sorting and Filtering
14. Excel 2019 Beginners: Outlining and Subtotaling
15. Excel 2019 Beginners: Working with Views
16. Excel 2019 Beginners: Linking Files
17. Excel 2019 Beginners: Advanced Formula Creation
18. Excel 2019 Beginners: PivotTables
19. Excel 2019 Beginners: Additional Excel Features
20. Excel 2019 Beginners: Shortcuts
21. Excel 2019 Beginners: Closing
22. Excel 2019 Advanced: Introduction to Advanced Course
23. Excel 2019 Advanced: Functions
24. Excel 2019 Advanced: Date and Time Functions
25. Excel 2019 Advanced: Text Functions
26. Excel 2019 Advanced: Logical Functions
27. Excel 2019 Advanced: Lookup Functions
28. Excel 2019 Advanced: Financial Functions
29. Excel 2019 Advanced: Statistical Functions
30. Excel 2019 Advanced: Connecting to External Data
31. Excel 2019 Advanced: Tables
32. Excel 2019 Advanced: PivotTables
33. Excel 2019 Advanced: Data Analysis
34. Excel 2019 Advanced: Graphs and Charts
35. Excel 2019 Advanced: Excel Web App
36. Excel 2019 Advanced: Course Conclusion