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.
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.
On successful completion, be able to apply their newfound skills and knowledge in roles such as:
- Corporate Accountant
- Bookkeeping Assistant
- Accounts Supervisor
|Professional Bookkeeper Introduction|
|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|
|The Accounting Equation and Transactions||00:16:00|
|Transactions – Journalizing||00:17:00|
|Entering Information - Posting Entries|
|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|
|The Purpose of the Adjusting Process||00:15:00|
|Adjusting Entries – Prepaid Expenses||00:13:00|
|Adjusting Entries – Accrued Revenues||00:10:00|
|Adjusting Entries – Depreciation Expense||00:09:00|
|Adjustment Summary – Review||00:13:00|
|Preparing a Worksheet|
|Preparing a Worksheet||00:06:00|
|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|
|Spreadsheet Exercise – Steps 1-4||00:11:00|
|Spreadsheet Exercise – Steps 5-7||00:37:00|
|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|
|Create Worksheet Formulas||00:15: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:17: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:07:00|
|Preview and Print a Workbook||00:10:00|
|Set Up the Page Layout||00:08:00|
|Configure Headers and Footers||00:07:00|
|Manage Workbook and Worksheet Views||00:07:00|
|Manage Workbook Properties||00:05:00|
No Reviews found for this course.