How to use Excel – Working with Charts in Excel 2010

How to use Excel - Working with Charts in Excel 2010

How to use Excel – Working with Charts in Excel 2010

The computer course on how to use excel continues with a computer lesson on working with charts in Excel 2010. Charts can show data in a way that demonstrates the meaning in a much clearer way. In this video tutorial made by gcflearnfree.org we are shown the common charts available to us with Excel 2010, they include Column Charts, Line Charts, Pie Charts, Bar Charts and Area Charts. The computer lesson demonstrates how to create charts to display excel data and also how to modify the charts, how to give a title to the charts and where applicable how to add axis titles before changing the style and finally moving the chart to it’s own excel spreadsheet.

The video computer lesson is suitable for anyone who already has a basic understanding of Excel and is learning more about excel or anyone following the course, how to use excel. [Read more…]

How to use Excel – Reviewing and Sharing Excel Workbooks

How to use Excel - Reviewing and sharing excel workbooks

How to use Excel – Reviewing and sharing excel workbooks

The course on how to use excel continues with a video computer lesson on reviewing and sharing excel workbooks. This video tutorial made by gcflearnfree.org demonstrates a company excel worksheet that is being shared and collaborated on by colleagues. The lesson shows that by using the review tab colleagues can make changes to excel cells that everyone can see using the track changes commands and also leave comments that others can see and read. These changes can be reviewed on the excel workbook at the end of the project and can then be accepted or rejected before being finalized, an extremely useful feature in Excel 2010.

A useful computer lesson for those wishing to learn how to use excel for use in the workspace or for using with others. [Read more…]

How to use Excel – Formatting Tables in Excel 2010

How to use Excel - Formatting Tables in Excel 2010

How to use Excel – Formatting Tables in Excel 2010

Tables are a great way of showing our data with more colour and the next in the computer course how to use excel takes a look at formatting tables in excel 2010. The computer lesson made by gcflearnfree.org demonstrates formatting excel tables using an invoice for a pasta company on an excel spreadsheet. The video tutorial shows how to select the cells you want in the table, format the table and then looks at the various design options through the design tab. The excel computer lesson then continues to show how to re-size the table and add additional data before talking about table styles. The lesson then finishes by showing the filter options that are added to your table when it is formatted.

A computer lesson for anyone looking to learn how to use excel but recommended that a beginners basic knowledge in excel is needed. [Read more…]

How to use Excel – Sorting Data in Excel 2010

How to use Excel 2010 - Sorting Data in Excel 2010

How to use Excel – Sorting Data in Excel 2010

Following on in the computer course how to use excel we have a video computer lesson explaining how to sort data in Excel 2010. At times we need to sort our data on our Excel spreadsheet and we can do this by re ordering data alphabetically, numerically, by date and even by font colour. This computer lesson made by gcflearnfree.org shows how you can sort data by using the home tab but concentrates on sorting data using the data tab on your Excel spreadsheet. The video tutorial uses a T shirt sales spreadsheet to demonstrate how to sort data using surnames in alphabetical ascending order and then reverse before showing how to re order in date sequence and room number. The video computer lesson then goes on to create a custom data sort for arranging in size order before finishing the lesson demonstrating how to sort in multiple data order.

The computer lesson is easy to follow and ideal for anyone who is learning how to use excel 2010 and already has a beginners understanding of excel.

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 – 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 – How to configure email on an iphone

Smartphones - How to configure email on an iphone

Smartphones – How to configure email on an iphone

Computer lessons on smartphones continue with a video tutorial demonstrating how to configure email on an iphone. The lesson made by Johnsiphone1 talks us through the procedure for adding a new email account to an iphone. During the computer video John shows us the options available for configuring email using the common email providers before going through the pop email configuration and imap. You will need to have your email account details close to hand in order to configure your email to your iphone.

This lesson is easy to follow and is intended for anyone new to iphones.

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 – Inserting Pictures and Images

How to use Powerpoint - Inserting Pictures and Images

How to use Powerpoint – Inserting Pictures and Images

A fifth computer tutorial for the computer course on how to use Powerpoint 2010 is about inserting pictures and images to your power point presentation slide. The computer lesson, made by titantechtraining, starts by demonstrating the layout tab to work with pictures before showing how to use pictures from your computer’s picture library. The lesson goes on to show dragging and resizing pictures and then formatting text to go with the picture, it then shows the picture tools menu that can be used with the picture.

The video tutorial continues to demonstrate clip art and how to obtain images from office.com clip art, how to crop images and the difference between cropping and resizing images.

This computer lesson is suitable foe anybody wishing to learn and understand how to use Powerpoint 2010 and is easy to follow for beginners or seniors.

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.

Technology – What is Cloud Storage?

What is File storage in cloud.

What is File storage in cloud.

A technology computer lesson explaining what is cloud storage. The video tutorial explains in a very simple way how cloud storage works. The narrator talks through with the aid of simple pictures what happens to a picture that is saved on the internet, where it goes to and how it is saved. The video goes on to explain that once something is saved in the cloud it can always be retrieved as opposed to a document or picture being lost at home.

The computer lesson is a guide for beginners and seniors and is duitable for anyone.

[Read more…]

What is a Smartphone

What is a Smartphone

What is a Smartphone

A short video answering the question, what is a smartphone? The video lesson made by about.com explains the differences between a modern smartphone and an old style cellphone or mobile phone. Most people have heard the term smartphone and many, particularly seniors and beginners may not understand what a smartphone is and what smartphones can do. This video tutorial explains that not only can smartphones make and receive telephone calls they can also provide a host of other features for example handle email accounts, provide web access and run other applications or apps.

With the everchanging world of technology todays smartphones may well be out of date in a few years but for now we hope this lesson helps.

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

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

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

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

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

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