We understand that your time and money are valuable. You don’t want to spend resources on a course that doesn’t fit your learning style with an unknown instructor. Even if there is a money back guarantee, you cannot get your time back. We get it.
Being able to hear and understand your instructor is very important. You can listen to Russ Coltman discuss the advantages of instructor led classes here:
We believe in our process so much that we offer a free 15 minute mini training session on the topic of your choice so you can be sure we are a good fit. It’s easy to find a spot that fits into your schedule using this link: https://calendly.com/russcoltman/30min
Our classes build upon each other and we recommend they be taken in order. We have found that even advanced users can greatly improve their efficiency by learning shortcuts. We move fast and make sure that both beginners and advanced users get value from each session.
We focus on exposing students to many features and not on memorizing where every detail is hidden. Our philosophy is if you know something is possible, then you can look it up. If you don’t know it exists, then you will never know to look it up.
Each online class occurs on a consecutive Thursday and Friday from 9 am to 12 noon EST for a total of 6 hours of instructor led training. Classes are limited to ten students for session. Each registered student will receive a student Excel file prior to class starting and the instructor file after the class is completed. Classes are $399 per person, a link to the class is provided after payment.
Classes offered – 6 hours total:
Excel 1: Basics – Excel basics for beginners and self taught users. Topics: Terminology, data entry shortcuts, formatting cells, rows, columns, and sheets, filtering, sorting, creating formulas.
Excel 2: – Creating and Editing Formulas – Excel formulas for managing by the numbers. Creating, copying, and troubleshooting formulas and functions across multiple sheets and workbooks. Relative and absolute references, introduction to functions.
Excel 3: Charting and Functions – Advanced functions and charting. Organizing data for graphing, creating and modifying chart components, charting tricks and tips. Inserting functions – lookups, database, statistical, and financial functions. Nesting functions and troubleshooting complex formulas.
Excel 4: Working with Large Data Sets and Pivot Tables – Creating Pivot tables for managing by the numbers. Creating pivot tables, applying filters, sorting and summarizing data, updating data sources, adding to data models.