SCGMA YPG Intermediate Excel Course – Part 2

Join Microsoft Certified Master Instructor, Rob Mendell, for Part 2 of our Repeat Intermediate Excel course. Build on your skills with advanced functions like VLOOKUP, XLOOKUP, INDEX, MATCH, and new techniques for combining lookup functions with Data Validation. Learn to work off the grid with Text Boxes, Comments, and Shapes, and master grid tools like Freeze, Hide, and Split. You’ll also explore Tables, basic charting (pie, line, column, sparkline, and map), and tips for efficient multi-sheet work. This repeat course is the perfect chance to refresh and enhance your Excel expertise!

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

Program Outline:

  • A few Reference functions
    • ROW
    • COLUMN
    • INDIRECT
    • OFFSET
  • Lookup functions
    • VLOOKUP
    • (IFERROR)
    • HLOOKUP
      • Also an example of inexact matching
    • INDEX
    • MATCH
    • New: XLOOKUP
    • Combine Lookup and Data Validation
  • Off the grid
    • Text Box
    • Comments
    • Insert Shape
    • Insert Screenshot
  • Use the grid
    • Freeze
    • Unfreeze
    • Hide
    • Unhide
    • Split
    • Work on more than one sheet at a time
    • Tables
      • Formulas are different in Tables
  • Basic Charting
    • Determine which chart you need
    • Pie
    • Line
    • Column
    • Sparkline
    • Map

 

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 Event – Open Session

Join us to learn more about Association happenings – trust fund updates, industry updates, man hour updates, and more. Date: Friday, November 14, 2025 Time: 7:00am – 7:30am Location: via Zoom Tentative agendas for these Open Sessions may include: Glazing Work…

October 20, 2025

SCGMA ConstructConnect Live Demo

Join us for a live demo with ConstructConnect, the leading preconstruction platform that helps commercial construction professionals find more projects, bid smarter, and work faster. Date: Tuesday, November 18, 2025 Time: 11:00am – 12:00pm Location: via Zoom Key Takeaways: Access 750,000+ active…

October 8, 2025

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
MORE STORIES