Basic Excel for Basic Bookkeeping and Accounting

In this lesson we will cover the learning objectives for section 2

In this lesson we will look at a simple sales daybook combined with a sales returns daybook in Excel and you will be introduced to the important details that you should record in this daybook for bookkeeping and accounting purposes.

In this lesson we will look at a simple purchase daybook combined with a purchase returns daybook in Excel and you will be introduced to the important details that you should record in this daybook for bookkeeping and accounting purposes.

In this lesson we will look at a simple pettycash daybook in Excel and you will be introduced to the important details that you should record in this daybook for bookkeeping and accounting purposes.

In this lesson we will look at a simple payments daybook and a receipts daybook in Excel and you will be introduced to the important details that you should record in this daybook for bookkeeping and accounting purposes.

In this lesson we will look at some key points from this section - Daybooks and Bookkeeping - The basics

Welcome to section 3 Excel - Working with data. In this lesson we will look at the learning objectives for this section.

In this lesson we are going to look at inserting and hiding rows and columns, merging and splitting cells, paste special, find and replace and hide and unhide

In this lesson - Excel - working with data 2, we are going to look at entering basic formulas, spell check and cell formatting

Complete these activities to ensure that you both understand what you have been shown and to ensure that you can apply this information to your spreadsheets

Welcome to section 4 Excel - Organizing and sorting data. In this lesson we will look at the learning outcome for this section

In this lesson Excel - Organizing and sorting data you will be introduced to tables and and filters

In this lesson Excel Organising and sorting data 2 you will be introduced to Lists, name and data validation.

Congratulations on completing section 4 - Organizing and sorting data in excel.

Do these practice activities to ensure that you both understand and can carry out these tasks in Excel

Welcome to section 5 Excel - Analyzing data in Excel. In this quick lesson we will cover the learning objectives for this section

In this lesson Excel - Analyzing data. In this lesson we will look at how you can insert a recommended chart to Excel

In this lesson Excel Analyzing data, you will be introduced to Excels Pivot tables

Congratulations on completing section 5 Excel - Analyzing data

To conclude on the course lets mention the key learning objectives of this course

Learn about excels print options.  It is such a pity when a workbook is prepared with such care, and then distributed without first checking the print settings.