Description
This course covers aspects of Microsoft Excel beyond building basic workbooks and deals with workbook automation and productivity features.
- nest functions to create complex formulas
- use advanced filters to analyse data in a list
- use a variety of data validation techniques
- use goal seeking to determine the values required to reach a desired result
- create, use and modify data tables
- create, modify and work with PivotTables and Pivot Charts
- use linking to create more efficient workbooks
- import and export files
- create and work with scenarios
- confidently open workbooks that contain macros
- create recorded macros in Excel
|
