Excel Basics Training – Part 1

Join us for part 1 of our Excel Basics training taught by Microsoft Certified Master Instructor, Rob Mendell. Don’t miss this opportunity to polish your Excel skills. This training will cover topics from launch, basic navigation, and theory definitions to formula fundamentals, basic cell formatting, and data entry. Real life examples and projects from our industry will be incorporated in this training.

 

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

 

Program Outline:

  • Launch, etc.
    • Launch, open, save, save as, close, exit
  • Definitions
    • Cell, Column, Row, Worksheet, Workbook
  • Basic navigation
    • Zoom
    • First cell, Last cell, Name box, etc.
  • Theory & Definitions:
    What can go in an Excel cell / An approach to setting up workbooks

    • Data
    • Label
    • Formula
  • Enter and Edit
    • Enter information into a cell
    • Edit a cell
  • Formula Fundamentals
    • Basic math with + – * / operators
    • The SUM function and AutoSum
    • F2 opens the formula to edit it in the cell
    • The AVERAGE function
    • The Fill Handle (copy by dragging the black plus-sign cursor)
  • Basic cell formatting
    • Font, Number, Alignment, Border, Fill
  • Data entry
    • Wrap Text
    • ALT+ENTER
    • CTRL+’
    • ‘ (apostrophe) to maintain formatting
  • Combining all the above to create a simple spreadsheet
    • Format Cell, Column, Row, Worksheet (name and tab color)
    • Center Across Selection (better than Merge & Center)
  • More with Formulas
    • Relative and absolute references – dollar signs in formula cell references (F4 as a toggle)
    • Precedence (a/k/a Order of Operations) – parentheses in formulas

 

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 Document Crunch Live Demo

Join us for a live demo of Document Crunch, the industry’s leading AI-powered risk platform built to simplify complex contracts and project documents, accelerate decision-making, and keep projects moving forward. Document Crunch empowers your team to quickly review contracts, specifications,…

September 10, 2025

WPCCA 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

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

WPCCA Lumber AI Live Demo

Discover how to streamline every aspect of your operations with AI and automation. Join us for a live demonstration of Lumber, the AI powered all-in-one construction workforce management platform built for modern contractors. From hiring and onboarding to payroll, time…

July 22, 2025

WPCCA Microsoft Word Course: Beyond the Basics

Take your Word skills to the next level in this hands-on training session, presented by Microsoft Master Instructor JoLynn Rihn. Designed for users with basic experience, this course covers advanced formatting and style management, multi-section page numbering, and tools like…

July 2, 2025
MORE STORIES