Excel for Office Administrator
Overview
Excel confidence is workplace currency; Microsoft reports that 82% of UK jobs require digital skills. Excel for Office Administrator from Thames College helps learners build practical spreadsheet ability across workbooks, worksheets, data entry, formatting, formulas, functions, lookup tools, charts, PivotTables, PivotCharts, sorting, filtering and validation.
Study this online Excel course to manage records, calculations, lists, dashboards, workbook protection, macros, sparklines and forecasting tools for daily office tasks. Designed for flexible study, it supports admin assistant, office administrator, receptionist, data entry clerk, finance assistant, business support officer, office assistant and office manager pathways. Enrol today and develop Excel skills valued across UK offices, finance teams, healthcare, education, retail, charities and business services, with certificate options for future career progression today and stronger workplace confidence from home.
Key Benefits Included
► Accredited by CPD
► 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 online course helps learners build Excel, spreadsheet, formula, chart and PivotTable knowledge for admin, office, finance and business support roles.
By the end of this course, learners will be able to:
► Navigate the Microsoft Excel interface and common commands.
► Create, save, open and manage Excel workbooks.
► Enter cell data, values, labels, dates and numbers.
► Format worksheets using text, number, style and theme tools.
► Create formulas for office calculations and spreadsheet tasks.
► Use Excel functions to support data handling and reporting.
Who is This Course For?
This course suits UK learners who want stronger Excel, spreadsheet and office admin knowledge for work, study or career growth.
► Beginners who want to learn Microsoft Excel for office tasks.
► Office administrators who manage records, reports and spreadsheets.
► Admin assistants who work with lists, forms and daily data.
► Receptionists who handle bookings, records and simple reports.
► Data entry learners building stronger spreadsheet confidence
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 Excel for Office Administrator course supports admin, office, data entry, finance support and business support routes where spreadsheet confidence is valued across UK workplaces today.
► Admin Assistant — Average UK salary: £21,000–£28,000 per year
► Office Administrator — Average UK salary: £21,000–£28,000 per year
► Administrative Assistant — Average UK salary: £20,728–£39,333 per year
► Office Assistant — Average UK salary: £19,500–£30,750 per year
► Data Entry Clerk — Average UK salary: £19,257–£31,107 per year
Course Curriculum
The course covers a wide range of essential topics, including:
Excellent
4.8 Average - 10 Reviews
Course Curriculum
| Getting Started with Microsoft Office Excel 2016 | |||
| Navigate the Excel User Interface | 00:28:00 | ||
| Use Excel Commands | 00:10:00 | ||
| Create and Save a Basic Workbook | 00:19:00 | ||
| Enter Cell Data | 00:12:00 | ||
| Use Excel Help | 00:05:00 | ||
| Performing Calculations | |||
| Create Worksheet Formulas | 00:15:00 | ||
| Insert Functions | 00:17:00 | ||
| Reuse Formulas and Functions | 00:17:00 | ||
| Modifying a Worksheet | |||
| Insert, Delete, and Adjust Cells, Columns, and Rows | 00:10:00 | ||
| Search for and Replace Data | 00:09:00 | ||
| Use Proofing and Research Tools | 00:07:00 | ||
| Formatting a Worksheet | |||
| Apply Text Formats | 00:16:00 | ||
| Apply Number Format | 00:08:00 | ||
| Align Cell Contents | 00:09:00 | ||
| Apply Styles and Themes | 00:12:00 | ||
| Apply Basic Conditional Formatting | 00:11:00 | ||
| Create and Use Templates | 00:08:00 | ||
| Printing Workbooks | |||
| Preview and Print a Workbook | 00:10:00 | ||
| Set Up the Page Layout | 00:09:00 | ||
| Configure Headers and Footers | 00:07:00 | ||
| Managing Workbooks | |||
| Manage Worksheets | 00:05:00 | ||
| Manage Workbook and Worksheet Views | 00:07:00 | ||
| Manage Workbook Properties | 00:06:00 | ||
| Working with Functions | |||
| Work with Ranges | 00:18:00 | ||
| Use Specialized Functions | 00:11:00 | ||
| Work with Logical Functions | 00:23:00 | ||
| Work with Date & Time Functions | 00:08:00 | ||
| Work with Text Functions | 00:11:00 | ||
| Working with Lists | |||
| Sort Data | 00:10:00 | ||
| Filter Data | 00:10:00 | ||
| Query Data with Database Functions | 00:09:00 | ||
| Outline and Subtotal Data | 00:09:00 | ||
| Analyzing Data | |||
| Create and Modify Tables | 00:16:00 | ||
| Apply Intermediate Conditional Formatting | 00:07:00 | ||
| Apply Advanced Conditional Formatting | 00:05:00 | ||
| Visualizing Data with Charts | |||
| Create Charts | 00:13:00 | ||
| Modify and Format Charts | 00:12:00 | ||
| Use Advanced Chart Features | 00:12:00 | ||
| Using PivotTables and PivotCharts | |||
| Create a PivotTable | 00:13:00 | ||
| Analyze PivotTable Data | 00:12:00 | ||
| Present Data with PivotCharts | 00:07:00 | ||
| Filter Data by Using Timelines and Slicers | 00:11:00 | ||
| Working with Multiple Worksheets and Workbooks | |||
| Use Links and External References | 00:12:00 | ||
| Use 3-D References | 00:06:00 | ||
| Consolidate Data | 00:05:00 | ||
| Using Lookup Functions and Formula Auditing | |||
| Use Lookup Functions | 00:12:00 | ||
| Trace Cells | 00:09:00 | ||
| Watch and Evaluate Formulas | 00:08:00 | ||
| Sharing and Protecting Workbooks | |||
| Collaborate on a Workbook | 00:19:00 | ||
| Protect Worksheets and Workbooks | 00:08:00 | ||
| Automating Workbook Functionality | |||
| Apply Data Validation | 00:13:00 | ||
| Search for Invalid Data and Formulas with Errors | 00:04:00 | ||
| Work with Macros | 00:18:00 | ||
| Creating Sparklines and Mapping Data | |||
| Create Sparklines | 00:07:00 | ||
| MapData | 00:07:00 | ||
| Forecasting Data | |||
| Determine Potential Outcomes Using Data Tables | 00:08:00 | ||
| Determine Potential Outcomes Using Scenarios | 00:09:00 | ||
| Use the Goal Seek Feature | 00:04:00 | ||
| Forecasting Data Trends | 00:05:00 | ||
| Resources | |||
| Resources – Spreadsheet Specialist Training | 00:00:00 | ||
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.
Excel for Office Administrator is an online Excel course covering workbooks, worksheets, data entry, formatting, formulas, functions, charts, PivotTables, PivotCharts, lookup tools, workbook protection, macros and forecasting features for admin, office and business support roles.
Yes, this Excel course is suitable for beginners and intermediate learners. It starts with Excel navigation, workbook creation and data entry before moving into formulas, functions, charts, PivotTables, lookup functions, workbook protection and automation.
Yes, Excel for Office Administrator can be studied online, giving learners flexible access around work, family, job applications or daily routines. It helps learners build Microsoft Excel confidence without fixed classroom attendance or travel.
The course covers Excel commands, workbooks, cell data, formulas, functions, formatting, printing, worksheets, lists, charts, tables, PivotTables, PivotCharts, lookup functions, formula auditing, workbook protection, macros, sparklines, mapping data and forecasting tools.
Yes, Excel knowledge can support admin assistant, office administrator, receptionist, data entry, finance assistant, business support and office manager routes. Career progress depends on your experience, wider software skills and employer requirements.
Access
Level
Number of Units
Duration
Course Type