MS Excel - Advanced Workshop

Date/Time: 

April 20, 2015 - 9:00am

Where: 

North Campus, Room L132

In this hands-on workshop, you will learn:

Advanced Functions:

• use the IF, COUNTIF, SUMIF, ROUND, TODAY and VLOOKUP functions
• nesting functions such as the SUM function with the IF function 
• sorting and creating a custom sort order list

 Pivot Tables:

• create a pivot table to summarize, organize, analyze & compare large amounts of data
• building a pivot table
• customizing a pivot table
• pivot table calculations

 Macros:

• create and use a simple macro

This class ends at 4:00 pm. 
There is still space in this workshop - please email Maureen to secure your spot!