Excel 2011 – Advanced

Product type
Level

Excel 2011 – Advanced

1TRAINING
Logo 1TRAINING

Need more information? Get more details on the site of the provider.

Description

Overview:

This excellent Excel 2011 – Advanced course will get you up to speed with Excel 2011, whether you’re an intermediate user of Excel, or you need to get to know the advanced features of Excel 2011, there is something for you to learn. The course will teach you the complex techniques such as how to link and consolidate data within a single workbook or between multiple workbooks, use Goal Seek and Scenarios, protect your data, and share Excel data with Microsoft Word. This course is taught by an expert instructor with years of experience, who has an abundance of insider knowledge to share with you.

Our learning material is available to students 24/7 anywhere in the world, so it’s ext…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Overview:

This excellent Excel 2011 – Advanced course will get you up to speed with Excel 2011, whether you’re an intermediate user of Excel, or you need to get to know the advanced features of Excel 2011, there is something for you to learn. The course will teach you the complex techniques such as how to link and consolidate data within a single workbook or between multiple workbooks, use Goal Seek and Scenarios, protect your data, and share Excel data with Microsoft Word. This course is taught by an expert instructor with years of experience, who has an abundance of insider knowledge to share with you.

Our learning material is available to students 24/7 anywhere in the world, so it’s extremely convenient. These intensive online courses are open to everyone, as long as you have an interest in the topic! We provide world-class learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date.

What skills will I gain?

  • Understand data validation, auditing and error checking
  • Enhance the data in your workbook
  • Learn to create custom date, time and number formats
  • Use data validation rules, create advanced sorting and filtering options

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.
  • You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days

What Certification am I going to receive?

Those who successfully pass this course will be awarded a Excel 2011 – Advanced certificate. Anyone eligible for certification will receive a free e-certificate, and printed certificate.

What careers can I get with this qualification? 

With this course, you are able to fulfil various roles, such as:

  • Administration
  • Reception
  • Accounting
  • Bookkeeping
  • Business ownership
  • PA professionals

Please note: We do not provide any software with this course.

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.