Exclusive Deal! 94% Off, Today Only!
Sale Ends In
In today’s digital workplace, many employees unable to cope up—not due to lack of talent, but because they never develop the Excel and accounting skills that nearly all modern roles now expect. Missed promotions, slower progress, and daily frustration often stem from this one knowledge gap. This course helps you avoid that setback by building confidence-boosting skills employers value most across the UK.
Throughout this CPD-Accredited programme, you’ll explore essential Excel functions such as formulas, data organisation, charts, PivotTables, workbook tools, and forecasting techniques. Alongside these digital abilities, you’ll gain a clear understanding of core accounting principles including transactions, adjustments, balancing methods and the full accounting cycle. Every module is designed to show how financial systems and spreadsheet tools work together.
By the end of the Microsoft Excel & Accounting Training Course, you’ll feel prepared to manage data accurately, support financial tasks effectively, and approach business information with confidence—skills many professionals only seek after they’ve already fallen behind. Start now and stay ahead.

After completing the MCQ assessment, you will qualify for the CPD Certificate from HF Online as proof of your continued professional development. You can order your certificate at a cost of £10 for PDF and £29 for hard copy certificate or both for £39.
For assessing your learning, you have to complete an automated MCQ exam. It is required for the students to score at least 60% to pass the exam. Learners can apply for the certificate after they clear the exam.
There are assignment questions provided at the end of the course. You are suggested to complete the questions to enrich your understanding of the course. You can complete this according to your preferred time. The expert tutor will provide feedback on your performance after assessing your assignment.
There are no prerequisites and you may use any internet-enabled device to study at your own speed, it is adaptable and available to students of all skill levels.
The combination of Excel and accounting skills supports a range of administrative, financial and analytical roles across UK workplaces. These skills are valued in business environments, retail, healthcare, education, charities, and corporate offices.
It covers essential Excel tools, formulas, data analysis features, and core accounting principles. You will learn how both skill sets work together in real workplace tasks.
The course introduces each topic gradually, using simple explanations and step-by-step examples. Learners can progress at a comfortable pace with full access to support materials.
Yes. Excel and accounting knowledge are highly valued in administrative, finance, and business roles. These skills support day-to-day tasks such as reporting, budgeting, and data management.
Yes. The course teaches calculations, lookup functions, text functions, and essential spreadsheet logic. These tools help simplify workloads and improve accuracy in financial tasks.
You will study the accounting equation, transactions, adjustments, worksheets, and financial statements. Each module builds your understanding of how the full accounting cycle works.
Yes. Excel is widely used for reconciliations, budget tracking, reporting, and ledger organisation. Its flexibility makes it a key tool in both small and large UK businesses.
Yes. You will learn how to analyse data using PivotTables, PivotCharts, and visual reports. These tools help present information clearly for decision-making.
Yes. You receive one full year of 24/7 access to every module in the course. This allows you to learn at your own pace using any modern device.
You will earn a CPD-accredited certificate that confirms your professional development. Digital copies are available, with optional printed versions at additional cost.
Yes. Employers value strong Excel and accounting skills across many UK industries. Adding these competencies to your CV can improve confidence and employability.
| **Microsoft Excel** | |||
| 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:07: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 | ||
| **Accounting Training** | |||
| Professional Bookkeeper Introduction | |||
| Professional Bookkeeper | 00:09:00 | ||
| Introduction to Accounting and Business | |||
| Defining a Business | 00:07:00 | ||
| Ethics in Accounting | 00:05:00 | ||
| Generally Accepted Accounting Principles (GAAP) | 00:10:00 | ||
| The Accounting Equation | |||
| The Accounting Equation | 00:07:00 | ||
| Transactions | 00:11:00 | ||
| Financial Statements | 00:13:00 | ||
| Analyzing Transactions | |||
| The Accounting Equation and Transactions | 00:16:00 | ||
| Double-Entry System | 00:11:00 | ||
| Transactions – Journalizing | 00:17:00 | ||
| Journal Entries | 00:38:00 | ||
| Entering Information - Posting Entries | |||
| Posting Entries | 00:10:00 | ||
| The Trial Balance | 00:10:00 | ||
| Finding Errors Using Horizontal Analysis | 00:09:00 | ||
| Horizontal Trend : Balance Sheet | 00:21:00 | ||
| Horizontal Trend: Income Statement | 00:36:00 | ||
| Adjusting Process | |||
| The Purpose of the Adjusting Process | 00:15:00 | ||
| Adjusting Entries | |||
| Adjusting Entries – Prepaid Expenses | 00:13:00 | ||
| Adjusting Entries – Accrued Revenues | 00:10:00 | ||
| Adjusting Entries – Depreciation Expense | 00:09:00 | ||
| Adjustment Summary | |||
| Adjustment Summary – Review | 00:13:00 | ||
| Vertical Analysis | 00:33:00 | ||
| Preparing a Worksheet | |||
| Preparing a Worksheet | 00:06:00 | ||
| Financial Statements | |||
| The Income Statement | 00:11:00 | ||
| Financial Statements – Definitions | 00:12:00 | ||
| Completing the Accounting Cycle | |||
| Temporary vs. Permanent Accounts | 00:19:00 | ||
| The Accounting Cycle Illustrated | |||
| Accounting Cycle Illustrated – Steps 1-5 | 00:11:00 | ||
| Accounting Cycle Illustrated – Steps 6-10 | 00:12:00 | ||
| Fiscal Year | |||
| Fiscal Year | 00:09:00 | ||
| Spreadsheet Exercise | |||
| Spreadsheet Exercise – Steps 1-4 | 00:11:00 | ||
| Spreadsheet Exercise – Steps 5-7 | 00:37:00 | ||
| Order Your Certificate | |||
| Order your Certificate | 00:00:00 | ||
| **Microsoft Excel** | |||
| 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:07: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 | ||
| **Accounting Training** | |||
| Professional Bookkeeper Introduction | |||
| Professional Bookkeeper | 00:09:00 | ||
| Introduction to Accounting and Business | |||
| Defining a Business | 00:07:00 | ||
| Ethics in Accounting | 00:05:00 | ||
| Generally Accepted Accounting Principles (GAAP) | 00:10:00 | ||
| The Accounting Equation | |||
| The Accounting Equation | 00:07:00 | ||
| Transactions | 00:11:00 | ||
| Financial Statements | 00:13:00 | ||
| Analyzing Transactions | |||
| The Accounting Equation and Transactions | 00:16:00 | ||
| Double-Entry System | 00:11:00 | ||
| Transactions – Journalizing | 00:17:00 | ||
| Journal Entries | 00:38:00 | ||
| Entering Information - Posting Entries | |||
| Posting Entries | 00:10:00 | ||
| The Trial Balance | 00:10:00 | ||
| Finding Errors Using Horizontal Analysis | 00:09:00 | ||
| Horizontal Trend : Balance Sheet | 00:21:00 | ||
| Horizontal Trend: Income Statement | 00:36:00 | ||
| Adjusting Process | |||
| The Purpose of the Adjusting Process | 00:15:00 | ||
| Adjusting Entries | |||
| Adjusting Entries – Prepaid Expenses | 00:13:00 | ||
| Adjusting Entries – Accrued Revenues | 00:10:00 | ||
| Adjusting Entries – Depreciation Expense | 00:09:00 | ||
| Adjustment Summary | |||
| Adjustment Summary – Review | 00:13:00 | ||
| Vertical Analysis | 00:33:00 | ||
| Preparing a Worksheet | |||
| Preparing a Worksheet | 00:06:00 | ||
| Financial Statements | |||
| The Income Statement | 00:11:00 | ||
| Financial Statements – Definitions | 00:12:00 | ||
| Completing the Accounting Cycle | |||
| Temporary vs. Permanent Accounts | 00:19:00 | ||
| The Accounting Cycle Illustrated | |||
| Accounting Cycle Illustrated – Steps 1-5 | 00:11:00 | ||
| Accounting Cycle Illustrated – Steps 6-10 | 00:12:00 | ||
| Fiscal Year | |||
| Fiscal Year | 00:09:00 | ||
| Spreadsheet Exercise | |||
| Spreadsheet Exercise – Steps 1-4 | 00:11:00 | ||
| Spreadsheet Exercise – Steps 5-7 | 00:37:00 | ||
| Order Your Certificate | |||
| Order your Certificate | 00:00:00 | ||

