Excel 2010 Training

Excel 2010 Training

interactive-training-excel-2010

Personalized Online Training

Get answers to everyday questions and on-demand training with over 7,000 Interactive Tutorials.

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 Devices

  • Desktop
  • Tablet / mobile
  • LMS / SCORM

Multiple Languages

Getting Started

Length: 5:00

Microsoft Excel 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, give commands, using help, and about new features in Excel 2010.

Lesson 1 Understanding the Excel Screen
2:09
Lesson 2 Creating a Workbook
0:47
Lesson 3 Navigating a Worksheet
0:55
Lesson 4 Opening and Saving a Workbook
1:02
Lesson 5 Working with Multiple Windows
1:28
Lesson 6 Printing a Workbook
0:39
Lesson 7 Getting Help
0:42
Lesson 8 Closing and Exiting
0:37

Editing a Workbook

Length: 11:00

Ready to roll your sleeves up and start building a spreadsheet? In this 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!

Lesson 1 Selecting Cells and Cell Ranges
1:17
Lesson 2 Entering Cell Data
Lesson 3 Editing Cell Data
1:15
Lesson 4 Cutting, Copying, and Pasting
1:04
Lesson 5 More Pasting Options
1:22
Lesson 6 Using AutoFill
1:06
Lesson 7 Inserting, Moving, and Deleting Cells
1:14
Lesson 8 Checking Spelling
0:52
Lesson 9 Finding and Replacing Text
1:28
Lesson 10 Hiding Rows and Columns
0:42

Formatting Worksheets

Length: 13:00

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, alignment, create borders and backgrounds, apply cell styles, insert images, and other special effects. Who said data had to be boring?

Lesson 1 Formatting Text
1:29
Lesson 2 Cell Alignment and Merging Cells
1:27
Lesson 3 Formatting Numbers and Dates
1:34
Lesson 4 Borders and Background Colors
1:01
Lesson 5 Copying Formatting
0:27
Lesson 6 Row Heights and Column Widths
1:08
Lesson 7 Applying Conditional Formatting
1:18
Lesson 8 Applying and Removing Cell Styles
0:59
Lesson 9 Creating and Modifying Cell Styles
1:18
Lesson 10 Find and Replace Formatting
1:15
Lesson 11 Inserting an Image
0:27

Building Formulas

Length: 12:00

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

Lesson 1 Formula Basics
2:20
Lesson 2 Working with Sums and Averages
0:54
Lesson 3 Referencing External Worksheets
1:20
Lesson 4 Absolute and Relative Cell References
Lesson 5 Working with Range Names
1:40
Lesson 6 Financial Formulas
1:24
Lesson 7 IF Formulas
Lesson 8 Text Formulas
1:07
Lesson 9 Lookup Formulas
Lesson 10 Understanding Formula Errors
2:35

Viewing and Managing Worksheets

Length: 7:00

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 course you will learn how to view, move, rename worksheets, freeze rows and columns, and how to hide worksheets and gridlines.

Lesson 1 Viewing Worksheets
1:35
Lesson 2 Moving and Copying Worksheets
0:48
Lesson 3 Insert, Rename, and Delete Worksheets
0:58
Lesson 4 Freezing Rows and Columns
1:32
Lesson 5 Hiding Worksheets and Gridlines
1:16

Working with Charts

Length: 6:00

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

Lesson 1 Creating a Chart
0:55
Lesson 2 Moving, Resizing, and Deleting a Chart
0:39
Lesson 3 Understanding Chart Types
Lesson 4 Changing Chart Layout and Style
0:47
Lesson 5 Working with Titles and Legends
1:15
Lesson 6 Gridlines, Labels, and Data Tables
Lesson 7 Formatting Chart Elements
1:14
Lesson 8 Add, Rename and Reorder Chart Data
Lesson 9 Filtering Charts
Lesson 10 Creating Sparklines
0:54

Printing Worksheets

Length: 5:00

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

Lesson 1 Changing Page Size and Scale
0:48
Lesson 2 Setting the Print Area and Viewing Page Breaks
1:00
Lesson 3 Adding Titles, Gridlines and Headings
0:43
Lesson 4 Creating Headers and Footers
0:57
Lesson 5 Adjusting Page Margins and Orientation
0:47

Working with Data and Tables

Length: 11:00

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

Lesson 1 Sorting Data
1:07
Lesson 2 Filtering Data
1:31
Lesson 3 Using Quick Analysis
1:09
Lesson 4 Working with Tables
1:07
Lesson 5 Remove Duplicates and Total
1:15
Lesson 6 Using Data Validation
1:53
Lesson 7 Filtering with Slicers
Lesson 8 Using Flash Fill
0:33
Lesson 9 Grouping and Outlining Data
Lesson 10 Importing and Exporting Text Files
2:03

Collaborating with Excel

Length: 8:00

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

Lesson 1 Working with Cell Comments
1:02
Lesson 2 Sharing Workbooks
0:48
Lesson 3 Tracking Changes in Workbooks
2:25
Lesson 4 Protecting a Worksheet
1:34
Lesson 5 Password Protecting a Workbook
0:43
Lesson 6 Saving Worksheets as Web Pages
0:34

Working with PivotTables

Length: 11:00

PivotTables are not just for geeks – they are 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 course you will learn how to create PivotTables and PivotCharts, specify data, change calculations, group data, and how to work with timelines.

Lesson 1 Creating a PivotTable
1:46
Lesson 2 Adding Multiple Fields to a PivotTable
0:58
Lesson 3 Specifying PivotTable Data
1:15
Lesson 4 Changing a PivotTable’s Calculation
0:35
Lesson 5 Filtering a PivotTable
1:00
Lesson 6 Working with Timelines
0:53
Lesson 7 Working with PivotTable Layout
0:43
Lesson 8 Grouping PivotTable Values
0:56
Lesson 9 Refreshing a PivotTable
1:05
Lesson 10 Formatting a PivotTable
0:29
Lesson 11 Creating a PivotChart
1:17