18-02-2020
How to Remove Duplicates in Excel 2020
18-02-2020
In this video tutorial, I will show you how to remove duplicates in excel 2020. I will be using the latest version of Microsoft Excel Office 365.
25-10-2018
Libre Office Calc Spreadsheet - Cell Borders Tutorial
25-10-2018
In this video tutorial, I will show you how to add borders to spreadsheet cells using Libre Office Calc 6. Adding borders to spreadsheet cells makes it easier to view content on a computer screen, in a PDF file or when you print the document.
24-10-2018
How to calculate VAT using Libre Office Calc Spreadsheet
24-10-2018
In this video tutorial, I will show you how to calculate VAT using Libre Office Calc Spreadsheet.
23-10-2018
How to Calculate Averages using Libre Office Calc Spreadsheet
23-10-2018
In this video tutorial, I will show you how to Calculate Averages using Libre Office Calc Spreadsheet.
17-10-2018
Libre Office Calc - How to format cells
17-10-2018
In this video tutorial, I will show you how to format cells in Libre Office Calc 6. It is important to understand how to format cell correctly in LibreOffice Calc. When cells are formatted correctly the data entered will display in the correct format. You can also change how data is displayed depending on the chosen format, for examples, currently, values may contain a "£" or "$" sign.
25-09-2017
How to save a Microsoft Excel spreadsheet in CSV format
25-09-2017
In this video tutorial, I will show you how to save an Excel Spreadsheet in CSV format. CSV stands for Comma Separated Values. CSV files are normally used for importing and exporting data from web and desktop applications. A good example is importing email addresses into a newsletter system, mail-chimp uses CSV files for importing emails into a mailing list.
05-08-2017
How to calculate percentages using Open Office Calc spreadsheet
05-08-2017
In this video tutorial, I will show you how to calculate percentages using Open Office Calc spreadsheet. Save yourself some time and use formulas to calculate percentages for small or big data sets.
23-05-2015
How to add gird lines to an open office calc spreadsheet
23-05-2015
In this tutorial, I will show you how to add gridlines to an open office calc spreadsheet.
10-05-2015
How to Calculate VAT using Open Office Calc spreadsheet
10-05-2015
In this tutorial, I will show you how to Calculate VAT using Open Office Calc Spreadsheet. We will use formulas to automatically calculate the VAT for any value.
08-03-2015
Libre Office Calc spreadsheet beginners tutorial
08-03-2015
This is a free Libre Office Calc Beginners Tutorial. In this tutorial, we will cover the fundamental of using Libre office Spreadsheets. Libre Office Calc is a spreadsheet software application which is very similar to Open Office Calc and Microsoft Excel. Libre Office Calc can be used to complete various analytical and business documentation tasks.
13-02-2015
Open Office Calc Spreadsheets - Sort Columns - ascending order / descending order
13-02-2015
In this tutorial, I will show you how to sort columns in Open Office Calc using ascending order or descending order. Sorting columns in a spreadsheet can be useful when you need to analyse data. Sorting by date or name is often required when analysing large data sets in a spreadsheet.
23-08-2014
Bookkeeping for small business tutorial part 1 - open office calc spreadsheets
23-08-2014
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.
23-08-2014
bookkeeping for small business tutorial part 2 - open office calc spreadsheets - invoice template
23-08-2014
This is a free video tutorial for small business bookkeeping - part 2 - open office calc spreadsheets - invoice template design. In this 2nd bookkeeping, the tutorial will focus on designing a custom invoice template. We will design the invoice template from a blank spreadsheet document, the goal is not only to design a custom invoice but also give you a better understanding of how to layout documents using Open Office Calc.
23-08-2014
Bookkeeping for small business tutorial part 3 - open office calc spreadsheet - expenditure tracking
23-08-2014
In this final tutorial (I hope you made it this far) we will focus on creating an expenditure tracking spreadsheet. Wouldn't it be great if you could look at the spreadsheet and find out how much you have spent on fuel over a period of a month or year? Or how much you have spent on telephone bills or broadband costs?
27-12-2013
Microsoft Excel beginners spreadsheet tutorial
27-12-2013
This is a free Microsoft Excel Beginners Spreadsheet Tutorial. In this tutorial will focus on the fundamentals of Microsoft Excel. We will look at various aspects which include columns, rows, formatting cells, cell alignment, changing fonts, formatting text, changing the cell background colour, adding cell borders, using auto filters and much more. Once you have completed the tutorial you should have a good understanding of Microsoft Excel.
01-09-2013
Open Office 4 - Calc Spreadsheet Beginners Tutorial
01-09-2013
This is a free video tutorial I will aim to give you a basic understanding of Open Office 4 – Calc Spreadsheet. The goal of this video tutorial is to give you a fundamental understanding of how spreadsheets work. In this tutorial, we will use Open Office 4 Calc. We will cover various common aspects of spreadsheet applications. We will look at column data, row data, auto filters, cells, cell types, cell formatting, cell colour controls and much more.
01-09-2013
How to make a chart using Open Office 4 Calc Spreadsheet Video Tutorial
01-09-2013
In this video tutorial, I will show you how to make a chart using Open Office 4 Calc Spreadsheet. Creating charts can be a useful tool when you need to visualise data. For example, you may want to create a chart showing how much revenue you have generated over a specific period of time or make a cart to show how many customers visit your shop on a daily basis. The chart can be easily created using Open Office 4 Calc Spreadsheets.
