1. Home
  2. Courses
  3. Information Technology
  4. Microsoft Office
  5. FREE Microsoft Excel 2016 - Advanced

FREE Microsoft Excel 2016 - Advanced

Advanced 5 (2 Ratings) 51 Students Enrolled
ACCREDITED BY CPD
FREE Microsoft Excel 2016 - Advanced Preview this course
FREE
Gift this course
Course Includes:
  • Accredited By: CPD
  • Course Level: Advanced
  • Course Duration: 365 Days
  • Number of Modules: 11
  • Guided Learning Hours: 5
  • Course Certificate: At completion
  • Assessment Included:
  • Course Material:
Training 5 or more people?

Get your team access to 600+ top NLA courses anytime, anywhere.

Try NLA for Business
Key Features

Asynchronous Learning

Easy Navigation

Support by Phone, Live Chat and Email

FREE Student ID Card

FREE Printed Certificates

42 Hrs Instructor-led Training
28 Hrs Self-paced Videos
56 Hrs Project Work & Exercises
Flexible Schedule
24 x 7 Lifetime Support & Access
Certification and Job Assistance
What Will I Learn?
  • Learn how to change print settings and print a document
  • Learn to navigate the Excel 2016 interface effectively
  • Learn to navigate, format and select texts
  • Learn to create, open and save documents
  • Understand how to work and customise the  quick access toolbar
Description

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 Next Learn Academy today.

Learning with Next Learn Academy has many advantages. The course material is delivered straight to you, and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand.

Why You Should Learn at Next Learn Academy?

Next Learn Academy is a leading online provider for several accrediting bodies, and provides learners the opportunity to take this exclusive CPD Course.  At Next Learn Academy, we give our fullest attention to our learners’ needs and ensure they have the necessary information required to proceed with the Course.   Learners who register  for their choice of course will be provided excellent support, discounts for future purchases and be eligible for a TOTUM Discount card and Student ID card with amazing offers and access to retail stores, the library, cinemas, gym memberships and their favourite restaurants. 

  • Learners should be over the age of 16, and have a basic understanding of English, ICT and numeracy.
  • A sound educational background is recommended

This course is recommended for,

  • Individuals interested in learning Excel 2016 for the first time
  • Anyone who wants to take a refresher course in Excel 2016
  • Individuals working in an office environment like Admin Assistants, PA’s, Executive Assistants and Secretaries

At the end of the course, learners will take an online multiple choice questions assessment test. This online multiple choice questions assessment test is marked automatically so that you will receive an instant grade and know whether you have passed the course. 
 

Upon the successful completion of the course, you can order a printed official certificate for free (Postage Excluded). The ‘Microsoft Excel 2016 - Advanced’ certificate awarded by CPD.

(We do not provide an E-Certificate for free courses.)

Benefits of taking this Free Course

Once you successfully complete the Free Microsoft Excel 2016 Advanced, it will demonstrate your understanding of how to use Microsoft Excel 2016 Advanced effectively in your place of work. The course will give you the confidence to apply Word in your day to day tasks, and your new-found skills and knowledge will impress your current employer or potential employers, in the process.

  • Learners should be over the age of 16, and have a basic understanding of English, ICT and numeracy.
  • A sound educational background is recommended

This course is recommended for,

  • Individuals interested in learning Excel 2016 for the first time
  • Anyone who wants to take a refresher course in Excel 2016
  • Individuals working in an office environment like Admin Assistants, PA’s, Executive Assistants and Secretaries

At the end of the course, learners will take an online multiple choice questions assessment test. This online multiple choice questions assessment test is marked automatically so that you will receive an instant grade and know whether you have passed the course. 
 

Upon the successful completion of the course, you can order a printed official certificate for free (Postage Excluded). The ‘Microsoft Excel 2016 - Advanced’ certificate awarded by CPD.

(We do not provide an E-Certificate for free courses.)

Benefits of taking this Free Course

Once you successfully complete the Free Microsoft Excel 2016 Advanced, it will demonstrate your understanding of how to use Microsoft Excel 2016 Advanced effectively in your place of work. The course will give you the confidence to apply Word in your day to day tasks, and your new-found skills and knowledge will impress your current employer or potential employers, in the process.

FREE Microsoft Excel 2016 - Advanced Preview this course
X
FREE
Gift this course
Course Includes:
  • Accredited By: CPD
  • Course Level: Advanced
  • Course Duration: 365 Days
  • Number of Modules: 11
  • Guided Learning Hours: 5
  • Course Certificate: At completion
  • Assessment Included:
  • Course Material:
Training 5 or more people?

Get your team access to 600+ top NLA courses anytime, anywhere.

Try NLA for Business
Program Fee
Starting @

?22,000/month

Total Program Fee ?3,25,000

Get a chance to win a scholarship up to Rs.1.10 Lakhs

APPLY FOR SCHOLARSHIP
Curriculum
11 Sections
21 Lectures

01: Text Functions

  • Text Functions (FREE Microsoft Excel 2016 Advanced)

02: Date & Time Functions

  • Date & Time Functions (FREE Microsoft Excel 2016 Advanced)

03: Understanding the functions

  • Module 3 - Recap
  • Module 3 - Nested IF with =MAX() Function
  • Module 3 - Part 3 - Max & Ifs - & And & OR Using If Function
  • Module 3 - Nested IF with multiple Ifs
  • Module 3 - IF functions with =AND() & =OR() functions

04: Working with VLOOKUP

  • Module 4- VLOOKUP To find the nearest match
  • Module 4 - VLOOKUP To find an exact match

05: Match & Index Functions

  • Module 5 - MATCH & INDEX Functions

06: Data Validation

  • Data Validation

07: Protecting Worksheets & Workbooks

  • Protecting Worksheets & Workbooks

08: Working With Templates

  • Working With Templates

09: Exploring Pivot Tables

  • Creating, rearranging and updating a Pivot Table
  • Filtering and grouping data in a Pivot Table
  • Slicers and timelines
  • Creating a Pivot chart

10: How to work with a Macro?

  • Recording a macro in a macro-enabled workbook (using relative references)
  • Running a macro and assigning it to objects
  • Editing and deleting a macro

11: Conclusion

  • Excel 2016 - Conclusion

Exams

Top Companies Trust Next Learn Academy
Get your team access to Next Learn Academy's top 600+ courses
Try NLA for Business

Preview Certificate and Apply for Student ID Card

Student Feedback
5
Average Rating
  • 100%
  • 0%
  • 0%
  • 0%
  • 0%
Reviews
  • CB
    Fri, 02-Oct-2020
    Connie Brown
    Very good
    Very good course. Useful information and materials. Helpful for data analyst.
  • AGMA
    Wed, 24-Aug-2022
    ABDUL GAFOOR MOHAMED ASFAK
    Hdjdf
    Chchch

Top Business Associates choose Next Learn Academy