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