Mastering Excel 2019 – Advanced

ToIT

0 (0)

Duration

3h 58m

Students

Last Updated

December 13, 2024

Overview
Curriculum
Reviews

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.

7 Sections
39 Lessons
3h 58m Duration

Expand All

Getting Started

9 Lessons

Introduction
Navigating the Interface
Selecting Data
Using Commands
Creating a New Workbook
Entering Cell Data
Using AutoFill
Using Flash Fill
Using Excel Help

Performing Calculations

4 Lessons

Creating Formulas
Inserting Functions
Copying Formulas and Functions
Using Absolute References

Modifying Worksheets

3 Lessons

Inserting and Deleting Cells
Searching and Replacing
Using Proofing and Researching Tools

Formatting Worksheets

9 Lessons

Applying Text Formats
Applying Number Formats
Customizing Number Formats
Aligning Cell Contents
Applying Cell Styles
Applying Themes
Inserting Hyperlinks
Applying Comparative Analysis Formatting
Using Templates

Printing Workbooks

5 Lessons

Printing Workbooks
Setting the Page Layout
Inserting Page Breaks
Configuring Headers and Footers, Part 1
Configuring Headers and Footers, Part 2

Managing Workbooks

6 Lessons

Managing Worksheets, Part 1
Managing Worksheets, Part 2
Creating a Custom View
Managing Worksheet Views
Managing Workbook Views
Managing Workbook Properties

Customizing Options

3 Lessons

Customizing General Options
Customizing the Ribbon
Customizing the Quick Access Toolbar

0

0 Ratings

5 Star 0%

4 Star 0%

3 Star 0%

2 Star 0%

1 Star 0%

Reviews

Free

Start Course

Course Includes

Linking cells and consolidating data
Sharing and protecting worksheets
Automating data validation and tasks
Using Lookup functions
Auditing formulas
Forecasting data
Creating geographic visuals like Map Charts and 3D Map Tours
Importing and exporting data
Creating a Web Query
Working with Forms and ActiveX controls