Accounts Clerk and MS Excel Training

4.8( 8 REVIEWS )
1 STUDENTS

Accounts Clerk and MS Excel Training

4.8( 8 REVIEWS )
1 STUDENTS

GET LIFETIME ACCESS TO ALL OUR COURSES FOR ONLY £199 £99 GET NOW

Accounts Clerk and MS Excel Course Take This Course

Course Overview

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Accounts Clerk and MS Excel Training will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time.

The Accounts Clerk and MS Excel Training will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently.

This course is designed to provide an introduction to Accounts Clerk and MS Excel Training and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area.

Learning Objectives

    • Learn the fundamental skills you require to be an expert
    • Explore different techniques used by professionals
    • Find out the relevant job skills & knowledge to excel in this profession
    • Get a clear understanding of the job market and current demand
    • Update your skills and fill any knowledge gap to compete in the relevant industry
    • CPD accreditation for proof of acquired skills and knowledge

Who is this Course for?

Whether you are a beginner or an existing practitioner, our CPD accredited Accounts Clerk and MS Excel Training is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further.

It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects.

Entry Requirement

Anyone interested in learning more about this subject should take this Accounts Clerk and MS Excel Training. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject.

The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day.

CPD Certificate from Course Gate

At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22.

Career path

The Accounts Clerk and MS Excel Training will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market.

Course Curriculum

Accounts Clerk Training
Professional Bookkeeper Introduction
Professional Bookkeeper FREE 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 Training
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
Certificate and Transcript
Order Your Certificates or Transcripts 00:00:00
Accounts Clerk and MS Excel Training
Accounts Clerk and MS Excel Course Take This Course

Share Link on svg

Instructors

© Course Gate Edukite Ltd, Reg no: 11378092

0
Your Cart

Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49.00per year

ADD OFFER TO CART

No more than 50 active courses at any one time. Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.