Written March 28th, 2012
How to use Excel – What is an Excel Cell
How to use Excel
Our computer lessons on how to use Excel continue with an online video tutorial, What is an Excel Cell on a worksheet. Following on from the start of our Excel computer course, this lesson recaps on topics learnt, on the Excel layout, looking at columns and rows before moving on to identifying Cell Addresses or Cell References. The computer lesson for Excel beginners then talks about the three types of data that can be added to cells, labels, values and formulas. The lesson builds up a very simple worksheet to demonstrate the three types of data being added and also introduces Excel beginners to the Name Box and the Formula Bar, two areas essential to understand for anyone who wants to know how to use excel.
The computer lesson on Excel is suitable for anyone worldwide wishing to improve their computer skills and particularly those learning Excel for work and looking at spreadsheets.
Read the rest of this entry »
Written April 15th, 2012
How to use Excel – How to use Excel Formulas on a Spreadsheet
How to use Excel Formulas in a Spreadsheet
We move on in our computer lessons for Excel with quite a long video tutorial showing how to use Excel Formulas in a spreadsheet. We use a simple Excel spreadsheet to calculate the profits from running a special steam train service. The computer lesson for excel beginners demonstrates how to change currencies to a single Excel cell and also multiple Excel cells before concentrating on how to use Excel Formulas. The online tutorial shoes how to multilpy cell and then repeat the calculation by dragging the Excel Formula down to the Excel row or rows below. The computer lesson also uses Auto sum to calculate totals and shows how to place a calculated total in to another Excel cell.
Understand Excel Formulas
Anyone wishing to improve their basic computer skills and learn how to use Excel this computer lesson will help to understand Excel Formulas and Excel spreadsheets better whether for work or home. Read the rest of this entry »
Written February 5th, 2013
How to use Excel – Basic Excel Functions
The next in the series how to use excel 2010 continues with a video computer lesson about using basic functions in excel. When excel formulas would be too complicated or too long we can use functions, functions are predefined and can be found from the formulas tab on your excel ribbon. This video tutorial made by gcflearnfree.org talks us through how to use functions in a very clear way. The excel lesson starts by demonstrating a simple sum function before moving on to show how to use a function to work out delivery time, given order and delivery dates on a spreadsheet.
This lesson is an easy to follow video tutorial suitable for anyone familiar with the basics of excel and wishing to learn how to use excel fully. Read the rest of this entry »