Alison Logo

Microsoft Excel 2010

  • Description
  • Outcome
  • Certification
  • Microsoft Excel 2010 is one of the most popular software applications worldwide and is part of the Microsoft Office 2010 productivity suite. This free online course will help you switch to Excel 2010 from a previous version of the software, and will give you a thorough knowledge and understanding of Excel and its applications if you have never used it before. You can use Excel to analyse data, for example, in accounts, budgets, billing and many other areas. You learn how to navigate this revised version of Excel, exploring the menu bar and the different tasks that can be done with it. You will work on sample spreadsheets doing basic math, adding and deleting columns and rows, and preparing the worksheet for printing. You will learn how to represent your data visually to show trends, patterns and comparisons between the data in a chart, table or other template, and how Excel 2010 will automatically do all the calculations for you once you add in the formula. This course will be of great interest to all professionals in business, finance and many other areas that need to analyse data in accounts, or keep records of stock or schedules, and to anyone trying to keep track of their personal finances at home.

  • After completing this Excel course, you will:
    - Understand how to navigate Excel's menu;
    - Learn about the improvements and new features of the software;
    - Create, save, prepare for printing and apply templates to a worksheet;
    - Work with formulas and functions; use VLOOKUP to search through the data in the spreadsheet;
    - Determine patterns and trends with conditional formatting, sparklines and charts;
    - Apply a table to the data; check conditions with the IF function;
    - Understand, save and run macros; figure out dates using formulas and work quicker with keyboard shortcuts.

  • All Alison courses are free to study. To successfully complete a course you must score 80% or higher in each course assessments. Upon successful completion of a course, you can choose to make your achievement formal by purchasing an official Alison Diploma, Certificate or PDF.

    Having an official Alison document is a great way to share your success. Plus it’s:

    • Ideal for including in CVs, job applications and portfolios
    • An indication of your ability to learn and achieve high results
    • An incentive to continue to empower yourself through learning
    • A tangible way of supporting the Alison mission to empower people everywhere through education.

Microsoft Excel 2010
  • Free

  • 6-10 Hours

  • Microsoft

  • Assessment

  • Certification

  • 50 Pts

Modules List( 19 )
  • When you complete this course you can receive an A...
  • Module
    Make the Switch to 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.
    • Switching to Excel 2010
    • Make the switch to Excel 2010
    • Work with files in Backstage view
    • Do the basics on the home tab
    • Math, Anywhere
    • Commands when you need them
    • Keyboard shortcuts
    • Keep your favorite buttons visible
    • Work between new and old Excel versions
  • Module
    What's New in Excel 2010
    • 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.
    • Access the right tools, at the right time
    • Backstage view in Excel 2010
    • Access workbooks in new ways
    • Make fast, effective comparisons from lists of data
    • Introduction to Sparklines
    • Obtain powerful analysis from your desktop
    • Changes made to functions
    • Create an Excel table
    • Create workbooks with more visual impact
    • Paste with live preview
    • Collaborate on workbooks in new ways
    • Collaborate on a worksheet in the browser
    • Find and fix accessibility issues
    • Extend workbooks in new ways
  • Module
    Basic Tasks in Excel 2010
    • 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.
    • What is Excel?
    • Create, save, print and apply templates to a workbook
    • Format numbers in a worksheet
    • Create an Excel table, formula and chart your data
    • Filter and sort your data
  • Module
    Create Your First Spreadsheet
    • 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.
    • Introduction to spreadsheets
    • Meet the Excel spreadsheet
    • Do basic math in Excel
    • Create column titles
    • Let Excel type for you
    • Get more (or less) columns, rows, spreadsheets
    • Keep column titles in sight as you scroll
    • Prepare to print
  • Module 4: Resources View Resource
  • Module
    Get to Know Excel 2010 - Create Formulas
    • 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.
    • Introduction to formulas in Excel
    • Formulas in Excel
    • Cell references in formulas
    • The SUM and AVERAGE functions
    • More about cell references and formulas
    • More about functions
  • Module 5: Resources View Resource
  • Module
    VLOOKUP - What It Is and When to Use It
    • 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.
    • Introduction to VLOOKUP
    • What is VLOOKUP
    • How, and when, to use VLOOKUP
    • Using more than one spreadsheet with VLOOKUP
    • Using absolute cell references with VLOOKUP
    • Avoiding VLOOKUP errors
  • Module 6: Resources View Resource
  • Module
    Understand Data at a Glance with Conditional Formatting
    • 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.
    • Understand data at a glance with conditional formatting
    • Format cells to make data stand out
    • Quick formatting
    • Work with rules
    • Make your own rules
  • Module 7 : Resources View Resource
  • Microsoft Excel 2010 - First Assessment
    • You must score 80% or more to pass this assessment.
    • Microsoft Excel 2010 - First Assessment
  • Module
    Sparklines - Use Tiny Charts to Show Data Trends
    • 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.
    • Sparklines - Use tiny charts to show data trends
    • Introduction to Sparklines
    • Line sparklines
    • Column sparklines
    • Win, loss sparklines
  • Module 8: Resources View Resource
  • Module
    Use Excel Tables to Manage Information
    • 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.
    • Use Excel tables to manage information
    • Introduction to tables
    • Sort, filter, and remove duplicates
    • Using formulas in tables
    • More about formulas
  • Module 9: Resources View Resource
  • Module
    The IF function - What It Is and How to Use It
    • 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.
    • The IF function - what it is, and how to use it
    • Introduction to the IF function
    • Add or multiply IF results
    • Using more than one IF function
  • Module 10: Resources View Resource
  • Module
    How to Create a Basic Chart in Excel 2010
    • There are many different charts in Excel for representing different data visually to show comparisons, patterns and trends.
    • How to create a basic chart in Excel 2010
    • Introduction to charts
    • How spreadsheet data appears in a chart
    • Change the chart view
    • Add chart titles
    • Change the look of your chart
    • Make a pie chart
    • More chart types
  • Module 11: Resources View Resource
  • Module
    Create and Run Macros in Excel 2010
    • 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.
    • Create and run macros in Excel 2010
    • Create and run macros
    • Edit an existing macro to change what it does
    • Save my macro in the Personal Workbook
    • Assign a button to my macro
  • Module 12: Resources View Resource
  • Module
    Module 13 : Figure Out Dates by Using Formulas in Excel 2010
    • This module explains how dates are stored in Excel for using in formulas to get the number of days between two dates.
    • Figure out dates by using formulas in Excel 2010
    • Dates and formulas
    • Find the number of days between two dates
    • Find the number of workdays between two dates
    • Find the date that falls after a number of workdays
    • Find the date that falls after a number of months
    • Find the date that falls after a year, months, and days
  • Module 13: Resource View Resource
  • Module
    Plan Payments and Savings in Excel 2010
    • 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.
    • Plan payments and savings in Excel 2010
    • Calculate credit card debt
    • Figure out mortgage payments
    • Calculate vacation savings
    • How a first deposit affects savings
    • Figure out a down payment
    • Paying off a personal loan
    • How much your savings add up to over time
  • Module 14: Resource View Resource
  • Module
    Keyboard Shortcuts
    • In this module you will learn how to use CTRL key shortcuts and ALT key shortcuts to gain a quicker workflow.
    • Keyboard shortcuts
    • Introduction to keyboard shortcuts
    • Basic keyboard shortcuts
    • Keyboard shortcuts for formulas
    • Keyboard shortcuts for moving around workbooks
    • Keyboard shortcuts for selecting
    • Keyboard shortcuts for adding and inserting
    • Keyboard shortcuts for formatting
    • Introduction to access keys
    • Access keys from previous versions
    • Access keys in dialog boxes
    • Other kinds of access key
  • Module 15: Resources View Resource
  • Module
    Microsoft Office 2010 Security
    • This module guides you through the various Security options available within Office 2010, including Protected View, Trusted Documents and Enabling Active Content.
    • Active Content
    • Enable Content
    • Trusted Documents
    • Protected View
  • Microsoft Excel 2010 - Second Assessment
    • You must score 80% or more to pass this assessment.
    • Microsoft Excel 2010 - Second Assessment
  • Module
    Microsoft Excel 2010 - Final Assessment
    • You must score 80% or more to pass this assessment.
    • Microsoft Excel 2010 - Final Assessment
Reviews and Rate
This course has no reviews yet.