£49.00
Course Includes:
- Accredited By: CPD
- Course Level: Certificate
- Course Duration: 365 Days
- Number of Modules: 26
-
Guided Learning Hours:
14
- 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 BusinessKey Features
Asynchronous Learning
Easy Navigation
Support by Phone, Live Chat and Email
FREE Student ID Card
FREE Printed Certificates
What Will I Learn?
- You will learn beginner, intermediate and advanced features and functions of Microsoft Excel 2016.
- Learn what it takes to deal with guests’ questions and queries, while working in the front of house operations.
- Learn about conditional formatting, creating tables and the quick analysis button.
- Learn to navigate through the software with ease.
- Learn different formulas which could be beneficial to your day to day operations.
- Gain expert skills in Excel 2016.
- Learners should be over the age of 16 and have a basic understanding in Maths, English and ICT
- You will need Microsoft Excel 2016 installed onto your computer, tablet, laptop
This course is introduction level, so will be suitable for those who have never used Excel before, or who would like an introduction to the programme.
At the end of the Microsoft Excel 2016 (Beginner to Advanced), learners will also take an online multiple choice questions assessment test. This online multiple choice questions test is marked automatically so you will receive an instant grade and know whether you have passed the course.
Those who successfully complete the course will be awarded the Certificate in Microsoft Excel 2016 (Beginner to Advanced) - Level 2 by CPD. It will make you valuable to employers, and your motivation at gaining new skills will be recognised.
Receive a Printed Certificate absolutely FREE, with applicable delivery fee
Access Duration
The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course. The course is self-paced and you can complete it in stages, revisiting the lectures at any time.
Awarding Body
CPD is an internationally recognised accrediting body that will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in an enterprise.
Other Benefits
- High-quality e-learning study materials.
- Tutorials/materials from industry-leading experts.
- 24/7 Access to the Learning Portal.
- Recognised Accredited Certification
- Learners should be over the age of 16 and have a basic understanding in Maths, English and ICT
- You will need Microsoft Excel 2016 installed onto your computer, tablet, laptop
This course is introduction level, so will be suitable for those who have never used Excel before, or who would like an introduction to the programme.
At the end of the Microsoft Excel 2016 (Beginner to Advanced), learners will also take an online multiple choice questions assessment test. This online multiple choice questions test is marked automatically so you will receive an instant grade and know whether you have passed the course.
Those who successfully complete the course will be awarded the Certificate in Microsoft Excel 2016 (Beginner to Advanced) - Level 2 by CPD. It will make you valuable to employers, and your motivation at gaining new skills will be recognised.
Receive a Printed Certificate absolutely FREE, with applicable delivery fee
Access Duration
The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course. The course is self-paced and you can complete it in stages, revisiting the lectures at any time.
Awarding Body
CPD is an internationally recognised accrediting body that will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in an enterprise.
Other Benefits
- High-quality e-learning study materials.
- Tutorials/materials from industry-leading experts.
- 24/7 Access to the Learning Portal.
- Recognised Accredited Certification
£49.00
Course Includes:
- Accredited By: CPD
- Course Level: Certificate
- Course Duration: 365 Days
- Number of Modules: 26
-
Guided Learning Hours:
14
- 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 BusinessProgram Fee
Starting @
Total Program Fee
?3,25,000
?22,000/month
Get a chance to win a scholarship up to Rs.1.10 Lakhs
Curriculum
30 Sections
38 Lectures
-
Microsoft Excel 2016 Introduction
-
Module One - Introduction to Excel
-
Module Two - Creating a worksheet
-
Module Three - Managing workbooks
-
Module Four - Formulas and basic functions
-
Module Five - Spreadsheet presentation
-
Module Six - Rearranging data
-
Module Seven - Printing
-
Module One - Statistical And Logical Functions
-
Module Two - Working With Multiple Sheets & Books
-
Module Three - Sorting, Filtering & Subtotaling Lists
-
Module Four - Conditional Formatting
-
Module Five - Charts
-
Module Six - Using The Worksheet Efficiently
-
Module Seven - Printing Large Spreadsheets
-
Module Eight - The Quick Analysis Button 8
-
Module 1 - Text Functions
-
Module 2 - Date & Time Functions
-
Module 3 - Part 1 - Recap
-
Module 3 - Part 2 - Nested IF with =MAX() Function
-
Module 3 - Part 3 - Max & Ifs - & And & OR Using If Function
-
Module 3 - Part 4 - Nested IF with multiple Ifs
-
Module 3 - Part 5 - IF functions with =AND() & =OR() functions
-
Module 4 - Part 1 - VLOOKUP To find the nearest match
-
Module 4 - Part 2 - VLOOKUP To find an exact match
-
Module 8 - Working With Templates
-
Module 5 - MATCH & INDEX Functions
-
Module 6 - Data Validation
-
Module 7 - Protecting Worksheets & Workbooks
-
Working With Templates - Microsoft Excel 2016 (Beginner to Advanced)
-
Module 9 - Part 1 - Creating, rearranging and updating a Pivot Table
-
Module 9 - Part 2 - Filtering and grouping data in a Pivot Table
-
Module 9 - Part 3 - Slicers and timelines
-
Module 9 - Part 4 - Creating a Pivot chart
-
Module 10 - Part 1 - Recording a macro in a macro-enabled workbook (using relative references)
-
Module 10 - Part 2 - Running a macro and assigning it to objects
-
Module 10 - Part 3 - Editing and deleting a macro
-
Module 11 - Conclusion
Preview Certificate and Apply for Student ID Card
Enlarge Certificate View
Student Feedback
Reviews
-
JCTue, 09-Jun-2020Justice CampbellGood Coursevery informative and well organized.
Top Business Associates choose Next Learn Academy
