WPCCA Intermediate Excel Course – Part 1

Join us for part 1 of our Intermediate Excel Course taught by Microsoft Certified Master Instructor, Rob Mendell. This session will provide a comprehensive review of Excel’s essential data manipulation tools and logical functions. From basic operations like Subtotal and Remove Duplicates to advanced techniques such as Goal Seek and Scenarios, attendees will gain proficiency in data analysis and master logical functions like OR, AND, and NOT, along with the IF function for decision-making. By the end, attendees will be equipped to handle complex data scenarios and perform efficient data summarization using functions like SUMIF and SUMIFS.

 

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

Program Outline:

  • Review of previous material — Q&A
  • 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

 

 

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@thewpcca.com.

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

Recent Posts

WPCCA Intermediate Excel Course – Part 4

Join us for part 4 of our Intermediate Excel Course taught by Microsoft Certified Master Instructor, Rob Mendell. In this session, attendees will explore Dates, Times, master Custom Cell Formats, and delve into more Conditional Formatting. They will learn to…

June 3, 2024

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

June 3, 2024

WPCCA Intermediate Excel Course – Part 2

Join us for part 2 of our Intermediate Excel Course taught by Microsoft Certified Master Instructor, Rob Mendell. In this session, Rob will dive deeper into the intricacies of protectings cells and mastering conditional formatting. From count functions to round…

June 3, 2024

WPCCA Microsoft Outlook Level 2 Course: Part 2

Join us for part 2 of our Microsoft Outlook Level 2 Course. In this session, Microsoft Master Instructor, JoLynn Rihn, will cover organization techniques such as categorizing items and managing junk mail effectively. Participants will have the opportunity to hone…

May 17, 2024

WPCCA Microsoft Outlook Level 2 Course: Part 1

Join us for part 1 of our Microsoft Outlook Level 2 Course. This course will delve deeper into the functionalities of Microsoft Outlook, empowering participants to streamline their communication, organization, and task management processes. In this session, Microsoft Master Instructor,…

May 17, 2024
MORE STORIES