SCGMA Intermediate Excel Course – Part 3

Join us for part 3 of our Intermediate Excel Course taught by Microsoft Certified Master Instructor, Rob Mendell. This session will cover creative spreadsheet elements like Text Boxes and Comments to advanced grid navigation such as Freezing, hiding and Splitting. Rob will demonstrate how to create Tables and charts for streamlined data management. Additionally, attendees will explore advanced filtering, text functions and more.

Date: Wednesday, July 24, 2024
Time: 11:00am – 12:30pm
Location: via Zoom

Program Outline:

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

 

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

March 4, 2025

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…

March 4, 2025

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…

March 4, 2025

Construction Documents Course – Saturday, May 10

Per our recent Glaziers MLA negotiations: “Effective June 1, 2023, a Foreman, in charge of five (5) to ten (10) employees, who has obtained a leadership certification through our Apprenticeship: a minimum of three dollars and fifty cents ($3.50) per…

February 21, 2025

SCGMA YPG Trulite Tour

Join us for a tour of Trulite’s fabrication facility in the City of Industry! This is a perfect opportunity to learn about their operations, especially with the launch of their new oven line. Learn about Trulite’s innovative glazing solutions and…

February 18, 2025
MORE STORIES