How to use Excel – Basic Excel Functions

How to use Excel - Basic Excel Functions

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.

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.

Smartphones – What is an Iphone ?

Smartphones - What is an iphone

Smartphones – What is an iphone

What is an iphone? This is a short video aimed as an introduction to one of the most popular smartphones, the Apple Iphone. The iphone has been around since 2007 and now we have the sixth generation the iphone 5 but for many seniors and beginners new to computing, trying to keep up with technology is difficult, especially when many have only just mastered cell phones or mobile phones and now the world has smartphones. The computer lesson explains that an iphone may be used as a normal cell phone but has lots of additional features made possible through apps or applications, demonstrating email, music, maps, games news and social media.

The lesson is elementary and suitable for beginners or seniors not yet aware of smartphones.

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.

How to use Powerpoint 2010 – Working with Smart Art Shapes

How to use Powerpoint 2010 - Using Smart Art Shapes

How to use Powerpoint 2010 – Using Smart Art Shapes

The computer course for how to use Powerpoint 2010 continues with lesson seven, working with smart art shapes. The computer tutorial made by titantechtraining continues working with smart art and starts with a cycle diagram, adding shapes to it, customizing the diagram and shows how to delete individual shapes and entire graphics. The computer lesson then combines text and graphics, inserts shapes and lines plus adding arrows to lines. The tutorial concludes by creating a map for a slide presentation using power point drawing tools.

The computer lesson is an easy to follow video and is suitable for beginner, senior and anyone wishing to learn how to use Powerpoint 2010.

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.

How to use Powerpoint 2010 – Using Smart Art Graphics

How to use Powerpoint 2010 - Using Smart Art Graphics

How to use Powerpoint 2010 – Using Smart Art Graphics

The series on how to use Powerpoint 2010 continuse with a sixth computer lesson focusing on using smart art graphics. The Powerpoint tutorial is made by titantechtraining and explains that you can add smart art graphics to your Powerpoint presentation slide easily. These smart art graphics are a selection of graphs, charts and diagrams available with your Powerpoint software. The computer tutorial runs through varies designs and shows how to stretch and adjust the size of the graphic to fit in to your needs. The video continues to explain how to edit the text associated to a graphic in a couple of ways before demonstrating the smart art tools available on the ribbon which can easily alter the style and appearance of your smart art graphic.

The computer lesson is an easy to follow video and is suitable for beginner, senior and anyone wishing to learn how to use Powerpoint 2010.

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.

How to use Powerpoint 2010 – Creating a Table for a Slide

How to use Powerpoint - Creating a Table for a Slide

How to use Powerpoint – Creating a Table for a Slide

The third computer lesson for how to use Powerpoint 2010 takes a look at creating a table for a power point slide. The computer video made by titantechtraining explains some of the options available for adding content to slides with Powerpoint 2010 before explaining how to add a table to your powerpoint presntation slide. The powerpoint computer tutorial explains the limitations of power point tables and suggests other Microsoft Office options for adding content to powerpoint slides. The video continues by creating a table and then explains how to change it’s style and look.

The video is suitable for any beginner wishing to learn how to use powerpoint 2010.

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.

How to use Excel – Editing cells in Excel computer lesson

How to use Excel - Editing cells in Excel

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.

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 – What is Excel – A First Look at Excel

How to use Excel - What is Excel?

How to use Excel – What is Excel?

How to use 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…]

Basic Computer Training – Using My Email Part 2

Basic computer training - Reply to my email

Reply to my email

Basic computer training

This basic computer training tutorial continues on from our lesson called using my email. The computer lesson for seniors and beginners demonstrates the reply to email, forward emails and print email commands frequently used when using webmail and an email client.

The tutorial is one of our basic computer lessons and shows, using a Gmail account and Hotmail account, how to use firstly, the reply to e-mail command followed by how to forward emails and finally points out the print icon for printing emails, the beginners lesson also demonstrates the seperate menus where all three basic computer commands can be found.

[Read more…]

Basic Computer Training – Filling Forms and Logging In

Join now. Form filling and logging in

Form filling and logging in

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 – Identifying Parts of an Application Window

Basic Computer Training - Identifying parts of an application window

Basic Computer Training – Computer Windows

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 Equalskills section.

The computer lesson shows an ordinary Wordpad document and explains the various parts of the Wordpad window, the titlebar, the menubar, 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

Basic Computer Training - The Taskbar or Task Bar

Man contemplates the task bar or taskbar

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 – Personalising Your Computer Desktop

Personalise your computer desktop

Personalise your computer desktop

Basic computer training

In this basic computer training lesson we demonstrate how easy it is to personalise your computer desktop if you know the right commands for your computer. The tutorial, aimed at seniors, beginners and computer novices, shows the three main areas to personalise on your desktop, the background picture, icons and gadgets. We demonstrate in this basic computer training lesson that with a few simple commands you can easily change the appearance of your desktop to make your computer much more personal to you and at the same time develop your computer skills.

The lesson starts be showing an easy way to change the back ground picture before creating an icon for a piece of work and then selecting a gadget. The basic computer training lesson is an ideal starter lesson for seniors and beginners showing how to use commands and menus that make a visible difference.

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 – Your Keyboard

Basic computer training

Basic computer training - Your keyboard

Basic computer training – Your keyboard

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

Software – Wordpad – Wordpad The Basics – Computer Courses for Seniors

Computer courses for seniors - wordpad the basics

Computer courses for seniors – wordpad the basics

Continuing our Computer courses for seniors we explain the basics to Wordpad, a pre installed software with windows. Wordpad is very similar to Microsoft Word but not quite as sophisticated and it doesn’t have nearly as many features. This tutorial works through the basic commands of Wordpad and demonstrates how to save a piece of work.

Troubleshooting – Screen Freezes Programme Stops – Basic IT Training for Seniors

Basic IT training for seniors - Troubleshooting - Screen freezes and programme stops

Basic IT training for seniors – Troubleshooting – Screen freezes and programme stops

In this basic IT training for seniors we explain a basic drill for troubleshooting if your screen freezes and the programme you are using stops working. The tutorial demonstrates how using your computer keyboard and by pressing the keys “Alt” “Ctrl” and “Delete” (Sometimes shown as “Del”) together you can access your task manager which should enable you to close the programme for simple problems.

Computer Basics – The Start Menu – Meganga First Click Courses for Seniors

Meganga's first click courses for seniors the start menu

Meganga’s first click courses for seniors the start menu

Computer Basics

The main navigation for all windows computers is through the start button in the bottom left of the computer screen, this computer lesson for beginners and seniors talks through the basic navigation of your computer.

As part of Meganga’s first click courses for seniors we have provided a tutorial demonstrating the elements that make up the start menu in Windows 7, the central navigation to any computer. The online learning tutorial for beginners shows you how to use the search box, where to find your programmes and shows you where your frequently used computer applications can be found. Learning to navigate around your computer avoids frustration when trying to find programmes and applications later on.

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

Seniors computer lesson search the web

Seniors computer lesson search the web

Seniors computer lesson

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. 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

Desktop – Computer Lesson for Seniors – Adding Desktop Gadgets to your Desktop

Computer lesson for seniors desktop computer gadgets

Computer lesson for seniors desktop computer gadgets

Computer lessons for seniors and beginners

In this computer lesson for seniors and beginners we demonstrate how to customise your desktop display by adding desktop gadgets such as a clock, news feeds and weather from around the world. The computer tutorial uses the windows 7 operating system although gadgets can also be displayed using Window Vista.

Gadgets are the handy little applications that let you know the time, the weather for home or your next holiday destination, exchange rates, latest news items and lots more. This online learning tutorial for beginners and seniors will demonstrate about gadgets, making your computer desktop much more personal to you and helping to enhance your own computer skills. The computer lesson is suitable for anyone worldwide wishing to learn about computers.

Level: Beginner/Intermediate

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

Software – Word 2007 – Creating a New Document

 

 

Creating word document computer lesson

Creating a New Document in Microsoft Word 2007®

This is currently not a video lesson.
With most tasks when using a computer there are several methods of achieving your desired objective. In this free on-line tutorial I will show you how to do the same task in two different ways. It is then your choice

Learning Objectives:

Target Audience:
Complete beginner/novice

 

Pre-requisites:
Starting Word course or know how to access and open Word [Read more…]

Internet – World Wide Web – What Are Hyperlinks Lesson

What are hyperlinks lesson

Basic computer training

Continuing our basic computer training for beginners and seniors we have a short online lesson explaining what are hyperlinks and how to recognise a link or hyperlink. The world wide web is navigated by clicking on hyperlinks to take the user from webpage to webpage. The seniors and beginners computer lesson goes on to cover how webpages can be opened in a new window, so as not to leave the webpage being viewed.

This online tutorial demonstrates how the world wide web is navigated which is essential for beginners starting out on the internet and by understanding how hyperlinks or links work anyone can understand how the world wide web is bound together. [Read more…]

Internet – World Wide Web – Using The Browser Address Bar Computer Lesson

Using the browser address bar computer lesson for seniorsOnline computer lessons for seniors

The next of our online computer lessons for seniors shows you how to get the most from your browser address bar. The address bar can be found toward the top of the browser and it can be used for searching or going directly to a website. This sneiors and beginners computer lesson follows on from our basic computer training tutorial about web browser basics as the lesson explains what a Uniform Resource Locator or URL is and how to navigate to your chosen websites using the address bar.

This computer lesson is ideal for the complete beginner who is new to using the Internet and the WWW (World Wide Web) and helps to get beginners using different parts of the web browser.

Level: Beginner [Read more…]

Your Computer – Desktop – Using The Recycle Bin Online Lesson

Computer lesson for seniors - using the recycle bin

Computer lessons for seniors and beginners

Using The Recycle Bin And Deleting Desktop Icons Free Online Computer Lesson For Seniors and Beginners

Recycle Bin and Icons

Learning Objectives

  • How to delete
  • How to restore deleted items
  • Understanding Desktop icons

Target Audience:
Complete computer beginner/novice [Read more…]