Microsoft Excel 2019 Series

Details

Introduction to Microsoft Excel 2019

This course focuses on the fundamentals of Excel 2019. You will first learn how to quickly and efficiently create fully formatted worksheets. You will then learn common formulas and functions, sorting and analyzing data, custom charts and graphs, and how to create three-dimensional workbooks. This course also introduces you to Quick Analysis, Flash Fill, and other powerful charting tools, which are further explored in the intermediate course.

Intermediate Microsoft Excel 2019

This course builds on the fundamental techniques you learned in the introductory Excel 2019 course. You will master charting and then learn more of Excel's time-saving features like PivotTables, Slicers, and Sparklines. You will learn how to harness the power of Excel's data analysis tools and AutoFilter commands to create macros that eliminate repetitive tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire.

Advanced Microsoft Excel 2019

This course will help you make the most of your investment in Microsoft Excel 2019. You will master advanced features that most users don't even know exist, such as scenarios and data tables to perform what-if data analysis. You will learn advanced techniques for PivotTables, conditional formatting to highlight duplicate entries, and importing external data using Excel's built-in Power Query tool. By the time you finish this course, you will know all the possible features and function of Microsoft's powerful spreadsheet software.

Series bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Series bundles.

Enrollment Options:

Instructor-Led
6 Weeks Access Course Code: B9404
Start Dates* Dec 18 | Jan 10 | Feb 07 | Mar 06
*Choose start date in cart

$390.00

USD

Enroll before 31th May and get high quality lamination on your hardcopy certificate absolutely free! Use your certificate to your advantage by showing your certified credentials to prospective employers and recruiters.

Trustpilot

Syllabus

  1. Introduction to Microsoft Excel 2019
    1. Excel Basics
    2. Creating a Worksheet
    3. Time-Savers
    4. Relative, Absolute, Mixed, and Circular References
    5. 3-Dimensional Workbooks
    6. Sorting, Subtotaling, and Filtering
    7. Charting Basics
    8. Advanced Charting Techniques
    9. Intro to Excel's Statistical Functions
    10. Financial Functions
    11. Worksheet Automation
    12. Mastering Excel's IF Function
  2. Intermediate Microsoft Excel 2019
    1. Excel Charts and Graphs
    2. More Excel Charts
    3. AutoFilter and Sorting
    4. Goal Seeking
    5. PivotTables
    6. Advanced PivotTables
    7. Solver
    8. Sparklines
    9. Macros
    10. Introduction to Functions
    11. Math/Trig Functions
    12. VLOOKUP, INDEX, and MATCH Functions
  3. Advanced Microsoft Excel 2019
    1. Customizing Excel
    2. Table Management
    3. Data Validation
    4. Custom Controls
    5. Conditional Formatting
    6. Consolidating and Outlining
    7. Excel Functions and Nesting
    8. Import External Data
    9. Data Tables
    10. What-If Analysis Tools
    11. Advanced PivotTables
    12. Analysis ToolPak, Advanced Filter, Array Formulas, and More!

Requirements

Hardware Requirements:

  • This course can be taken on either a PC or Mac.

Software Requirements:

  • PC: Windows 8 or newer.
  • Mac: OS X Snow Leopard 10.6 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.

Other:

  • Email capabilities and access to a personal email account.

Prerequisites

There are no prerequisites to take this course.

Instructor

Chad Wambolt

Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $5 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.

Reviews

About ExpertRating

ExpertRating is an ISO 9001:2015 certified company offering online certification and training services to individuals and companies globally. Over 25 million people have benefited from ExpertRating Online Certifications and assessments. ExpertRating is the winner of the Google SME Hero's award for showing outstanding use of technology in delivering trusted services to thousands of people on a daily basis. Our affordable certifications are an excellent way of demonstrating your knowledge and skills to prospective employers as well as vastly boosting your chances of moving ahead in your business or career.

Company Timeline

Since 2001

Decades of excellence

800+ Skill Tests

World’s largest test inventory

2500+ Companies

Thousands depend on use

25 Million People Tested

10 tests every minute

35 Countries Serviced

Over 1500 clients in the US

86% Reorder Rate

Satisfied clients

We deliver over 3 million online certification tests and online courses annually.

Awards

ExpertRating is a winner of the Google SME Heroes award. This award has been instituted by Google to honor IT companies that have excelled in their domain and have leveraged the internet to grow and expand their businesses in innovative ways.


ExpertRating is an ISO 9001:2015 certified company, which reflects that our courses and tests conform to the highest international quality standards. Our training material is prepared by thorough professionals with years of experience, and goes through several rounds of analysis by expert teams to help develop well-balanced, comprehensive and meaningful content.


SITE LINKS
ExpertRating Solutions

280 Madison Avenue, 912 - 9th Floor New York, NY 10016 US

Copyright © 1997 - 2021 All rights reserved. The material on this site cannot be reproduced or redistributed unless you have obtained prior written permission from ExpertRating Solutions.
.