Microsoft Excel – Basics for Real World Use
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.

starts 01/14/2020
11:00 AM - 1:00 PM ET

$195 per person

Microsoft Excel – Basics for Real World Use

Session 1: January 14

Session 2: January 16

Session 3: January 21

Session 4: January 23

$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.

ZenTek, LLC is approved by the New Jersey State Board of Professional Engineers and Land Surveyors to offer CPC (also known as CEC/PDH depending on your state) credits for Autodesk Revit training courses. 

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

©2016 - 2019 BY ZENTEK. LLC