Microsoft Excel Training (Introductory, Intermediate, and Advanced Levels)
Course Outline
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
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