Microsoft Excel 2007 Advanced
Microsoft Excel 2007 Advanced
Course info
This course is ideal for a person with a strong working knowledge of Microsoft Excel, who is seeking to become familiar with the advanced functions of the software. At the conclusion of this course, participants should have a very comprehensive understanding of MS Excel and its application.
Course Pre-requisites
Participants should be familiar with working in a Windows environment and have a general computer working knowledge. One should also have a sound knowledge of Microsoft Excel.
Lessons:
- Lookup Functions
- Setting Excel Options
- Chart Object Formatting
- Labels and Names
- Protecting Data
- Summarising and Subtotalling
- Data Linking
- Data Consolidation
- Pivot Tables
- PivotTable Techniques
- PivotCharts
- Goal Seeking
- Grouping and Outlining
- Solver
- Recorded Macros
- Recorder Workshop
Course Delivery
Scheduled Courses In-House and On-Site, Customised Courses
Work Load | One Full Day Course | 9:00am 4:00pm | Total Duration 7 hours
Buy Today
Contact UsFree Info Pack