Meganga.

How to use Excel – Printing in Excel Computer Lesson

by

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

How to use Excel – Editing cells in Excel computer lesson

by

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.

Computer skills

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.

To enlarge the video left click on the small square icon in four triangular pieces bottom right of video. Press the Esc button on your keyboard to return to normal view.
Thanks for watching. If you like our lessons subscribe to our YouTube channel, it’s free and helps us tremendously, click on the button below.

Copyright notice:

You are free to copy the contents and use it for any purpose providing you keep the following credit intact and include it on the same page:

<p> <a href=”http://www.meganga.com” title=”Try www.meganga.com for free online computer lessons and tutorials for seniors and beginners”> Free online computer lessons and tutorial for seniors and beginners</a> from www.meganga.com</p>

The above code shows like this:
Free online computer lessons and tutorials for seniors and beginners from www.meganga.com

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

by

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

How to use Excel – A start with simple Excel Formulas

by

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

What is Excel – Understand How to Use Excel Worksheets

by

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

by

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

by

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

How to use Excel – What is Excel – A First Look at Excel

by

How to use Excel – What is Excel – A First Look at Excel

We start a fresh computer course for beginners by asking What is Excel ? This computer lesson about Microsoft Excel will take a first look at excel answering the question of what is excel? It starts by giving a definition and then demonstrating the type of tasks undertaken with Microsoft Office Excel by looking at the types of templates available through your Microsoft Office software. The online video computer lesson talks through the similarities between Excel and Word with the layout and The Ribbon, the excel tutorial then introduces beginners to the workbook, worksheets, columns, rows and cells.

Our computer course on how to use Excel has easy to follow step by step video computer lessons making it particularly suitable for those learning Excel for work.

[Read more…]

Follow Us

ABOUT US

Meganga.com was created to fill a very much needed gap in the provision of computer training for the elderly and beginners alike. We have a passionate belief that you are never too old to learn. Learning to use computers can open up a whole new world to people and seeing and hearing people’s enthusiasm once they do start to learn is a reward in itself.

 
Web Designer: Orkis Media