Loading

Microsoft Excel 2010 - Revised 2017

Microsoft Excel 2010 - Revised 2017

Start Course Now

16

Modules

125

Topics

6-10

hours

microsoft excel 2010
Microsoft Excel Resources
Module 1
Making the switch to Excel 2010
Resources available

This module will teach you about switching from and older versions of Microsoft Excel to Excel 2010

Making the switch to Excel 2010 Learning Outcomes

Start Topic

Making the switch to Excel 2010

Start Topic

Work with files in the Backstage view

Start Topic

Do the basics on the home tab

Start Topic

Math, Anywhere

Start Topic

Commands when you need them

Start Topic

Keyboard shortcuts

Start Topic

Keep your favorite buttons visible

Start Topic

Work between new and old Excel versions

Start Topic

Making the switch to Excel 2010 Lesson Summary

Start Topic
Module 2
What's new in Excel 2010
Resources available

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.

What's new in Excel 2010 Learning Outcomes

Start Topic

Access the right tools, at the right time

Start Topic

Backstage view in Excel 2010

Start Topic

Access workbooks in new ways

Start Topic

Make fast, effective comparisons from lists of data

Start Topic

Introduction to Sparklines

Start Topic

Obtain powerful analysis from your desktop

Start Topic

Changes made to functions

Start Topic

Create an Excel table

Start Topic

Create workbooks with more visual impact

Start Topic

Paste with live preview

Start Topic

Collaborate on workbooks in new ways

Start Topic

Collaborate on a worksheet in the browser

Start Topic

Find and fix accessibility issues

Start Topic

Extend workbooks in new ways

Start Topic

What's new in Excel 2010 Lesson Summary

Start Topic
Module 3
Basic Tasks in Excel 2010
Resources available

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.

Basic Tasks in Excel 2010 Learning Outcomes

Start Topic

What is Excel?

Start Topic

Create, save, print, and apply templates to a workbook

Start Topic

Format numbers in a worksheet

Start Topic

Create an Excel table, formula and chart your data

Start Topic

Filter and sort your data

Start Topic

Basic Tasks in Excel 2010 Lesson Summary

Start Topic
Module 4
Create your first spreadsheet
Resources available

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.

Create your first spreadsheet Learning Outcomes

Start Topic

Meet the Excel spreadsheet

Start Topic

Do basic math in Excel

Start Topic

Create column titles

Start Topic

Let Excel type for you

Start Topic

Get more(or less) columns, rows, spreadsheets

Start Topic

Keep column titles in sight as you scroll

Start Topic

Prepare to print

Start Topic

Create your first spreadsheet Lesson Summary

Start Topic
Module 5
Create Formulas
Resources available

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.

Create Formulas Learning Outcomes

Start Topic

Formulas in Excel

Start Topic

Cell references in formulas

Start Topic

The SUM and AVERAGE functions

Start Topic

More about cell references and formulas

Start Topic

More about functions

Start Topic

Create Formulas Lesson Summary

Start Topic
Module 6
VLOOKUP - What it is and when to use it
Resources available

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.

VLOOKUP - What it is and when to use it Learning Outcomes

Start Topic

What is VLOOKUP

Start Topic

How, and when to use VLOOKUP

Start Topic

Using more than one spreadsheet with VLOOKUP

Start Topic

Using absolute cell references with VLOOKUP

Start Topic

Avoiding VLOOKUP errors

Start Topic

VLOOKUP - What it is and when to use it Lesson Summary

Start Topic
Module 7
Understand Data at a glance with Conditional Formatting
Resources available

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 Learning Outcomes

Start Topic

Format cells to make data stand out

Start Topic

Quick formatting

Start Topic

Work with rules

Start Topic

Make your own rules

Start Topic

Understand Data at a glance with Conditional Formatting Lesson Summary

Start Topic
Module 8
Sparklines - Use tiny charts to show data trends
Resources available

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 Learning Outcomes

Start Topic

Introduction to Sparklines

Start Topic

Line sparklines

Start Topic

Column sparklines

Start Topic

Win, Loss sparklines

Start Topic

Sparklines - Use tiny charts to show data trends Lesson Summary

Start Topic
Module 9
Use Excel tables to manage information
Resources available

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 Learning Outcomes

Start Topic

Introduction to tables

Start Topic

Sort, filter, and remove duplicates

Start Topic

Using formulas in tables

Start Topic

More about formulas

Start Topic

Use Excel tables to manage information Lesson Summary

Start Topic
Module 10
The IF Function - What it is and how to use it
Resources available

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 Learning Outcomes

Start Topic

Introduction to the IF function

Start Topic

Add or multiply IF results

Start Topic

Using more than one IF function

Start Topic

The IF Function - What it is and how to use it Lesson Summary

Start Topic
Module 11
How to create a basic chart in Excel 2010
Resources available

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 Learning Outcomes

Start Topic

Introduction to charts

Start Topic

How spreadsheet data appears in a chart

Start Topic

Change the chart view

Start Topic

Add chart titles

Start Topic

Change the look of your chart

Start Topic

Make a pie chart

Start Topic

More chart types

Start Topic

How to create a basic chart in Excel 2010 Lesson Summary

Start Topic
Module 12
Save time by creating and running macros in Excel 2010
Resources available

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.

Save time by creating and running macros in Excel 2010 Learning Outcomes

Start Topic

Create and run macros

Start Topic

Edit an existing macro to change what it does

Start Topic

Save my macro in the Personal Workbook

Start Topic

Assign a button to my macro

Start Topic

Save time by creating and running macros in Excel 2010 Lesson Summary

Start Topic
Module 13
Figure out dates by using formulas in Excel 2010
Resources available

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 Learning Outcomes

Start Topic

Dates and formulas

Start Topic

Find the number of days between two dates

Start Topic

Find the number of workdays between two dates

Start Topic

Find the date that falls after a number of workdays

Start Topic

Find the date that falls after a number of months

Start Topic

Find the date that falls after a year, months, and days

Start Topic

Figure out dates by using formulas in Excel 2010 Lesson Summary

Start Topic
Module 14
Plan payments and savings in Excel 2010
Resources available

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 Learning Outcomes

Start Topic

Calculate credit cart debt

Start Topic

Figure out mortgage payments

Start Topic

Calculate vacation savings

Start Topic

How a first deposit affects savings

Start Topic

Figure out a down payment

Start Topic

Paying off a personal loan

Start Topic

How much your saving add up to over time

Start Topic

Plan payments and savings in Excel 2010 Lesson Summary

Start Topic
Module 15
Keyboard shortcuts in Excel 2010
Resources available

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

Keyboard shortcuts in Excel 2010 Learning Outcomes

Start Topic

Introduction to keyboard shortcuts

Start Topic

Basic keyboard shortcuts

Start Topic

Keyboard shortcuts for formulas

Start Topic

Keyboard shortcuts for moving around workbooks

Start Topic

Keyboard shortcuts for selecting

Start Topic

Keyboard shortcuts for adding and inserting

Start Topic

Keyboard shortcuts for formatting

Start Topic

Introduction to access keys

Start Topic

Access keys from previous versions

Start Topic

Access keys in dialog boxes

Start Topic

Other kinds of access key

Start Topic

Keyboard shortcuts in Excel 2010 Lesson Summary

Start Topic
course assessment: Microsoft Excel 2010 - Revised 2017
Module 16
Course assessment
Resources available

Microsoft Excel 2010 - Course Assessment

Start Assessment