Want to learn something new – We’ll Show You.
Welcome, Please Log in
Welcome to Kingston Open College. Please log in to access your account and explore a world of knowledge and growth.
Sign in to your Account
About Us
At Kingston, we offer the best in e-learning courses, featuring regulated and endorsed qualifications for your career growth.
We Are Social
Follow Us:
Contact Us
-
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
-
Create Worksheet Formulas 00:15:00
-
Insert Functions 00:17:00
-
Reuse Formulas and Functions 00:17:00
-
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
-
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
-
Preview and Print a Workbook 00:10:00
-
Set Up the Page Layout 00:09:00
-
Configure Headers and Footers 00:07:00
-
Manage Worksheets 00:05:00
-
Manage Workbook and Worksheet Views 00:07:00
-
Manage Workbook Properties 00:06:00
-
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
-
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
-
Create and Modify Tables 00:16:00
-
Apply Intermediate Conditional Formatting 00:07:00
-
Apply Advanced Conditional Formatting 00:05:00
-
Create Charts 00:13:00
-
Modify and Format Charts 00:12:00
-
Use Advanced Chart Features 00:12:00
-
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
-
Use Links and External References 00:12:00
-
Use 3-D References 00:06:00
-
Consolidate Data 00:05:00
-
Use Lookup Functions 00:12:00
-
Trace Cells 00:09:00
-
Watch and Evaluate Formulas 00:08:00
-
Collaborate on a Workbook 00:19:00
-
Protect Worksheets and Workbooks 00:08:00
-
Apply Data Validation 00:13:00
-
Search for Invalid Data and Formulas with Errors 00:04:00
-
Work with Macros 00:18:00
Course Overview
This premium QLS endorsed Excel for Bookkeeping course comes with intensive study modules, dedicated tutor assistance, customer support, flexible learning opportunity and a globally recognised certification all-together. Thus, successful completion of our Excel for Bookkeeping course will give you limitless opportunities anywhere and everywhere, since the value of QLS endorsed courses are quite high, to say the least!!
What’s more, the quality of our first-class course is uncompromising for both you and us. You will be taught the richest of materials from this exquisite Excel for Bookkeeping course, enabling you to open up a vast world of opportunities for you to grasp and gain success from. For the price point, this course is actually an absolute steal! It’s an investment you absolutely do not want to miss out on!
So, why delay any longer? Benefit your career progression by joining us today and distinguish yourself as, unquestionably, the most skilled one in your workplace!
Key features
- E-learning and E-assessment system with flexibility.
- Learners get interactive resources.
- Expert advice from qualified professionals
- Globally recognised certificate.
- 14 days refund guarantee.
- 24/7 Tutor Support
Learning Outcome
- Have a thorough grasp of the Excel for Bookkeeping in just a few hours, rather than years.
- Acquainted yourself with the most recent industry developments and changes.
- Adjust and adapt in any working setting by combining your academic and practical expertise.
- Seek assistance from our qualified teachers at any moment.
- Get your hands on professionally developed and prepared course materials.
- Study whenever and from anywhere you wish.
Course Details
We, as one of the leading eLearning service providers across the globe, strive to provide all our learners with the best eLearning experience possible that can make a real difference in their career progression.
- 9+ hours of video lectures and digital resources are available on demand.
- Learn at your own speed with affordable, high-quality E-learning content.
- When you finish the course, you will be given a certificate of completion.
- Enhance your resume from a globally recognised Accredited Qualification.
- You’ll discover how effective salespeople use a researched and proven technique to boost their careers.
- You’ll be able to successfully implement several practical sales strategies and have a deeper understanding of your consumers.
Our course is open for everyone. This Excel for Bookkeeping is ideal for those who aspire to gain in-depth knowledge & efficient skill to embark into the relevant sector as a promising potential.
- Module 01: Getting Started with Microsoft Office Excel 2016
- Module 02: Performing Calculations
- Module 03: Modifying a Worksheet
- Module 04: Formatting a Worksheet
- Module 05: Printing Workbooks
- Module 06: Managing Workbooks
- Module 07: Working with Functions
- Module 08: Working with Lists
- Module 09: Analyzing Data
- Module 10: Visualizing Data with Charts
- Module 11: Using PivotTables and PivotCharts
- Module 12: Working with Multiple Worksheets and Workbooks
- Module 13: Using Lookup Functions and Formula Auditing
- Module 14: Sharing and Protecting Workbooks
- Module 15: Automating Workbook Functionality
Learners must submit a comprehensive summerised assignment on all the units that will be assessed by our expert tutor if all the learning outcomes are met as per the standard set by QLS. After the quality check, learner will be provided with the Excel for Bookkeeping certificate
An endorsed certificate will be issued to learners at the end of the course as recognition of course completion. Provided that learner completes all the assessment of a course can claim for certificate.
QLS endorsed this certified course as a highly qualified, non-regulated provision and training programme. There will be a trainer to answer all your questions including your progression routes into further higher education. It is a non-accredited course.
There are no formal requirements needed for this Excel for Bookkeeping course. So learners do not require any prior qualifications to enrol in this course.
Course Reviews
No Reviews found for this course.
Course Info
Lessons : 53
Assignments : No assignments
Duration : 9 hours, 48 minutes
Access : 1 year
Enrol now, pay later in easy instalments(Interest free) with Clearpay.
