TOIT Training

Facebook X-twitter Linkedin Instagram
Menu
Microsoft Office 2019

Mastering Excel 2019 – Advanced

Overview
Curriculum

There are two kinds of people: Those who are masters at Excel 2019 or Excel 365, and those who wish they were  

When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course builds on your existing Excel knowledge and teaches you how to use links, Lookup functions, Data Validation, Macros, data tables, and more.    

This is our most requested training course!    If you are comfortable with using Excel for a variety of tasks, let our Microsoft Certified Trainer, Kathy Jones, walk you through more advanced topics that will take your spreadsheets to the next level and help you to be more efficient in analyzing your data. 

Curriculum

  • 7 Sections
  • 39 Lessons
  • 3h 58m Duration
Expand All
Getting Started
9 Lessons
  1. Introduction
  2. Navigating the Interface
  3. Selecting Data
  4. Using Commands
  5. Creating a New Workbook
  6. Entering Cell Data
  7. Using AutoFill
  8. Using Flash Fill
  9. Using Excel Help
Performing Calculations
4 Lessons
  1. Creating Formulas
  2. Inserting Functions
  3. Copying Formulas and Functions
  4. Using Absolute References
Modifying Worksheets
3 Lessons
  1. Inserting and Deleting Cells
  2. Searching and Replacing
  3. Using Proofing and Researching Tools
Formatting Worksheets
9 Lessons
  1. Applying Text Formats
  2. Applying Number Formats
  3. Customizing Number Formats
  4. Aligning Cell Contents
  5. Applying Cell Styles
  6. Applying Themes
  7. Inserting Hyperlinks
  8. Applying Comparative Analysis Formatting
  9. Using Templates
Printing Workbooks
5 Lessons
  1. Printing Workbooks
  2. Setting the Page Layout
  3. Inserting Page Breaks
  4. Configuring Headers and Footers, Part 1
  5. Configuring Headers and Footers, Part 2
Managing Workbooks
6 Lessons
  1. Managing Worksheets, Part 1
  2. Managing Worksheets, Part 2
  3. Creating a Custom View
  4. Managing Worksheet Views
  5. Managing Workbook Views
  6. Managing Workbook Properties
Customizing Options
3 Lessons
  1. Customizing General Options
  2. Customizing the Ribbon
  3. Customizing the Quick Access Toolbar

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Buy for group

Mastering Excel 2019 – Advanced
No groups Found

You don't have any groups yet

Create a group and add group members. Sync Group(s)
Choose Group(s)
Sync Group(s)
    Create a new group Go to Checkout