-
Please login to continue
-
Sign Up For Free
Join the World’s Largest Free Learning Community
orThis is the name that will appear on your Certification
-
Forgot password?
Please enter you email address and we will mail you a link to reset your password.
16
Modules
125
Topics
6-10
hours
Modules (16)
Resources ()
-
microsoft excel 2010
- Microsoft Excel Resources
-
Module 1
Making the switch to Excel 2010
Resources availableThis module will teach you about switching from and older versions of Microsoft Excel to Excel 2010Making the switch to Excel 2010 Learning Outcomes
Start TopicMaking the switch to Excel 2010
Start TopicWork with files in the Backstage view
Start TopicDo the basics on the home tab
Start TopicMath, Anywhere
Start TopicCommands when you need them
Start TopicKeyboard shortcuts
Start TopicKeep your favorite buttons visible
Start TopicWork between new and old Excel versions
Start TopicMaking the switch to Excel 2010 Lesson Summary
Start Topic -
Module 2
What's new in Excel 2010
Resources availableThere 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 TopicAccess the right tools, at the right time
Start TopicBackstage view in Excel 2010
Start TopicAccess workbooks in new ways
Start TopicMake fast, effective comparisons from lists of data
Start TopicIntroduction to Sparklines
Start TopicObtain powerful analysis from your desktop
Start TopicChanges made to functions
Start TopicCreate an Excel table
Start TopicCreate workbooks with more visual impact
Start TopicPaste with live preview
Start TopicCollaborate on workbooks in new ways
Start TopicCollaborate on a worksheet in the browser
Start TopicFind and fix accessibility issues
Start TopicExtend workbooks in new ways
Start TopicWhat's new in Excel 2010 Lesson Summary
Start Topic -
Module 3
Basic Tasks in Excel 2010
Resources availableThis 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 TopicWhat is Excel?
Start TopicCreate, save, print, and apply templates to a workbook
Start TopicFormat numbers in a worksheet
Start TopicCreate an Excel table, formula and chart your data
Start TopicFilter and sort your data
Start TopicBasic Tasks in Excel 2010 Lesson Summary
Start Topic -
Module 4
Create your first spreadsheet
Resources availableThis 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 TopicMeet the Excel spreadsheet
Start TopicDo basic math in Excel
Start TopicCreate column titles
Start TopicLet Excel type for you
Start TopicGet more(or less) columns, rows, spreadsheets
Start TopicKeep column titles in sight as you scroll
Start TopicPrepare to print
Start TopicCreate your first spreadsheet Lesson Summary
Start Topic -
Module 5
Create Formulas
Resources availableThis 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 TopicFormulas in Excel
Start TopicCell references in formulas
Start TopicThe SUM and AVERAGE functions
Start TopicMore about cell references and formulas
Start TopicMore about functions
Start TopicCreate Formulas Lesson Summary
Start Topic -
Module 6
VLOOKUP - What it is and when to use it
Resources availableYou 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 TopicWhat is VLOOKUP
Start TopicHow, and when to use VLOOKUP
Start TopicUsing more than one spreadsheet with VLOOKUP
Start TopicUsing absolute cell references with VLOOKUP
Start TopicAvoiding VLOOKUP errors
Start TopicVLOOKUP - What it is and when to use it Lesson Summary
Start Topic -
Module 7
Understand Data at a glance with Conditional Formatting
Resources availableThis 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 TopicFormat cells to make data stand out
Start TopicQuick formatting
Start TopicWork with rules
Start TopicMake your own rules
Start TopicUnderstand Data at a glance with Conditional Formatting Lesson Summary
Start Topic -
Module 8
Sparklines - Use tiny charts to show data trends
Resources availableHere 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 TopicIntroduction to Sparklines
Start TopicLine sparklines
Start TopicColumn sparklines
Start TopicWin, Loss sparklines
Start TopicSparklines - Use tiny charts to show data trends Lesson Summary
Start Topic -
Module 9
Use Excel tables to manage information
Resources availableIn 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 TopicIntroduction to tables
Start TopicSort, filter, and remove duplicates
Start TopicUsing formulas in tables
Start TopicMore about formulas
Start TopicUse Excel tables to manage information Lesson Summary
Start Topic -
Module 10
The IF Function - What it is and how to use it
Resources availableIn 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 TopicIntroduction to the IF function
Start TopicAdd or multiply IF results
Start TopicUsing more than one IF function
Start TopicThe 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 availableThere 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 TopicIntroduction to charts
Start TopicHow spreadsheet data appears in a chart
Start TopicChange the chart view
Start TopicAdd chart titles
Start TopicChange the look of your chart
Start TopicMake a pie chart
Start TopicMore chart types
Start TopicHow 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 availableYou 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 TopicCreate and run macros
Start TopicEdit an existing macro to change what it does
Start TopicSave my macro in the Personal Workbook
Start TopicAssign a button to my macro
Start TopicSave 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 availableThis 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 TopicDates and formulas
Start TopicFind the number of days between two dates
Start TopicFind the number of workdays between two dates
Start TopicFind the date that falls after a number of workdays
Start TopicFind the date that falls after a number of months
Start TopicFind the date that falls after a year, months, and days
Start TopicFigure out dates by using formulas in Excel 2010 Lesson Summary
Start Topic -
Module 14
Plan payments and savings in Excel 2010
Resources availableYou 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 TopicCalculate credit cart debt
Start TopicFigure out mortgage payments
Start TopicCalculate vacation savings
Start TopicHow a first deposit affects savings
Start TopicFigure out a down payment
Start TopicPaying off a personal loan
Start TopicHow much your saving add up to over time
Start TopicPlan payments and savings in Excel 2010 Lesson Summary
Start Topic -
Module 15
Keyboard shortcuts in Excel 2010
Resources availableIn 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 TopicIntroduction to keyboard shortcuts
Start TopicBasic keyboard shortcuts
Start TopicKeyboard shortcuts for formulas
Start TopicKeyboard shortcuts for moving around workbooks
Start TopicKeyboard shortcuts for selecting
Start TopicKeyboard shortcuts for adding and inserting
Start TopicKeyboard shortcuts for formatting
Start TopicIntroduction to access keys
Start TopicAccess keys from previous versions
Start TopicAccess keys in dialog boxes
Start TopicOther kinds of access key
Start TopicKeyboard shortcuts in Excel 2010 Lesson Summary
Start Topic -
course assessment: Microsoft Excel 2010 - Revised 2017
-
Module 16
Course assessment
Resources available