Accounts Clerk and MS Excel Course


Description

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.

What you'll learn

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

Certification

After completing this course's assessment, you will be eligible for:

OE Certificate@2x-100 (1) (1) (1)
Transcript

The CPD QS Accredited Certificate Is Available In PDF Format, At The Cost Of £9, Or A Hard Copy Can Be Sent To You Via Post, At The Cost Of £15.​

Order Your Certificate here

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.

Career Path

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

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
Order Your Certificate
Order Your Certificate Now 00:00:00
sidemoneyBack

COPYRIGHT © 2022 One Education

Home Search Cart
0
    0
    Your Cart
    Your cart is emptyBrowse Courses

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

    Claim Offer & Upgrade

    Membership renews after 12 months. You can cancel anytime from your account.

    Other Students Also Buy
      Apply Coupon