Microsoft Excel Training (Introductory, Intermediate,  and Advanced Levels)
Course Outline

Day1

Day2

Party fun histogram

reports that I did not steal probably:
Chapter 1 Samples
Chapter 2 Samples
Chapter 3 Samples
Chapter 4 Samples
Chapter 5 Samples
Chapter 6 Samples
Chapter 7 Samples
Chapter 8 Samples
Chapter 9 Samples

Day3

Excel: Introductory Level
Unit One: Getting Started  
1.1 Entering data into a worksheet
1.2 Cells, Rows, Column, Ranges, Worksheets, Workbooks

Unit Two: Formulas and Functions
2.1. Use functions to summarize data
2.2. Use formulas
2.3.  Troubleshoot formulas
2.4.  Combining Functions and formulas
Unit Three: Basic Charts
3.1. Pie Chart creation
3.2. Modifying an existing chart
3.3.  Creating a variety of other charts
3.4.  Modifying labels, placement within a worksheet of a chart
Unit Four: Customizing Printouts
4.1. Create and modify tables
4.2. Sort and filter data
Unit Five: Formatting Cells and Ranges
5.1- Borders, background colors, and font colors
5.2- Copying formats from other Workbooks
Unit Six: Sharing your results
6.1. Printing your workbook
6.2. Copying and pasting into MS word, Webpages, and PowerPoint
6.3.  Customizing your printouts
6.4.  Exporting to PDF, XML, HTML
Unit Seven: Working with Multiple Worksheets and Workbooks Simultaneously
7.
1 Understand the benefits of using an Excel table over a range of data
7.2. Convert a data range into an Excel table
7.3. Review of the Excel table contextual tab
7.4. Quickly format a table with pre-defined table styles
7.5. Filter data within a table

 

Excel: Intermediate Level
Unit One: Customizing the Excel Environment 

 

vlookups!

string functions


1.1 Configure Excel options
1.2 Customize the ribbon and the Quick Access Toolbar
1.3 Enable Excel Add-Ins (Fred)
Unit Two: Creating Advanced Formulas
2.1- Use range names in formulas
2.2- Use specialized functions
2.3- Use array formulas
Unit Three: Analyzing Data with Functions and Conditional Formatting
3.1- Analyze data by using text and logical functions
3.2- Apply advanced conditional formatting
Unit Four: Organizing and Analyzing Datasets and Tables
4.1- Create and modify tables
4.2- Sort and filter data
Unit Five: Visualizing Data with Basic Charts
5.1- Create charts
5.2- Modify and format charts
Unit Six: Analyzing Data with Pivot Tables, Slicers, and PivotCharts PivotTables
6.1- Create a pivot table
6.2- Analyze pivot table data
6.3- Present data with PivotCharts
6.4- Filter data by using slicers
Unit Seven: Working with Multiple Worksheets and Workbooks Simultaneously
7.1- Use 3D-References
7.2- Use links and external references
7.3- Consolidate data
7.4- Use SUBTOTAL and database functions

 

 

 

Excel: Advanced Level
Unit One: Automating Workbook Functionality
1.1- Apply data validation
1.2- Work with forms and controls
1.3- Work with macros
Unit Two: Auditing Worksheets
2.1- Trace cells
2.2- Search for invalid data and formulas with errors
2.3- Watch and evaluate formulas
Unit Three: Using Automated Analysis Tools
3.1- Determine Potential Outcomes by Using Data Tables 
3.2- Determine Potential Outcomes by Using Scenarios 
3.3- Use the Goal Seek Feature 
3.4- Activate and Use the Solver Tool 
3.5- Analyze Data with Analysis ToolPak Tools
Unit Four: Presenting data visually
4.1- Apply advanced chart features: trend lines, dual axes, and chart templates
4.2- Apply data analysis using automated analysis tools
4.3- Perform what-if analysis
Unit Five: Manipulating Data Using Statistical and Lookup Functions
5.1- Forecasting Using Statistical Functions (regression)
5.2- Evaluate Sales Data Using Statistical Functions 
5.3- Analyze Stock Data Using Statistical Functions 
5.4  Vlookup, HLookups, and index/match
Unit Six: Analyzing Data Using Data Analysis Tools
6.1- Analyze Time Series Data Using Exponential Smoothing 
6.2- Optimize a Stock Portfolio Using Solver