Written April 10th, 2012
How to use Excel – Simple Excel Formulas
Simple Excel Formulas
In this computer lesson for Excel we take a look at some simple Excel Formulas. The online video tutorial first explains how the common mathematical operations and their mathematical symbols are used in simple Excel formulas, the lesson then continues to explain that an equals sign is always inserted at the beginning of each Excel formula and demonstrates by showing some very simple Excel Formulas using add, subtract, multiply and divide. The Excel computer lesson then shows how to use the AutoSum command pointing at the Marquee effect when cells are selected. Following this, the online computer lesson demonstrates how to build simple excel formulas by selecting individual cells for each formula and concludes by showing how to round down to the desired decimal place.
How to use Excel
The computer course is part of the how to use Excel course and the next lesson in the series goes on to demonstrate simple Excel formulas used on an Excel spreadsheet. The lesson is suitable for anyone wishing to improve their basic computer skills and learn how to use Excel. 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 »