- When:April 20, 2015 9:00am
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
- create a pivot table to summarize, organize, analyze & compare large amounts of data
- building a pivot table
- customizing a pivot table
- pivot table calculations
- create and use a simple macro
There is still space in this workshop - please email Maureen to secure your spot!