Microsoft Excel 2016 Advanced Training Course

1 Training

Short course

Online

Save 75%
£ 29 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Methodology

    Online

  • Class hours

    5h

  • Duration

    365 Days

Microsoft Excel 2016 Advanced certificate

"Created by a highly skilled professional, this course will guide learners through Microsoft Excel 2016. This computer program is commonly used in the world of work, so no matter what industry you hope to break into, this course will give your CV a boost. Whether you’re someone who is already working, or if you’re just starting out, this course is packed with useful information to help you succeed

This course covers advanced level functions of Microsoft Excel, such as data validation, slicers and timelines, and the running a macro. If you’re someone who has used Excel before, but you don’t know how to get the most out of it, then this course is for you. So, become a master of Excel with 1Training today.

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."

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course





"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)"

If you pass the exam successfully then you will be awarded a Microsoft Excel 2016 Advanced certificate.

Our online programme is well designed that you feel same as you are in the classroom. This course is comprised of professionally narrated e-Learning modules, interactive quizzes, tests and exams. All delivered through a system that you will have access to 24 hours a day, 7 days a week in 365 days (12 months). Effective support service, and study materials including step by step guided tutorial videos build your confidence to study well and guide you to secure your qualification.


On receiving your request, one of our stuff members will call you or send you a message by explaining everything about the course you are requesting information including how you can sign up, payment options, exam and enrollment requirements etc.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2018

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 7 years

Subjects

  • Excel
  • Office IT
  • Microsoft Excel
  • Quality
  • Office Assistant
  • Quality Training
  • Microsoft excel training
  • MS Excel
  • Office Admin
  • Office Executive

Teachers and trainers (1)

Bobby Harty

Bobby Harty

Emmy-nominated composer, audio engineer, record producer, songwriter

Course programme

"

Course Curriculum

1: Text Functions

2: Date & Time Functions

3: Understanding The Functions

4: Working With Vlookup

5: Match & Index Functions

6: Data Validation

7: Protecting Worksheets & Workbooks

8: Working With Templates

9: Exploring Pivot Tables

10: How To Work With A Macro?

11. Conclusion

What skills will I gain?

  • Understand how to work with text functions
  • Understand how to create Macros
  • Learn how to protect worksheets & workbooks
  • Understand how to use the MATCH & INDEX Functions
  • Learn how to apply data validation

Are there any course benefits?

  • Gain an accredited UK qualification
  • Access to excellent quality video tutorials
  • Learners will be eligible for an NUS Discount Card
  • Excellent tutor support Monday-Friday
  • One year’s access to the course
  • Support by phone, live chat, and email
  • Join a friendly online learning platform

What career or progression opportunities are there?

This course allows you to pursue a career in any of the following job roles:

  • Office Administrator (average UK salary according to payscale.com: £17,207)
  • Receptionist (average UK salary according to payscale.com: £15,950)
  • PA (average UK salary according to payscale.com: £27,453)
  • Office Assistant (average UK salary according to payscale.com: £16,100)
  • Executive Assistant (average UK salary according to payscale.com: £30,606)

"

Additional information

How will I be assessed?
At the end of the course learners will take an online multiple choice question assessment test. This online multiple choice question test is marked automatically so you will receive an instant grade and know whether you have passed the course. Those who successfully pass this course will be awarded a free e-certificate, and only need to pay £19 for your printed certificate.

See related categories

Microsoft Excel 2016 Advanced Training Course

£ 29 VAT inc.

The best Excel courses

See all

See all