Excel Training Kansas City

To see additional full training class outlines for other classes see our Classes page.
Excel 2013: Basic
Topic-Level Outline

Days: 1
Prerequisites: Windows 7: Basic or equivalent experience
Unit 1: Getting started
Topic A: Spreadsheet terminology
Topic B: The Excel environment
Topic C: Navigating a worksheet
Topic D: Using a template
Unit 2: Entering and editing data
Topic A: Entering and editing text and values
Topic B: Entering and editing formulas
Topic C: Saving and updating workbooks
Unit 3: Modifying a worksheet
Topic A: Moving and copying data
Topic B: Moving, copying, and viewing formulas
Topic C: Absolute and relative references
Topic D: Inserting and deleting ranges, rows, and columns
Unit 4: Functions
Topic A: Entering functions
Topic B: AutoSum
Topic C: Other common functions
Unit 5: Formatting
 Topic A: Text formatting
Topic B: Row and column formatting
Topic C: Number formatting
Topic D: Conditional formatting
Topic E: Additional formatting options
Unit 6: Charts
Topic A: Chart basics
Topic B: Formatting charts
Unit 7: Graphics
Topic A: Working with pictures
Topic B: Conditional formatting with graphics
Topic C: SmartArt graphics
Unit 8: Printing
 Topic A: Preparing to print
Topic B: Page Setup options
Topic C: Printing worksheets

Excel 2013: Intermediate
Duration: 1 day

Table Of Contents:
Unit 1: Managing workbooks and worksheets
Topic A: Viewing large worksheets
Topic B: Printing large worksheets
Topic C: Working with multiple worksheets 
Topic D: Linking worksheets with 3-D formulas
Topic E: Using multiple workbooks
Topic F: Linking workbooks

Unit 2: Advanced formatting
Topic A: Using special number formats
Topic B: Working with themes
Topic C: Other advanced formatting

Unit 3: Outlining and subtotals
Topic A: Outlining and consolidating data
Topic B: Creating subtotals

Unit 4: Cell and range names
Topic A: Creating and using names
Topic B: Managing names

Unit 5: Data structure and tables
Topic A: Sorting and filtering data 
Topic B: Working with tables

Unit 6: Web and sharing features
Topic A: Saving workbooks as Web pages
Topic B: Using hyperlinks
Topic C: Sharing workbooks 

Unit 7: Documenting and auditing
Topic A: Auditing features
Topic B: Comments in cells and workbooks
Topic C: Protection
Topic D: Workgroup collaboration

Unit 8: Application settings and templates
Topic A: Application settings
Topic B: Working with templates

Excel 2013: Advanced
Duration: 1 day

Table Of Contents: 
Unit 1: Advanced functions and formulas
Topic A: Logical functions
Topic B: Conditional functions
Topic C: Financial functions
Topic D: Text functions
Topic E: Date functions
Topic F: Array formulas

Unit 2: Lookups and data tables
Topic A: Using lookup functions 
Topic B: Using MATCH and INDEX
Topic C: Creating data tables

Unit 3: Advanced data management
Topic A: Validating cell entries
Topic B: Advanced filtering

Unit 4: Advanced charting 
Topic A: Chart formatting options
Topic B: Combination charts
Topic C: Graphical objects

Unit 5: PivotTables and PivotCharts 
Topic A: Working with PivotTables
Topic B: Rearranging PivotTables
Topic C: Formatting PivotTables 
Topic D: PivotCharts

Unit 6: Exporting and importing data
Topic A: Exporting and importing text files
Topic B: Getting external data 

Unit 7: Analytical tools
Topic A: Goal Seek
Topic B: Scenarios

Unit 8: Macros and Visual Basic
Topic A: Running and recording a macro
Topic B: Working with VBA code

Share by: