Excel Basics training – Part 2

Join us for part 2 of our Excel Basics training taught by Microsoft Certified Master Instructor, Rob Mendell. Don’t miss this opportunity to polish your Excel skills. This session will cover topics such as sorting and filtering, functions, copying and moving, formulas on order of operations and absolute references, conditional formatting and more. Real life examples and projects from our industry will be incorporated in this training.

 

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

 

Program Outline:

  • Even More with Formulas
    • MIN and MAX
    • Using formulas in context
    • Using MIN or MAX as thresholds
    • Using precedence in a worksheet
    • Using absolute references in in a worksheet
    • Edit a formula (F2), Esc v. CTRL+Z – warning about Undo
    • Named Ranges
    • Show Formulas
    • Create a running total
  • Basic worksheet actions
    • Delete, move, copy, insert Cell, Column, Row, Worksheet
    • Name and (Tab) Color
    • Basic Sorting and Filtering
    • Basic Conditional Formatting
    • Basic Charting (e.g., pie, line, column)
    • Insert hyperlink
    • Hide and unhide Column, Row, Worksheet
    • Freeze and Unfreeze and Split
  • Error messages
    • #NAME?, #DIV/0!, etc.
    • Formula Auditing
    • Circular references

 

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 Webinar: How Technology is Transforming the Construction Industry

Technology is driving dramatic changes throughout the construction industry and every company is being affected. There is growing use of established software solutions while a host of emerging technologies and digital processes are rapidly gaining traction. Users are learning to…

February 29, 2024

WPCCA Microsoft Project Level 1 Course – Lesson 1

Join us for our first lesson of Microsoft Project Level 1 Course taught by Microsoft Certified Professional, James Law. This lesson will provide training on getting started with Microsoft Project. Attendees will learn how to identify project management concepts from…

February 27, 2024

HubSpot Platform Demo and Q&A

Join us learn more about HubSpot– a holistic customer platform that makes it easy for an entire company to work together — from marketing and sales to customer service. HubSpot provides an all-in-one solution. This demo will focus on their…

February 15, 2024

WPCCA Economic Outlook Webinar: The Good, The Bad, & The Ugly

Has the Federal Reserve successfully engineered a soft landing?  Or, is the confluence of geopolitical conflict, a presidential election, rising consumer debt levels, and still high interest rates conspiring to produce economic downturn in 2024?  It is difficult to know…

January 30, 2024

Clarity On State Law & Drug Testing In The Construction Industry

In 2022, Governor Newsom signed legislation (AB 2188) making cannabis users a protected class of employee. AB 2188 contained a delayed implementation date and took effect on January 1, 2024. The measure prohibited employers from discriminating in hiring, firing or…

January 29, 2024
MORE STORIES