Online Class: Excel 2019

no certificate
with CEU Certificate*
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
- 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.
Assessment Guide
Assessment | Points |
---|---|
My Excel Experience | 1 |
Lesson 1 Quiz | 9 |
Lesson 2 Quiz | 9 |
Lesson 3 Activity Assignment | 1 |
Lesson 3 Quiz | 10 |
Lesson 4 Activity Assignment | 1 |
Lesson 4 Quiz | 10 |
Lesson 5 Activity Assignment | 1 |
Lesson 5 Quiz | 10 |
Lesson 6 Activity Assignment | 1 |
Lesson 6 Quiz | 10 |
Lesson 7 Activity Assignment | 1 |
Lesson 7 Quiz | 10 |
Lesson 8 Activity Assignment | 1 |
Lesson 8 Quiz | 10 |
Lesson 9 Activity Assignment | 1 |
Lesson 9 Quiz | 10 |
Lesson 10 Activity Assignment | 1 |
Lesson 10 Quiz | 10 |
Lesson 11 Activity Assignment | 1 |
Lesson 11 Quiz | 10 |
Lesson 12 Quiz | 9 |
Lesson 13 Activity Assignment | 1 |
Lesson 13 Quiz | 10 |
Lesson 14 Quiz | 10 |
Lesson 15 Quiz | 9 |
The Final Exam | 70 |
Total Points: | 227 |
Related Articles
- What Can You Do With Microsoft Excel 2019?
- How to Create Data Lists in Excel 2019
- How to Create Pivot Tables and Pivot Charts in Excel 2019
- How to Sort and Filter Data in Excel 2019
- How to Create Formulas, Functions, and Do Calculations in Excel 2019
- Tables, Databases, and SQL...oh my!
- How to Create Tables with HTML5
- How to Use the IF Function in Excel 2019
- Working with Objects in PowerPoint 2019
- Understanding Documents and Pages in Word 2019
- How to Set Out of Office Messages in Outlook 2019
- Using Mathematical Functions in Excel 2019
- User Agent Values in jQuery
- Understanding HTML5 and Web Design
- Adding Transitions and Animation to PowerPoint 2019 Presentations