Participants will learn how to streamline and enhance spreadsheets with templates, charts, graphics, and formulas, as well as how to create templates, sort and filter data, import and export and analyze data, and work with Excel on the web.
Upon successful completion of this course, Participants will be able to:
- Use advanced formulas
- Organize worksheet and table data
- Create and modify charts
- Analyze data using PivotTables and PivotCharts
- Insert graphic objects
- Customize the Excel 2016 environment