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