Microsoft Excel Basics
4-Part Online Training Series
MEMBER EXCLUSIVE
Microsoft Excel Basics
4-Part Online Training Series
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 training. This series was developed for the beginner, or infrequent user of Microsoft Excel who wants to improve their knowledge, understanding, and skills in the following areas of one of the most powerful programs on the market. This series is part of the MBI LIVE Learning and Development curriculum being offered to MBI members as an exclusive membership offering at no additional charge to anyone from your company.
Understanding the Basics January 3, 2024 | 9:00am - 11:00am l Zoom
LEARNING OBJECTIVES • • • • • •
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 Master Builder Designation: Project Management - 2 credits
The Master Builder Designation program will offer credits for completion of this course. For more information on becoming a ‘Master Builder’, please visit MBI’s website at www.MBI.Build/mbd.
INSTRUCTOR
Fun with Functions and Formulas
January 8, 2024 | 9:00am – 11:00am l Zoom
LEARNING OBJECTIVES • • • • •
Controlling Worksheet Views Using Automatic Fill Features Understanding Formulas and the Formula Bar Using Common Functions and Formulas Using Formulas across Worksheets Master Builder Designation: Project Management - 2 credits
Delving into Data
January 22, 2024 | 9:00am – 11:00am l Zoom
LEARNING OBJECTIVES • • • • •
Working with Data Filters Understanding Data Sorting Removing Duplicate Values How to Merge and Split Data Cells Adding Data Validation Master Builder Designation: Project Management - 2 credits
Summarizing Simplified
February 5, 2024 | 9:00am – 11:00am l Zoom
LEARNING OBJECTIVES • • • • •
Controlling Page Layouts Inserting Images and Symbols Creating Simple Charts Editing Chart Display Options Working with Pivot Tables Master Builder Designation: Project Management - 2 credits
If you have any questions, please contact Tom Fulcher -TFulcher@MBI.Build or 515-250-4485
David Mills ZenTek Consultants Hackensack, NJ David 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. David 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.
Microsoft Excel Basics
4-Part Online Training Series
Contact Name: Title: Email: Company: Address: City:
State:
Phone:
Cell:
Zip:
The sessions below are scheduled for a la carte registration allowing attendees to participate in the sessions that provide the most value. Please mark which online session(s) you would like to connect to:
Understanding the Basics
Delving into Data
Fun with Functions and Formulas
Summarizing Simplified
January 3, 2024 | 9:00 am - 11:00 am
January 22, 2024 | 9:00 am - 11:00 am February 5, 2024 | 9:00 am - 11:00 am
January 8, 2024 | 9:00 am - 11:00 am
Fee:
No Charge / MBI Members $160 per person / Non-Members
Only the individual whose email address is used to register and is attached to the Zoom connection is eligible to receive Master Builder Designation credits.
METHOD OF PAYMENT: Credit card Credit Card Type:
Check enclosed Master Card
Please invoice Visa
Discover
Card number:
American Express
Expiration date:
Name on card: Card address: Total enclosed: $
Cancellation Policy: Registration cancellations must be submitted to Master Builders of Iowa via email to NFry@MBI.Build. Cancellation requests submitted at least 14 days prior to the start of this program will be refunded 100%. Cancellations received between 7 and 14 days prior to the start of this program will be refunded 50%. No refund for cancellations less than 7 days prior to the start of this program. No refund for no-shows.
Please send registration and payment to: MASTER BUILDERS OF IOWA 4100 Westown Pkwy | West Des Moines, Iowa 50266 Attn: Nichole Fry NFry@MBI.Build
Further information and instructions for each of the online sessions will be forwarded to participants upon receipt of registration. For more information, please contact Tom Fulcher at (515) 657-4395 or TFulcher@MBI.Build