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.
|Lesson 1 Quiz||10|
|Lesson 2 Quiz||10|
|Lesson 3 Quiz||10|
|Lesson 4 Quiz||10|
|Lesson 5 Quiz||10|
|Lesson 6 Quiz||10|
|Lesson 7 Quiz||10|
|Lesson 8 Quiz||10|
|Lesson 9 Quiz||10|
|Lesson 10 Quiz||10|
|Lesson 11 Quiz||10|
|Lesson 12 Quiz||9|
|Lesson 13 Quiz||10|
|Lesson 14 Quiz||10|
|Lesson 15 Quiz||9|
|The Final Exam||77|
- How to Create Data Lists in Excel 2019
- How to Add and Edit Images, Graphics, and TextBoxes in Excel 2019
- What Can You Do With Microsoft Excel 2019?
- The Most Useful And Overlooked Functions in Excel 2019
- Using the What-If Analysis in Excel 2019
- Animation Developments Using jQuery
- Using INNER and OUTER JOINs in SQL
- How to Use Data Lookups in Excel 2019
- A Closer Look at Event Handling in jQuery
- Using The Messages App in OS X Yosemite
- Using Stored Procedures in SQL
- How to Use the Analysis ToolPak in Excel 2019
- How to Restore and Backup MySQL Databases
- Understanding Security in OS X Yosemite
- What are Transactions in SQL?