Practical Excel Training - Basic Excel for Basic Bookkeeping

Basic Excel for Basic Bookkeeping - an introductory Class for those that are new to Excel and new to Bookkeeping or need a refresher class

In This Class You Will Learn The Basics Of Excel, The Very Basics of Bookkeeping, And How You Can Do Simple and Basic Bookkeeping in Excel.

If you need to record basic transactions for your business. If you are new to Excel? Do you need an Excel Refresher course THEN REGISTER NOW

Course Overview

We will begin this course by introducing you to Excel, where you will learn the very basics. We will introduce you to a workbook and the ribbons, and you will learn how to select, enter and delete data.

In section 2 we will move into the very basics of bookkeeping, we will introduce you to the day books that you should keep and we will identify key details that you should record in these day-books. These day-books, prepared in Excel, are available for download, and we will use them in the rest of this course while we are working in Excel.

In section 3 - Excel working with data, you will learn how insert, remove and merge cells, rows and columns. We will also look at find and replace, hide and unhide and Special paste. After this we will move on to entering basic formula and some formatting.

Section 4 of this course - Excel Organizing and sorting data, will give you the opportunity to organize the day-books using tables, filters, names and data validation

Finally in section 5 Excel Analyzing data you will be introduced to Excels recommended charts and recommended pivot tables.

Once you have finished this class you will be ready for some more advanced Excel. Check out my profile to see what else I have available

• Courseintro
• Section 1 overview
• Excel - The basics 1
• Excel - The basics 2
• Excel - The basics 3
• Review
• Introduction to Daybooks, Bookkeeping and Accounting
• Sales and sales returns daybook
• Purchase and purchase returns daybook
• Petty Cash
• Bank
• Review 2
• Introduction to working with Data
• Working with data 1
• Working with data 2
• Organizing and sorting data introduction
• Organizing and sorting data 1
• Organizing and sorting data 2
• Review
• Introduction to Analyzing data
• Analyzing data 1
• Analyzing data 2
• Analyzing data
• Conclusion