Microsoft Excel–Basics for Real World Use

Microsoft Excel is the most useful, and most often misunderstood, program in the Office Suite. Many of us shy away because it seems so complex and overwhelming, but learning the tools that will help get your daily work done is simple . . . if you have the right instructor. ZenTek developed this class for the beginning, or infrequent, user of Excel who wants to get a better handle on how to perform basic formatting, calculation, and data sorting functions in one of the most powerful programs on the market.

ZenTek Consultants, a certified Microsoft Cloud Solutions Provider, will show students the tools they need in order to use MS 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 MS Excel 2016 and students are encouraged to use same.

Must attend all four sessions. 

Session 1: Understanding the Basics

  • Understanding and Creating Worksheets

  • Working with Multiple Worksheets

  • Understanding Cells and Columns

  • Formatting and Aligning Cells

  • Understanding and Editing Data Types

  • How to Format, Merge, and Control Cells


Session 2: Fun with Functions and Formulas

  • Controlling Worksheet Views

  • Using Automatic Fill Features

  • Understanding Formulas and the Formula Bar

  • Using Common Functions and Formulas

  • Using Formulas across Worksheets


Session 3: Delving Into Data

  • Working with Data Filters

  • Understanding Data Sorting

  • Removing Duplicate Values

  • How to merge and Split Data Cells

  • Adding Data Validation


Session 4: Summarizing Simplified

  • Controlling Page Layouts

  • Inserting Images and Symbols

  • Creating Simple Charts

  • Editing Chart Display Options

  • Working with Pivot 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 – Basics 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