Microsoft Excel, Fundamentals
This hands-on class covers the core features and shortcuts needed to create and update professional-looking worksheets with a minimum of wasted time and effort. It is designed for anyone who wishes to gain a foundational understanding of Excel whether they are truly new to its use or simply wish to “fill in the gaps” of their knowledge. Special emphasis will be given to taking the mystery out of formulas and functions.
Class format will provide time for the instructor to recommend best practices, explain new concepts, introduce shortcuts, and answer questions. Participants will have time to apply new skills to real world scenarios.
Topics include:
Using best practices & shortcuts to perform common tasks
Customizing the Quick Access Toolbar on the fly
Building custom worksheets from scratch
Understanding how math is done in an Excel spreadsheet
Converting written formulas into Excel format
Applying the Order of Operations to multi-step equations
Identifying key Excel functions and deciphering their syntax
Applying common summary functions to various scenarios
Leveraging the Intellisense feature when building functions
Reusing a single formula across multiple rows or columns
Utilizing relative, mixed and absolute references to avoid errors
Transforming data with the Paste Special command
Modifying worksheet data and structure quickly and easily
Selecting and updating multiple entries more efficiently
Using Excel’s built-in proofing and research tools to verify info
Enhancing worksheet appearance with formatting, styles & themes
Building navigation shortcuts into your worksheet with hyperlinks
Copying complex formats with the Excel format painter
Incorporating basic data visualization with conditional formatting
Using Excel templates to accelerate the creation of new workbooks
Avoiding common printing frustrations
Applying page layout options & configuring headers/footers
Organizing and managing multi-sheet workbooks
Selecting optimal view options for updating large files
Using workbook properties to tag & search for related files
Custom delivery
This class can be tailored to meet your company's needs. It can be delivered at your facility, or off-site at our office. Please contact Employers Network for more information.
Instructor
Schedule
March 11, 2025
Class will meet 8:30a.m. to 4:30 p.m.
Fee
Members: $308 per person
Non-members: $433 per person
Attendance
Should you need to cancel your registration, please email Candace Hall at candace@employersnet.com. Kindly note the following:
Eventbrite Service Fee: Non-refundable under all circumstances.
Employer's Network Cancellations: If Employers Network cancels the class for any reason, your ticket can be transferred to any class of your choice of equal value.
No-Show Policy: Registered participants who do not attend the class ("no-shows") will be charged the full class cost. No-show fees cannot be used as credit for any future Employers Network class, event, or service.
Cancellation Window: Cancellations made less than 10 business days prior to the class start will be charged the full class cost. This fee may not be used as credit for future Employers Network classes, events, or services. However, substitutions are welcome.
Real-Time Event Changes: Employers Network reserves the right to make real-time changes to event content or offerings as necessary. In such cases, no refunds, partial refunds, or alternative offers will be made beyond the terms stated in this cancellation policy.