Microsoft Excel – Level 3

This workshop is for individuals looking to further their Microsoft Excel proficiency around tables and pivot charts, financial functions, and workbook protection. 

Topics covered:

• Working with tables ? special table features, structured references, creating sparklines

• PivotTables and PivotCharts ? using PivotTables for analysis, filtering a PivotTables, creating calculated fields, creating PivotCharts

• Working with macros ? recording macros, running and assigning macros

• Data management for business ? importing and exporting data, summarizing data

• Workbook completion ? inserting hyperlinks, inserting and viewing comments, inspecting your workbook, creating forms, protecting workbooks