Microsoft Excel Custom Training

Build-Your-Own-Course

Our build‑your‑own‑course program provides the ultimate level of flexibility to ensure your team gets the most out of their training. Simply mix‑and‑match any of the topics listed below and send us your list. We will work with you to ensure the material will fit into a single day of training.

Every "build-your-own-course" includes a customized reference manual for each person featuring your topics, and the same 30 days of technical support as our standard offerings.

$ 275 / person. Minimum charge of 4 people. Discounts for groups of 6 or more.

View Excel Master Topic List as PDF ›

  •   Beginner Topics

  • Getting Started with Excel

  • The startup screen
  • Workbooks and sheets
  • Customize the Quick Access Toolbar
  • Using the Ribbon
  • Entering Text, Numbers & Formulas

  • Rules for entering data
  • Deleting cell contents
  • Editing cell entries
  • Moving around a worksheet
  • Selecting cells (shortcuts)
  • What is Quick Analysis (2013/2016)
  • Using Clear
  • Using Undo and Redo
  •  
  • Formulas & SUM/AVERAGE

  • Entering a basic formula
  • Operators & order of operations
  • Using the Sum & Average functions
  •  
  • Using Number Formats

  • Choosing number formats
  • Date formats & custom date formats
  • How Excel stores dates
  • The Today and Now functions
  • Setting decimal places
  • Negative value display
  • Cell Alignment Options

  • Left, center and right
  • Vertical cell alignment
  • Centering a heading
  • Wrapping text
  • Rotating text
  • Using indent to create space
  • Columns & Rows

  • Column widths & row heights
  • Hiding and Unhiding
  • Inserting and deleting
  • Cut, Copy, Paste and Paste Special

  • Drag & Drop to move or copy
  • Cut, Copy, & Paste (different in Excel)
  • Using Paste Special
  • Using Fill

  • Automate entering months, days, a series of numbers, and more
  • Using Fill to copy formulas
  • Fill options / Fill tricks
  • Using Flash Fill (2013/2016)
  •  
  • Fonts, Borders & Cell Colour

  • Changing fonts and sizes
  • Bold, italic, underline
  • Font colour & cell colour
  • Applying borders
  • Databases - Quick Overview

  • Understanding/setting up a database
  • A quick look at sorting
  • A quick look at filtering
  • Files

  • Saving & opening
  • Working with multiple files open
  • Closing files
  • Creating new files
  •  
  • Page Layout & Printing

  • Portrait & landscape
  • Scaling
  • Paper size
  • Margins
  • Centre on page
  • Print preview
  • Printing
  • Zooming In and Out

  • Using the zoom bar & dialog box
  • Zoom to selection
  • AutoCorrect

  • Using built‐in settings
  • Using existing abbreviations
  • Adding/Delete abbreviations
  • Find and Replace

  • Finding or Replacing entries, formulas
  • and formats
  •   Intermediate Topics

  • Setting up a Database

  • Proper database design
  • The current region
  • Sorting

  • Multiple level sorting
  • Sort options
  • Sort warning
  • Custom sorts & custom lists for Fill
  • Sorting by colour/icon
  • Back to original sort order
  • Filtering With AutoFilter

  • Activating filter
  • Using the search box / check marks
  • Entering custom criteria
  • Understanding arguments
  • And vs. Or
  • Filter on cell values
  • Formulas with filters
  • Reapplying a filter
  • Clearing filters
  • Using the Subtotal function
  • Using data forms
  • Saving filters (see Custom Views)
  • Split & Freeze

  • Splitting the screen into 2 or 4 panes
  • View widely separated areas simultaneously
  • Freezing panes to lock headings
  • Removing a split or freeze
  • Conditional Formatting

  • Highlight cell rules
  • Top/bottom rules
  • Data bars, color scales, icon sets
  • Using Quick Analysis (2013/2016)
  • Pre-set and custom formats
  • A trick for finding duplicates
  • Using formulas in rules
  • More rules / new rules
  • Using manage rules
  • Clearing rules
  • Multiple Sheets

  • Navigating from sheet to sheet
  • Sizing sheet display area
  • Adding, deleting, renaming sheets
  • Setting sheet tab colour
  • Moving and copying sheets
  • Hiding & unhiding sheets
  • Setting defaults for all sheets
  • Setting default number of sheets
  • Sheet background picture
  • Protecting a Workbook
  • View multiple sheets on the screen
  • Multiple Windows

  • Creating new windows
  • Switching windows
  • View multiple sheets/multiple files
  • Arranging together on the screen
  • Hiding windows
  • Closing all windows
  • Save Workspace (2007/2010)
  • Creating Custom Views

  • Saving multiple print settings
  • Saving multiple filters
  • Saving other settings
  • Advanced Page Setup & Printing

  • Normal, layout and page break views
  • Creating headers and footers
  • Using print titles
  • The Page Setup options
  • Using Page Breaks
  • Cell Styles

  • Using Styles to Speed Repetitive Formatting
  • Creating and Editing Cell Styles
  • Using Cell Styles in Other Workbooks
  • Using the Format Painter

  • Customize the Ribbon (2010-2016)

  • Customize the Quick Access Toolbar

  • Shapes/Objects

  • Lines, arrows, boxes, circles, etc.
  • Text boxes
  • Arrange, align and rotate
  • Group and ungroup
  • Styles, fill and outline
  • Moving, Sizing, Formatting Objects
  • Add Pictures and Clip Art
  • SmartArt Graphics
  • Charts (Basic)

  • Create column,bar,line & pie charts
  • Instant charts
  • Quick analysis charts (2013/2016)
  • Recommend charts (2013/2016)
  • Unlinking a chart (make it static)
  • Selecting, moving & sizing charts
  • Changing the chart type
  • Transposing the data
  • Change data ranges
  • Chart titles & data labels
  • Using the chart buttons (2013/2016)
  • Printing charts
  • Quick chart layouts & chart styles
  • Changing colour schemes (2013/2016)
  • Selecting, moving & sizing elements
  • Formatting chart elements
  • Charts (Advanced)

  • Adding Chart Elements
  • Adding Pictures to Charts or as Backgrounds
  • X‐Axis and Y‐Axis
  • Data tables
  • Error bars
  • Gridlines
  • Legends
  • Series lines
  • Trendlines
  • Up/Down bars
  • Creating Advanced Charts
  • Pie of Pie / Bar of Pie
  • Combo Charts (bar and line)
  • A Quick Look at Other Chart Types
  • Bubble, Gantt, Radar, Combined, Stock, Doughnut
  • Adding Sparklines (2010/2013/2016)
  • Passwords & Protecting

  • Protecting sheets
  • Protecting Workbooks
  • Password to open files
  • Password to modify files
  • Data Validation

  • Setting the Validation Rules
  • Setting the Allowable Values
  • Choosing from a Drop-Down List
  • Input Message
  • Error Alert
  • Cell Comments

  • Attaching Comments to Cells
  • Editing, Deleting & Printing Comments
  • Moving & Sizing Comments
  • Setting Comment Options
  • Multiple Files

  • Opening Multiple Files
  • Displaying Multiple Files
  • Linking Formulas Between Files
  • Updating & Editing Links
  • Closing All Files
  • Range Names

  • Creating a Range Name
  • Using Range Names For Navigation
  • Using Names Already Entered as Headings
  • Range Names as Bookmarks
  • Filtering Range Names
  •     Formulas Topics

  • Formulas Basics

  • Creating a Basic Formula
  • Copying and Filling Formulas
  • Order of Calculation
  • Absolute Formulas

  • Relative vs Absolute
  • Full & Partial Absolute Formulas
  • Range Names in Formulas

  • Why use a range name
  • Range name rules
  • Different ways to create range names
  • Using Range Names in new and existing formulas
  • Entering and Formatting Dates

  • Entering dates and times properly
  • How Excel interprets dates & times
  • Formatting – pre-set and custom
  • Formulas to calculate dates or times
  • Multiple Sheet/File Formulas

  • Formulas that Reference Other Sheets
  • Formulas that Reference Other Files
  • Text with Values

  • Showing text with a value
  • Performing calculations
  • More About Formulas

  • Using Transpose to flip data
  • Tips for editing formulas
  • Displaying formulas (sheet or cells)
  • Reference a single cell in a formula
  • Concatenating formulas
  • Converting formulas to values
  • Splitting one column into several
  • Flash Fill to split data (2013/2016)
  • Using manual calculation
  • Protecting formulas
  • Mapping Formulas with Auditing

  • Tracing formulas
  • Tracing dependents and precedents
  • Step into a formula
  • Error checking
  • The watch window
  • Goal Seek

  • Have Excel Change Cell Value To Arrive At Desired Result
  • Formulas That Cannot Be Edited

  • Creating Array Formulas
  • Editing Array Formulas
  • Trouble Shooting – Error Messages in Formulas

  • How to fix errors
  • Error indicators
  •     Functions Topics

  • Using Functions

  • Using Sum & Average
  • Using AutoSum
  • Quick Analysis Totals (2013/2016)
  • Using Insert Function
  • The Function icons
  • Understanding Function Syntax
  • Functions Across Multiple Ranges

  • Multiple Ranges on Same Sheet
  • Multiple Ranges on Different Sheets
  • Multiple Ranges in Different Files (Linking)
  • The IF Function

  • Quick overview
  • Rules and conditions
  • True and false
  • Using Data Validation
  • Ifs without IF
  • Nesting IF’s
  • Closing brackets
  • Multiple conditions with AND/OR
  • The VLOOKUP Function

  • Quick overview
  • Creating a lookup table
  • Using VLookup with that table
  • Numbers outside the range
  • Using IF and OR with VLookup
  • Using IFNA with VLookup (2013/2016)
  • Using Data Validation with VLookup
  • Vlookup vs. HLookup
  • Other Lookup Functions

  • Choose
  • Transpose
  • FormulaText
  • Statistical Functions

  • Count
  • CountA
  • Large
  • Small
  • Rank
  • Max
  • Min
  • Average
  • Median
  • Mode
  • Math and Trig Functions

  • Product
  • Roman
  • Arabic
  • Sum
  • SumIf
  • Round / RoundUp / RoundDown
  • Ceiling
  • Floor
  • Ceiling.Math/Floor.Math
  • Other Functions can be included upon request

  • Date and Time Functions

  • Today
  • Now
  • Date
  • Value with dates
  • Day / Month / Year
  • Days (2013/2016)
  • Weekday
  • NetworkDays / Workday
  • Text Functions

  • Left / Mid / Right
  • Len
  • Search
  • Trim
  • Lower / Upper / Proper
  • NumberValue (2013/2016)
  • Value
  • Information Functions

  • IsErr
  • NA
  • IsText / / IsNumber / IsBlank
  • IfNa
  • Sheet/Sheets
  • Financial Functions

  • IRR
  • FV
  • PMT
  • PV
  • DB
  •   Advanced Topics

  • Create and Format a Table

  • Why use a table and how to create one
  • Using table tools
  • Filtering & Sorting with Tables
  • Using Slicers (2013/2016)
  • Displaying Totals
  • Design Your Own Table Style
  • Advanced Filter

  • AutoFilter vs. Advanced Filter
  • The three ranges
  • Entering simple and formula-based criteria
  • Performing a filter
  • Using OR conditions and range names
  • Copy unique records
  • Using Subtotal, Sumif/ifs, Averageif/ifs and Countif/ifs
  • Duplicate records (finding/removing)
  • Group, Outline & Subtotals

  • Grouping rows/columns on a sheet
  • Showing/hiding details in an outline
  • Display/hide outline symbols
  • Creating Groups
  • Adding automatic subtotals
  • Adding other automatic analysis (Average, Count, etc)
  • Removing subtotals
  •  
  • Basic Pivot Tables

  • Creating a pivot table
  • Recommended pivot tables
  • Adding columns, rows & filters
  • Moving & removing fields
  • Adding multiple fields in an area
  • Hiding/showing data
  • Accessing tools and options
  • Refreshing data
  • Using value field settings
  • Using and creating styles
  • Advanced Pivot Tables

  • Creating and working with groups
  • Adding a timeline (2013/2016)
  • Collapse and expand fields
  • Changing report layout
  • Using subtotals and grandtotals
  • Using calculated fields
  • Using calculated items
  • Listing formulas used
  • Creating drill-downs
  • Creating report filter pages
  • Filtering pivot table fields
  • Using slicers (2010/2013/2016)
  • Setting pivot table options
  • Multiple consolidation ranges
  • Creating pivot charts
  •  
  • Importing Data

  • From another spreadsheet
  • Paste link
  • Insert object
  •  
  • Get External Data

  • Importing from Access
  • Importing text files
  • Importing from web
  • Working with connections
  • Open external files
  • Templates

  • Using an Existing File as a Template
  • Creating a Template
  • Using In a New File
  • Templates and Inserting Sheets
  • Auto templates for default Books or Sheets
  • Forms

  • Form Templates
  • Designing the Form
  • Tools-Combo Boxes, List Boxes, etc.
  • Control Properties
  • Protecting the Form
  • Sharing Workbooks and Tracking Changes

  • Sharing workbooks on a network
  • Multiple users in the same file
  • Controlling which changes are saved
  • Data Consolidation

  • Consolidate Multiple Worksheets into One
  • Consolidate by Position
  • Consolidate by Category
  • Consolidate from Other Workbooks
  • Customizing Excel

  • Changing Default Options
  • Custom Lists
  • Custom Number Formats

  • Creating custom formats
  • Formatting Codes
  • Custom date & time formats
  • Special characters
  • Codes that react to different number types
  • Dividing / multiplying formats
  • Scenarios

  • Creating and Saving the Scenario
  • Displaying Scenarios
  • Other Scenario Options-Edit, Merge, Summary, etc.
  • Data Tables

  • Creating
  • Substitute Consecutive Values in a Formula
  • Solver

  • Setting Objective/Target
  • Specifying Variable Cells
  • Specifying Constraints
  • PowerPivot (2013/2016)

  • PowerQuery (2013/2016)

  • PowerView (2013/2016)

  • Creating Forecast Sheets (2016)

  • A Brief Introduction to Macros

  • What is a Macro?
  • Recording a Macro
  • Playing a Macro
  • Relative Referencing
  • Rerecording a Macro
  • More About Recording Macros

  • Macro Options
  • Storing Macros
  • Editing A Macro
  • Debugging A Macro
  • Step Into, Step Over, Step Out
  • Run To Cursor
  • Seven Ways To Run A Macro; Adding To Toolbars, Creating Buttons, Etc.
  •   VBA (Visual Basic)

  • We have 8 days of material available on Macros & VBA. View VBA Master Topic List PDF