A step-by-step, fully illustrated guide to using Microsoft Excel 2016 (part 3 of 3 - advanced).
Activities include: creating and using macros; assigning a macro to a button; macro security; using filters to investigate and sort large data sets; conditional formatting; worksheet protection; goal seeking; using pivot tables to investigate, display, and summarize information; modifying pivot tables by grouping, rearranging fields, displaying multiple fields, and varying data presentation; importing data to create a pivot table; making pivot charts; and drilling down into a pivot table.
All files required for the activities are available as a free download through a link at the bottom of the title page.
This item is also available as part of the Excel 2016 bundle,
and the Office 2016 bundle.
Click on the links for more details.