WPCCA 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.

 

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

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

Recent Posts

WPCCA 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 5, 2025

WPCCA 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 5, 2025

WPCCA Introduction to ChatGPT and AI

This course introduces contractors to the transformative potential of AI, showing how it can save time, streamline operations, and boost business efficiency. Participants will learn the basics of AI and ChatGPT, discover how AI enhances customer communication, automates scheduling, generates…

February 12, 2025

WPCCA Introduction to Microsoft Copilot 365 – Part 2

Building on our introduction to Microsoft Copilot 365, this session will explore practical applications in everyday tasks. Discover how Copilot can enhance your productivity in Microsoft Word, PowerPoint, and Teams. In part 2 of this training, JoLynn Rihn will demonstrate…

February 4, 2025

WPCCA Introduction to Microsoft Copilot 365 – Part 1

Dive into the world of Microsoft Copilot 365 with this introductory session. Learn the basics of how Copilot can assist you in your daily tasks, from drafting emails to generating reports. In Part 1 of this training, led by Microsoft…

February 4, 2025
MORE STORIES