Build on the Excel® skills you developed in Level 1 or increase your mastery of Excel® 2013/2016 in this Level 2, one day workshop. In this session you’ll work on creating workbooks using templates, sorting, subtotaling, filtering data, and analyzing data using Pivot Tables and Pivot Charts—including creation and formatting of Pivot Tables. Then we will address calculating data with advanced formulas and how to create charts. In the chart creation session, you’ll learn how to create and modify charts for more effective data presentations and how to enhance visual appeal using graphic objects.
Fee includes all training materials and 6 months of post-training phone or email support.
Who Should Attend
All employees who would benefit from understanding how to leverage more advanced functions of Excel®
- Calculate Data with Advanced Formulas
- Organize Worksheet and Table Data Present Data Using Charts
- Analyze Data Using PivotTables, Slicers and PivotCharts
- Insert Graphics Objects
- Customize and Enhance the Excel® Environment ® Workbook