Examples of topics taught in custom courses in the past:
Basic to Intermediate – Full Day Class
- 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 - 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 - Basic Formulas
-Using the “=” sign and parenthesis “( )” manage formulas
-Absolute References (F4 Function)
-Statistical Formulas: SUM, AVG, COUNT, - Formatting and Charts
-Number/Data Formatting
-Alignment, Font, and Sizes
-Highlight and Colors
-Basic Charts
Intermediate to Advanced – Full Day Class
- 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 - Advanced Formulas and Functions
-IF Formula
-Trim and Concatenate
-VLOOKUP and HLOOKUP Formula
-Text to Columns
-Data Validation – Drop Down List Menu - Excel Shortcuts
-Finding Functions
-Finding Answers
-Keyboard Shortcuts - Pivot Tables
-Introduction to Pivot Table functionality
-Setting up the data to be ready for Pivot Tables
-Practical Examples and custom pivot table reports
Advanced to Expert – Full Day Class
- IF Function in Detail and operators
-Sytax of IF
-AND / OR Operators
-SUMIF, COUNTIF, AVERAGEIF - Lookup Formulas in Detail
-VLookup explained with practical examples
-HLookup explained with practical examples
-Working with Name Ranges to simply lookups
-Nested LOOKUPs - Data Functions and Text Formulas
-MATCH, INDEX, CHOOSE, FIND
-LEN and TRIM
-FIND and MID
-LEFT and RIGHT - “What if” analysis with Goal Seek and Solver
- Macros – *Note: No VBA coding will be taught, just recorded event macros
Expert – Half-Day Class
- Advanced Topics in Pivot Tables, Slicers, PivotCharts, and PowerPivot
- Outside Database sources via ODBC, SQL, and other Sources
- Large Data cleanup and processing
- Automation techniques with Macros
- Importing Excel transaction data into QuickBooks using Transaction Pro
Learn more about our custom excel training options or our scheduled live classes