Excel 2010 Training


excel-2010-wbt

Start learning now.

Sign up for Microsoft Office training, SharePoint training and more.

100% spam free.


What's Included:

Interactive Tutorials
Bite-sized software simulations.
Interactive Quizzes
Accurately test your staff's skills.
Customizable Courseware
Training manuals with unlimited printing rights.
FREE Cheat Sheets
Just sign up, download, and share.
Multiple Platforms
  • Desktop
  • Tablet / mobile
  • LMS / SCORM

Excel 2010 Courses

Getting Started

Length: 9 minutes

Microsoft Excel 2010 Training is a product used by individuals and business professionals around the world, ranging from biologists to accounting professionals and students. Excel has something for everyone! In this course you will learn how to create workbooks, navigate multiple windows, using help, and about new features in Excel 2010 Training.

Understanding the Excel Screen
Creating a Workbook
Navigating a Worksheet
Opening and Saving a Workbook
Working with Multiple Windows
Printing a Workbook
Getting Help
Closing and Exiting

Editing a Workbook

Length: 11 minutes

Ready to roll your sleeves up and start building a spreadsheet? In this Excel 2010 Training course you will learn how to enter and edit cell data, fix typos, remove data you no longer need, hide rows and columns, and why using AutoFill is your new best friend!

Selecting Cells and Cell Ranges
Editing Cell Data
Cutting, Copying, and Pasting
More Pasting Options
Using AutoFill
Inserting, Moving, and Deleting Cells
Checking Spelling
Finding and Replacing Text
Hiding Columns and Rows

Formatting Worksheets

Length: 13 minutes

I bet you're wondering how to make this boring pile of data into a visually appealing pile of data that is easy to understand. Well, not to worry because in this course you will learn how to format text, cell alignment, create borders and backgrounds, apply cell styles, insert images, and other special effects. Who said data had to be boring in Excel 2010 Training?

Formatting Text
Cell Alignment and Merging Cells
Formatting Numbers and Dates
Borders and Background Colors
Copying Formatting
Row Heights and Column Widths
Applying Conditional Formatting
Applying and Removing Cell Styles
Creating and Modifying Cell Styles
Find and Replace Formatting
Inserting an Image

Building Formulas

Length: 18 minutes

Now that you understand spreadsheets, it's time to dig a little deeper and turn your data into meaningful and informative information. In this Excel 2010 Training course you will learn how to build IF Formulas, Financial Formulas, VLOOKUP, and Text Formulas. Learn how to interpret formula errors, reference external worksheets, and work with range names, sums, and averages.

Formula Basics
Sums and Averages
Referencing External Worksheets
Absolute and Relative Cell References
Cell and Range Names
Financial Formulas
IF Formulas
Text Formulas
Using VLOOKUP
Understanding Formula Errors

Viewing and Managing Worksheets

Length: 7 minutes

It is no surprise that most of your time will be spent managing your worksheets, which is why it is important that you understand how to navigate them properly. In this Excel 2010 Training course you will learn how to view, move, rename worksheets, freeze rows and columns, and how to hide worksheets and gridlines.

Viewing Worksheets
Moving and Copying Worksheets
Insert, Rename, and Delete Worksheets
Freezing Rows and Columns
Hiding Worksheets and Gridlines

Charts

Length: 11 minutes

Excel 2010 offers a variety of charts and options that will save you time while keeping your data organized and easier to understand. In this Excel 2010 Training course you will learn how to create a chart, change layout styles, format chart elements, create sparklines, and how to work with titles and legends.

Creating a Chart
Moving, Resizing, and Deleting a Chart
Understanding Chart Types
Changing Chart Layout and Style
Working with Titles and Legends
Gridlines, Labels, and Data Tables
Formatting Chart Elements
Modify Chart Data
Filtering Charts
Creating Sparklines

Printing Worksheets

Length: 5 minutes

To print and distribute your worksheets you will need to configure a few settings to make sure your worksheets don't print out the wrong way. In this Excel 2010 Training course you will learn about changing page size and scale, setting the print area, viewing page breaks, adding titles and headlines, creating headers and footers, and adjusting page margins and orientation.

Changing Page Size and Scale
Setting the Print Area and Viewing Page Breaks
Adding Titles, Gridlines and Headings
Creating Headers and Footers
Adjusting Page Margins and Orientation

Working with Data and Tables

Length: 12 minutes

If working with charts is not your cup of tea and you're looking for a simple way to build and analyze data, then using data tables is the perfect solution! In this Excel 2010 Training course you will learn how to sort and filter data, use quick analysis, work with data tables, remove duplicates and total, filter with slicers, and the power of data validation.

Sorting Data
Filtering Data
Using Quick Analysis
Working with Tables
Remove Duplicates and Total
Using Data Validation
Filtering with Slicers
Using Flash Fill
Importing and Exporting Text Files

Collaborating with Excel

Length: 8 minutes

If your workbook requires collaborating with other people then you're in luck! With Excel 2010 Training you have a variety of collaboration tools, making it easier than ever to work with others. In this Excel 2010 Training course you will learn about working with cell comments, sharing workbooks, tracking changes, password protecting a worksheet, and saving worksheets for web page viewing.

Working with Cell Comments
Sharing Workbooks
Tracking Changes in Workbooks
Protecting a Worksheet
Password Protecting a Workbook
Saving Worksheets as Web Pages

Working with PivotTables

Length: 10 minutes

PivotTables are not just for geeks, they're for anyone who has a large amount of data that needs consolidation. It's a useful and powerful data analysis tool that will summarize, analyze, and present you data. In this Excel 2010 Training course you will learn how to create PivotTables and PivotCharts, change calculations, group PivotTable Values, and how to work with timelines.

Creating a PivotTable
Adding Multiple Fields to a PivotTable
Changing a PivotTable's Calculation
Filtering a PivotTable
Working with Timelines
Working with PivotTable Layout
Grouping PivotTable Values
Refreshing a PivotTable
Formatting a PivotTable
Creating a PivotChart