Meganga.

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

Computer Lessons for Office Word – Creating a Newsletter

by

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

Computer Courses – Word tutorials – Creating a Simple Table

by

Microsoft Office Word Tutorials

One of the great tools available in Microsoft Office Word is the ability to create a simple table quickly and easily, whether the table is for delivery times, membership numbers or in this case a football league, tables are a great way of showing data. This computer lesson for beginners and seniors demonstrates from scratch how to create a simple table by selecting the table parameters, adding the data, adding additional rows and adding a title to the table. The online word tutorial then changes the font, style and size to create a simple table easy to understand. [Read more…]

Computer Courses – Word tutorials – Creating Business Letters

by

Office Word Computer Courses

Our word computer course continues with a computer lesson about creating business letters. The online tutorial for Microsoft Office Word takes a look at creating a business letter using a template before creating a UK business letter from scratch. The computer lesson for beginners and seniors demonstrates how to position using the Tab Key and also how to use the bullet list command, when talking through how to create a UK business letter. [Read more…]

Computer Courses – Office Word Tutorials – Working With Templates

by

Microsoft Office Word Tutorials

Our Microsoft Office Word Tutorials continue with a computer lesson for beginners about working with templates in office word. The word tutorials are part of our computer courses giving basic computer skills for seniors and beginners. In the computer lesson we demonstrate where to find the pre-loaded templates when working with Word 2010 and explains where in Word 2007, the tutorial then shows templates may be downloaded from Microsoft Office online where a huge number of templates are available for all sorts of office word tasks.

The computer lesson demonstrates how to alter templates for individual use and finishes by showing templates are also available when searching online. [Read more…]

Computer Courses – Office Word Tutorials – Working With Pictures

by

Office Word tutorials

Our computer lessons for beginners and seniors continue with an Office Word tutorial, working with pictures in microsoft word, part of our computer courses for microsoft office. The online tutorial demonstrates how to place a picture in the text of a word document, resize the picture, crop the picture and wrap text around the picture. The computer lesson also shows the Picture Tools menu and some of the commands available when working with pictures in Microsoft Office Word. [Read more…]

Word Tutorials – How to Cut Copy and Paste

by

Microsoft Office Word Tutorials

Our Microsoft Office Word tutorials continue with a computer lesson showing how to cut, copy and paste in Word 2010. The online computer lesson is for seniors and beginners learning how to use Office Word. The online lesson shows how to select text in order to cut and paste it within a document, explaining that all types of data can be altered using the commands cut copy and paste. The computer word tutorial then talks about paste options demonstrating later in the lesson and covers copy and paste along with using the clipboard. The differences between Word 2010 and Word 2007 regarding paste options are spoken about. [Read more…]

Office word tutorials – Mini toolbar Quick access toolbar and help button

by

Microsoft Office Word Tutorials

We continue our Office Word Tutorials for seniors and beginners with a short computer lesson about the mini toolbar, quick access toolbar and help button, this is part of our computer courses for beginners. The computer lesson demonstrates what the mini toolbar is and how to use it, shows the quick access toolbar and points out the office word help button. The online tutorial also shows how to customize the quick access toolbar in different ways. [Read more…]

Office Word tutorials – Creating a simple flyer with word

by

In the next of our Free Microsoft Office Word tutorials we show how to create a simple flyer using word. This computer lesson for seniors and beginners is part of our word computer course and starts to demonstrate how easy it is to create pieces of work with a little planning and an understanding of the Office Word commands.

The computer lesson demonstrates how to make a flyer by producing a lost cat poster. We start with a simple bit of text which, using the word commands, we change by altering the font type, creating a title, headings and changing the font size. The online word tutorial demonstrates how to select text for altering and uses some basic word commands before running a spell check and sending the flyer for printing and saving. [Read more…]

Computer courses for beginners – Word tutorials – Tabs and Commands

by

The next of our Word Tutorials continues our computer courses for beginners and seniors with a computer lesson about the tabs and commands on the Microsoft Office Word Ribbon. The tutorial follows on from the previous computer lesson about the layout of Microsoft office word 2010 and 2007 by demonstating the other Tabs along the Office Word ribbon. Key commands are pointed out on each tab and we also demonstrate that information about commands is easily available when moving your computer mouse. [Read more…]

Computer courses for beginners – Word tutorials – The layout

by

The next of our computer courses for beginners and seniors takes a look at productivity and we start with Word tutorials, how to use Microsoft Office Word. This computer lesson demonstrates the layout of Microsoft word, because when you break down the layout and understand how Microsoft Word is arranged it becomes a lot easier to use.

In this word tutorial we demonstrate how the Ribbon is broken down into the three basic elements, Tabs, Groups and Commands. The tutorial then goes on to look at the home tab and the file tab, talking about the Microsoft Office button for those using word 2007, as the online computer lessons about Microsoft Office Word are shown using Microsoft Office Word 2010 but any differences with Word 2007 are pointed out. [Read more…]

Computer courses for beginners – Email file attachments

by

Computer courses for beginners and seniors

Meganga’s free computer courses for beginners and seniors continues with a computer lesson taking a look at email file attachments, an essential part of basic computer training.

The online tutorial starts by attaching a file to an email using the Gmail account it then shows an email that has been received with files attached, the free computer lesson checks through the email before opening it and explaining about file size restrictions when sending or receiving emails and points out the difference in file sizes for  photographs and documents.

The computer lesson aimed as part of our free computer courses for beginners and seniors explains about the dangers from opening email file attachments that are from unknown senders or suspicious, the lesson goes on to explain about computer viruses with the help of the Microsoft Safety and Security Centre and gives advice and computer training for beginners and seniors about guarding against security threats to computers. [Read more…]

Basic Computer Training – Using My Email

by

Basic computer training for seniors and beginners

Our basic computer training for beginners and seniors continues with an online computer tutorial, using my email. The tutorial takes a look at a basic Gmail account and talks through the email folders including my email inbox, sent mail and how to organise your email received mail.

The beginners computer training then shows how to compose email or create e-mail showing where to add email recipients and those mail recipients intended for information. The seniors online tutorial talks about adding file attachments to your emails and the limitations to consider.

[Read more…]

Basic Computer Training – Filling Forms and Logging In

by

We move on in our basic computer training for seniors and beginners with an online learning tutorial about filling forms and logging in to websites. As you move on and gain more confidence and better computer skills you will want to register on websites, whether for social networking, reading media or shopping, whatever the reason at some point you will need to fill out an online form. This computer lesson for beginners takes a look at two well known websites and just runs through the information you need to provide, in order to log in, along with talking about providing computer passwords.

The lesson is suitable for any beginners or seniors learning online and for those looking to qualify in the European Computer Driving Licence (ECDL), this lesson covers elements 7.7 and 7.10. [Read more…]

Basic Computer Training – Web Browsers the Basics

by

Online computer lesson

Following on in our basic computer training for seniors and beginners we have an online computer lesson pointing out the basic elements of web browsers, using the most common browsers, internet explorer and mozilla firefox. The lesson explains the what the home page is, what is meant by the term URL and goes on to explain about browsing history, bookmarking and favourites. Important for anyone learning new computer skills.

The computer tutorial is suitable for any beginner and those beginners looking to qualify in the European Computer Driving Licence (ECDL) the lesson covers elements 7.2, 7.3, 7.4 and 7.5 of the computer basics course.

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.

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 courses and tutorials for seniors and beginners”> Free online computer courses and tutorial for seniors and beginners</a> from www.meganga.com</p>

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

Basic Computer Training – Document Creation in Wordpad

by

Basic computer training

Everyone who switches on a computer, will, at some point, want to create documents and our free basic computer training for beginners and seniors shows how to get started. The online tutorial shows how to find WordPad, a word processing software, in your computer. The computer training then explains about font icons, shows how to change font style and size as well as text colour, before showing how to print and save the document. The tutorial is suitable for any beginner or senior and continues through element 4 for those looking to qualify in The European Computer Driving License (ECDL).

Being able to create documents is an important part of developing computer skills and this learning online tutorial is designed to get beginners started. More computer lessons in Microsoft Office Word, a more advanced software are available elsewhere on our website. [Read more…]

Basic Computer Training – Identifying Parts of an Application Window

by

Basic computer training

When learning anything new there is always new terminology and as with all new things it is essential when learning about computing that you understand terminology as part of learning your computer skills and this basic computer training tutorial helps by identifying the parts of an application window. The basic computer lesson is suitable for any beginner, senior, novice and for anyone looking to qualify in The European Computer Driving Licence (ECDL) the lesson covers elements 3.1 and 3.3 of the Equal skills section.

The computer lesson shows an ordinary WordPad document and explains the various parts of the WordPad window, the title bar, the menu bar, WordPad toolbar (also known as the Ribbon), scroll bars and the status bar.

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

Basic Computer Training – The Taskbar

by

Basic computer training

Our basic computer training course continues with a lesson explaining about the taskbar and some of the features of the task bar. The tutorial is suitable for any beginners and for anyone looking to learn online and qualify in The European Computer Driving Licence (ECDL), this tutorial will cover Equal skills elements 2.3, 2.4, 2.5 and 2.6.

The lesson uses screen capture software to demonstrate the taskbar, icons associated with the task bar and how to pin favourite programmes to the taskbar, as well as opening applications from your desktop. Seniors, beginners and computer novices will benefit from this basic computer training tutorial which also demonstrates how programmes remain running and available for use from the task bar. Understanding about the taskbar is essential for improving computer skills. [Read more…]

Basic computer training – Your desktop and icons

by

Basic computer skills

To continue our basic computer training course for seniors, beginners and novices, we move on to a tutorial explaining the layout of your computer desktop and an introduction to desktop icons. The lesson is suitable for anyone learning online worldwide and for those looking to qualify in The European Computer Driving Licence (ECDL) this lesson will cover Equal Skills, desktop, elements 2.1 and 2.2.

The lesson demonstrates a conventional computer desktop and lists the three main areas, icons, gadgets and taskbar. The computer lesson then goes on to explain about desktop shortcuts and how they are identified fundamental for improving your computer skills.

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 and are viewing them on YouTube then you can 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 courses and tutorials for seniors and beginners”> Free online computer courses and tutorial for seniors and beginners</a> from www.meganga.com</p>

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

Basic Computer Training – Your Keyboard

by

Basic Computer Training

We continue our basic computer training for beginners, seniors and novices with a tutorial demonstrating you can use your computer keyboard for much more than just typing. The basic computer lesson is suitable for anyone worldwide and for those looking to learn about computers and qualify in the European Computer Driving Licence (ECDL) the basic computer training covers Equal Skills computer basics 1.9 and 1.10.

The tutorial explains how your keyboard is divided and demonstrates different keys and their functions, a core part of elementary computer skills.

[Read more…]

Basic Computer Training Understanding Your Cursor

by

Basic Computer Training

Continuing our basic computer courses for seniors, beginners and computer novices, we have a lesson about understanding your cursor. Your cursor behaves differently as it interacts with webpages and software, it is therefore important to understand what your cursor is telling you so that you can follow hyperlinks and type text where you need to. This basic computer training lesson will help you to identify the different appearances of the mouse or cursor.

The lesson is suitable for anyone learning online worldwide and covers elements 1.7 and 1.8 of the European Computer Driving Licence (ECDL) qualification in EqualSkills, Computer Basics.

To enlarge the video left click on the small square icon in four 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 courses and tutorials for seniors and beginners”> Free online computer courses and tutorial for seniors and beginners</a> from www.meganga.com</p>

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

Basic Computer Training – Your Computer

by

Basic Computer Training

This is the start of our basic computer training course for seniors, beginners and complete novices. The computer lesson will answer questions about your computer, what is a chip, what is a processor, what is ram and what is a hard drive?

Designed to improve computer skills, the course is suitable for anyone worldwide and for those looking to learn about computers and qualify in The European Computer Driving Licence (ECDL), this lesson will cover EqualSkills computer basics elements 1.1 and 1.2, looking at your computer.

The lesson will demonstrate different personal computers and there various parts, talk about adding accessories before giving a brief description about some of the components inside your computer including the processor, RAM and hard drive.

 

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

Your Computer Working With Windows Computer Courses for Seniors

by

Free Computer Courses For Seniors

The next tutorial in our free computer courses for seniors is a tutorial showing how to work with windows. Microsoft Windows comes in various forms, e.g. Windows 7, Windows Vista, Windows XP, Windows 2000, Windows ME and others. They all have one thing in common – they all have windows. This tutorial shows opening, closing, minimizing and maximizing those windows. An elementary lesson in developing basic computer skills.

This tutorial will continue the basic computer training for seniors, beginners and novices, those students looking to learn online and qualify in The European Computer Driving License (ECDL) this lesson will cover Equal skills element 3.2.

This is an elementary part of using your computer.

Level: Beginner

To enlarge the video left click on the small square icon in four 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

World Wide Web – What is a Search Engine – Using Google to Search the Web

by

Seniors & Beginners Computer Lesson – What is a Search Engine?

In this seniors computer lesson we ask what is a search engine? For the answer we take a look at the search engine Google, currently the most popular search engine and we see how we can use Google to search the web. We use the UK Google site in this online tutorial however Google does have many regional sites around the world as explained in a later online tutorial for beginners. If you click on the “About Google” link on any Google search page you can find out lots more information about Google.

This tutorial is of use to anyone learning online worldwide and for those looking to gain computer skills and qualify in The European Computer Driving Licence (ECDL) this lesson covers elements 7.11 and 7.12.

Level: Beginner

To enlarge the video left click on the small square icon in four pieces bottom right of video. Press the Esc button on your keyboard to return to normal view.

Thanks for watching.

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

Internet – World Wide Web – What Is a Web Browser Lesson

by

Online computer lesson

For those following our basic computer training course for seniors and beginners this next learning online computer lesson takes a look at the world wide web and asks what is a web browser?

The computer lesson for seniors and beginners will explain what a browser is and what web browsers are used for. It goes on to cover some of the different browsers available to you, including: Internet Explorer, FireFox, Google Chrome, Safari and others.

Anyone looking to qualify in the European Computer Driving License (ECDL), this lesson will cover element 7.1 in the course.

Level: Beginner [Read more…]

Your Computer – How to use a Mouse – Online Computer Lesson

by

How to use a mouse free online computer lesson for seniors and beginners.

This tutorial forms part of our basic computer training course and for those looking to learn about computers and qualify in the European Computer Driving Licence (ECDL) the tutorial will cover elements 1.4 and 1.5 of the Equal Skills module and shows how to use a mouse, essential for improving computer skills.

Learning Objectives

  • Using the left and right mouse buttons
  • Double clicking
  • Using the mouse wheel

Target Audience:

Complete computer beginner/novice [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