Booking options
£10.99
£10.99
On-Demand course
4 hours 25 minutes
All levels
Welcome to the world of Excel 2016 Formulas and Functions, your key to unlocking the full potential of Microsoft Excel. Whether you're a novice or looking to enhance your spreadsheet skills, this course is your passport to becoming an Excel expert. Get ready to excel in Excel!
In this engaging program, you'll embark on a journey through the fundamentals of Excel. You'll learn to navigate Excel commands, create and save workbooks, and enter data efficiently. Dive into the world of formulas and functions, where you'll discover how to create and reuse them effectively. With hands-on activities and customizable options, you'll master Excel like never before, making it an indispensable tool for both personal and professional use.
Learning Outcomes
Navigate Excel commands with ease.
Create and manage basic workbooks.
Efficiently enter data into Excel.
Harness the power of formulas and functions.
Customize Excel to suit your needs.
Unlimited access to the course for a lifetime.
Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course.
Structured lesson planning in line with industry standards.
Immerse yourself in innovative and captivating course materials and activities.
Assessments designed to evaluate advanced cognitive abilities and skill proficiency.
Flexibility to complete the Course at your own pace, on your own schedule.
Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.
Unlock career resources for CV improvement, interview readiness, and job success.
Beginners looking to master Excel.
Professionals seeking to enhance their spreadsheet skills.
Students wanting to excel in data management.
Individuals aiming to boost their productivity.
Anyone eager to unlock the potential of Excel 2016.
Data Analyst: £25,000 - £55,000
Financial Analyst: £30,000 - £70,000
Business Analyst: £30,000 - £70,000
Accountant: £25,000 - £60,000
Project Manager: £35,000 - £80,000
Office Manager: £25,000 - £45,000
This Excel 2016 Formulas and Functions does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.
After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.
Getting Started with Microsoft Excel 2016 | |||
Use Excel Commands | 00:10:00 | ||
Create and Save a Basic Workbook | 00:19:00 | ||
Enter Cell Data | 00:12:00 | ||
Use Excel Help | 00:05:00 | ||
Basic Formulas and Functions | |||
Create Worksheet Formulas | 00:15:00 | ||
Insert Functions | 00:17:00 | ||
Reuse Formulas and Functions | 00:17:00 | ||
Formulas and Functions Activities | |||
Create Formulas in a Worksheet | 01:00:00 | ||
Activity - Create Formulas in a Worksheet | 00:05:00 | ||
Insert Functions in a Worksheet | 00:30:00 | ||
Activity - Insert Functions in a Worksheet | 00:05:00 | ||
Reuse Formulas | 00:30:00 | ||
Activity - Reuse Formulas | 00:05:00 | ||
Customize Formula Options | 00:30:00 | ||
Activity - Customize Formula Options | 00:05:00 | ||
Assignment | |||
Assignment - Excel 2016 Formulas and Functions | 00:00:00 |
Studyhub is a premier online learning platform which aims to help individuals worldwide to realise their educational dreams. For 5 years, we have been dedicated...