How to use Excel – Working with Sparklines in Excel 2010

How to use Excel - Working with Sparklines in Excel 2010

How to use Excel – Working with Sparklines in Excel 2010

Moving on with the computer course on how to use Excel the next computer lesson is about working with sparklines in Excel 2010. Sometimes, when data is complicated, we need to create charts that fit into a single excel cell to make our excel spreadsheet easier to understand, these charts are called sparklines. This computer lesson made by gcflearnfree.org shows how to work with sparklines. The commands for sparklines may be found through the insert tab where there is a group of commands for sparklines for line, column or win/loss. This example shows a large sales force and by using a sparkline at the end of each line we can see the trend of each salesperson. The computer lesson goes on to show how the sparkline can be made easier to read and changed to a different type of sparkline as desired.

The lesson is suitable for anyone following the course how to use excel but you will need an understanding of excel. [Read more…]

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.

Excel lessons – Printing in excel 2010

Printer

Printing in Excel

Printing in Excel 2010 continued. We have added another computer lesson in our Excel computer lessons about printing. This video tutorial is by Gcflearnfree and probably demonstrates better than our own the Excel commands used when printing in excel. The computer lesson is clear and concise showing the constraints and the thought needed to plan your excel printing from your Excel worksheet or workbook.

This Printing in Excel computer lesson is suitable for any computer beginner looking to understand how to use excel and for those looking to gain formal qualifications, the online computer tutorial will help with excel spreadheets sections, printing in excel and understanding the excel print area.

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 – Printing in Excel Computer Lesson

How to use Excel - Printing in Excel Computer Lesson

How to use Excel – Printing in Excel Computer Lesson

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

How to use Excel – A start with simple Excel Formulas

How to use Excel - Simple Excel Formulas

How to use Excel – Simple Excel Formulas

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

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

Computer courses for beginners – An introduction to our productivity course of lessons

Computer Software Discs

Introduction to Productivity Software

Our next computer course for beginners is all about being productive with your computer and productive software. You may have completed some of our other free computer lessons for basic computer training or you may be looking to get more productive with your computer by understanding how to use the software available, if so our next series of computer lessons for seniors and beginners will run through the Microsoft Office Suite of computer programmes. The computer lessons will run through in a step by step guide how to use Microsoft Office Word, a word processor programme, explains how to use Excel, a spreadheet application and Microsoft PowerPoint a presentation programme.

The courses of computer lessons are particularly useful for those looking to improve their computer skills and learn Office Word for work or Excel for work.

[Read more…]

Using Excel Formulas to Add Numbers Lesson

Computer lesson for seniors - using excel formula

Using Excel Formulas to Add Numbers Lesson

Learning objectives:

  • Learn to use a formula in an excel spreadsheet
  • Learn to sum (add) a group of numbers

Target audience:
Computer beginner/novice

Prerequisite Knowledge
Know how to open office programs, such as Excel [Read more…]