Dive into the limitless potential of Excel with Mastering Excel 2016, the ultimate guide to harnessing this powerful software. From mastering complex calculations to crafting visually captivating graphs, this course takes you step by step through all the essentials of Excel 2016. Discover how to manage databases effectively, unlock the secrets of Pivot Tables, and automate tasks using macros—all designed to elevate your productivity and analytical skills. Whether you’re refining your spreadsheet knowledge or starting from scratch, Mastering Excel 2016 equips you with everything needed to handle data with precision and confidence.
Learning Outcomes
After studying the course materials of the Mastering Excel 2016 there will be a written assignment test which you can take either during or 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.
This Mastering Excel 2016 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Mastering Excel 2016 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.
Unit 01: Calculating in Excel | |||
Introduction | 00:01:00 | ||
Selecting Cells | 00:01:00 | ||
Enter Data | 00:01:00 | ||
Columns and Rows | 00:01:00 | ||
Adding Up | 00:01:00 | ||
Horizontal and Vertical Align | 00:01:00 | ||
Copying Formulas | 00:02:00 | ||
Dividing and Multiplying | 00:01:00 | ||
Rows and Columns | 00:03:00 | ||
Unit 02: Function and Graph | |||
Introduction | 00:01:00 | ||
Percentages and Currencies | 00:01:00 | ||
Absolute Reference | 00:01:00 | ||
Cellnames | 00:02:00 | ||
Borders | 00:01:00 | ||
Printing Preview | 00:01:00 | ||
Using Functions | 00:02:00 | ||
Conditional Layout | 00:01:00 | ||
Creating Graphs | 00:01:00 | ||
Multiple Graphs | 00:01:00 | ||
Coloring Graphs | 00:01:00 | ||
Adding Labels | 00:01:00 | ||
Graph Backgrounds | 00:01:00 | ||
What-If Analysis | 00:01:00 | ||
Unit 03: Excel Database | |||
Introduction | 00:01:00 | ||
Freeze Titles | 00:01:00 | ||
Sorting Multiple Items | 00:01:00 | ||
Filtering | 00:01:00 | ||
Multiple Criteria | 00:01:00 | ||
Calculating Dates | 00:02:00 | ||
Automatic Date | 00:01:00 | ||
Print Scaling | 00:01:00 | ||
Headers and Footers | 00:01:00 | ||
Printing Area | 00:01:00 | ||
Unit 04: Subtotals, Pivot Tables and Macros | |||
Introduction | 00:01:00 | ||
Automatic Series | 00:01:00 | ||
Drop-Down List | 00:01:00 | ||
Predicted Words | 00:01:00 | ||
Adding a Warning | 00:02:00 | ||
Subtotals | 00:01:00 | ||
Collapse and Extend Subtotals | 00:01:00 | ||
Pivot Table | 00:01:00 | ||
Changing a Pivot Table | 00:01:00 | ||
Updating Pivot Table | 00:01:00 | ||
Pivot Table Criteria | 00:01:00 | ||
Macros | 00:02:00 | ||
Saving Macro Sheets | 00:01:00 | ||
Opening Macro Sheets | 00:01:00 | ||
Unit 05: Summary | |||
Overall Summary | 00:01:00 |
Master the art of professional document creation and elevate your productivity with Microsoft Word Advanced. This course empowers you to …
0
Step into the world of seamless data management with Microsoft Access for Beginners, your gateway to building, organizing, and analyzing …
0
Step into the world of seamless content creation with The OBS Course for Recording, your gateway to professional-quality video production. …
0