Site Content

Microsoft Excel Advanced

If you enjoyed our Microsoft Excel Basics class, join us for more hands-on activities to help you absorb the material. We will delve into more advanced features of Excel. Class modules include:

Managing Multiple Workbooks and Worksheets

Using 3-D References in formulas
Using links and External References in formulas
Applying cell and range names
Consolidating data using the Consolidate command

Analysis Tools

Applying advanced Conditional Formatting
Determining potential outcomes with Data Tables
Performing What-if Analysis using Goal Seek and Scenarios
Exploring the basics of PivotTables and PivotCharts

Managing Worksheet Functionality

Adding Data Validation criteria
Creating and editing a basic macro
Working with forms and controls
Examining invalid data and formula errors


PLEASE NOTE: Registration is required for this event. Use the "Register" link on this page.

Thursday, October 31 at 9:00am to 11:00am

University Corporate Center, 1018
1100 Reynolds Blvd, Winston-Salem, NC ‎

Event Type

Training & Professional Development

Departments

Information Systems, Administrative, Professional Development Center

Target Audience

Faculty, Staff, Students

Website

http://pdc.wfu.edu/event/13619/

Subscribe
Google Calendar iCal Outlook

Recent Activity

Event Registration Required

This event requires registration.