Name: Basic Excel for Book Keeping
SKU: 90276
Availability: InStock

Overview

Excel is one the most powerful and most used application. You can use an excel sheet to store any sort of information in an easy to read format. By the end of this course, you can expect yourself to be able to use Excel very easily. Also, you will be able to work with the data in an excel sheet – input, organize, sort and analyze any data that you might require.

Learning Outcomes

Open, save and close a workbook in Excel
Identify parts of an Excel workbook
Enter and delete data
Insert and remove columns and rows
Use cut, copy, paste, undo, redo, find and replace
Insert basic formula
Use paste special
Format text and cells
Use excel autofill, flash fill, auto-sum and autocomplete
Sort data
Insert tables and filters
use names and data validation to restrict user inputs
Insert charts
Insert pivot tables, timeline, and charts
Set up a basic Sales and sales returns daybook in Excel
Set up a basic Purchase and purchase returns daybook in Excel
Set up a basic petty cash daybook in Excel
Set up basic payments and receipts daybooks
Identify key information to record in the daybooks

Sample Award

REQUESTING FOR COMPLETION CERTIFICATION (additional, optional service)
It is possible that you desire to celebrate your accomplishment in completing courses in our reskilling programme by receiving relevant, verifiable, nationally recognized and internationally accredited professional qualifications (digital copy) that correspond to the course(s) you had undertaken and successfully concluded. This is possible at an affordable fee as follows:

Completed one course – Eligible for PROFESSIONAL CERTIFICATE (FOUNDATION LEVEL) @ 29 Euro only
Completed two courses – Eligible for PROFESSIONAL CERTIFICATE (PRACTITIONER LEVEL) @ 39 Euro only
Completed three courses – Eligible for PROFESSIONAL CERTIFICATE (EXPERT LEVEL) @ 49 Euro only
Completed four courses – Eligible for PROFESSIONAL CERTIFICATE (MASTER LEVEL) @ 59 Euro only
Completed five courses – Eligible for PROFESSIONAL DIPLOMA @ 69 Euro only
Completed six courses – Eligible for PROFESSIONAL HIGHER DIPLOMA @ 79 Euro only
Completed seven courses – Eligible for PROFESSIONAL POST GRADUATE CERTIFICATE @ 89 Euro only
Completed eight courses – Eligible for PROFESSIONAL POST GRADUATE DIPLOMA @ 99 Euro only

To request for a digital copy award, please contact: [email protected]

Note: Since you are permitted to select the course(s) that are most useful to your own job roles, the specialization field mentioned on the qualification ordered will be determined by you. In other words, you would decide what to call your qualification. For example, if you had completed three courses, namely, Body Language for Professional Success, Public Speaking, and Workplace Communication, you could then choose to request your award to be granted with the name ADVANCED COMMUNICATION SKILLS, or PROFESSIONAL COMMUNICATION SKILLS, or any others, as per your own liking and choice. Hence, your full qualification will be called “PROFESSIONAL CERTIFICATE (EXPERT LEVEL) in ADVANCED COMMUNICATION SKILLS”