View all our CPD accredited Microsoft Office Excel courses below and how we can help you become an MS Excel expert regardless of your prior skills.
Microsoft Excel is one of the most important and popular pieces of software used in the workplace. Commonly used for analysing, sorting, displaying, reporting and storing data.
Certification
All of our courses are accredited by the CPD Certification Service as conforming to universally accepted Continuing Professional Development (CPD) guidelines.
On completion of each course candidates will be emailed a quality assured certificate, where CPD points gained can be used elsewhere.
MK-Office Microsoft Excel courses
We offer instructor led, CDP accredited courses delivered face-to-face to any location in the UK, or online to any country in the world.
Our courses cover every function MS Excel has to offer including hot keys to save time, practical examples/explanations to ensure in-depth understanding and adequate time for delegates to apply new knowledge.
All courses are delivered by a qualified teacher with over 20 years experience in Excel, who will help to facilitate your goal in becoming competent to an expert in MS Excel.
Who should take this course?
MK-Offices’ CPD accredited Microsoft Office Excel courses are suitable for everyone regardless of experience and prior knowledge. Whether you a looking to update, refresh or learn new spreadsheet skills you are in safe hands with MK-Office.
We have not only designed industry leading content but created errors for candidates to learn from. Learning a function or formula in Excel is one skill but being able to correct or spot an error is another skill needed in everyday use in the workplace
What we offer
We have a full list of CPD accredited Microsoft Office Excel courses below for you to choose from. Our training days are very different to other companies in how we structure the day. We work with you. You can inform us on what courses you would like delivered and what time to deliver them through out the day. Alternatively, you can inform us on what courses are need or skills staff already possess, and we can advise on the best way to structure the day.
We offer evening, full, half and day training. With a maximum of 12 candidates per course (we are flexible with this, please contact us to discuss).
Why do you not have beginner, intermediate and advanced training days?
Every candidate’s job role is different, everyone’s end goal is personal and most importantly everyone’s time is money. Attending a full days beginner training, when you only need one part of the course, doesn’t make sense to you or us.
Why attend a full day course, when you only need one aspect of it.
We don’t believe in limiting our candidates progression in learning aspects of MS Excel needed for their job role. We have labelled our individual courses B (beginner), I (intermediate) and A(advanced) as that is what people like to use for a bench mark.
Regardless of your prior knowledge and experience our trainer will personalise each course to the delegates expertise in the room. That is the benefit from MK-Office having a trainer with a teaching qualification and over 20 years of experience using excel. Below is a list of courses, we offer.
Will I need my own device?
Yes, we do not supply candidates with computers or software packages for our courses.
Benefits from onsite MS Excel training
We provide onsite instructor led training to companies within the UK, which gives an excellent balance between flexibility and cost-effectiveness. All employees have access to training that works around their schedule. No travelling, training done on the company’s premises saves valuable time for employees. It also allows a company to bespoke their training day to get the most value out of MK-Office.
Why send an employee to attend part of a course they already know? This way employees can attend what they need at a time that best suits delegates.
Why invest in MS Excel training?
Acquiring in-depth knowledge of working with Microsoft Excel functions and formulas will enable delegates to use Excel efficiently in their daily work life. Companies benefit from a wide range of aspects when staff are fluent in MS Excel:
Increased productivity
Reduce human error in calculations
Reduce time on mundane tasks
Consistency of data
Duplication and sorting of data efficiently
Charts to display data
Why we are the Best for You?
We work with you to deliver the most effective training days that will benefit you or your company. The flexibility we offer candidates helps to ensure you learn what you need and no time is wasted.
The content of all our courses have been accredited by the CPD Certification Service and designed not just by a specialist in MS Excel but by an experienced qualified teacher.
We teach delegates the hot keys needed, how to save time but most importantly structure time to practice and embed skills learnt with a trainer.
We allow candidates the opportunity to bring their own spreadsheets to the course to practice and apply new skills with a trainer present.
Anything else?
Yes, unlike other Excel providers we offer you the opportunity during a training day to schedule a drop-in session. Drop-in sessions are where employees can bring spreadsheets, they are having issues with or that are not performing efficiently for our expert to take a look at and fix.
During these sessions our Excel expert can sit with an employee(s) and help to create or advise on the best formulas and formatting to help with their data. We can, if needed create bespoke spreadsheets for companies.
Basically, use our knowledge and experience for works best for your end goal.
CPD accredited Microsoft Office Excel courses
Explore all of our CPD accredited Microsoft Office Excel courses. Click each box to read a brief overview of the course followed by a more detailed break down.
Cell Comment (B)
Protected: Cell Comment (B)
Overview
You will learn how to insert a comment to a cell. Then the course will explore how to view, alter and delete a comment.
Course Break Down
Insert a Comment ○ Alter a Comment ○ View a Comment ○ Delete a Comment ○ Show all Comments
This course covers 2 courses 1.Cell Comment 2.Spelling Check
Enter Password to Download:12570 Downloads
Chart (I)
Protected: Chart (I) (3 Hours)
Overview
This course will go through all the different types of charts you can create using templates already created. You will learn how bespoke each chart with a linked title, legend etc. Change the colour of fonts, chart arears etc.
Course Break Down
Types of Charts ○ Creating Charts ○ Format Chart ○ Chart Design – Chart Type ○ Chart Design – Row ↔ Column ○ Chart Design – Chart Layout ○ Chart Design – Chart Style ○ Chart Design – Chart Style ○ Chart Design – Chart Style ○ Chart Size ○ Chart Layout – Chart Title ○ Chart Layout – Horizontal Axis Title ○ Chart Layout – Vertical Axis Title ○ Chart Layout – Legend ○ Chart Layout – Data Labels ○ Chart Layout – Data Table ○ Chart Layout – Data Table ○ Chart Layout – Data Table ○ Chart Layout – Axes ○ Axis Options ○ Chart Layout – Horizontal Gridlines ○ Chart Layout – Vertical Gridlines ○ Chart – Format ○ Chart – Font Format ○ Format Data Series ○ Format Data Series ○ Format Data Series
Enter Password to Download:12990 Downloads
Conditional Formatting (A)
Protected: Conditional Formatting (A) (3 Hours)
Overview
Conditional formatting is when you set up a format to automatically appear depending on a cell value. This course will cover all aspects of conditional formatting and progress to creating a formula to determine the formatting of a cell.
Course Break Down
Greater Than ○ Less Than ○ Between ○ Equal To ○ Text That Contains ○ A Date Occurring ○ Duplicate Values ○ More Rules ○ Data Bars ○ Color Scales ○ Icon sets ○ New Rule ○ Clear Rules ○ Manage Rules
Enter Password to Download:14269 Downloads
Copy or Move Data (B)
Protected: Copy or Move Data (B)
Overview
Here you will learn how to use the cut, copy and paste feature within excel. Then how to use the drag and drop options to move cells around the spreadsheet. You will then explore all the options available when applying drag and fill to cells.
Course Break Down
Using Cut, Copy and Paste ○ Drag and Drop ○ Drag and Fill ○ Deleting Rows and Columns
Enter Password to Download:13562 Downloads
Copy or Move Data, Drag and Fill Date (B)
Protected: Copy or Move Data, Drag and Fill Date (B) (1 Hour)
This course covers two courses 1.Copy or Move Data 2.Drag and Fill Date
Enter Password to Download:14526 Downloads
Count (A)
Protected: Count (A) (1 Hour 30 Mins)
Overview
The count function will return a value for the amount of cells that contain a specific criteria. You could for example highlight a range of cells and count how many blank cells are contained within that range. The course also covers how you can be a lot more specific in using the countif and countifs functions. These functions allow you to set up the criteria for if a cell is counted or not.
Course Break Down
Count a Blank Cell ○ Count ○ =count() ○ =countif() ○ Count Cells Containing Data ○ =countifs()
Enter Password to Download:14677 Downloads
Data Validation (A)
Protected: Data Validation (A) (2 Hours)
Overview
Data validation is used to ensure incorrect data is not entered in to a cell. It can restrict the amount of human error when entering data in to a spreadsheet. You can set restrictions on a cell so a value greater than 1000 for example can not be entered and if it is an error message will appear to the user. You can stop the user continuing until the data entered is corrected or allow them to continue with a warning so they are aware of the value entered in the cell. The most common use of data validation is a drop down list.
Course Break Down
Data Validation ○ Whole Number ○ Decimal ○ List ○ Date ○ Time ○ Text Length ○ Input Message ○ Error Alert
Enter Password to Download:15643 Downloads
Drag and Fill Date (B)
Protected: Drag and Fill Date (B)
Overview
You will learn how to automatically change the day, month and year only when copying cells that contain a date. You will cover how to copy cells and only display weekend dates.
Course Break Down
Using Cut, Copy and Paste ○ Drag and Drop ○ Drag and Fill
Enter Password to Download:13423 Downloads
Edit Row or Column (B)
Protected: Edit Row or Column (B) (45 Mins)
Overview
You will cover how to hide, insert, re-size and delete a row or column. You will then move on to how to apply all these skills to multiple rows or columns to save time.
Course Break Down
Hiding Rows and Columns ○ Inserting Rows and Columns ○ Sizing Rows and Columns ○ Deleting Rows and Columns
Enter Password to Download:14683 Downloads
Error Correction (B)
Protected: Error Correction (B)
Overview
Here you will be shown how to use the undo and redo button feature in excel.
Course Break Down
Undo ○ Redo
Enter Password to Download:8906 Downloads
Filters (A)
Protected: Filters (A) (1 Hour)
Overview
On this course you will learn how to set up a filter. You will then learn all the functions that are available on a filter so you will go through how to sort your data in alphabetical order in chronological order. It will cover how to search for data within a filter. You will learn how to search for data depending on colour. You will also go through the importance of not setting up totals within the data and to use a specific function created for a filter to write formulas to sum data within the filter range.
Course Break Down
Setting up a Filter ○ Selecting Certain Values ○ Sort A to Z ○ Sort by Date Order ○ Search ○ Course Break Down ○ Filter by Colour ○ Custom Filters ○ Total / Subtotal
Enter Password to Download:15219 Downloads
Find and Select (I)
Protected: Find and Select (I) (1 Hour)
Overview
This course explores how to find data within a spreadsheet. You will then be shown how to replace the data found, saving hours of work with the spreadsheet by a few clicks. You will then learn how to use the functions available under find and select. For example you could use this function to find all the cells that contain an error within a formula.
Course Break Down
Find & Select ○ Find ○ Replace ○ Go To ○ Go To Special
Enter Password to Download:16334 Downloads
Format a Cell (B)
Protected: Format a Cell (B)
Overview
You will cover on this course how to apply borders to a cell. You will learn how to change the colour of a border and add bespoke border to one cell or multiple cells at once. You will then cover how to apply the format painter to save time repeating borders within the spreadsheet.
Course Break Down
Adding Borders to a Cell ○ Adding Colours to Cell ○ Using the Format Painter
Enter Password to Download:14678 Downloads
Format Cells (I)
Protected: Format Cells (I) (2 Hours)
Overview
This courses will cover how to format the data inside a cell. For example you will be shown how to set a currency format on a cell so when you enter in data the computer will automatically insert a pound sign in front of the value.
Course Break Down
Wrap ○ Merge ○ General ○ Number ○ Currency ○ Accounting ○ Date ○ Time ○ Percentage ○ Fraction ○ Scientific ○ Text ○ Special ○ Custom
Enter Password to Download:14626 Downloads
Format Font (B)
Protected: Format Font (B)
Overview
This covers all you need to know when changings the font of a cell. You will learn how to change the style, colour and position of font within a cell. You will also cover how to apply the format painter in order to save time when repeating font styles.
Course Break Down
Working with Fonts ○ Colour of Font ○ Aligning the Content of a Cell ○ Bold, Italic & Underline ○ Using the Format Painter
Enter Password to Download:14567 Downloads
Format Font, Format a Cell (B)
Protected: Format Font, Format a Cell (B) (1 Hour)
This course covers 2 courses 1.Format Font 2.Format a Cell
Enter Password to Download:13572 Downloads
Formula Auditing (A)
Protected: Formula Auditing (A) (1 Hour 15 Mins)
Overview
This course will show you find out which cells contribute to a value in a certain cell. It will also show you how to find out if a value in one cell contributes to the formula in another cell within the workbook. You will learn how check the worksheet for any errors in formulas. If an error is found within a formula how to pinpoint where the problem lies. You will also learn the importance of removing circular references contained in a workbook and why they come about.
Course Break Down
Trace Precedents ○ Trace Dependents ○ Remove Arrows ○ Show Formulas ○ Error Checking ○ Evaluate Formula ○ Circular Reference
Enter Password to Download:24753 Downloads
Freeze Panes (I)
Protected: Freeze Panes (I) (30 Mins)
Overview
This course will talk you through how to freeze panes in a spreadsheet. Freezing panes allows you to ensure rows or column headers stay stationary when navigating around the sheet.
Course Break Down
Freeze Panes ○ Unfreeze Panes
Enter Password to Download:12594 Downloads
Functions (I)
Protected: Functions (I) (45 Mins)
Overview
On this course you will learn how to use the count, average, sum, max and min functions. You will then learn how to apply these functions on data from a range and data that is scattered through the spreadsheet.
Course Break Down
Sum Function ○ Count Function ○ Average Function ○ Min Function ○ Max Function
Enter Password to Download:16257 Downloads
Hot Keys
Hot Keys
Here you can download a selection of hotkeys to save you time while working on a spreadsheet.
The if function uses a logical formula to return a value for if it is true or false. It is mostly used to compare two cells and return a value depending on the criteria set up. This function can save hours when analyzing data.
Course Break Down
Formulas ○ Correcting Formulas
Enter Password to Download:16298 Downloads
Maths (I)
Protected: Maths (I)
Overview
Course Break Down
Four Operations ○ Absolute ○ Pi ○ Square root ○ Power
Enter Password to Download:1571 Downloads
Navigation (B)
Protected: Navigation (B)
Overview
Course Break Down
Here you will explore how to navigate about the spreadsheet, Using the scroll bars and hot keys. You will also learn how to zoom in and out of the spread sheet.
Left – Right ○ Up – Down ○ Zoom
Enter Password to Download:73527 Downloads
Odd Even (I)
Protected: Odd Even (I)
Overview
Course Break Down
=even() ○ =odd() ○ =iseven() ○ isodd()
Enter Password to Download:1583 Downloads
Odd Even, Maths (I)
Protected: Odd Even, Maths (I) (1 Hour)
Two courses are covered here 1.Odd Even 2.Maths
Enter Password to Download:16218 Downloads
Paste Special (I)
Protected: Paste Special (I) (1 Hour)
Overview
This course covers different ways in which you can paste data within a spreadsheet. Giving you a lot move control on which aspects of the data are copied.
Course Break Down
Paste Special ○ Formulas ○ Formulas and Number Formatting ○ Keep Source Formatting ○ No Borders ○ Keep Source Column Widths ○ Transpose ○ Values ○ Values and Number Formatting ○ Formatting ○ Paste Link ○ Mathematical Operations ○ Skip Blanks ○ Comments
Enter Password to Download:15214 Downloads
PivotTable (A)
Protected: PivotTable (A) (3 Hours)
Overview
You will learn how to create a PivotTable.
Course Break Down
What is a PivotTable ○ Data Source ○ Creating a PivotTable ○ Refresh Data ○ Field and Areas Section ○ Field Search ○ Field Sort ○ Change Data Source ○ Named Range ○ Format Cells ○ Column Width ○ Style options ○ Report Filter Pages ○ Empty Cells ○ Grand Totals ○ Subtotals ○ Extract Records ○ Report Layout ○ Blank Rows ○ Recommended PivotTables ○ Remove a Field ○ Re-order Fields ○ Custom Name ○ Group Data
Enter Password to Download:32406 Downloads
Print (I)
Protected: Print (I) (1 Hour)
Overview
This course will cover all the different ways you can print out data from a spreadsheet. The aim is to ensure the document printed out is presented correctly and not spread over an unnecessary amount of paper, ensuring the data can read correctly. Saving time and money.
Course Break Down
Print Copies ○ Printer ○ Print PDF ○ Print Selection ○ Set Print Area ○ Print Certain Pages ○ Collated / Uncollated ○ Orientation ○ Paper Size ○ Margins ○ Scaling ○ Page Setup ○ Print Preview ○ Page Breaks
Enter Password to Download:16219 Downloads
Protection (A)
Protected: Protection (A)
Enter Password to Download:16781 Downloads
Protection, Shared Workbook (A)
Protected: Protection, Shared Workbook (A)
Enter Password to Download:12354 Downloads
Round (I)
Protected: Round (I) (1 Hour)
Overview
Here you will see how values change depending on which round function you apply. You will explore how to manipulate values depending on which rounding function you use.
Here we will cover 3 courses. 1. Selecting Cells 2. Navigation 3.Error Correction
Enter Password to Download:23415 Downloads
Share Workbook (A)
Protected: Share Workbook (A)
Enter Password to Download:5421 Downloads
Sheet Tabs (B)
Protected: Sheet Tabs (B) (45 Mins)
Overview
On this course it will guide you through how to change the name of a sheet tab. How to change the colour of a sheet tab you will then learn how to duplicate spreadsheets. How to move them from one workbook to another, you will then be shown how to delete a worksheet. You will then learn how to hide a spreadsheet so that it doesn’t look visible within the workbook. You will learn how to insert a new spreadsheet to a workbook and you will also be shown how to navigate between taps using hot keys.
Course Break Down
Rename a tab ○ Tab colour ○ Hide – Unhide a tab ○ Duplicate a Spreadsheet ○ Insert a New Spreadsheet ○ Navigate Between Tabs
Enter Password to Download:2360 Downloads
Spelling Check (B)
Protected: Spelling Check (B)
Overview
You will learn how to use the spell check button in to correct spelling errors contained within the spreadsheet. You will also cover how to use the thesaurus button.
Course Break Down
Spelling Button ○ Thesaurus Button
Enter Password to Download:2345 Downloads
=sumif() (A)
Protected: =sumif() (A) (1 Hour)
Overview
The sum if function works by adding together a range of cells depending on the sumif criteria. The sumifs function works by adding together a range of cells depending on multiple criteria’s.
Course Break Down
=sumif() ○ =sumifs() ○ Correcting Folmulas
Enter Password to Download:15393 Downloads
Text Function (A)
Protected: Text Function (A) (1 Hour 15 Mins)
Overview
This course will show you some time saving functions when dealing with text within a spreadsheet. You will learn how to combine cells. How to remove parts of text within a cell, this function can also be used on numerical data within a cell. All these functions come in useful when data in your spreadsheet has come from an external source and you need to manipulate the data to suit your needs. You can also use these functions to correct text and then copy the data to another program, ensuring your time is not wasted re-writting data you already have.