Learn Excel 2016 with formulas, charts, data analysis, pivot tables, macros and productivity tools for workplace success.
( 29 Reviews )
277 Students
Mastering Excel 2016 is a comprehensive learning programme designed to develop confident spreadsheet management, calculation, reporting and data-handling abilities. This Excel 2016 course begins with essential navigation, cell selection, data entry and formulas before progressing towards functions, charts, filtering, PivotTables, What-If Analysis and macros. Furthermore, learners explore formatting, printing, automated lists, data validation and workbook organisation. As a result, the programme provides a structured route from Excel 2016 for beginners towards more capable workplace spreadsheet usage, while introducing valuable advanced Excel 2016 skills.
Turn everyday spreadsheet tasks into organised, efficient workflows with Mastering Excel 2016. This comprehensive Microsoft Excel 2016 training introduces the core tools needed to create, format and manage professional workbooks. First, learners explore cells, rows, columns, data entry, alignment, formulas, percentages and currencies. They then progress through Excel formulas and functions, absolute references, named cells and conditional layouts, creating a strong foundation for confident spreadsheet work. The programme also works well as an Excel spreadsheets course for anyone seeking structured development.
Next, the curriculum moves into visual reporting and information management. Learners discover Excel charts and graphs, multiple chart formats, labels, backgrounds and What-If Analysis. In addition, sorting, filtering, multiple criteria, date calculations and printing controls support more organised reporting. Consequently, the course introduces valuable Excel data analysis training concepts that can be applied to administrative, commercial and analytical tasks. The structured lessons also reinforce Microsoft Office Excel training across common workplace requirements.
Finally, learners explore automatic series, drop-down lists, warnings, subtotals and PivotTables, followed by macro creation and macro-sheet management. Therefore, the programme supports stronger Excel productivity skills while extending the learner’s toolkit beyond basic spreadsheet use. Whether starting with Excel 2016 for beginners content or developing advanced Excel 2016 skills, participants can build a broader approach to workbook creation, reporting and data organisation.
Once the Mastering Excel 2016 is successfully completed, the learner can obtain the PDF certificate without any cost. The hard copy of the certificate is also available for £4.99. However, anyone ordering the hard copy certificate from outside the United Kingdom may incur an additional delivery charge.
Data Analyst
Analyse structured datasets, prepare reports and present findings using spreadsheet-based analytical methods.
Average Salary: £45,000 – £60,000 per year
Business Analyst
Evaluate business information, identify trends and support organisational decisions through structured reporting.
Average Salary: £50,000 – £70,000 per year
Management Accountant
Prepare financial information, monitor budgets and produce analytical reports for business planning.
Average Salary: £45,000 – £65,000 per year
Financial Analyst
Assess financial data, develop forecasts and support commercial decisions through numerical analysis.
Average Salary: £50,000 – £70,000 per year
Reporting Analyst
Create recurring reports, organise datasets and communicate key performance information to stakeholders.
Average Salary: £42,000 – £58,000 per year
Operations Analyst
Review operational information, identify process trends and support efficiency-focused business decisions.
Average Salary: £45,000 – £62,000 per year
This course is suitable for beginners, office professionals, administrators, students, and anyone looking to improve their Microsoft Excel 2016 skills.
You will learn formulas, functions, data entry, formatting, charts, filtering, sorting, Pivot Tables, What-If Analysis, and basic macros.
No. The course begins with essential Excel features, making it suitable for learners starting with Excel 2016.
Yes. It covers useful Excel productivity skills for organising data, performing calculations, analysing information, creating reports, and presenting results clearly.
Yes. Excel skills are valuable across administration, finance, sales, business operations, data analysis, and many other UK workplace roles.
An outstanding online course with clear explanations and practical examples. I could study at my own pace and still feel fully supported throughout. It’s truly boosted my confidence and career prospects
The course was well-structured, engaging, and easy to follow. The flexibility made it perfect alongside my full-time job. I’ve gained valuable, real-world skills that I can apply immediately.
Excellent learning experience from start to finish. The content was professional, up-to-date, and highly relevant. I would highly recommend it to anyone looking to upskill online.
| 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 | ||
| Assignment | |||
| Assignment – Mastering Excel 2016 | 00:00:00 | ||
Yes, Discover Training provides accredited and CPD-certified courses, ensuring learners receive recognised qualifications that support career progression and professional compliance.
Anyone can enrol, including students, professionals, job seekers, career changers, and organisations. Most courses do not require previous experience, making them accessible to learners at all levels.
Discover Training offers courses across multiple sectors, including business, health and safety, compliance, leadership, IT, personal development, and professional skills training.
You will have 14 days to revoke your Course purchase from your purchase date. Regrettably, refunds are not allowed after your purchase have been approved, and materials have been posted to the student’s dashboard or accessed.
Yes, learners receive a downloadable digital certificate upon successful completion, suitable for CPD records, CVs, and professional portfolios.
14-Day Money-Back Guarantee