CPD-accredited courses from £39 · Instant e-certificates · 2,700+ courses
CPD-accredited certificates 020 4618 6402 Team training
Home / Courses / Microsoft Office / Excel 2016 Intermediate
CPD course All Levels

Excel 2016 Intermediate

4.9 (9 ratings) 3 enrolled 4h 4m of learning Updated Nov 2026
CertificateOn completion
4h 4mSelf-paced
75 lessonsOn the UISC learning portal
All LevelsNo prior training needed

Course curriculum

1 modules 75 lessons 4h 4m total
01 Excel 2016 Intermediate 75 lessons
  1. Introduction
  2. Customizing the Ribbon
  3. Customizing the Quick Access Tool Bar
  4. Customizing the General and Formula Options
  5. Customzing the Auto Correct Options
  6. Customizing the Save Default
  7. Customizing Advanced Excel Options
  8. Linking Workbooks and Worksheets
  9. Linking Worksheets with 3D References
  10. Understanding the Consolidate Feature
  11. What are Range Names
  12. Creating Range Names Using the Name Box and Define Name
  13. Creating Range Names Using Create from Selection
  14. Working with the Most Common Logical Functions
  15. Evaluate Data with the AND Function
  16. Evaluate Data with the OR Function
  17. Understanding IF Functions
  18. Nesting AND and OR Inside and IF Function
  19. What are Lookup Functions
  20. Using VLookup
  21. Using HLookup
  22. Differences Between Sorting & Filtering
  23. Sorting Lists
  24. Filtering Lists
  25. Creation and Benefits of a Table
  26. Elements of a Table
  27. Formatting a Table
  28. Sorting Tables
  29. Filtering Tables
  30. Filtering with Slicers
  31. Calculating with Tables
  32. Removing Erroneous Table Data
  33. Exporting, Refreshing, Converting Tables
  34. What is Conditional Formatting
  35. Conditional Formatting and Highlight Cells and Top Bottom Rules
  36. Conditional Formatting Data Bars, Icon Sets, and Color Scales
  37. Using Custom Fonts and Colors
  38. Using Custom Conditional Formatting
  39. Modify or Remove Conditional Formatting
  40. What are Subtotals and Grouping
  41. Creating Subtotals
  42. Grouping and Ungrouping Data
  43. What are Charts
  44. Creating Charts
  45. Understanding Chart Elements
  46. Modifying Chart Elements
  47. Changing and Moving Charts
  48. Filtering a Chart
  49. Formatting Charts
  50. Adjusting Numbering
  51. Creating Dual Axis Charts
  52. Forecasting with Trendlines
  53. Creating a Chart Template
  54. Displaying Trends with Sparklines
  55. What is a Pivot Table
  56. Creating a Pivot Table
  57. Working with the Pivot Table Fields Pane
  58. Basic Data Organization and Analysis with Pivot Table
  59. Formatting Pivot Tables
  60. Creating a Pivot Chart
  61. Modifying and Formatting a Pivot Chart
  62. Adding Slicers and Timeline Slicers
  63. Formatting Slicers
  64. What is Flash Fill
  65. Using Flash Fill and Autofill
  66. Filling Various Series
  67. What are Date and Time Functions-
  68. Using TODAY, NOW, and DAY Functions
  69. Using NETWORKDAYS and YEARFRAC Functions
  70. What are Text Functions
  71. Using CONCATENATE
  72. Using Text to Columns
  73. Using LEFT, RIGHT, & MID Functions
  74. Using UPPER, LOWER, & PROPER Functions
  75. Course Recap

About this course

Excel 2016 Intermediate course teaches you everything on the topic thoroughly from scratch so you can achieve a professional certificate for free to showcase your achievement in professional life. This Excel 2016 Intermediate course is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it.

To become successful in your profession, you must have a specific set of skills to succeed in today’s competitive world. In this in-depth training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills.

The training materials of this course are available online for you to learn at your own pace and fast-track your career with ease.

  • Accredited by CPD
  • Instant e-certificate
  • Fully online, interactive course with Professional voice-over
  • Self paced learning and laptop, tablet, smartphone friendly
  • 24/7 Learning Assistance
  • Discounts on bulk purchases

Sneak Peek

Who should take the course

Anyone with a knack for learning new skills can take this Excel 2016 Intermediate course. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions.

Certification

Once you’ve successfully completed your Excel 2016 Intermediate course, you will immediately be sent a digital certificate. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Accreditation

All of our courses, including this Excel 2016 Intermediate course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.

Assessment

At the end of the course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven’t, there’s no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself.

Course Curriculum

Introduction

Customizing Excel

Linking Workbooks and Worksheets

Working with Range Names and Advanced Formulas

Analyzing Data with Common Logical Functions

Analyzing Data with Common Lookup Functions

Sorting and Filtering Range Data

Analyzing and Organizing with Tables

Using Conditional Formatting

Outlining with Subtotals and Grouping

Displaying Data Graphically

Understanding PivotTables and PivotCharts and Filtering with Slicers

Working with Flash Fill

Working with Date and Time Functions

Working with Common Text Functions

Conclusion

Your certificate

CPD certificate — download it when you finish

Issued the moment you complete the final module. Every certificate lists the course aims and objectives, anticipated learning outcomes, the quality-assurance process — the elements required for verifiable CPD. Non-registrants can use it as CQC training evidence and for appraisals.

Aims & objectives Learning outcomes Unique certificate number

Learner ratings

4.9

Rated by 9 learners on the UISC learning portal · 3 enrolled

Common questions

Where do I take the course?

On the UISC learning portal. "Enrol now" takes you to this course there, where you pay securely, get your login and study at your own pace. Your certificate is issued there when you finish.

When can I start?

Immediately. Access opens the moment your order is confirmed and you can learn from any device, in any order, as many times as you like.

How is the course assessed?

A short multiple-choice or scenario-based assessment at the end of the course with instant results. You can retake it as many times as you need at no extra cost.

Can I enrol my whole team?

Yes. Organisations can buy multiple places on one invoice and receive a training record for every learner. Contact us for team pricing.

Keep learning

Related courses

More in Microsoft Office
Data Analysis In Excel
Save 86%
31 lessons
Microsoft Office 4h 51m

Data Analysis In Excel

16 others bought this course in the last 24 hours! Data Analysis In Excel teaches you everything on the topic thoroughly from scratch so you can achieve a profe...

4.7 (7) 4 enrolled
£39.00 £279.00
Enrol now
Microsoft Excel
Save 86%
23 lessons
Microsoft Office 4h 17m

Microsoft Excel

Microsoft Excel Training Course is designed for data coordinators, accounts assistants, administrative professionals or any individual who wants to brush up the...

4.9 (9) 4 enrolled
£39.00 £279.00
Enrol now
£39.00 4h 4m · All Levels
Enrol now