Microsoft Excel Advanced 2019 Online Course
Microsoft Excel Advanced 2019 Training Course
Get beyond the basics and supercharge your current skill level in Excel. With this 9-hour, expert-led video training course, you’ll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information.
Upon completion of this course, you'll be able to create charts that have an impact from databases that communicate data and financial records efficiently and effectively.
You will be able to report data in various formats including: tables, graphs and PivotTables. Once completed you'll have advanced understanding of Excel that will positively impact your professional capability.
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
