Excel 2008 – Advanced

Overview:

During this excellent Microsoft Excel 2008 – Advanced course is intended to give you an advanced understanding of how to use Excel 2008. If you’re an intermediate level user of Excel 2008, or if you’ve just updated to Excel 2008, then this course contains all the information you need, and it will help you to get up to speed with all the advanced features of Excel 2008. Learners of this 2008 – Advanced course will be taught by an expert instructor who has years of experience and tons of insider tips and tricks to share with you. Be guided through all the advanced features of Excel 2008, like how to link and consolidate worksheets, how to share data with Word, how to work with custom number formats.

Our courses couldn’t be more convenient, the course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand. This course is comprised of professional learning material, all delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months).

What skills will I learn?

• Learn to work with templates
• Learn to work with dates and times
• Learn to work with custom number formats
• Learn to link and consolidate worksheets

Course outline:

• Module 01: Templates
• Module 02: Working with Dates and Times
• Module 03: Custom Number Formats
• Module 04: Advanced Charting
• Module 05: Data Validation
• Module 06: Sorting and Filtering
• Module 07: Outlines
• Module 08: Linking and Consolidating Worksheets
• Module 09: What-if Analysis
• Module 10: Workbook Protection
• Module 11: Auditing and Error Checking
• Module 12: Sharing Data with Word

What are the requirements?

• You must be 16 or over
• You should have a basic understanding of English, Maths and ICT
• You will need a computer or tablet with internet connection (or access to one)

How will I be assessed?

• You will have one assignment. Pass mark is 65%.
• You will only need to pay £19 for assessment and certification.
• You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days.

Certification:

Successful candidates will be awarded a Microsoft Excel 2008 – Advanced certificate.

Career Path:

This excellent Microsoft Excel 2008 – 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