Accounts Clerk and MS Excel Course

Accounts Clerk and MS Excel Course



This bundle course is designed to enrich our learner’s knowledge of business accounting by providing a 2-in-1 training program that will leave them fully equipped with the relevant skills and knowledge to fast track their career. This course is also suitable for those who want to improve their efficiency in managing financial information. 

The Business accounting Training course provides a sweeping overview of the accounting cycle and the role of an accountant. It covers essentials areas of business accounting, such as the accounting equation, the role that ethics plays in accounting and business, and the different types of trial balances. You will also develop your knowledge of the financial market and financial forecasting. On successful completion, you will have a solid understanding of economic activities in business and how they play a vital role in organisational decision-making.

Enhance your general office skills and master the world’s leading spreadsheet software with The MS Office 2016 Excel for Beginners course. This instructor-led program covers everything you need to know to perform everyday data-based tasks efficiently. You will start by exploring the main functions and features of Excel, including navigating the interface. Next, you will get step-by-step guidance on how to modify your worksheets and manage your workbooks. This course is packed full of tips, tricks and practical exercises to boost your professional development.

Highlights  of  The Accounts Clerk and MS Excel Course

  • Get step-by-step training on how to navigate the Excel interface
  • Learn how to modify and format a worksheet in Excel
  • Familiarise with Excel’s basic formulas and functions
  • Understand the steps to create a basic workbook and worksheet formula
  • Discover tips and tricks for managing your workbooks 
  • Get an overview of the business accounting cycle and the accounting equation
  • Understand the role of ethics in accounting and the five codes of ethics
  • Gain a solid understanding of the balance sheet and the types of trial balances 
  • Explore the role and day-to-day responsibilities of an accountant in detail
  • Learn the definition of the fiscal year and the accounting period

Accounts Clerk and MS Excel Course Design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Video lessons
  • Online study materials
  • Mock exams
  • Multiple-choice assessment

Who is This Course for?

This course is a stepping stone towards a successful career in accounting and is ideal for aspiring accountants and small business owners who wish to gain the relevant skills to manage their financial data and make smarter business decisions.

Why study this course

Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.

The Accounts Clerk and MS Excel Course is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

How is the course assessed?

To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.

Will I receive a certificate of completion?

Upon successful completion you will qualify for the UK and internationally-recognised professional qualification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.

Career Path

On successful completion,   be able to apply their newfound skills and knowledge in roles such as:

  • Corporate Accountant
  • Bookkeeping Assistant
  • Accounts Supervisor

Course Curriculum

**Accounts Clerk**
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
**MS 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: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

Course Reviews


8 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.


COPYRIGHT © 2018 One Education