Microsoft Excel 2010 - Advanced
Who is the course for?
This course is ideal for those who have intermediate Microsoft Excel skills and want to learn the advanced features. Participants will learn data linking, Pivot Tables, Pivot Charts, grouping and outlining, solver, and working with macros. Participants will be able to produce complex spreadsheets.
What is Microsoft Excel?
Microsoft Excel is a widely used program that is used to create and format spreadsheets. This course focuses on advanced spreadsheet production using Microsoft Excel 2010, part of the Microsoft Office 2010 suite, which is used in the majority of enterprises.
What skills will I learn?
- Use lookup functions
- Set the default options
- Format objects
- Use labels and names
- Protect data
- Summarising and subtotaling
- Linking between workbooks
- Working with PivotTables
- Understand grouping and outlining
- Run solver reports
- Work with macros
- Prepare data for an application
What are the benefits?
- Become a better job candidate
- Work with advanced spreadsheets
- Become a more effective worker
- Develop your software application skills
Modules
- Look up functions
- Setting Excel options
- Chart Object formatting
- Labels and names
- Protecting data
- Summarising and subtotaling
- Data linking
- Data consolidation
- Pivot Tables
- Pivot Table techniques
- Pivot Charts
- Goal seeking
- Grouping and outlining
- Solver
- Recorded macros
- Recorder workshops
Click here to download the full course guide.
Why study with us?
- Experienced RTO
- CBD located training centres
- Modern facilities
- Qualified trainers
- On-site training available for groups
For more about our training methodology click here
