Accounts Clerk and MS Excel Course
Accounts Clerk and MS Excel Course
Original price was: £425.£29Current price is: £29. ex Vat
Take This Course OR
1 Year Access 
Beginner
13 Students -
11 hours, 48 minutes
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
- 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
Certification
After completing this course's assessment, you will be eligible for:
- A CPD QS accredited Certificate from One Education.
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:
- 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 | ||
| Order Your Certificate | |||
| Order Your Certificate Now | 00:00:00 | ||
Related Courses
Important Links
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add