Microsoft Excel 2007 Advanced Course

Course Curriculum

1: Summarizing Data

2: Working With Pivot Tables

3: Charting In Excel

4: Getting Visual

5: Creating Powerful Formulas

6: Recording Macros

7: Tips & Tricks

What skills will I learn?

• Learn how to sort and filter data faster in Excel 2007. You can even sort or filter by colour.
• Master pivot tables to summarise a million rows of transactional data into a flexible summary without writing a single formula.
• Reduce repetitive tasks to a single mouse click by creating a macro. Plus, find out why most recorded macros don’t work and the one setting to change to allow many recorded macros to work.
• See how to use the three new charting ribbon tabs to quickly format a chart or how to use the dialog boxes to coax charts out of Excel that don’t look like Excel charts. You’ll discover how to make charts in your company’s colours with one keystroke.
• Create a report for every customer or department with a couple of mouse clicks. Learn five ways to summarise data and when to use each method

Career Path:

This excellent Excel 2007: Advanced course will qualify you to be an Executive Assistant. As an Executive Assistant you’ll usually be working in an office as part of a team, you’ll work under more senior members of staff and can work your way up the company, so pay will go up with experience. The average salary of an Executive Assistant in the UK is £30,627, and this will go up with experience (payscale.com). With this course you could fulfil any of the following roles:

• Executive Assistant
• Office Assistant
• Accounts Assistant
• Administrator
• PA