Universal Class: Over 500 Online Certificate Courses

Course Syllabus: Advanced Excel 2019

Microsoft Excel Courses Picture
no certificate
- OR -
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.

Course Description

Excel is one of the most powerful tools in Microsoft Office. You can import, query, analyze and manipulate data to create powerful reports that can be used by individuals and enterprise businesses alike. This course explores some of the more advanced features of Microsoft Excel to give you a more powerful experience when you need the most out of spreadsheet software.

The course starts with functions and data lookups, as these components of Excel help the spreadsheet creator with advanced calculations and import functionality. It then covers conditional formatting for highlighting important cells based off of conditions. Sparklines are also covered so that the reader can get a quick data visualization of the information stored in each worksheet.

Pivot tables are one of the most beneficial tools in Excel, and this course covers pivot tables both basic and advanced features. It then moves on to pivot charts, which are graphs that can be used with pivot table data.

Analysis tools are some of the most advanced and useful to users that want to run complex reports on data. Excel has three What-If analysis tools that can be run on data and provide reports on goals that give answers to your problems. The Solver and Analysis Toolpak are two add-ins that expand on these tools, and they are covered in this course.

The final lessons cover data validation, troubleshooting, querying data and macros. These chapters provide ways to work with data and clean up unstructured information. This course fully covers advanced features in Excel so that you can create complex spreadsheets for business or individual use.

Course Requirements

This course will not require you to have previous experience in any particular area but you should have a high school reading level. No books will be required

Course Topics

Lesson 1: Outlines, Custom Views, and Templates

Lesson 2: Mathematical Functions

Lesson 3: Data Functions

Lesson 4: Data Lookups

Lesson 5: The IF Function

Lesson 6: Manipulating Text

Lesson 7: Exploring Conditional Formatting

Lesson 8: Working with Sparklines

Lesson 9: Linking To and Consolidating Worksheets

Lesson 10: Importing and Cleaning Data

Lesson 11: Pivot Tables

Lesson 12: Continuing to Work with Pivot Tables

Lesson 13: Pivot Charts

Lesson 14: The What-if Analyses

Lesson 15: Goal Seek and Solver

Lesson 16: The Analysis ToolPak

Lesson 17: All About Data Validation

Lesson 18: Using Get & Transform to Perform Queries

Lesson 19: Troubleshooting and Auditing in Excel 2019

Lesson 20: Exploring Macros in Excel 2019

Course Materials

This course will not require you to have previous experience in any particular area but you should have a high school reading level. No books will be required

Grading Policy

Each lesson will include a lesson review quiz. Students will successfully complete this course by mastering all learning outcomes with 70% or higher overall grade.

Learning Outcomes

By successfully completing this course, students will be able to:
  • Demonstrate working with outlines, custom views, and templates in Excel 2019.
  • Demonstrate using mathematical functions.
  • Demonstrate using data functions, data lookups, and the IF function.
  • Demonstrate using conditional formatting.
  • Demonstrate working Sparklines.
  • Demonstrate linking to and consolidating worksheets.
  • Describe importing and cleaning data.
  • Demonstrate creating and using Pivot Tables and Pivot Charts.
  • Demonstrate creating and using the What-if Analyses.
  • Demonstrate creating and using the Goal Seek and Solver.
  • Demonstrate creating and using the the Analysis ToolPak.
  • Demonstrate creating and using the using get & transform to perform queries, and
  • Demonstrate mastery of lesson content at levels of 70% or higher.

Assessment Guide

Assessment Points
My Excel Experience1
Lesson 1 Exam9
Lesson 2 Activity Assignment1
Lesson 2 Exam10
Lesson 3 Activity Assignment1
Lesson 3 Exam10
Lesson 4 Activity Assignment1
Lesson 4 Exam10
Lesson 5 Activity Assignment1
Lesson 5 Exam10
Lesson 6 Activity Assignment1
Lesson 6 Exam10
Lesson 7 Activity Assignment1
Lesson 7 Exam10
Lesson 8 Activity Assignment1
Lesson 8 Exam10
Lesson 9 Activity Assignment1
Lesson 9 Exam10
Lesson 10 Activity Assignment1
Lesson 10 Exam10
Lesson 11 Activity Assignment1
Lesson 11 Exam10
Lesson 12 Exam10
Lesson 13 Activity Assignment1
Lesson 13 Exam10
Lesson 14 Exam10
Lesson 15 Activity Assignment1
Lesson 15 Exam10
Lesson 16 Exam9
Lesson 17 Activity Assignment1
Lesson 17 Exam10
Lesson 18 Exam10
Lesson 19 Exam9
Lesson 20 Activity Assignment1
Lesson 20 Exam10
The Final Exam75
Total Points:287

Related Articles

Follow Us Online
  • Follow us on FaceBook Follow us on Twitter Follow us on YouTube
© Copyright 1999-2020 Universal Class™ All rights reserved.