Universal Class: Over 500 Online Certificate Courses
 

Course Syllabus: Excel 2019


Microsoft Training Picture
$50.00
no certificate
- OR -
$75.00
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.
 
 

Course Description

Microsoft Excel 2019 is the latest iteration of the popular spreadsheet software. Excel allows users to create rich applications used for charting, storing data, and creating visual content that represents your data. Before you get started with Excel and create your spreadsheets, you should know how to use features in Excel that will make it easy to work with the data that you store.

The first few lessons explain how to use Excl and use its basic formatting rules and techniques. We then move on to formulas. Formulas are the foundation for most basic and complex spreadsheets that store data and calculate results based on thousands of rows and dozens of columns. You can use these formulas and then move on to scenarios, pivot tables and what-if charts. These features provide you with a more advanced tools that track your reports and create projections for your business.

Most Excel spreadsheets have at least one chart included, so we have tutorials on using graphs and images. These added components help make spreadsheets more visually appealing. We also include ways to use common functions. We include ways to sort and filter data, so you can view large data sets in chronological, alphabetical or numerical order.

The final lesson covers the basics of Visual Basic for Applications (VBA).  VBA is a language used to make macros using the Visual Basic language. We show you how to create simple recorded macros and macros created for complex applications. After you read through this course, you are ready to get started with Microsoft Excel 2019 for individual or business 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 - Introduction to Microsoft Excel 2018

Lesson 2 - Worksheets and Workbooks

Lesson 3 - Formatting Cells and Data

Lesson 4 - Editing Worksheets and Cells

Lesson 5 - Introduction to Formulas

Lesson 6 - Creating a What-If Analysis

Lesson 7 - Adding Images and Graphics

Lesson 8 - Charts and Diagrams

Lesson 9 - Creating Data Lists

Lesson 10 - Pivot Tables and Charts

Lesson 11 - Templates and Macros

Lesson 12 - Retrieving External Data

Lesson 13 - Sorting and Filtering

Lesson 14 - Common Useful Functions

Lesson 15 - Introduction to VBA

Course Materials

All course material will be provided in the lessons and netlinks. There are no required materials to purchase before taking the class.

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:
  • Describe what a spreadsheet is and what Excel's capabilities are.
  • Demonstrate working with worksheets, workbooks and entering data in Excel.
  • Demonstrate formatting cells and data.
  • Demonstrate using formulas and calculations in Excel.
  • Demonstrate creating and using What-If Analysis tool.
  • Demonstrate adding images and graphics.
  • Demonstrate creating charts and diagrams.
  • Demonstrate creating data lists and managing data.
  • Demonstrate creating and using Pivot Tables and Charts.
  • Describe techniques for sorting and filtering data, and
  • Demonstrate mastery of lesson content at levels of 70% or higher.
Show More
 

Assessment Guide

My Excel Experience1
Lesson 1 Quiz9
Lesson 2 Quiz9
Lesson 3 Activity Assignment1
Lesson 3 Quiz10
Lesson 4 Activity Assignment1
Lesson 4 Quiz10
Lesson 5 Activity Assignment1
Lesson 5 Quiz10
Lesson 6 Activity Assignment1
Lesson 6 Quiz10
Lesson 7 Activity Assignment1
Lesson 7 Quiz10
Lesson 8 Activity Assignment1
Lesson 8 Quiz10
Lesson 9 Activity Assignment1
Lesson 9 Quiz10
Lesson 10 Activity Assignment1
Lesson 10 Quiz10
Lesson 11 Activity Assignment1
Lesson 11 Quiz10
Lesson 12 Quiz9
Lesson 13 Activity Assignment1
Lesson 13 Quiz10
Lesson 14 Quiz10
Lesson 15 Quiz9
The Final Exam75
Total Points:232
Show More

Related Articles