|
Details:
|
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.
|