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

Microsoft Excel 2010


Create a Classroom
 

 
 

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

  • ADARSH TIKMANI India its nice . 2014-04-18 14:04:07
  • Kate Seher United States of America Very helpful and informative. 2014-04-15 20:04:43
  • Jigisha Soni United States of America NICE... 2014-04-09 19:04:38
  • CASSANDRA DEMEIS United States of America I highly recommend this course. Very impressed with the changes from 2007 version. 2014-04-09 16:04:24
  • Peta Allard Canada I found this course very useful and easy to follow along with. I think it has enhanced my excel skills. I would recommend it to frends. 2014-04-04 15:04:04
  • Matthew Browne Ireland good 2014-03-31 15:03:00
  • tani sheikh Pakistan This comprehensive course helps me a lot in gaining complete insight of Excel. 2014-03-26 20:03:54
  • Clare Louise Davis United Kingdom Course Module: Module 12: Create and Run Macros in Excel 2010 Course Topic: Save my macro in the Personal Workbook Comment: this is really fascinating - thank you for giving me the confidence to go away and try this out 2013-10-19 11:10:19
  • Pankaj Yadav India Course Module: Module 4: Create Your First Spreadsheet Course Topic: Meet the Excel spreadsheet Comment: GR8 KNOWLEDGE WITH ANIMATION. 2013-09-15 12:09:34
  • Lucia Zwedala South Africa Course Module: Module 1: Make the Switch to Excel 2010 Course Topic: Switching to Excel 2010 Comment: good for me i lean more 2013-08-06 11:08:50
More Comments and Reviews >>

Microsoft Excel 2010

Learn about Microsoft Excel 2010 and update your spreadsheet skills.

Start Now!