Course Syllabus: Excel 2019
with CEU Certificate*
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.
|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||73|
- How to Create and Edit Beautiful Charts and Diagrams in Excel 2019
- How to Format Cells and Data in Excel 2019
- Using the What-If Analysis in Excel 2019
- The Most Useful And Overlooked Functions in Excel 2019
- What Can You Do With Microsoft Excel 2019?
- How to Create VIEWs in SQL
- How to Import and Clean Your Data in Excel 2019
- Understanding HTML5 and Web Design
- Make Your Spreadsheets Pop with Sparklines in Excel 2019
- Marketing Strategies that Use Google+ Effectively
- How to Use Pivot Charts Effectively in Excel 2019
- What are Transactions in SQL?
- How to Use the IF Function in Excel 2019
- Understanding Notifications in OS X Yosemite
- Understanding the Basics SQL