Microsoft Excel
An online Microsoft Excel Training course teaching fundamental Excel skills including formulas, charts, data entry and analysis — self‑paced and CPD certified.
173 Students
Overview
Excel skills open doors in offices, finance and data-led teams; Microsoft reports that 82% of UK jobs require digital skills. The Microsoft Excel course from Thames College helps learners build confidence with workbooks, worksheets, data entry, formulas, functions, charts, templates, datasets, PivotTables, PivotCharts, PowerPivot and lookup functions.
Study this online Excel training to handle reports, records, calculations, dashboards, validation, formula auditing, What-If analysis, macros, VBA and forecasting. Designed for flexible study, it supports routes towards admin assistant, office administrator, data entry clerk, finance assistant, reporting assistant, Excel specialist, data analyst, business support officer and spreadsheet analyst. Enrol today and develop Excel knowledge valued across UK admin, finance, operations, education, retail, healthcare and business teams, with certificate options for career progression and workplace confidence from home.
Key Benefits Included
► Accredited by CPD
► Endorsed by QLS (Quality Licence Scheme)
► Instant Access
► 24/7 Learning Assistance
► Self-paced learning and laptop, tablet, smartphone-friendly
► Fully online, interactive course with audio voiceover
► Developed by qualified professionals in the field
Learning Outcomes
This course helps learners build Excel, spreadsheet, formula, PivotTable, PowerPivot and VBA knowledge for office, finance, data and reporting roles.
By the end of this course, learners will be able to:
► Navigate the Microsoft Excel interface and start screen.
► Create, save, open and manage Excel workbooks.
► Enter labels, numbers, dates and worksheet values.
► Build formulas and use correct order of operations.
► Apply relative and absolute cell references.
► Use Excel functions such as SUM, MIN, MAX, AVERAGE and COUNT.
Who is This Course For?
This course suits UK learners who want stronger Microsoft Excel knowledge for work, study, reporting or career growth.
► Beginners who want to learn Microsoft Excel from the start.
► Office administrators who manage records, lists and reports.
► Admin assistants who work with spreadsheets and daily data.
► Finance assistants who need formula and calculation confidence.
► Data entry learners building stronger spreadsheet ability.
► Business support staff preparing reports and summaries.
Certification
CPD Certification
After successfully completing the assessment of this course, you can apply for the CPD accredited certificates.
PDF certificate: £9.99
Hardcopy certificate: £15.99
Career Opportunities
This Microsoft Excel course supports admin, office, finance, data, reporting and business support routes where spreadsheet confidence is valued across UK workplaces. Salary ranges vary by employer, location, experience, software knowledge and role level.
► Admin Assistant — Average UK salary: £20,275–£27,550 per year
► Administrative Assistant — Average UK salary: £19,092–£32,230 per year
► Office Administrator — Average UK salary: £20,000–£30,000 per year
► Data Entry Clerk — Average UK salary: £19,000–£31,000 per year
► Finance Administrative Assistant — Average UK salary: £19,931–£26,676 per year
Course Curriculum
The course covers a wide range of essential topics, including:
Excellent
4.7 Average - 9 Reviews
Course Curriculum
| Unit 01: Excel from A-Z Course Introduction | |||
| Excel from A-Z Course Intro | 00:03:00 | ||
| Excel Job Opportunities | 00:03:00 | ||
| Excel Job Types | 00:04:00 | ||
| Microsoft Excel Marketplace | 00:04:00 | ||
| What is Microsoft Excel? | 00:04:00 | ||
| Who is This Course For? | 00:03:00 | ||
| Unit 02: Getting Started With Excel | |||
| Finding & Opening Excel | 00:01:00 | ||
| Excel’s Start Screen | 00:03:00 | ||
| Explaining the Excel Interface | 00:03:00 | ||
| Excel Interface Continued | 00:01:00 | ||
| Excel Workbook vs. Excel Worksheet | 00:02:00 | ||
| Saving an Excel Document | 00:04:00 | ||
| Customizing the Quick Access Toolbar | 00:02:00 | ||
| Customizing the Excel Ribbon | 00:03:00 | ||
| Excel Shortcut Keys | 00:02:00 | ||
| Unit 03: Values, Referencing and Formulas | |||
| Creating Excel Labels | 00:03:00 | ||
| Entering Numeric Values in Excel | 00:03:00 | ||
| Formatting Date Values in Excel | 00:05:00 | ||
| Building Basic Formulas in Excel | 00:05:00 | ||
| Order of Operations | 00:06:00 | ||
| Relative vs. Absolute Cell References | 00:07:00 | ||
| Unit 04: Intro to Excel Functions | |||
| Excel Functions Explained | 00:03:00 | ||
| The SUM() Function | 00:08:00 | ||
| The MIN() & MAX() Function | 00:04:00 | ||
| The AVERAGE() Function | 00:02:00 | ||
| COUNT() Functions | 00:05:00 | ||
| Unit 05: Adjusting Excel Worksheets | |||
| Moving & Copying Data | 00:07:00 | ||
| Insert & Delete Rows and Columns | 00:05:00 | ||
| Adjusting the Width and Height of Cells | 00:05:00 | ||
| Hiding and Unhiding Excel Rows and Columns | 00:04:00 | ||
| Renaming, Moving & Deleting Excel Worksheets | 00:05:00 | ||
| Adding Protection to Specific Cells | 00:04:00 | ||
| Protecting the Structure of a Workbook | 00:02:00 | ||
| Adding a Workbook Password to Open File | 00:02:00 | ||
| Unit 06: Visually Pleasing Cell Formatting | |||
| Formatting Fonts and Cell Background Color | 00:05:00 | ||
| Adding Cell Borders | 00:05:00 | ||
| Formatting Data Appropriately | 00:05:00 | ||
| The Magic behind Excel’s Format Painter | 00:03:00 | ||
| Creating Styles for Formatting Efficiency | 00:06:00 | ||
| Merging Cells for a Cleaner Look | 00:03:00 | ||
| The Power of Conditional Formatting | 00:06:00 | ||
| Unit 07: How to Insert Images and Shapes! | |||
| Grab User’s Attention using Illustrations | 00:09:00 | ||
| Customizing Icons | 00:05:00 | ||
| Create Compelling Graphics with SmartArt | 00:06:00 | ||
| Unit 08: Visualize Data with Charts | |||
| The Commonly Used Column Chart | 00:03:00 | ||
| Changing the Chart Design.mp4 | 00:02:00 | ||
| Formatting Elements of a Chart | 00:06:00 | ||
| Modifying the Data, Type & Location of a Chart | 00:06:00 | ||
| Unit 09: Excel’s Printing Options | |||
| Print Preview Options | 00:04:00 | ||
| Excel’s Page Layout View | 00:07:00 | ||
| Printing a Specific Range of Cells | 00:03:00 | ||
| Converting Spreadsheets to PDF Files | 00:02:00 | ||
| Unit 10: Benefits of Using Excel Templates | |||
| Why Create an Excel Template | 00:01:00 | ||
| How to Create an Excel Template | 00:05:00 | ||
| Unit 11: Working with Excel Datasets | |||
| How to Prepare Data for Analysis | 00:04:00 | ||
| How to Sort Data in Excel | 00:03:00 | ||
| Multi-Level Sorting | 00:03:00 | ||
| Custom Sorting Datasets in Excel | 00:02:00 | ||
| Applying Filters to Datasets | 00:05:00 | ||
| Creating Subtotals within a Dataset | 00:06:00 | ||
| Converting Datasets into Tables | 00:06:00 | ||
| Little Slice of Pie Charts | 00:05:00 | ||
| Finding & Removing Duplicate Values | 00:07:00 | ||
| Unit 12: Excel Database Functions | |||
| The SUMIF() Function | 00:09:00 | ||
| The DSUM() Function | 00:08:00 | ||
| The DSUM() Function Cont. | 00:07:00 | ||
| The SUBTOTAL() Function | 00:06:00 | ||
| Unit 13: Excel Data Validation | |||
| What is Excel Data Validation? | 00:02:00 | ||
| Creating a Drop Down List with Data Validation | 00:07:00 | ||
| Different Types of Excel Data Validation | 00:06:00 | ||
| Adding Custom Alerts to Data Validation | 00:07:00 | ||
| Creating a Dynamic Drop Down List | 00:03:00 | ||
| Complex Validation: Dependent Drop Down List! | 00:09:00 | ||
| Unit 14: Excel PivotTables | |||
| Creating an Excel Pivot Table | 00:06:00 | ||
| Modifying Excel PivotTables | 00:06:00 | ||
| Grouping & Filtering PivotTable Data | 00:06:00 | ||
| Drilling Down into PivotTable Data | 00:02:00 | ||
| Creating Pivot Charts & Utilizing Slicers | 00:08:00 | ||
| Unit 15: Excel’s PowerPivot Add-In | |||
| What is PowerPivot? | 00:04:00 | ||
| Activating the Excel PowerPivot Add-In | 00:02:00 | ||
| Creating Relationships between Data Tables.mp4 | 00:06:00 | ||
| Using Data Models to Create PivotTables | 00:05:00 | ||
| How to Create PowerPivot KPI’s | 00:08:00 | ||
| Unit 16: Excel’s Conditional Functions | |||
| Excels IF Function | 00:05:00 | ||
| IF() Function with AND() Criteria | 00:05:00 | ||
| IF() Function with OR() Criteria | 00:05:00 | ||
| Nesting Multiple IF() Functions | 00:07:00 | ||
| The COUNTIF() Function | 00:04:00 | ||
| Key Benefits of Named Ranges | 00:04:00 | ||
| Unit 17: Excel’s Lookup Function | |||
| VLOOKUP() Function | 00:09:00 | ||
| The Beauty of Excel’s IFERROR() Function | 00:04:00 | ||
| HLOOKUP() Function | 00:06:00 | ||
| The INDEX Function | 00:05:00 | ||
| MATCH() Function | 00:05:00 | ||
| INDEX() and MATCH() Combined | 00:05:00 | ||
| Two-Way Lookup with INDEX() and MATCH() | 00:04:00 | ||
| Unit 18: Text Based Functions in Excel | |||
| LEFT(), RIGHT() and MID() Function | 00:07:00 | ||
| Extracting Specific Text using LEN() & SEARCH() | 00:13:00 | ||
| Combining Text with CONCATENATE() | 00:06:00 | ||
| Quick Tips & Other Text Based Functions | 00:06:00 | ||
| Unit 19: Auditing Formulas and Views in Excel | |||
| Tracing Precedents & Dependents in Formulas | 00:04:00 | ||
| Showing Formulas | 00:02:00 | ||
| Grouping Data | 00:03:00 | ||
| 3D Referencing in Formulas | 00:05:00 | ||
| Utilizing the Watch Window in Excel | 00:03:00 | ||
| How to Freeze Panes in Excel | 00:03:00 | ||
| Unit 20: Excel’s “what If?” Tools | |||
| Excel’s Scenario Manager Tool | 00:06:00 | ||
| Goal Seek in Excel | 00:06:00 | ||
| Compare Results with Excel Data Tables | 00:04:00 | ||
| Solver Tool | 00:11:00 | ||
| Unit 21: Welcome to Excel VBA | |||
| The Power Behind Excel VBA | 00:03:00 | ||
| A Look Inside the Visual Basic Editor (VBE) | 00:04:00 | ||
| Recording a Macro | 00:09:00 | ||
| Saving & Opening a Macro-Enabled Workbook | 00:02:00 | ||
| Unit 22: The VBA Language | |||
| Modules and Procedures | 00:07:00 | ||
| Objects, Methods and Properties | 00:06:00 | ||
| Excel VBA Variables | 00:05:00 | ||
| Unit 23: Writing VBA Code | |||
| Referencing a Range | 00:13:00 | ||
| InputBox & MsgBox | 00:06:00 | ||
| Using Variables in VBA Code | 00:05:00 | ||
| If Then Else Statement | 00:10:00 | ||
| Worksheet Functions inside VBA | 00:08:00 | ||
| Creating User Defined Functions | 00:09:00 | ||
| User Defined Functions within VBA Scripts | 00:06:00 | ||
| Unit 24: Important VBA Tools and Logic | |||
| Find Last Row of Data | 00:06:00 | ||
| Find Last Column of Data | 00:03:00 | ||
| With Statement | 00:05:00 | ||
| Debugging & Error Handling | 00:07:00 | ||
| Debugging & Error Handling Cont. | 00:07:00 | ||
| Unit 25: Excel VBA Loop | |||
| For Next Loop | 00:09:00 | ||
| Do Until Loop | 00:06:00 | ||
| For Each Loop | 00:04:00 | ||
| Unit 26: Triggering Macros | |||
| Assigning Macros to Shapes | 00:04:00 | ||
| Form Controls vs ActiveX Controls | 00:08:00 | ||
| Worksheet Events | 00:04:00 | ||
| Workbook Events | 00:03:00 | ||
| Fun with VBA Events! | 00:07:00 | ||
| Unit 27: Excel User Forms | |||
| Creating an Excel UserForm | 00:03:00 | ||
| Adding Controls to UserForms | 00:10:00 | ||
| How to Show an UserForm | 00:03:00 | ||
| Passing TextBox Values to Desired Cells | 00:07:00 | ||
| Passing Option Buttons to Desired Cells | 00:07:00 | ||
| UserForm ComboBoxes | 00:08:00 | ||
| Clearing Values from UserForm Controls | 00:03:00 | ||
| How to Close an UserForm | 00:02:00 | ||
| UserForms and Protected Sheets | 00:05:00 | ||
| Unit 28: Starting a Career in Excel | |||
| Creating an Excel Resume | 00:05:00 | ||
| Getting Started with Freelancing | 00:06:00 | ||
| How to Become an Excel Freelancer | 00:05:00 | ||
| Top Freelance Websites | 00:05:00 | ||
| How to Get Your First Client | 00:08:00 | ||
| Personal Branding | 00:07:00 | ||
| Networking Do’s and Don’ts | 00:04:00 | ||
| Importance of Having a Website | 00:04:00 | ||
| Assignment | |||
| Assignment – Microsoft Excel | 3 weeks, 4 days | ||
Certificate of Achievement
Upon completion, you will receive a CPD-accredited certificate recognised globally. Choose from:
Pdf Certificate & Transcript £7.99
Hardcopy Certificate & Transcript £17.99
This certification validates your knowledge and skills, boosting your employability in healthcare.
Course Reviews
No Reviews found for this course.
Microsoft Excel is an online course covering workbooks, worksheets, formulas, functions, charts, datasets, PivotTables, PowerPivot, lookup tools, What-If analysis, macros and VBA. It helps learners build spreadsheet confidence for office, finance, reporting and data roles.
Yes, this Microsoft Excel course starts with the basics, including the Excel interface, workbooks, worksheets, values, formulas and formatting. Learners then progress into functions, charts, PivotTables, PowerPivot, lookup tools, macros and VBA awareness
Yes, Microsoft Excel can be studied online, giving learners flexible access around work, family, job applications or daily routines. It helps learners build spreadsheet, reporting and data confidence without fixed classroom attendance or travel.
The course covers Excel setup, workbook management, values, formulas, functions, formatting, charts, printing, templates, datasets, database functions, data validation, PivotTables, PowerPivot, lookup functions, formula auditing, What-If tools, macros and VBA
Yes, Excel knowledge can support admin, finance, data entry, reporting, operations, business support and analyst pathways. Career progress depends on your experience, wider software skills, employer requirements and how confidently you apply Excel at work
Exclusive Deal! 95% Off, Today Only!
Offer Ends Soon
Take All courses for £49
Access
Level
Number of Units
Duration
Course Type
Exclusive Deal! 95% Off, Today Only!
Discounted Total:- 50% discount for orders of 10+ courses
- 60% discount for orders of 50+ courses
- 70% discount for orders of 100+ courses