This registration page may not work well in Internet Explorer. Please use a different browser to complete your registration.

Microsoft Excel Intermediate Users Online Course

March 4, 2025 8:00 AM - 10:00 AM (HST)

Description

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? 

Microsoft 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 course will show you exactly how simple Microsoft Excel can be, when you get proper training that is focused on how to use the program in the real world.

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:  March 4, 11, 18 & 25, 2025 | 1:00 – 3:00PM ET | 8:00 – 10:00AM HST

Course Curriculum

This is an intermediate level course.

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 and 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

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.

Time

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

Pricing

GCA Member:  $225

Non-Member:  $325

Registration Deadline and Cancellation policy: February 25, 2025 Please note!!   Full refunds will be made for cancellations received prior to this date.  After this date, no refunds will be granted.  Replacements accepted.  

Class may be cancelled if minimum enrollment is not met.  

View Event

Contact Information

General Contractors Association of Hawaii
Name: Gladys Hagemann
Phone: (808) 386-2014
Email: gladys@gcahawaii.org
We're sorry. No registrations are currently available. You may wish to contact the event organizer for assistance.
{{ vm.EventInfo.ErrorMessage }}

Select Registration Options

Edit
{{vm.regWarningMessage}}
{{vm.regAlertMessage}}

Exhibitor Opportunities

Name Price Att Qty
{{ et.Name }}
{{ et.IncludedAttendeesCount }} {{ et.AttendeeRegType.RemainingPerType }} Remaining {{ et.AttendeeRegType.RemainingPerType * -1 }} on Waiting List {{ et.AttendeeRegType.RemainingPerType * -1 }} Over Limit
{{ et.Remaining }} Remaining
 Sold out

Attendee Registration Options Total Remaining: {{ vm.EventInfo.VacantSpotsPerEvent }}

Waiting List Available
{{ vm.stats.totalAttendeesCount }} Registered , {{ vm.OverallOverAmount() }} on Waiting List , {{ vm.OverallOverAmount() }} Over Limit
Name Price Qty
{{ rt.Name }}
{{ rt.IsMemberOnly ? ' (Members Only)' : '' }}
Limit: {{ rt.LimitPerPurchase }}
Included Attendees: {{ rt.AttendeesCountPerOneRegistration }}
{{rt.Price | currency }} {{rt.PriceAfterDiscount | currency }} {{ rt.Price | currency }}
{{ rt.RemainingPerType }} Remaining
{{ rt.RemainingPerType * -1 }} on Waiting List
{{ rt.RemainingPerType * -1 }} Over Limit

{{'[[Sponsorship]] Opportunities' | localizeString:'['}}

Name Price Att Qty
{{ st.Name }}
{{ st.IncludedAttendeesCount }} {{ st.AttendeeRegType.RemainingPerType }} Remaining {{ st.AttendeeRegType.RemainingPerType * -1 }} on Waiting List {{ st.AttendeeRegType.RemainingPerType * -1 }} Over Limit
{{ st.Remaining }} Remaining
 Sold out
Continue

Registration Information

Edit

Exhibitor - {{er.Name}}

Exhibitor #{{ $index + 1 }}

Total: {{exhibitor.TotalPrice | currency}} {{ exhibitor.IsBenefit ? "- Included as a Benefit" : exhibitor.IsDiscounted ? "- Discounts have been applied" : ""}}
Exhibitor Directory
Primary Contact
Booth Information
Additional Information
Additional Items

Attendee - {{er.Name}}

{{ att.getAttendeeTerm(vm.EventSettings.AdditionalAttendeesTerm, $index) }} #{{ att.getAttendeeIndexDisplay(vm.EventSettings.AdditionalAttendeesTerm, $index) }}

Total: {{att.TotalPrice | currency}} {{att.DiscountMessage | localizeString:'['}}
A No Show fee is being assessed for {{fee.EventName}} on {{fee.EventStartLocalTimeString}}.
More Information Less information

Address

Phone

Additional Information
Event Sessions

{{slot.Name}}

{{$select.selected.SessionName}}
(full)
{{slot.SelectedSession.SessionDescription + (slot.HasFees ? " (Price: " + (slot.PriceTotal | currency) +")" : "")}}
Additional Items

{{'[[Sponsorship+]]' | localizeString:'['}} - {{er.Name}}

{{'[[Sponsor]]' | localizeString:'['}} #{{ $index + 1 }}

Total: {{sponsor.Price | currency}}
Continue

Additional Items

Edit

{{(vm.EventInfo.Terms.Donation || "Fundraising") + " Opportunities"}}

Campaign Name Item Description Amount
{{item.CampaignName}} {{item.Description + (item.ShowMinimumPrice && item.MinimumPrice ? " (Min: " + item.MinimumPrice + ")" : "")}}
Continue

Complete Registration

Edit

Terms & Conditions

No Show Policy

{{ vm.EventInfo.EventSettings.NoShowPolicy }}

Enter Promo Code
This event is synced to a webinar so no confirmation email will be sent from GrowthZone.

Thank you to our {{'[[Sponsor+]]' | localizeString:'['}}