Basic Excel for Book Keeping

Productivity - Paula Guilfoyle

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

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