Microsoft Excel: Advanced

Microsoft Excel: Advanced

This course is being evaluated to be offered in an online format with live instruction at the scheduled day/time. Registered individuals will receive communication by the registration deadline regarding format and access.

Registration deadline: Monday, October 19th, 2020

11 seats left for this class

Lunch included in course fee - please contact training@sodcenter.com with any dietary restrictions

 
Mon, Oct 26, 2020
08:00 am -  03:00 pm
Registration options:
Ticket Name Ticket Price Qty
SOD Members
lunch included
$ 159.00
Non-members
lunch included
$ 199.00

Event description:

*Participants MUST bring their own laptop loaded with Microsoft Excel*

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

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.

 

Information

Location Details

Organizer Details

Intro Image

Training Center.

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