Sign-up today to join over 4 million learners already on ALISON:

Microsoft Excel 2010


Create an ALISON Manager Group
 

 
 

Course Features

Video

High

Audio

High

Animation

None

Equivalent to FETAC

Level 5

Equivalent to QCF (UK)

Level 3

Language

EN

Publisher

Microsoft

Rating

Start Now!

Learning Outcome

Modules in Microsoft Excel 2010

In this module you will be introduced to Excel, how to navigate the menu and the different tasks that can be done with it.


Start

There are many new and improved features in this version of Excel. This module will show you these changes that will allow you to be more productive.


Start

This module will help you get set up and started using Excel. These simple step by step instructions will guide you through creating and saving a workbook and show you how to complete basic tasks.


Start

This module will get you started working on a spreadsheet, doing basic math, add and delete columns and rows and prepare the worksheet for printing.


Start

This module explains that when working with formulas the results automatically update when values are changed and also how to use functions which are more complicated formulas.


Start

You will be introduced to VLOOKUP in this module; it is used to look up a value to find corresponding data on the same row.


Start

This module explains how to use conditional formatting to make your data stand out, this helps you to analyse data and to determine patterns and trends.


Start

You must score 80% or more to pass this assessment.


Start

Here you will be shown Sparklines which are tiny charts that fit into a spreadsheet cell, these give a visual representation of your data to help spot patterns and trends.


Start

In this module you will learn to apply tables in Excel, their used to store related information to make it easier to format, sort and total your data.


Start

In this module you will learn about the IF function, this checks if a condition you specify is true or false and it executes a reaction depending on the result.


Start

There are many different charts in Excel for representing different data visually to show comparisons, patterns and trends.


Start

You will be shown how to save and execute a macro in this module, macros are used to record a set of instructions you do all the time to use whenever you want.


Start

This module explains how dates are stored in Excel for using in formulas to get the number of days between two dates.


Start

You will be shown in this module how to use more complex formulas for figuring out mortgage repayments and calculating the accumulative interest on your savings.


Start

In this module you will learn how to use CTRL key shortcuts and ALT key shortcuts to gain a quicker workflow.


Start

This module guides you through the various Security options available within Office 2010, including Protected View, Trusted Documents and Enabling Active Content.


Start

You must score 80% or more to pass this assessment.


Start

You must score 80% or more to pass this assessment.


Start

Sponsored


Start Course Now!

Comments & Reviews

  • Robert Hudson United Kingdom Good course 2014-10-21 19:10:02
  • Susan Horn Other I have enjoyed looking at the information on this site and found it very interesting to find all the information 2014-09-16 11:09:49
  • Jeetendra Yadav India Excellent, came to know many shortcuts, new features pertaining to math functions,date concepts,macros basics etc. 2014-09-10 04:09:06
  • Komal Fari Pakistan its a gr8t course i m soo happy i can learn online 2014-07-18 19:07:35
  • Nyeche Woke United States of America This is an excellency and well detailed outline,It is interesting thanks nyeche 2014-07-01 12:07:32
  • Denise Dorwart United States of America I learned a lot from this course. 2014-06-11 15:06:51
  • DAVID TETIDRICK United States of America Very good course. 2014-06-09 13:06:26
  • Michelle Danielson United States of America I thought the course was very thorough although entirely too much emphasis on keyboard shortcuts - also I could not get the application to recognize the three assessments I took along with several components of the first sections of each module , even after hitting the finish button several times. 2014-06-07 20:06:36
  • Vicki Schoenhardt United States of America very useful class 2014-05-30 10:05:04
  • Mario Agawin Philippines I like this course...very much..thank you 2014-05-06 14:05:34
More Comments and Reviews >>

Microsoft Excel 2010

Learn about Microsoft Excel 2010 and update your spreadsheet skills.

Start Now!