THIS IS A PAST EVENT.

Microsoft Excel Advanced

THIS IS A PAST EVENT.

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, May 16, 2019 at 9:00am to 11:00am

Z. Smith Reynolds Library
1834 Wake Forest Road Winston-Salem, NC 27106

Event Type

Professional Development

Departments

Information Systems, Administrative, Professional Development Center

Target Audience

Faculty, Staff, Students

Website

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

Subscribe
Google Calendar iCal Outlook

Recent Activity

You're not going yet!

This event requires registration.