Microsoft Excel: Advanced

Microsoft Excel: Advanced

12 seats left for this class

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

Tue, Mar 10, 2020
08:00 am -  03:00 pm
Registration options:
Ticket Name Ticket Price Qty
SOD Members
lunch included
$ 125.00
Non-members
lunch included
$ 155.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