Posts tagged ‘formulas’

How to use Excel – What is an Excel Cell on a Worksheet

How to use Excel - What is an Excel Cell

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 »

How to use Excel – Basic Excel Functions

How to use Excel - Basic Excel Functions

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 »