Menu

Christmas Sale Get up to 10% off until 25th Decsee the offers

×

GET IN TOUCH

  • This field is for validation purposes and should be left unchanged.
×

GET IN TOUCH

  • This field is for validation purposes and should be left unchanged.
Menu

  • No products in the basket.

Microsoft Excel 2016 Advanced

5( 1 REVIEWS )
810 STUDENTS
ACCREDITED BY
Microsoft Excel 2016 Advanced
Buy Now

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

 

Key Features

Gain an accredited UK qualification

Access to excellent quality study materials

Learners will be eligible for TOTUM Discount Card

Personalized learning experience

One year’s access to the course

Support by phone, live chat, and email

  • 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
  • Job hunters & School leavers
  • College or University students, graduates & Teachers
  • Personal assistant & Receptionist
  • Assistant for company director
  • Office Administrators & Office managers
  • Office clerk, Marketing assistant & Administration Assistant
  • Secretary or Executive
  • Account assistance, Bookkeeper & Accountant
  • IT professionals & Businessman
  • 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.

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

 

This Course is based on Microsoft Excel 2016

 

 

 

  • 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
  • Job hunters & School leavers
  • College or University students, graduates & Teachers
  • Personal assistant & Receptionist
  • Assistant for company director
  • Office Administrators & Office managers
  • Office clerk, Marketing assistant & Administration Assistant
  • Secretary or Executive
  • Account assistance, Bookkeeper & Accountant
  • IT professionals & Businessman
  • 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.

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

 

This Course is based on Microsoft Excel 2016

 

 

 

Course Curriculum Total Units : 33
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
Exercise Files
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
Exercise Files
Mock Exam
Mock Exam: Advanced Microsoft Excel 2016 Training – Online
Final Exam
Exam: Advanced Microsoft Excel 2016 Training – Online
Certificate Download Guide
Certificate Download Guide
WhatsApp chat