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. This workshop covers Microsoft Excel 2021/365. 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