Microsoft Excel: Advanced with Cheryl Welch, PH.D

Microsoft Excel: Advanced With Cheryl Welch, PH.D

This course is being offered in an VIRTUAL format with LIVE online instruction at the scheduled day/time online. Registered individuals will receive communication format and zoom access.

Registration deadline: Tuesday, May 14, 2024

Minimum Class Participant Requirement: 5

Wed, May 22, 2024
09:00 am -  12:00 pm
Registration options:
Ticket Name Ticket Price Qty
SOD Members $ 110.00
Non-members $ 132.00

Event description:

LIVE, Instructor-Led Online Microsoft Excel Advanced Course

Our same great instructor, Cheryl Welch, PhD, will be providing Microsoft Excel Advanced, but now you can tune in LIVE online, from your office or home. You will need to have Microsoft Excel on your laptop or computer.

Prior to the class date an informational packet will be emailed to you with a PDF handout, a data file to be accessed during the class, and instructions.

Experienced Excel users can learn advanced functions and tips to streamline processes with this course. Content includes:

  • Advanced functions and formulas
    • Review of the basic IF function
    • Nested IFs
    • Handling the look of complex formulas
    • Conditional formatting
    • Capturing and handling errors
    • Arrays
  • Troubleshooting formulas
    • Calculation options
    • Trace cells
    • Watch and evaluate formulas
  • Tables
    • Create and modify a table
    • Importing data
    • Apply data validation
  • Pivot tables and Pivot charts
    • Working with pivot tables
    • Modifying pivot tables
    • Formatting pivot tables
    • Using pivot charts
  • Analytical tools
    • Goal seek scenarios
    • Instant data analysis
  • Macros
    • Recording
    • Running
    • Editing in VBA

What version of Excel can I use?  2007 and up

The instructor will be using a Windows based version.  Mac and Windows versions are significantly different in regards to the ribbon and finding command buttons. This may prove to be confusing for Mac users. 

Note: It is presumed that participants have a solid grasp of Excel and its use and are fluid with all skills covered in Excel Basics and Excel Intermediate courses.



Organizer Details

Intro Image

Start Growing In Salem.

We support your business growth through site selection, retention, expansion, entrepreneurship, infrastructure, workforce development and quality of life. No wonder, businesses are Growing In Salem.

How SOD Center Does Work for You.

"We support all businesses, small and large, to attract, retain, expand and develop. We help build entrepreneurship, provide training facilities and connect you with the right resources – while collaborating with regional, state and national resources. We are all Growing in Salem." - Julie Needs, Executive Director, SOD Center