Upcoming Events

Loading Events

« All Events

  • This event has passed.

Automating Your Excel Spreadsheets

April 20, 2017 @ 2:00 pm - 3:00 pm

| $139.00
Automating Your Spreadsheets: Templates, Tools, and Macros
Far too much of our day is spent performing steps that (1) we’ve done before, and (2) we know we’ll do again. This session focuses on trying to plan ahead, by creating templates for our spreadsheets, that include formatting and validation on cells before anyone gets their hands on them. We’ll also automate a number of tasks by creating macros, giving us hours back every week! Our topics include:

  • Applying Number Formatting to Cells before Data Entry
  • Using Conditional Formatting to Provide Real-Time Feedback
  • Setting Up Calculations with Error Handling
  • Creating Named Ranges to Simplify Calculations
  • Using Data Validation to Save Sanity
  • Planning and Saving Template Files
  • Recording Macros to Save Time

Price of the workshop includes:

  1. Executive Overview Document (emailed prior to session)
  2. Live Q&A session following presentation
  3. Recording of session (available for 60 days)
  4. 30 days free email one-on-one coaching
  5. Toll Free access

Your Presenter: Neil Malek. Neil Malek is a Microsoft Certified Trainer, Adobe Certified Instructor, and CompTIA Certified Technical Trainer. With more than a decade of teaching experience, he focuses on answering ‘why’ before getting to the details of ‘how’ to do something.
Date: April 20, 2017
Time: 2:00pm ET
Cost: Only $139.00 per dial in line (unlimited attendance)


To Register: Email david@on-the-right-track.com with “Register Me for Automating Your Spreadsheets” in the subject line and he will send you your dial in information and the invoice.


April 20, 2017
2:00 pm - 3:00 pm