Microsoft Excel 2019
About this course
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.
Course Outline
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 AbsoluteReferences
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 andWorkbooks
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 newrule
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