Mastering Excel

Excel Training Session

Hands-on, Instructor Led

This workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer.

This WorkShop is Best Suited…

  • for those who want to take their Microsoft Excel skills to the next level.
  • for those who have basic or intermediate Excel skills.
  • for those with advanced skills who want to further improve their productivity.

If you have never opened the software before this workshop is not for you.

About The Session

  • Software Used – Microsoft Excel 365.
  • Hands-On – yes.
  • Manuals – we don’t provide manuals. You are welcome to take the work files with you which will serve as an excellent refresher.
Register Now!

In-Person On-Site Training & Remote Live Classes
Chicago, IL

Small Group WorkShop Business Data Analysis Learn Pivot Tables IF, SUMPRODUCT VLOOKUP Excel Beyond Basics Must-Know Shortcuts INDEX, MATCH Session led by .. Excel VBA Developer

  • Mastering Excel
    - Intermediate

    • Shortcuts for Managing Large Datasets
    • SUBTOTAL, Filters
    • VLOOKUP
    • Merge Data with Lookup Functions
    • Error Handling
    • Named Ranges
    • Pivot Tables
  • Mastering Excel
    - Advanced

    • Logical Test
    • IF Function
    • AND OR Functions
    • SUMIF Function
    • INDEX, MATCH
    • Merge Data with INDEX, MATCH Functions
    • Text Manipulation
    • Cleaning Data
    • Table Objects

REGISTER ONLINE

Registration Open Now

    Questions?

    If you have any questions please contact our Customer Service

    Staff Training & Individual Tutoring

    Highly Personalized Sessions

    Staff Training

    Excel Training Session
    • ONSITE STAFF TRAINING

      At your office, home, conference room… you name it. Training at your location, at your convenience.

    One-Day Sessions

    Perfect for increasing staff efficiency.

    One-Day Sessions

    No other participants, just you and your instructor.

    One-On-One Training

    Excel Training Session
    • ONSITE TRAINING

      At your office, home, conference room, our location… you name it, we’ll make it happen!

    On-Site Training

    We offer Microsoft® Excel classes, location training, VBA coding, general spreadsheet services and automation in the Chicago, IL. Not only do we automate tasks in Excel, we connect it with other data sources, APIs and the World Wide Web. Now your spreadsheets may come to life like they never did before.

    Class Size

    Our regular session is a private one-on-one session; you may add more participants for an additional charge. We offer unique learning experience from working professional developers. Classes can be tailored to your unique requirements.

    Professional Instructors

    All instructors are working professionals. We believe that in addition to theory, it’s important to have real world experience in using the applications we teach. Our passionate instructors are well regarded for their knowledge of the software, patience, and clarity of instructions.

    All Levels

    Courses of all levels are available: introductory to advanced. Customers also receive 15 days email support after the course.