Loading
Register/Login Alison Logo

Microsoft Excel 2010

certifcate icon
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.

Modules List( 19 )
  • MICROSOFT EXCEL 2010 TRAINING
  • When you complete this course you can receive an A...
  • Module 1: Make the Switch to Excel 2010
    • 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 2: What's New in Excel 2010
    • 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 3: Basic Tasks in Excel 2010
    • 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 4: Create Your First Spreadsheet
    • 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
  • Module 5: Get to Know Excel 2010 - Create 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
  • Module 6: VLOOKUP - What It Is and When to Use It
    • 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
  • Module 7: Understand Data at a Glance with Conditional Formatting
    • 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
  • Microsoft Excel 2010 - First Assessment
    • Microsoft Excel 2010 - First Assessment
  • Module 8: Sparklines - Use Tiny Charts to Show Data Trends
    • Sparklines - Use tiny charts to show data trends
    • Introduction to Sparklines
    • Line sparklines
    • Column sparklines
    • Win, loss sparklines
  • Module 8: Resources
  • Module 9: Use Excel Tables to Manage Information
    • Use Excel tables to manage information
    • Introduction to tables
    • Sort, filter, and remove duplicates
    • Using formulas in tables
    • More about formulas
  • Module 9: Resources
  • Module 10: The IF function - What It Is and How to Use It
    • 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
  • Module 11: How to Create a Basic Chart in Excel 2010
    • 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
  • Module 12: Create and Run Macros in Excel 2010
    • 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
  • Module 13 : Figure Out Dates by Using Formulas in Excel 2010
    • 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
  • Module 14: Plan Payments and Savings in Excel 2010
    • 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
  • Module 15: Keyboard Shortcuts
    • 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
  • Module 16: Microsoft Office 2010 Security
    • Active Content
    • Enable Content
    • Trusted Documents
    • Protected View
  • Microsoft Excel 2010 - Second Assessment
    • Microsoft Excel 2010 - Second Assessment
  • END OF COURSE ASSESSMENT
  • Module 17: Microsoft Excel 2010 - Final Assessment
    • Microsoft Excel 2010 - Final Assessment
Topics List ( 5 )
Module 3: 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.
Topics List ( 8 )
Module 4: 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.
Topics List ( 6 )
Module 5: 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.
Topics List ( 6 )
Module 6: 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.
Topics List ( 5 )
Module 7: 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.
Topics List ( 1 )
Microsoft Excel 2010 - First Assessment
You must score 80% or more to pass this assessment.
Topics List ( 5 )
Module 8: 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.
Topics List ( 5 )
Module 9: 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.
Topics List ( 4 )
Module 10: 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.
Topics List ( 8 )
Module 11: 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.
Topics List ( 5 )
Module 12: 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.
Topics List ( 8 )
Module 14: 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.
Topics List ( 4 )
Module 16: 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.
Topics List ( 1 )
Microsoft Excel 2010 - Second Assessment
You must score 80% or more to pass this assessment.
Topics List ( 1 )
Module 17: Microsoft Excel 2010 - Final Assessment
You must score 80% or more to pass this assessment.
Course Features
  • Duration

    6-10 Hours

  • Publisher

    Microsoft

  • Video

    Yes

  • Audio

    Yes

  • Assessment

    Yes

  • Certification

    Yes

  • Price

    Free

  • Reward

    50 Pts

  • Responsive

    No

Reviews and Rate
This course has no reviews yet.
Tags