Microsoft EXCEL Intermediate | Practical Skills to Boost Productivity
Microsoft Excel is the most useful, and most often misunderstood, program in the Office Suite. Learning the tools will help you to boost your productivity in your daily work. Take this intermediate class to take your skills to the next level.
This is an intermediate-level course taught over four days. Students must attend all four sessions.
Course Curriculum
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 Data
- 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
Note: Instructor will be using the latest version of Microsoft Excel and students are encouraged to use same.
Recording: Registrants for this course will receive access to a recording of each session for 7 consecutive days. Access will start the next business day after the session ends.
Facilitated by David Mills of ZenTek Consultants
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.
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. He trains on multiple construction programs that include: Bluebeam, Procore, as he is proficient in Microsoft Office, Revit, PlanSwift, PlanGrid, Smartsheet, Adobe Photoshop and Adobe Illustrator.
Course Schedule:
Session 1 - March 17, 2026 | 10:00am-12:00pm EST
Session 2 - March 19, 2026 | 10:00am-12:00pm EST
Session 3 - March 24, 2026 | 10:00am-12:00pm EST
Session 4 - March 26, 2026 | 10:00am-12:00pm EST
Pricing & Cancellation/Refund Policy:
Member Rate: $199/person
Non-Member Rate: $259/person
No refunds for no-shows or cancellations on or after noon/12:00pm on March 10, 2026. Substitutions from your company are permitted at any time. For any questions, please Contact ABC Staff.