Microsoft Excel - Intermediate for Real World Use

Most of us can work through Microsoft Excel basics – add a few cells together, create basic formulas, and even handle a bit of formatting and display control. When it comes to getting a smarter worksheet though, one that will handle recurring data entry with reliable results, we either push it off to our IT folks or default back to pen/paper and calculators. Wouldn’t it be nice to be able to create your own worksheets that will easily handle the work you regularly do, with just a few lines of data entry, instead of spending hours figuring out the same things again and again, by hand? Excel is the most powerful tool in the Microsoft Office suite of products, but it’s developed a reputation for being difficult to use and understand once you move past the basics – and nothing could be farther from the truth! This Intermediate level class will show you exactly how simple Excel can be, when you get proper training that is focused on how to use the program in the real world.


ZenTek Consultants, a certified Microsoft Cloud Solutions Provider, will show students the tools they need in order to use Microsoft Excel on real-world jobs. This eight (8) hour course is delivered in four (4), two-hour long sessions that students can attend online, right from their own desk. A live instructor will explain the detailed functions, and address questions as the class progresses.


Note: Instructor will be using Microsoft Excel 2016 and students are encouraged to use same.

Must attend all four sessions. 

Session 1 - Working with Templates

  • Using Excel Online Templates

  • Creating Templates from a Worksheet

  • Saving and Sharing Templates

  • Editing Templates

  • Using Templates to Start New Worksheets

  • Template Best Practices


Session 2 – Data Controls

  • Sorting Data

  • Filtering Data

  • Finding Data

  • Working With Conditional Formatting

  • Integrating Filters and Conditional Formatting


Session 3 – Conditional & Lookup Formulas

  • Linking Workbooks and Worksheets Via Formulas

  • Conditional Formulas & Functions

  • Lookup Formulas & Functions

  • Nesting Formulas

  • Other Useful Formulas and Functions


Session 4 – Charts & Tables

  • Chart Planning

  • Creating Basic Charts and Tables

  • Chart Types and Formats

  • Pivot Tables

  • Sharing Charts & Tables

Don't see a class that meets your needs. Suggest topics using the button below.

Live class not available at this time. Click on Add to Waitlist if you would like to be contacted when this course is scheduled.

$195 per person

ON DEMAND: Microsoft Excel – Intermediate for Real World Use

Now available on demand. Take the course when you want!

Please reload

We also offer this training for individual firms who want to arrange a group session at a time that's convenient for them. Group rates are available. Contact us to schedule a group session.

Online Training Cancellation Policy

Registration may be modified or cancelled at no charge up to 24 hours prior to the start of class. Cancellations made less than 24 hours before the start of class will result in a cancellation fee of 50% of the quoted tuition. No refunds will be given once a class has begun. ZenTek reserves the right to cancel or reschedule a course for any reason.

  • White Facebook Icon
  • White Twitter Icon
  • White LinkedIn Icon
  • White YouTube Icon
Procore Certified Consultant
Solution Partner White@2x.png

©2016 - 2020 BY ZENTEK. LLC