Microsoft Excel Advanced

  1. Wednesday, February 13th, 20199:00am - 11:00am

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

Event Details

  • Location:
    ZSR Library 477
  • Special Notes:
    Please bring your laptop.
  • Laptop Required:
    Yes
  • Sponsor:
  • Open To:
    Faculty, Graduate Students, Staff, Students
  • Facilitated by: