Booking options
£14
£14
On-Demand course
4 weeks
All levels
The Microsoft Excel for Bookkeeping is all you need to advance your career in relevant fields.
Enrol now to discover everything you need to know about the Microsoft Excel for Bookkeeping and the skills to improve your talents in this field and be confident in your knowledge bucket with One Education as your right hand!
Meet the Endorsement
The Quality Licence Scheme has been designed specifically to recognise high-quality courses. This Microsoft Excel for Bookkeeping course materials are recognised by Quality Licence Scheme (QLS). This ensures the deep research and quality resource allocation behind the development phase of the course. In addition, the QLS certificate enriches your CV and recognises your quality study on the relevant subject.
Meet the Accreditation
CPD Quality Standards (CPD QS) accreditation assure the Microsoft Excel for Bookkeeping course training and learning activities are relevant, reliable, and upto date.
Expert Support
Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.
Key Benefits
Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.
Get 24/7 access to all content for a full year.
Each of our students gets full tutor support on weekdays (Monday to Friday)
Course Curriculum
This Excel for Bookkeeping course is designed with the following modules:
Getting Started with Microsoft Office Excel 2016
Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter Cell Data
Use Excel Help
Performing Calculations
Create Worksheet Formulas
Insert Functions
Reuse Formulas and Functions
Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows
Search for and Replace Data
Use Proofing and Research Tools
Formatting a Worksheet
Apply Text Formats
Apply Number Format
Align Cell Contents
Apply Styles and Themes
Apply Basic Conditional Formatting
Create and Use Templates
Printing Workbooks
Preview and Print a Workbook
Set Up the Page Layout
Configure Headers and Footers
Managing Workbooks
Manage Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties
Working with Functions
Work with Ranges
Use Specialized Functions
Work with Logical Functions
Work with Date & Time Functions
Work with Text Functions
Working with Lists
Sort Data
Filter Data
Query Data with Database Functions
Outline and Subtotal Data
Analyzing Data
Create and Modify Tables
Apply Intermediate Conditional Formatting
Apply Advanced Conditional Formatting
Visualizing Data with Charts
Create Charts
Modify and Format Charts
Use Advanced Chart Features
Using PivotTables and PivotCharts
Create a PivotTable
Analyze PivotTable Data
Present Data with PivotCharts
Filter Data by Using Timelines and Slicers
Working with Multiple Worksheets and Workbooks
Use Links and External References
Use 3-D References
Consolidate Data
Using Lookup Functions and Formula Auditing
Use Lookup Functions
Trace Cells
Watch and Evaluate Formulas
Sharing and Protecting Workbooks
Collaborate on a Workbook
Protect Worksheets and Workbooks
Automating Workbook Functionality
Apply Data Validation
Search for Invalid Data and Formulas with Errors
Work with Macros
Course Assessment
To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%.
When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme.
Certificate of Achievement
Endorsed Certificate of Achievement from the Quality Licence Scheme
After successfully completing the Microsoft Excel for Bookkeeping course, learners will be able to order an endorsed certificate as proof of their achievement. Hardcopy of this certificate of achievement endorsed by the Quality Licence Scheme can be ordered and received straight to your home by post, by paying
Within the UK: £119
International: £119 + £10 (postal charge) = £129
CPD Accredited Certification from One Education
After successfully completing this Microsoft Excel for Bookkeeping course, you will qualify for the CPD accredited certificate from One Education. Certification is available in both PDF & hardcopy format, which can be received by paying -
PDF Certificate: £9
Hardcopy Certificate (within the UK): £15
Hardcopy Certificate (international): £15 + £10 (postal charge) = £25
150 CPD hours / points Accredited by CPD Quality Standards
This Microsoft Excel for Bookkeeping course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge.
This Microsoft Excel for Bookkeeping course is open to all, with no formal entry requirements.
Upon successful completion of the Microsoft Excel for Bookkeeping Course, learners will be equipped with many indispensable skills and have the opportunity to grab.
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn apply to your career aspirations in manag...