Enrollment Options:

1. Introduction to Microsoft Excel 2019
   1. Excel Basics
   2. Creating a Worksheet
   3. Time-Savers
   4. Relative, Absolute, Mixed, and Circular References
   5. Three-Dimensional Workbooks
   6. Sorting, Subtotaling, and Filtering
   7. Charting Basics
   8. Advanced Charting Techniques
   9. Intro to Excel's Statistical Functions
   10. Financial Functions
   11. Worksheet Automation
   12. Mastering Excel's IF Function
2. Intermediate Microsoft Excel 2019
   1. Excel Charts and Graphs
   2. More Excel Charts
   3. AutoFilter and Sorting
   4. Goal Seeking
   5. Pivot Tables
   6. Advanced PivotTables
   7. Solver
   8. Sparklines
   9. Macros
   10. Introduction to Functions
   11. Math/Trig Functions
   12. VLOOKUP, INDEX, and MATCH Functions
3. Advanced Microsoft Excel 2019
   1. Customizing Excel
   2. Table Management
   3. Data Validation
   4. Custom Controls
   5. Conditional Formatting
   6. Consolidating and Outlining
   7. Excel Functions and Nesting
   8. Import External Data
   9. Data Tables
   10. What-If Analysis Tools
   11. Advanced PivotTables
   12. Analysis ToolPak, Advanced Filter, Array Formulas, and More!
4. Introduction to Microsoft Project 2019/Office 365
   1. Overview of Microsoft Project
   2. Creating a Solid Foundation
   3. Creating and Managing Resources
   4. Defining and Assigning Costs
   5. Project Templates, Security, and Constraints
   6. Working With Views and Managing Information
   7. Fine-Tuning Your Project Plan
   8. Baselines and Tracking
   9. Managing Variances
   10. Closing Your Project
   11. Printing Views
   12. Using and Creating Reports