Skip to content

Microsoft Excel Advanced - 2016

ACCREDITED BY CPD & IAP | Free Digital Certificate Included | Unlimited Access 365 Days | Quality e-Learning Materials

1 Training

Summary

Price
£14 inc VAT
Study method
Online
Duration
15 hours · Self-paced
Access to content
365 days
Qualification
No formal qualification
CPD
15 CPD hours / points
CPD What's this?
Additional info
  • Exam(s) / assessment(s) is included in price
  • Tutor is available to students

Overview

Certificate in Microsoft Excel 2016 Advanced

Do you need to get to grips with Excel 2016?Course Description:

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organised with checklists. This course is advanced level, so will be helpful for those who have some experience of Microsoft Excel.

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 how to manage cell contents in a worksheet
  • Learn how to create financial reports
  • Understand accounting formulas, functions & specialised functions
  • Learn cell attributes & cell formatting
  • Gain a full understanding of printing excel sheets
  • Logging in to this course, you’ll learn how to insert & modify graphic objects
  • Learn conditional formatting and data validations
  • Learn how to export, import & integrate data with other sources

CPD

15 CPD hours / points
Accredited by The CPD Certification Service

Course media

Description

Course Duration:

Learners will have 365 days access to their chosen course. The course is self-paced so you decide how fast or slow the training goes. If you need to extend your course access duration, it can be done at any time by extending your subscription.

COURSE CURRICULUM

MICROSOFT EXCEL 2016 - BEGINNER

  • Getting Started with Microsoft Excel
  • Data Entering
  • Creating Formulas and Functions
  • Formatting
  • Worksheet Views, Multiple Worksheets and Workbooks
  • IF, VLOOKUP, and Power Functions, Security & Sharing
  • Data Management, Data Analysis Tools
  • PivotTables & Macros
  • Exercise Files: Microsoft Excel 2016

MICROSOFT EXCEL 2016 - ADVANCE FORMULAS & FUNCTIONS

  • Introduction to Excel 2016 Advance Formula and Functions
  • Values and Formulas
  • Operations in Formulas
  • IF, AND, OR and NOT Functions
  • VLOOKUP and HLOOKUP
  • Tabulating Data and Multiple Criteria
  • Median, Mode and Ranking Data
  • Date, Time and Functions
  • Array Formulas and Frequency Functions
  • OFFSET and INDIRECT Function
  • Different TEXT & Information Functions

MICROSOFT EXCEL 2016 - ADVANCE FORMATING AND TECHNIQUES

  • Introduction to Excel Advance Formatting & Techniques
  • Adjust Fonts, Font Sizes & Font Colours
  • Adjust Cells and Tools
  • Work with Formulas & Tables
  • Adjust Row, Columns and Sheets
  • Different Formatting Styles and Set up Data for Outlines
  • Formatting Picture Styles
  • Formatting Techniques – Restore Missing Data in a Column

Method of Assessment

  • 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

Certificate

Upon the successful completion of the course, you will be awarded the “Certificate in Microsoft Excel 2016 Advanced Training”.

Who is this course for?

  • Job hunters & School leavers
  • College or University students, graduates & Teachers
  • Personal assistant & Receptionist
  • Assistant for company director
  • New or Temporary staff
  • Office Administrators & Office managers
  • Office clerk, Marketing assistant & Administration Assistant
  • Secretary or Executive
  • Account assistance, Bookkeeper & Accountant
  • IT professionals & Businessman

Requirements

  • You must be 16 or over
  • You should have a basic understanding of English and basic IT knowledge
  • You will need a computer or tablet with internet connection (or access to one)
  • Learners must have Microsoft Excel 2016 installed onto their computer

Career path

  • Completing this training course will show any potential employer that you are comfortable and confident with using key Microsoft Excel applications.
  • This Qualification is helpful for any Office job, such as PA, Secretary, and Administrator or any other role in the office environment. Being able to demonstrate you have a high level of Microsoft Office skills will help you stand out to employers.

Questions and answers

No questions or answers found containing ''.

Student asked:

What version of Excel do you need to take this course? I have the 365 suite?

Answer:

Dear Student, Thank you for your Query. Yes with 365 Suite will be able to take this course. Regards, Student Support Team

This was helpful. Thank you for your feedback.
proton asked:

hi, if the online multiple-choice question assessment test at the end of course is not passed is there the possibility of a free re-sit? thanks.

Answer:

Dear Sir/Ma'am Thank you very much for your query. There is very less chance for you to get failed as all the study material are well structured and you will recieve tutor support aswell to complete successfully. However you can retake the exams upon small subscription. Hurry up to grab the discount as it ends soon. Regards, Student Support Team.

This was helpful. Thank you for your feedback.
proton asked:

hi, what exactly is 12 cpd hours in terms of ordinary hours. is it the same number of hours, ie 12 hours? thanks.

Answer:

Dear Sir/Ma'am Thank you very much for your query. Course duration is 15 Hours and this has 12 CPD hours / points. Hurry up to grab the discount as it ends soon. Regards, Student Support Team.

This was helpful. Thank you for your feedback.
Justyna asked:

Good evening I have a question if I am not a student can use this course?

Answer:

Dear Justyna Thank you very much for your query. The only requirement for you to study this course is that you need a computer or tab with an internet connection and Microsoft Office software installed in it. Also, it’s better to have a notepad and a pen with you. Pay and enroll today before the discount end tomorrow. Regards, Student Support Team.

This was helpful. Thank you for your feedback.
Ask a question

Reviews

3.3
Course rating
60%
Service
60%
Content
80%
Value

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Online courses

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2024. All rights reserved.