SCGMA YPG Intermediate Excel Course – Part 1

Join us for Part 1 of our Repeat Intermediate Excel course, led by Microsoft Certified Master Instructor, Rob Mendell. Enhance your data analysis skills with advanced tools like Subtotal, Goal Seek, Scenarios, and Data Validation, along with logical functions such as IF, AND, OR, and NOT. You’ll also master SUMIF, Conditional Formatting, and count/round functions, while learning how to handle complex conditions and protect cells. This repeat course is perfect for those looking to refresh and expand their Excel expertise in a hands-on environment.

Date: Thursday, March 27, 2025
Time: 11:00am – 12:30pm
Location: via Zoom

Program Outline:

  • Data Tools
    • Subtotal
    • Goal Seek
    • Scenarios
    • Remove Duplicates
    • Data Validation
    • Dropdown Lists
    • Data Validation Circles
  • Logical functions: OR, AND, NOT
    • = as a TRUE/FALSE test
    • OR
    • AND
    • NOT
    • Nesting logical functions
  • IF
    • What IF does
    • Syntax
    • Write an IF statement
    • Blank/Empty/Nil does not equal zero – How to handle empty cells
    • Working with more complex conditions
    • How to get more than two results (Nested IFs)
    • IFS
    • SUMIF / SUMIFS
  • Protecting Cells
  • Conditional Formatting
    • What is Conditional Formatting?
      • Graphics
      • Shading
      • (Using Wingdings)
  • Count Functions
    • COUNT
    • COUNTA
    • COUNTIF
  • Round Functions
    • ROUND
    • ROUNDUP
    • ROUNDDOWN

 

About Rob Mendell:

Microsoft Office Trainer and Consultant Rob MendellRob Mendell is an Independent Contractor and a Microsoft Certified Master Instructor for Microsoft Office, providing training and support for end-users. Rob also designs and develops bespoke software solutions inside Microsoft Office by programming in VBA (Visual Basic for Applications): macros, automation templates, and fully customized dialog boxes. Since 1993, He has trained and supported individuals and groups of all sizes, and developed a myriad of robust solutions in the world’s most ubiquitous business software: Microsoft Office. Rob has worked with NECA (National Electrical Contractors Association) and WC&C (Association of Wall-Ceiling & Carpentry Industries), government agencies, healthcare facilities, over 100 law firms, companies in a wide variety of businesses, and individuals.

Recent Posts

SCGMA AI for Personal Productivity & Firm Transformation Workshop

In this fast-paced, hands-on workshop, AI consultant Stjepan Mikulic will help you turn AI into measurable results—both personally and across your entire firm. You’ll learn how to create custom GPTs, use AI to build presentations, visuals, and reports. Then, we’ll…

September 24, 2025

SCGMA Technical Bulletin – True Divided Lite Glazing Versus Simulated

The glazing industry has always responded to architect’s desire for enhanced glazing details, providing options that meet the design intent and address budget constraints.  Such is the case of divided lite window glazing, the subject of this Technical Bulletin. Divided…

September 22, 2025

SCGMA Document Crunch Live Demo

Join us for a live demo of Document Crunch, the industry’s leading AI-powered risk platform built to simplify complex contracts and project documents, accelerate decision-making, and keep projects moving forward. Document Crunch empowers your team to quickly review contracts, specifications,…

September 10, 2025

SCGMA YPG 2025 Glazing Boot Camp & Water Testing Demo

Join us for our 2025 Glazing Boot Camp at the Apprenticeship Training Facility in Commerce. This session will provide a hands-on learning experience as participants work alongside our apprentices to build storefront and curtainwall mockups, while exploring key installation techniques…

August 27, 2025

SCGMA 3 Pillars of AI Implementation Webinar

Join us for an engaging presentation with Stjepan Mikulic, founder of AI in AEC, a global training provider serving architects, engineers, and construction professionals in more than 60 countries. Stjepan will explore the three key aspects every firm must navigate…

August 21, 2025
MORE STORIES