Microsoft Excel: Practical Workplace Skills
Microsoft Excel: Practical Workplace Skills
This course provides practical training in Microsoft Excel for professionals who handle, analyse, or report on workplace data. It focuses on developing the core skills required to organise raw numbers, perform accurate calculations, and present clear, professional spreadsheets essential for everyday business operations.
Participants will engage in hands-on exercises covering data entry, essential formulas, cell formatting, data sorting, basic charting, and layout tools. Particular emphasis is placed on improving data accuracy, streamlining routine tasks, and creating structured workbooks that save time and reduce manual workload in the office.
By the end of the course, participants will have greater confidence in using Microsoft Excel to automate routine calculations, spot key data trends, and produce polished, easy-to-read reports suitable for any administrative or business environment.
ShareCourse Info
What you’ll learn
By the end of this programme, you will be able to:
- Confidently navigate the Microsoft Excel interface, including the Ribbon, workbooks, and worksheets.
- Create, edit, and organise worksheets by inserting, deleting, and managing rows, columns, and tabs.
- Format spreadsheets professionally by adjusting fonts, borders, text alignment, and number formats, including currencies, dates, and percentages.
- Apply custom formatting to display information exactly as required, including large numbers, customised date formats, and other formatting options.
- Use conditional formatting to highlight important data, trends, and duplicate values automatically.
- Enter and edit data accurately to create clean, reliable spreadsheets.
- Perform essential calculations using formulas and functions such as SUM, AVERAGE, and COUNT.
- Sort and filter data to organise information and quickly locate key records.
- Apply spreadsheet best practices to create clear, accurate, and easy-to-read workbooks.
- Use practical keyboard shortcuts to improve efficiency and speed up everyday tasks.
Course details
This course is designed for professionals who want to improve the accuracy, organisation, and efficiency of their workplace spreadsheets. Delivered through practical, hands-on training, the course focuses on the essential Microsoft Excel skills required to manage, analyse, and present data clearly and effectively.
Participants will learn how to structure and format spreadsheets correctly, work with essential formulas and functions, organise and filter datasets, and apply visual tools like tables and charts to communicate insights. The course also covers time-saving shortcuts, templates, and data management best practices commonly used in professional environments.
This course offers
Online
- 9 Modules presented from 08:30 – 16:30
- Live virtual sessions via Teams
- E-certificate of completion
- Accessible on all standard mobile and PC devices with Wi-Fi access
In-Person
- In-person training may be arranged on request for 10 or more attendees
- Full-day workshop at Lynnwood Academy or at the client’s site
On Site
Contact us for a personalised quote
A course by
You get:
Certificate of Attendance
Who this course is for:
- Administrative and office professionals
- Personal and executive assistants
- Finance and HR professionals
- Project coordinators and administrators
- Engineers and technical professionals
- Anyone looking to improve their Microsoft Excel skills for the workplace
| Course Date | DELIVERY METHOD | COURSE FEE | SECURE YOUR SPOT |
|---|---|---|---|
| COURSE DATES COMING SOON | |||
Course Content
9 Discussion Points | 8 hours total length
Excel Interface and Navigation
- Understand the Microsoft Excel interface, including the Ribbon, Formula Bar, Grid, and Status Bar.
- Create, save, and navigate workbooks and worksheets.
- Use Search, Find & Replace, and Help tools effectively.
- Select cells, ranges, and navigate worksheets efficiently.
- Navigate between worksheets with ease.
- Apply useful permanent settings to customise your Excel environment.
Data Entry and Basic Formatting
- Edit data using Cut, Copy, Paste, and Undo functions.
- Apply text alignment and indentation.
- Use Find & Replace to locate and update data.
- Format numbers as General, Currency, Date, Percentage, Scientific, or Text.
- Format cells using fonts, colours, borders, shading, and alignment. Use Flash Fill to automate repetitive data entry tasks.
Custom Formatting
- Create custom number and date formats.
- Apply custom formatting to display large numbers, dates, and other values in a meaningful way.
- Hide cell contents while retaining the underlying data.
Cell Styles
Apply built-in cell styles to create a consistent, professional, and company-prescribed appearance.
Working with Multiple Worksheets
- Duplicate worksheets within a workbook.
- Copy worksheets between workbooks.
- Reorder worksheets.
- Freeze panes to keep headings visible while scrolling.
Conditional Formatting
- Create simple conditional formatting rules to highlight important information.
- Identify duplicate values and apply common methods to resolve them.
- Dynamically highlight rows based on cell values.
Calculations and Formulas
- Use absolute and relative cell references.
- Perform calculations using functions such as SUM, AVERAGE, MIN, MAX, COUNT, and COUNTA.
- Apply the AGGREGATE and IFERROR functions.
- Create cross-sheet and cross-workbook references.
Quick Access Toolbar
- Add frequently used commands from the Ribbon.
- Add commands that are not available on the Ribbon.
- Customise the Quick Access Toolbar for improved efficiency.
Sorting and Filtering
Sort and filter data by dates, numbers, text, and colour to organise and analyse information more effectively
About this course
This course provides practical training in Microsoft Excel for professionals who handle, analyse, or report on workplace data. It focuses on developing the core skills required to organise raw numbers, perform accurate calculations, and present clear, professional spreadsheets essential for everyday business operations.
Participants will engage in hands-on exercises covering data entry, essential formulas, cell formatting, data sorting, basic charting, and layout tools. Particular emphasis is placed on improving data accuracy, streamlining routine tasks, and creating structured workbooks that save time and reduce manual workload in the office.
By the end of the course, participants will have greater confidence in using Microsoft Excel to automate routine calculations, spot key data trends, and produce polished, easy-to-read reports suitable for any administrative or business environment.
