About This Training Course

Now that you are a highly efficient Excel user it is time to perfect your skills. The Excel Excellence Training Course will help you master the techniques of an advanced user so that you can create accurate and well presented documents.

Let the experts teach you how to consolidate the data from several workbooks into one & use the Solver function to solve more complex problems.

Subjects Covered

This Excel Excellence Training Course will cover the following subjects:

1. Lookup Functions
2. Setting Excel Options
3. Chart Object Options
4. Labels and Names
5. Protecting Data
6. Summarising and Subtotalling
7. Data Linking
8. Data Consolidation
9. PivotTables
10. PivotTable Techniques
11. PivotCharts
12. Goal Seeking
13. Grouping and Outlining
14. Solver
15. Recorded Macros
16. Recorder Workshop

Training Course Outcomes

At the end of the Excel Excellence Training Course participants will be able to:

- use a range of lookup and reference functions
- modify Excel options
- create and use labels and names in a workbook
- protect data in worksheets and workbooks
- summarise data using subtotals and relative range naming
- use data linking to create more efficient workbooks
- use the Data Consolidation feature to combine data from several workbooks into one
- understand and create simple PivotTables
- construct and operate PivotTables using some of the more advanced techniques
- use goal seeking to determine the values required to reach a desired result
- group cells and use outlines to manipulate the worksheet
- use Solver to solve more complex and intricate problems
- create recorded macros in Excel
- use the macro recorder to create a variety of macros

Prerequisites

This Excel Excellence Training Course assumes you are very familiar with Microsoft Excel and have knowledge equivalent to that established in the Excel Efficiency course

Other Information

If you need further information contact Startnextweek.com.au on 1300 728 102