Excel 2016 for PC – Frequently Used Formulas & Functions

Product type
Level

Excel 2016 for PC – Frequently Used Formulas & Functions

1TRAINING
Logo 1TRAINING

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

Description

Overview:

This excellent Excel 2016 for PC – Frequently Used Formulas & Functions course will get you up to speed with the formulas and functions of Excel 2016. The course will teach you the common uses for a variety of formulas in Excel. Additionally, we’ll cover how to alter formulas and check for errors. 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 c…

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 2016 for PC – Frequently Used Formulas & Functions course will get you up to speed with the formulas and functions of Excel 2016. The course will teach you the common uses for a variety of formulas in Excel. Additionally, we’ll cover how to alter formulas and check for errors. 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?

  • Learn to use Excel’s formulas and functions, like MAXIFS and MINIFS
  • Learn to link and consolidate worksheets, including how to consolidate commands
  • Learn to audit and error check, including how to evaluate and check for errors
  • Learn to use SUM, AVERAGE, TRANSPOSE, LOOKUP, and HLOOKUP functions

Course outline:

  • Module 01: Getting Started & What’s New
  • Module 02: Formulas
  • Module 03: Linking and Consolidating Worksheets
  • Module 04: Auditing & Error Checking

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 2016 for PC – Frequently Used Formulas & Functions 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
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.