Overview
Microsoft Excel is the most popular spreadsheet application for both personal and professional use, so staying on top of the latest version is very important for anyone considering career advancement. Regardless of your level of understanding, you will benefit from this Microsoft Excel 2019 training course because it covers basic, intermediate and advanced topics.
Our Microsoft Excel 2019 training course will help arm you with the knowledge to use it more effectively whether you are using it at home or in the workplace. Understand how to manipulate data within a spreadsheet, validate and present information using the built-in structure and functions of Microsoft Excel.
Curriculum
Module 1: Beginner
1. Intro
2. The Ribbon
3. Saving Files
4. Entering and Formatting Data
5. Printing from Excel & Using Page Layout View
6. Formulas Explained
7. Working with Formulas and Absolute References
8. Specifying and Using Named Range
9. Correct a Formula Error
10. What is a Function
11. Insert Function & Formula Builder
12. How to Use a Function – AUTOSUM, COUNT, AVERAGE
13. Create and Customize Charts
Module 2: Intermediate
1. Recap
2. Navigating and editing in two or more worksheets
3. View Options – Split Screen, View Multiple Windows
4. Moving or Copying Worksheets to Another Workbook
5. Create a Link Between Two Worksheets and Workbooks
6. Creating Summary Worksheets
7. Freezing Cells
8. Add a Hyperlink to Another Document
9. Filters
10. Grouping ad Ungrouping Data
11. Creating and Customizing All Different Kinds of Charts
12. Adding Graphics and Using Page Layout to Create Visually Appealing Pages
13. Using Sparkline Formatting
14. Converting Tabular Data to an Excel Table
15. Using Structured References
16. Applying Data Validation to Cells
17. Comments – Add, Review, Edit
18. Locating Errors
Module 3: Advanced
1. Recap
2. Conditional (IF) Functions
3. Nested Condition Formulas
4. Date and Time Functions
5. Logical Functions
6. Informational Functions
7. VLOOKUP & HLOOKUP
8. Custom Drop Down Lists
9. Create Outline of Data
10. Convert Text to Columns
11. Protecting the Integrity of the Data
12. What is it, how we use it and how to create a new rule
13. Clear Conditional Formatting & Themes
14. What is a Pivot Table and Why Do We Want One
15. Create and Modify Data in a Pivot Table
16. Formatting and Deleting a Pivot Table
17. Create and Modify Pivot Charts
18. Customize Pivot Charts
19. Pivot Charts and Data Analysis
20. What Is It and What Do We Use It For
21. Scenarios
22. Goal Seek
23. Running Preinstalled Macros
24. Recording and Assigning a New Macro
25. Save a Workbook to be Macro Enabled
26. Create a d Simple Macro with Visual Basics for Applications (VBA)
27. Outro
Zahara –
The course was flexible, allowing me to access the materials anytime and from any device.
Nontobeko –
Your course is top-notch. Thank you for the outstanding learning experience!
Elijah –
The course had a logical progression, building on previous concepts and gradually increasing difficulty.
Sanaa –
The course helped me develop a solid foundation in the subject matter, even as a beginner.
Charlotte –
Best course I have ever done!