Microsoft Excel & Accounting Training

Microsoft Excel & Accounting Training

get Access To All 3500+ One Education Courses For Just £49/Year!
Claim Offer

Overview:

This 2-in-1 CPD bundle course program is designed to give our learners a more in-depth understanding of business accounting by equipping them with the skills to manage everyday accounting tasks by mastering Microsoft Excel. 

Are you training to become a bookkeeper or accountant, but lack the necessary admin skills required for this role? The Microsoft Excel 2016 course is designed to help learners master Microsoft Excel for small business accounting to manage financial data more efficiently. This instructor-led training program starts by familiarising you with the interface, essential Excel functions, formulas, and commands. You will learn how to modify worksheets, use the lookup functions, share workbooks, calculate forecasts and much more.

Develop the necessary skills and knowledge to kickstart your career in the accounting sector with The Business Accounting Training course. This course covers the fundamental principles and practices of business accounting, with an in-depth look at the accounting life cycle. You will learn how to analyse transactions, prepare a trial balance, and use the accounting equation to make smarter financial decisions. On completion, you will have a solid understanding of accounting theory and practice.

Highlights  of The Microsoft Excel & Accounting Training:

  • Get acquainted with basic Excel formulas, functions and commands
  • Learn how to create, save, print and share workbooks in Excel
  • Understand how to format and modify your worksheets for basic administrative tasks
  • Know how to apply intermediate and advanced conditional formatting
  • Understand the basics of data forecasting and analysing to determine potential outcomes
  • Gain a solid understanding of the fundamentals of business accounting 
  • Explore the different steps of the accounting cycle
  • Familiarise with the accounting equation formula for double-entry accounting
  • Learn how to prepare a trial balance and be able to identify the different types of trial balances
  • Take steps to become a bookkeeper or accountant with a recognised certification

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

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

Who is This Course for?

This bundle course certification is recommended for aspiring business accountants and bookkeepers, including those who are new to the finance sector. This is an entry-level course ideal for beginners who wish to gain the core skills and industry knowledge to fast track their career.

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 Microsoft Excel & Accounting Training 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 certificate 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, learners will have the confidence and practical knowledge to pursue the following roles:

  • Business Accountant
  • Bookkeeper
  • Finance Assistant
  • External Auditor
  • Chartered Accountant

Course Curriculum

**Microsoft 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:07: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
Working with Functions
Work with Ranges 00:18:00
Use Specialized Functions 00:11:00
Work with Logical Functions 00:23:00
Work with Date & Time Functions 00:08:00
Work with Text Functions 00:11:00
Working with Lists
Sort Data 00:10:00
Filter Data 00:10:00
Query Data with Database Functions 00:09:00
Outline and Subtotal Data 00:09:00
Analyzing Data
Create and Modify Tables 00:16:00
Apply Intermediate Conditional Formatting 00:07:00
Apply Advanced Conditional Formatting 00:05:00
Visualizing Data with Charts
Create Charts 00:13:00
Modify and Format Charts 00:12:00
Use Advanced Chart Features 00:12:00
Using PivotTables and PivotCharts
Create a PivotTable 00:13:00
Analyze PivotTable Data 00:12:00
Present Data with PivotCharts 00:07:00
Filter Data by Using Timelines and Slicers 00:11:00
Working with Multiple Worksheets and Workbooks
Use Links and External References 00:12:00
Use 3-D References 00:06:00
Consolidate Data 00:05:00
Using Lookup Functions and Formula Auditing
Use Lookup Functions 00:12:00
Trace Cells 00:09:00
Watch and Evaluate Formulas 00:08:00
Sharing and Protecting Workbooks
Collaborate on a Workbook 00:19:00
Protect Worksheets and Workbooks 00:08:00
Automating Workbook Functionality
Apply Data Validation 00:13:00
Search for Invalid Data and Formulas with Errors 00:04:00
Work with Macros 00:18:00
Creating Sparklines and Mapping Data
Create Sparklines 00:07:00
MapData 00:07:00
Forecasting Data
Determine Potential Outcomes Using Data Tables 00:08:00
Determine Potential Outcomes Using Scenarios 00:09:00
Use the Goal Seek Feature 00:04:00
Forecasting Data Trends 00:05:00
**Accounting Training**
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
sidemoneyBack

COPYRIGHT © 2022 One Education

Home Search Cart
2
  • Item added to cart
  • Item added to cart
2
Your Cart
Create Videos, Motion Graphics and Animation Using Canva

Create Videos, Motion Graphics and Animation Using Canva
- +
£29
Get A PDF Certificate & Transcript After You Complete Your Course

Scholarship: Score 80% or more in your final exam to get this Fee refunded.

New Certificate On A Table
- +
£9.99

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