Intermediate/Advanced Excel Series (weekly through February)

Go from beginner to power PivotTable user. Learn how to use Excel PivotTables and PivotCharts for powerful data analysis. This practical guide from Lynda.com is filled with lots of hands-on exercises and real-world use cases. You will learn how to structure data; change table layouts and styles; leverage design controls; perform sorting, filtering, and grouping; and create interactive dashboards. Use the PDF cheat sheets and the Excel solution file to follow along as you learn.

Topics include:
~Customizing a PivotTable field list
~Grouping dates and values
~Enabling multiple filters
~Conditional formatting
~Refreshing source data
~Adding custom sort lists

Click here to register: https://sunyorange.edu/profdev/regform.html?class_id=1531