Posts tagged ‘video tutorial’

Computer Lessons for Office Word – Creating a Newsletter

Create a Simple Newsletter - Computer Lessons for Office Word

Create a Simple Newsletter – Computer Lessons for Office Word

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 the rest of this entry »

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 »

What is Excel – Working with Excel Cells Computer Lesson

What is Excel - Working with Excel Cells

What is Excel – Working with Excel Cells

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 the rest of this entry »

What is Excel – Understand How to Use Excel Worksheets

What is Excel - Understand how to use Excel Worksheets

What is Excel – Understand how to use Excel Worksheets

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 the rest of this entry »

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

How to use Excel - How to use Excel Formulas on a Spreadsheet

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 »

How to use Excel – Creating complex formulas

How to use Excel - Creating complex formulas

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 »