• No products in the basket.

  • LOGIN

Login

  • 17 Students

  • Certified

Introduction

There are a few binding skills that employers always look for before selecting a person into the company process – Excel is one of them. By enrolling in this Excel 2016 Advanced Formulas and Functions course, you can go from a primary level user to an expert level user of Excel.

Course description

This course will teach you more than 450 formulas and advanced functions in Excel, following with how to apply these functions in formulas within spreadsheets, and gain a firm understanding of the spreadsheet interface and how to intensify your calculation skills.

Moreover, you will learn to do a lot in numerical computation, data presentation, static reports arrangement, printing, and more.

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Video lessons
  • Online study materials

How is the course assessed?

This course does not involve any assessment.

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and a Hardcopy Certificate for £15.

Why study this course

Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.

The Excel 2016 Advanced Formulas and Functions is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

Course Curriculum

Advanced Functions
Work with Ranges 00:18:00
Use Specialized Functions 00:11:00
Work with Logical Functions 00:23:00
Work with Date & Time Functions 00:08:00
Work with Text Functions 00:11:00
Working with Lists
Query Data with Database Functions 00:09:00
Outline and Subtotal Data 00:09:00
Using Lookup Functions and Formula Auditing
Use Lookup Functions 00:12:00
Trace Cells 00:05:00
Watch and Evaluate Formulas 00:08:00
Automating Workbook Functionality
Search for Invalid Data and Formulas with Errors 00:04:00
Troubleshoot Invalid Data and Formula Errors 00:15:00
Other Functions and Formulas
Use Text Functions 00:30:00
Use Specialized Functions 00:30:00
Use Date Functions 00:30:00
Use Financial Functions 00:30:00
Automate SUM Functions 00:30:00
  • £425.00 £25.00 ex Vat
  • 1 year
  • Number of Units17
  • Number of Quizzes0
  • 4 hours, 43 minutes

Course Reviews

No Reviews found for this course.

Certifications

Get accredited certificates

New skills

Add skills to your CV

Exams

Test your skills

Dedicated Support

for any questions

Set your own speed

Self-paced learning

Enjoy first 7 days free

Start for free

COPYRIGHT © 2021 One Education