On-site Microsoft Excel Training
Instructor

Lee has a Mechanical Engineering degree from Clemson University and has professionally developed millions of dollars' worth of Excel-based software since 2011.

He created the coursework for and is co-instructor of UC San Diego Extension's "Advanced Excel..." course which launched in 2016.

Lee Gilley

Owner, Docmo

On-site Training

Every training is tailored to the customer. Choose your style of training and any topics you'd like to learn about. We are located in Houston, TX.

Style

Choose a style of training: all Q&A, mostly presentation, or anywhere in between. For smaller groups, we encourage a more conversational and Q&A-style training.

Presentation

We will lead the training through a selection of topics below.

Q&A

Ask questions and showcase your challenges; we'll solve them together!

Topics
Basic
  1. Navigation (the ribbon, zoom, hiding rows/columns, freezing panes)
  2. Printing
  3. Formatting cells, rows, columns and sheets
  4. Formatting text
  5. Working with shapes
  6. Basic formulas (absolute and relative references, arithmetic, understanding parameters)
  7. Hyperlinks
  8. Sorting and filtering
  9. Importing text or .csv
  10. Data tools (flash fill, remove duplicates, text to columns)
  11. Custom lists and data types
Advanced
  1. Named ranges
  2. Commenting and sharing
  3. Charting and sparklines
  4. Slicers
  5. Hotkeys
  6. Tables and pivot tables
  7. Advanced formulas (logic, lookup, text and date, mathematics)
  8. Tracing and error checking formulas
  9. Data validation and dropdown menus
  10. Conditional formatting
  11. Protecting sheets and cells
  12. Querying external sources (web, database, spreadsheet)
  13. Macros, automation, and VBA
Rates

$400 for the first hour and $300/hr afterwards. Multi-session and monthly on-site retainer pricing available.

Email inquiry@docmo.co to book.

Requirements

A projector or big screen, and friendly folks eager to improve!

Slider