Live, Online Microsoft Excel Training
Get the most out of working from home!
Start...

Working smarter.

Building sustainable and scalable spreadsheets.

Being nimble.

Class Schedule

To sign up, send an email to the address at the top of this page. Please register 24hrs in advance. Max capacity of 10 students per class.

Tuesdays

11:00 am (Central)

A 45-minute presentation on selected topics, followed by 15 minutes of Q&A.

We cover 2-4 basic topics on Tuesdays; every class is different.

See description of topics below.

Thursdays

2:00 pm (Central)

A 45-minute presentation on selected topics, followed by 15 minutes of Q&A.

We cover 2-4 advanced topics on Tuesdays; every class is different.

See description of topics below.

Private Classes Available

Great for groups and departments.

Presentation

Classroom lecture format.

Best for getting comfortable with new features, mastering old features, and understanding best-practices.

Great for departments and groups.

Q&A

Conversational and interactive.

Best for addressing current problems and projects in real-time.

Students are welcome to stay for the entire duration to ask and listen, or to drop in with a couple questions.

Instructor

Your instructor is our Founder and CEO; he has professionally developed millions of dollars' worth of Excel-based software and graduated from Clemson University with a Mechanical Engineering degree.

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

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

$50 per student. Group rates available.

Requirements

Friendly folks eager to improve! The class will be hosted using Microsoft Teams; you can join with your web browser.

Slider