.jpg?cache=always)
Online Course: Microsoft Excel & Accounting Training with One Education
Merchant Name Location
Loading Gallery...
An online course you can do in the comfort of your own home!
- The class will be taught via the internet, all you need is an internet connection
- You don't have to be online at a specific time, you can do the course whenever you have free time
Microsoft Excel & Accounting Training
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.
What you Get
- 1 x Hyperli code to redeem on the One Education website for Microsoft Excel & Accounting Training
How to Redeem
- Click HERE to redeem your voucher
- Copy-Paste your Hyperli voucher in the 'Voucher Code' section provided
- Copy-Paste the name of the course purchased in the 'Purchased Course Name' section
- You will then be redirected to the course you've purchased
Questions?
- Email info@oneeducation.org.uk
About the Course
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
Course Content
**Microsoft Excel**
- Getting Started with Microsoft Office Excel 2016
- Performing Calculations
- Modifying a Worksheet
- Formatting a Worksheet
- Printing Workbooks
- Managing Workbooks
- Working with Functions
- Working with Lists
- Analyzing Data
- Visualizing Data with Charts
- Using PivotTables and PivotCharts
- Working with Multiple Worksheets and Workbooks
- Using Lookup Functions and Formula Auditing
- Sharing and Protecting Workbooks
- Automating Workbook Functionality
- Creating Sparklines and Mapping Data
- Forecasting Data
**Accounting Training**
- Professional Bookkeeper Introduction
- Introduction to Accounting and Business
- The Accounting Equation
- Analyzing Transactions
- Entering Information - Posting Entries
- Adjusting Process
- Adjusting Entries
- Adjustment Summary
- Preparing a Worksheet
- Financial Statements
- Completing the Accounting Cycle
- The Accounting Cycle Illustrated
- Fiscal Year
- Spreadsheet Exercise
For full course content, click HERE
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.
See General Terms & Conditions of a voucher
- The voucher is valid for 12 months from the date of purchase
- To redeem your Hyperli voucher, visit https://www.oneeducation.org.uk/redeem-voucher/
- Copy your Hyperli voucher in the 'Voucher Code' section provided
- Copy the name of the course purchased in the 'Purchased Course Name' section
- You will then be redirected to the course you've purchased
- Please note, no refunds apply once your Hyperli voucher has been purchased ;
R225.22 Excl. VAT
R259.00 Incl. VAT
R8,230.22 Excl. VAT
R9,464.75 Incl. VAT
39% Off
Redeem your voucher on the One Education website.