Excel Custom Training – Example Curricula

Examples of topics taught in custom courses in the past:

Basic to Intermediate – Full Day Class

1. Entering data and working with sheets
   -Enter Text, Numbers, or Dates Data
   -AutoComplete and AutoFill
   -Copy/Duplicate Sheet
   -Rename, organize, and reference multiple sheets
   -AutoSum
2. Organizing Data:
   -Sorting and Filtering
   -Adding, Copying, and  Deleting Columns.  Rows as well
   -Copy and Paste as Text
   -Find and Replace
   -Basic Formatting of headers, lines, fonts, column sizes
3. Basic Formulas
   -Using the “=” sign and parenthesis “( )”  manage formulas
   -Absolute References (F4 Function)
   -Statistical Formulas: SUM, AVG, COUNT,
4. Formatting and Charts
   -Number/Data Formatting
   -Alignment, Font, and Sizes
   -Highlight and Colors
   -Basic Charts

 

Intermediate to Advanced – Full Day Class

1. Filters Tips and Tricks
   -Working with Filters, zero/no value items
   -Conditional Formatting
   -Copying and pasting filtered data / SUM and Count Filtered data only
   -Table / Data Range Naming
2. Advanced Formulas and Functions
   -IF Formula
   -Trim and Concatenate
   -VLOOKUP and HLOOKUP Formula
   -Text to Columns
   -Data Validation – Drop Down List Menu
3. Excel Shortcuts
   -Finding Functions
   -Finding Answers
   -Keyboard Shortcuts
4. Pivot Tables
   -Introduction to Pivot Table functionality
   -Setting up the data to be ready for Pivot Tables
   -Practical Examples and custom pivot table reports