Basic Excel for Book Keeping
Productivity - Paula Guilfoyle
Ready to take this Premium course?
Sign up today and continue this course plus 1000 more courses anytime, anywhere.
23 Lessons ( 1h )
-
1.
Course Introduction
-
2.
Overview
-
3.
Basics 1
-
4.
Basics 2
-
5.
Basics 3
-
6.
Conclusion
-
7.
Introduction to Daybooks,…
-
8.
Sales and Sales Returns Daybook
-
9.
Purchase and Purchase return…
-
10.
Petty cash daybook
-
11.
Payments and receipts daybooks
-
12.
Conclusion
-
13.
Introduction
-
14.
Working with data 1
-
15.
Working with data 2
-
16.
Introduction
-
17.
Organizing and Sorting Data…
-
18.
Organizing and Sorting Data…
-
19.
Conclusion
-
20.
Introduction
-
21.
Analysing Data 1
-
22.
Analysing Data 2
-
23.
Review
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 Objectives:
- 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
Instructor
Paula Guilfoyle
Operations and Business Management Expert
Paula carries around 15 years of experience in the field of Accountancy, Auditing, Business and Operations…
Training 5 or more people?
Get your team access to WIISE top 2,000 courses anytime, anywhere.
Try WIISE for Business
What will you cover?
-
Course Introduction
0:01:10
-
Overview
0:01:00
-
Basics 1
0:04:24
-
Basics 2
0:04:28
-
Basics 3
0:03:02
-
Conclusion
0:00:58
-
Introduction to Daybooks, Bookkeeping and Accounting
0:01:10
-
Sales and Sales Returns Daybook
0:02:04
-
Purchase and Purchase return daybook
0:02:01
-
Petty cash daybook
0:01:30
-
Payments and receipts daybooks
0:03:24
-
Conclusion
0:03:01
-
Introduction
0:01:00
-
Working with data 1
0:05:17
-
Working with data 2
0:06:31
-
Introduction
0:00:36
-
Organizing and Sorting Data 1
0:02:54
-
Organizing and Sorting Data 2
0:04:19
-
Conclusion
0:00:35
-
Introduction
0:02:19
-
Analysing Data 1
0:02:19
-
Analysing Data 2
0:06:20
-
Review
0:00:24
Instructor
Paula Guilfoyle
Operations and Business Management Expert
Paula carries around 15 years of experience in the field of Accountancy, Auditing, Business and Operations…
Training 5 or more people?
Get your team access to WIISE top 2,000 courses anytime, anywhere.
Try WIISE for Business
Project Description
Please download the attached workbook in supporting materials and practice the examples as you go through the video
When you have a section complete - post the section number and complete so we know that you are completing the exercises
Section 1:
Ensure that you have gained some knowledge to understand this section, try out the following
- Open a new workbook in Excel
- Save a new workbook
- Select cell A2 and type in your name
- Select cell A2 and delete your name
- Undo the delete so that your name reappears.
Using the sample Day Book file from section 2, have a go at the following
- On the worksheet, paste special, Find the value 500 and replace it with 1.42
- On the worksheet, paste special, use the paste special function to multiple all of the values in column A by the multiplier value in cell C1
- On any Day Book that has row 2 blank, delete this row.
- Format the Day Book Name on each day book so that it has been merged and centered.
- Ensure dates and % are in the correct format
- Enter any missing columns to the petty cash day book including any necessary formula
Using the workbook, you will be working on the following
- Create a table for each of the day books
- On the sheet Salestax_vat, give a name to the sales tax rates range.
- In each of the Day Books, set up data validation for the sales tax rates, so that the % is pulled directly from the named list that you set up in 2 above.
Attachments
Basic Book Keeping-Zip File - 19 KB
User Projects Not found ! in this Course
Ready to take this Premium course?
Sign up today and continue this course plus 1000 more courses anytime, anywhere.
-
1.
Course Introduction
-
2.
Overview
-
3.
Basics 1
-
4.
Basics 2
-
5.
Basics 3
-
6.
Conclusion
-
7.
Introduction to Daybooks,…
-
8.
Sales and Sales Returns Daybook
-
9.
Purchase and Purchase return…
-
10.
Petty cash daybook
-
11.
Payments and receipts daybooks
-
12.
Conclusion
-
13.
Introduction
-
14.
Working with data 1
-
15.
Working with data 2
-
16.
Introduction
-
17.
Organizing and Sorting Data…
-
18.
Organizing and Sorting Data…
-
19.
Conclusion
-
20.
Introduction
-
21.
Analysing Data 1
-
22.
Analysing Data 2
-
23.
Review
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 Objectives:
- 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
Instructor
Paula Guilfoyle
Operations and Business Management Expert
Paula carries around 15 years of experience in the field of Accountancy, Auditing, Business and Operations…
Training 5 or more people?
Get your team access to WIISE top 2,000 courses anytime, anywhere.
Try WIISE for Business
What will you cover?
-
Course Introduction
0:01:10
-
Overview
0:01:00
-
Basics 1
0:04:24
-
Basics 2
0:04:28
-
Basics 3
0:03:02
-
Conclusion
0:00:58
-
Introduction to Daybooks, Bookkeeping and Accounting
0:01:10
-
Sales and Sales Returns Daybook
0:02:04
-
Purchase and Purchase return daybook
0:02:01
-
Petty cash daybook
0:01:30
-
Payments and receipts daybooks
0:03:24
-
Conclusion
0:03:01
-
Introduction
0:01:00
-
Working with data 1
0:05:17
-
Working with data 2
0:06:31
-
Introduction
0:00:36
-
Organizing and Sorting Data 1
0:02:54
-
Organizing and Sorting Data 2
0:04:19
-
Conclusion
0:00:35
-
Introduction
0:02:19
-
Analysing Data 1
0:02:19
-
Analysing Data 2
0:06:20
-
Review
0:00:24
Instructor
Paula Guilfoyle
Operations and Business Management Expert
Paula carries around 15 years of experience in the field of Accountancy, Auditing, Business and Operations…
Training 5 or more people?
Get your team access to WIISE top 2,000 courses anytime, anywhere.
Try WIISE for Business
Project Description
Please download the attached workbook in supporting materials and practice the examples as you go through the video
When you have a section complete - post the section number and complete so we know that you are completing the exercises
Section 1:
Ensure that you have gained some knowledge to understand this section, try out the following
- Open a new workbook in Excel
- Save a new workbook
- Select cell A2 and type in your name
- Select cell A2 and delete your name
- Undo the delete so that your name reappears.
Using the sample Day Book file from section 2, have a go at the following
- On the worksheet, paste special, Find the value 500 and replace it with 1.42
- On the worksheet, paste special, use the paste special function to multiple all of the values in column A by the multiplier value in cell C1
- On any Day Book that has row 2 blank, delete this row.
- Format the Day Book Name on each day book so that it has been merged and centered.
- Ensure dates and % are in the correct format
- Enter any missing columns to the petty cash day book including any necessary formula
Using the workbook, you will be working on the following
- Create a table for each of the day books
- On the sheet Salestax_vat, give a name to the sales tax rates range.
- In each of the Day Books, set up data validation for the sales tax rates, so that the % is pulled directly from the named list that you set up in 2 above.
Attachments
Basic Book Keeping-Zip File - 19 KB