SCGMA YPG Intermediate Excel Course – Part 3

Join Microsoft Certified Master Instructor, Rob Mendell, for Part 3 of our Repeat Intermediate Excel course. Learn advanced filtering, text functions (including TEXTJOIN and TEXTSPLIT), and how to work with dates and times. Master custom cell formats, like displaying leading zeros, and enhance your Conditional Formatting skills with formula-based rules. You’ll also discover efficient techniques like Go To Special for selecting filtered rows. This repeat course is your chance to refine your Excel skills with expert guidance!

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

Program Outline:

  • Advanced Filter (filtering with “and” and “or” Booleans)
  • Text functions
    • LEFT, RIGHT, MID, LEN, FIND, TRIM, UPPER, LOWER, and PROPER
    • New: ARRAYTOTEXT, TEXTBEFORE, TEXTAFTER, TEXTSPLIT, and TEXTJOIN
    • Text To Columns
  • ISEVEN, ISODD, MOD
    • Determining if a value is even or odd
    • The MOD function
    • Combining MOD with text
  • Dates and Times
    • TODAY, NOW
    • How Excel stores dates
    • Formatting dates
    • Functions: YEAR, MONTH, WEEKDAY, (others?)
    • Math with dates
    • Making a Last Day of Month series
  • Custom and Special Cell Formats
    • Show leading zeros, enter telephone and social security numbers, red negatives, etc.
  • More with Conditional Formatting
    • Format other cells based on formula results
  • Go To Special
    • How to select filtered rows

 

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.

 

Click Here to Download the Event Flyer.

RSVP Required. To RSVP, please email Rowanne Khafagy at rkhafagy@scgma.com.

Free for SCGMA Members*
$35 for Non-Members*

Recent Posts

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

SCGMA YPG Event Recap: FHC Tour

On Thursday, August 14, FHC welcomed our Young Professionals Group to their new South Gate campus for an exclusive tour highlighting innovation across the architectural glass and metal industry. The day began in FHC’s showroom with introductions and product demonstrations…

August 19, 2025

SCGMA Event – Open Session

Join us to learn more about Association happenings – trust fund updates, industry updates, man hour updates, and more. Date: Wednesday, August 6, 2025 Time: 4:00pm – 4:30pm Location: via Zoom Tentative agendas for these Open Sessions may include: Glazing Work…

August 6, 2025

What Employers Need to Know About No Tax on Overtime

On July 3, 2025, the U.S. House of Representatives narrowly passed H.R.1, the so-called “One Big Beautiful Bill Act,” ending a dramatic journey through Congress that dominated headlines in recent weeks. The Act includes several provisions related to campaign promises…

July 23, 2025
MORE STORIES