Course Syllabus: Excel 2019

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.

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

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

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

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.

By successfully completing this course, students will be able to: