Pankaj Shah

I hope you enjoy reading our blog posts. If you want DCP to build you an awesome website, click here.

Bookkeeping for small business tutorial part 1 - open office calc spreadsheets

23-08-2014

Back

(Click image above to watch video tutorial)

This is a free video tutorial for small business bookkeeping - part 1 - open office calc spreadsheets - invoice tracking - bookkeeping training.

In this video tutorial, I will show you how to keep track of invoices which you have sent to your clients. By the end of this tutorial, you will be able to keep track of all your invoices and know who has paid and more importantly how has NOT paid so you can chase up payments.

We will create a spreadsheet with various informative columns which will give you a quick overview of your invoices. We will use open office calc to create the spreadsheet, but the same logic can easily be applied to Libre Office Calc or Microsoft Excel spreadsheet. 

I will show you how to use colour codes so at a glance you can quickly see which invoices are paid and which are outstanding. I will also show you how to use auto filters which simply allows to you quickly analyse information in your invoice tracking spreadsheet.

Subscribe to access 500+ video tutorials: https://www.youtube.com/dcpwebdesigners

To complete this tutorial you will need to download Open Office.

In the next tutorial will focus on designing a custom invoice template. This will be designed using open office Calc application.

Subscribe to DCP YouTube for more free business bookkeeping video tutorials.

# bookkeeping for small business

# bookkeeping tutorial for beginners

# bookkeeping training YouTube


Business bookkeeping video tutorial by: DCP Website Design


Tell Us Your Thoughts

Thank you for contacting us.
We will reply to you in next 2 working days.


Releated Posts


How to use Windows 10 Snipping Tool

30-08-2018

How to use Windows 10 Snipping Tool

In this video tutorial, I will show you how to use the Windows 10 snipping tool. The snipping tool is super useful if you simply want to screen capture your computer screen, a specific part of an image, document or web page. You can then make comments or highlight parts of the image for reference. You can quickly send the image using popular email applications with a few simple mouse clicks.

Libre Office 6 - Calc - Basic Formulas Tutorial

09-10-2018

Libre Office 6 - Calc - Basic Formulas Tutorial

In this video tutorial, I will show you how to use basic formulas in Libre Office Calc 6. Understanding how formulas work in spreadsheets can save you lots of time. You can use formulas to repeat processings like adding numbers together or create more custom complex formulas for data analysis.

Libre Office pivot table tutorial

01-10-2017

Libre Office pivot table tutorial

In this video tutorial, I will show you how to setup Libre Office pivot tables. Pivot tables allow you to structure and filter vast amounts of information using custom table structures. In basic terms, the goal of pivot tables is to give you an overview of information which can be easily viewed and interrogated. You can also create custom charts directly from a pivot table.

Libre Office Calc - Array Formulas and Functions - Part 1

02-11-2018

Libre Office Calc - Array Formulas and Functions - Part 1

In this video tutorial, I will show you how to use Libre Office Calc Array Formulas and Functions. Array Formulas and Functions can speed up the tasks when using spreadsheets. When you have to analyse data in a spreadsheet, Array Formulas and Functions can help proceed data more efficiently.

GET YOUR FREE QUOTE


CLAIM YOUR 2 HOURS

FREE CONSULTANCY


  • AFFORDABLE PRICING
  • 15 YEAR KNOWLEDGE
  • LONDON BASED DESIGN AGENCY

NO OBLIGATION QUOTE

arrow
Please enter your name
Please enter correct email
Please enter your phone number
Please enter your message

Your data is encrypted and never shared.
View our privacy policy.

Thank you for contacting us.
We will reply to you in next 2 working days.

back