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 April 18th, 2012
How to use Excel – Editing cells in Excel
How to use Excel
Editing Excel Cells
We continue our computer course showing how to use Excel with a computer lesson demonstrating editing cells in Excel. The lesson talks about how you can set permissions and passwords to protect your work in Excel without going in to too much detail at this time, before showing three ways of editing Excel cells, firstly double clicking the selected cell, secondly using the Excel formula bar and then explaining how key F2 can be used. The computer lesson for excel beginners goes on to demonstrate the status bar at the bottom of the Excel worksheet.
The course for how to use Excel is suitable for anybody looking to improve their computer skills and understand about spreadsheets for work or home. Those people looking to qualify in the European Computer Driving Licence (ECDL) will also find this computer lesson helpful for obtaining their qualification. Read the rest of this entry »
Written May 7th, 2012
How to use Excel – Printing in Excel Computer Lesson
Our course in how to use Excel for beginners and seniors continues with a computer lesson about printing in Excel. The Excel print area is not as straightforward as Microsoft word and some thought and planning needs to be applied to get the best Excel print area. The beginners Excel tutorial talks through the commands for printing in excel showing that there are options for printing the active excel worksheet, printing the entire workbook, selecting several worksheets or just choosing the excel print area. During the Excel computer lesson the different orientations are demonstrated, portrait or landscape, collated printing is explained and scaling the Excel print area is shown.
The Printing in Excel computer lesson is suitable for any beginner looking to understand how to use excel and for those looking to gain a formal qualification the online computer tutorial will help with excel spreadheets sections, printing in excel and understanding excel print area. Read the rest of this entry »
Written January 9th, 2013
Printing in Excel
Printing in Excel 2010 continued. We have added another computer lesson in our Excel computer lessons about printing. This video tutorial is by Gcflearnfree and probably demonstrates better than our own the Excel commands used when printing in excel. The computer lesson is clear and concise showing the constraints and the thought needed to plan your excel printing from your Excel worksheet or workbook.
This Printing in Excel computer lesson is suitable for any computer beginner looking to understand how to use excel and for those looking to gain formal qualifications, the online computer tutorial will help with excel spreadheets sections, printing in excel and understanding the excel print area.
Read the rest of this entry »
Written January 9th, 2013
How to use Excel – Creating complex videos
The next in the How to use Excel 2010 computer lessons takes a look at more complex excel formulas. To fully understand the potential of Excel 2010 you need to understand how to create and use complex formulas and this video tutorial made by Gcflearnfree.org explains in a very clear way how to create complex excel formulas and shows a typical application in which a complex formula may be used for. The video gives a thorough explanation of the order of operation for all formulas, rules that are essential to understand.
The online video tutorial shows the order of operation of 1. Parentheses or Brackets, 2. Exponents, 3. Multiplication & Division and 4. Addition & Subtraction and an easy way to remember the rule.
The video is suitable for anyone who has covered the basic Excel 2010 computer lessons.
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 »