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
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 |
Have you ever scrolled through social media and been blown away by captivating edits? Maybe it was a seamless transition, …
0
Imagine diving into your photos, not just looking at them. Imagine transporting viewers to the heart of your scene, letting …
0
Imagine transforming your stunning photographs into captivating moving narratives. Learn After Effects for Photography unlocks a world of creative possibilities, …
0