Mastering Excel 2016 is a must for anyone looking to unlock the full potential of this powerful tool. Dive deep into the intricate world of Excel as you explore its advanced functionalities designed to make data management, calculations, and reporting a breeze. With Mastering Excel 2016, you’ll not only learn to manipulate cells and functions but also master the art of creating dynamic graphs, filtering data, and working with pivot tables to analyze vast amounts of information effortlessly. Whether you’re a beginner aiming to build a strong foundation or someone seeking to refine your Excel skills, this course offers a structured approach that will transform you into a proficient user of Excel. You’ll delve into essential features like sorting, filtering, formulas, and even macros, enhancing your ability to work efficiently. Mastering Excel 2016 will empower you to automate tasks, improve data accuracy, and present insights clearly through well-designed charts. By the end of the course, you’ll gain confidence in using Excel’s advanced features to make data-driven decisions, all while enjoying a comprehensive understanding of the software. Join us and take your Excel skills to the next level with Mastering Excel 2016.
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 |
Dive into the world of persuasive writing with Content Writing & Copy Writing For SEO and Sales, a course designed …
0
Instagram Ads Success puts the power of Instagram advertising at your fingertips, offering you the strategies and tools to unlock …
0
Transform your creative vision into stunning designs with Creating and Branding with Canva Advanced Level. This course is a game-changer …
0