How to use Excel – How to use Simple Excel Formulas in a Spreadsheet

April 15, 2012 by steve

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 more…]

What is Excel – Understand How to Use Excel Worksheets

April 8, 2012 by steve

How to use Excel

Our What is Excel course of computer lessons for Excel continues with an online video tutorial, Understand how to use Excel worksheets, helping beginners, seniors and those looking to learn Excel for work. The computer lesson explains why we may need a number of Excel worksheets for different projects. The online lesson then continues to show how to rename, colour code, drag and copy worksheets before demonstrating how to use Excel worksheets grouped togethor to make alterations. The tutorial also demonstrates how to keep headings in view when scrolloing large Excel worksheets before saving the work to file.

The computer lesson helps to understand what is Excel and is designed in an easy to follow format being suitable for seniors, beginners and anyone looking to improve their basic computer skills and learning Excel for work. The computer lesson follows a sequence in an Excel course and should be viewed in conjunction with other videos from our course. [Read more…]

What is Excel – Working with Excel Cells Computer Lesson

April 8, 2012 by steve

What is Excel

This computer lesson for What is Excel takes a closer look at how to use Exel Cells. The online video tutorial demonstrates how to select multiple cells, how to merge cells and how to resize columns and rows to fit Excel labels or text. The beginners Excel computer lesson continues to show how to selcect entire excel columns and excel rows before demonstrating where the commands are to insert additional rows and columns. By learning how to use excel cells enables easy editing and helps with Excel layout, important for topics later in our Excel computer course.

The online computer lesson is suitable for anyone worldwide who is trying to improve their computer skills, particularly those looking to learn Excel for Work. [Read more…]

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

March 28, 2012 by steve

What is an Excel Cell on a worksheet

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 more…]

Computer Lessons for Office Word – Creating a Newsletter

March 18, 2012 by steve

Computer courses in Microsoft Office Word

Our computer course for beginners in Microsoft Office Word continues with a computer lesson creating a simple newsletter in Office Word. The tutorial starts by showing there are plenty of templates to choose from through your Microsoft Office Word software before demonstrating through a step by step online tutorial how to create a simple newsletter from scratch.

The computer lesson for beginners, seniors and anyone looking to improve their basic computer skills shows how to build a title, add the date and fit columns to a document, before going on to insert a photograph and a table. The online learning tutorial reinforces lessons already learnt and adds some other office word commands and techniques. [Read more…]