Description

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 course for the beginning, or infrequent, user of Microsoft 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.

This training will be delivered over the course of four sessions, each lasting two hours. The sessions will be spread out to ensure a manageable pace, allowing participants to absorb and apply the material effectively. 

The recording will be available to participants for a limited time following each session, and a certificate of completion will be issued upon successful completion of the training.  

ZenTek Consultants will show you the most effective means of using the software you already own, so you can get the ROI you were hoping for.

NOTE: Courses are taught using the latest Microsoft software.

Multi-day:  February 4, 11, 18 & 25, 2025 | 1:00 – 3:00PM ET | 8:00 am – 10:00AM HST

Course Curriculum

This is a beginner level course.

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

The Instructor:

David Mills has been working within the construction industry for nearly a decade. He has developed commercial and healthcare projects ranging from $100,000 to $100,000,000+, while working in various positions, including Estimator, Project Engineer, Field Engineer, and Assistant Project Manager. During the COVID-19 pandemic, he was an Owner’s Representative on a large healthcare campus in Michigan. This project had several Construction Managers on it using different software products, which Mr. Mills successfully taught team members to use efficiently.

Mr. Mills joined ZenTek Consultants as a Technology Specialist in early 2023. During his time at ZenTek, he has developed custom solutions and training for clients, as well as written numerous articles and blogs on using Bluebeam and Procore efficiently. His knowledge of software does not end at Bluebeam and Procore, as he is proficient in Microsoft Office, Revit, PlanSwift, PlanGrid, Smartsheet, Adobe Photoshop and Adobe Illustrator.