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 Introduction
CPD course All Levels

Excel 2016 Introduction

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

Course curriculum

1 modules 66 lessons 3h 46m total
01 Excel 2016 Introduction 66 lessons
  1. Introduction
  2. What is Excel
  3. Opening Excel
  4. Navigating the Excel User Interface
  5. Using the Excel Ribbon
  6. Understanding Excel Work Components
  7. Using the Backstage View
  8. Creating a New Workbook
  9. Creating Workbooks Using Templates
  10. Saving an Excel Workbook
  11. Using Convert and Checking Compatiblity
  12. Navigating a Worksheet by Mouse or Keyboard
  13. Excel Data Types
  14. Cell and Range Addressing
  15. Data Selection Techniques
  16. Common Excel Commands
  17. Using the Autofill Handle
  18. What are Formulas and Functions
  19. Components of a Formula
  20. Calculation Hierarchy Using the Order of Operations_Revise
  21. Creating Basic Formulas
  22. Working with Basic Functions and Autosum
  23. Using Cell References
  24. Using the Quick Analysis Tool
  25. Modifying Columns and Rows
  26. Hiding and Unhiding Worksheets
  27. Formatting and Aligning Data
  28. Merging Data
  29. Wrapping Text Orientation
  30. Formatting Numbers
  31. Using Borders and Shading
  32. Using the Format Painter
  33. Removing Formatting Quickly
  34. Understanding Cell Styles
  35. Applying Cell Styles
  36. Applying Themes
  37. Inserting and Formatting Images
  38. Inserting and Formatting Shapes
  39. Inserting and Formatting Smart Art
  40. Inserting Screenshots
  41. Inserting Hyperlinks
  42. Inserting Symbols and Equations
  43. Inserting Word Art Or Text Boxes
  44. Inserting Other Excel Objects
  45. Arranging Objects
  46. Using Find and Replace
  47. Finding and Replacing Formatting
  48. Using Got to and Go to Special
  49. Using the Spell Checker
  50. Using the Theasaurus and Translation Feature
  51. Printing and Previewing Excel Files
  52. Creating Custom Margins and Scaling
  53. Adding Headers and Footers
  54. Formatting a Page with the Page Layout Tab
  55. Printing Titles and Specific Worksheet Areas
  56. Exporting to PDF and XPs
  57. Renaming and Coloring Worksheet Tabs
  58. Adding, Deleting, and Navigating Worksheets
  59. Moving and Copying Worksheets
  60. Viewing Workbooks
  61. Using Zoom Tools
  62. Configure Sheet Options
  63. Using Freeze Panes and Split Commands
  64. Working with Window Commands
  65. Adjusting Workbook Properties
  66. Course Recap

About this course

Excel 2016 Training 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 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 Excel 2016 Training 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 of The Excel 2016 Training Course

Who Should Take The Excel 2016 Training Course

Anyone with a knack for learning new skills can take this Excel 2016 Training 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 Course, you will immediately be sent a digital certificate. All of our courses 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. 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 Training 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 Excel 2016 Training 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

Getting Started with Excel

Creating Workbooks and Using Templates

Entering Data

Excel Formula Basics Data

Adjusting a Worksheet

Formatting and Aligning Worksheet Data

Using Cell Styles and Themes

Inserting Objects and Graphics

Proofing a Workbook

Printing an Excel File

Managing Worksheets

Navigating and Viewing Excel Files

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 3h 46m · All Levels
Enrol now