Business Basics

The Complete Mastering Excel 2010 Learning Path

With expert instruction.

Get Started

68 skill-based courses

In 1 Skill Sets

Learning Path Duration

09H 23M

What Will I Learn?

Learning Path

About Mastering Excel 2010

Mastering Excel 2010 Skills

What is Excel? (Workbooks and Worksheets)

What is Excel? (Workbooks and Worksheets)

What is Excel? (Workbooks and Worksheets)

What is Excel? (Workbooks and Worksheets)

9m 12s

What is Excel 2010? (Workbooks and Worksheets)

Adding and Changing Workbooks

Adding and Changing Workbooks

Adding and Changing Workbooks

Adding and Changing Workbooks

6m 36s

Adding and Changing Workbooks in Excel 2010

Basic Text and Number Entry

Basic Text and Number Entry

Basic Text and Number Entry

Basic Text and Number Entry

12m 55s

Basic Text and Number Entry in Excel 2010

The Interface Part 1: Ribbon and Quick Access Toolbar

The Interface Part 1: Ribbon and Quick Access Toolbar

The Interface Part 1: Ribbon and Quick Access Toolbar

The Interface Part 1: Ribbon and Quick Access Toolbar

6m 34s

The Interface, Part 1: Ribbon and Quick Access Toolbar in Excel 2010

The Interface Part 2: Status Bar and View Options

The Interface Part 2: Status Bar and View Options

The Interface Part 2: Status Bar and View Options

The Interface Part 2: Status Bar and View Options

14m 58s

The Interface, Part 2: Status Bar and View Options in Excel 2010

Keyboard Shortcuts

Keyboard Shortcuts

Keyboard Shortcuts

Keyboard Shortcuts

9m 59s

Keyboard Shortcuts for Mastering Excel 2010

File Types

File Types

File Types

File Types

9m 39s

File Types for Mastering Excel 2010

Open, Save, and Autosave

Open, Save, and Autosave

Open, Save, and Autosave

Open, Save, and Autosave

14m 36s

Open, Save, and Autosave for Mastering Excel 2010

Templates

Templates

Templates

Templates

7m 48s

Templates for Mastering Excel 2010

Autocorrect

Autocorrect

Autocorrect

Autocorrect

5m 45s

Autocorrect for Mastering Excel 2010

Undo and Redo

Undo and Redo

Undo and Redo

Undo and Redo

4m 37s

Undo and Redo for Mastering Excel 2010

Text Formatting Part 1: Font Style, Size, and Color

Text Formatting Part 1: Font Style, Size, and Color

Text Formatting Part 1: Font Style, Size, and Color

Text Formatting Part 1: Font Style, Size, and Color

8m 58s

Text Formatting, Part 1: Font Style, Size, and Color in Excel 2010

Text Formatting Part 2: Alignment and Numbers

Text Formatting Part 2: Alignment and Numbers

Text Formatting Part 2: Alignment and Numbers

Text Formatting Part 2: Alignment and Numbers

9m 22s

Text Formatting Part 2: Alignment and Numbers in Excel 2010

Adding Hyperlinks

Adding Hyperlinks

Adding Hyperlinks

Adding Hyperlinks

4m 27s

Adding Hyperlinks for Mastering Excel 2010

Scientific Equations

Scientific Equations

Scientific Equations

Scientific Equations

6m 42s

Scientific Equations for Mastering Excel 2010

The Windows Clipboard (Paste Options)

The Windows Clipboard (Paste Options)

The Windows Clipboard (Paste Options)

The Windows Clipboard (Paste Options)

12m 14s

The Windows Clipboard (Paste Options) in Excel 2010

The Office Clipboard (Advanced Cut and Paste)

The Office Clipboard (Advanced Cut and Paste)

The Office Clipboard (Advanced Cut and Paste)

The Office Clipboard (Advanced Cut and Paste)

6m 29s

The Office Clipboard (Advanced Cut and Paste) in Excel 2010

Find and Replace

Find and Replace

Find and Replace

Find and Replace

8m 7s

Find and Replace for Mastering Excel 2010

Spellcheck and Reference

Spellcheck and Reference

Spellcheck and Reference

Spellcheck and Reference

9m 7s

Spellcheck and Reference for Mastering Excel 2010

Shapes Part 1: Inserting and Formatting

Shapes Part 1: Inserting and Formatting

Shapes Part 1: Inserting and Formatting

Shapes Part 1: Inserting and Formatting

11m 15s

Shapes Part 1: Inserting and Formatting in Excel 2010

Shapes Part 2: Arranging and Re-Shaping

Shapes Part 2: Arranging and Re-Shaping

Shapes Part 2: Arranging and Re-Shaping

Shapes Part 2: Arranging and Re-Shaping

8m 39s

Shapes Part 2: Arranging and Re-Shaping in Excel 2010

Working with Pictures

Working with Pictures

Working with Pictures

Working with Pictures

11m 11s

Working with Pictures in Excel 2010

Pictures + Shapes = Awesome

Pictures + Shapes = Awesome

Pictures + Shapes = Awesome

Pictures + Shapes = Awesome

4m 1s

Pictures + Shapes = Awesome in Excel 2010

Clip Art and SmartArt

Clip Art and SmartArt

Clip Art and SmartArt

Clip Art and SmartArt

10m 7s

ClipArt and SmartArt for Mastering Excel 2010

Text Boxes

Text Boxes

Text Boxes

Text Boxes

5m 59s

Text Boxes for Mastering Excel 2010

Navigating and Highlighting in a Spreadsheet

Navigating and Highlighting in a Spreadsheet

Navigating and Highlighting in a Spreadsheet

Navigating and Highlighting in a Spreadsheet

11m 51s

Navigating and Highlighting in a Spreadsheet in Excel 2010

Insert, Delete, Hide, and Unhide

Insert, Delete, Hide, and Unhide

Insert, Delete, Hide, and Unhide

Insert, Delete, Hide, and Unhide

10m 13s

Insert, Delete, Hide, and Unhide in Excel 2010

Entering Data in Series

Entering Data in Series

Entering Data in Series

Entering Data in Series

8m 51s

Entering Data in Series for Mastering Excel 2010

Formulas: Order of Operations, Absolute vs Relative

Formulas: Order of Operations, Absolute vs Relative

Formulas: Order of Operations, Absolute vs Relative

Formulas: Order of Operations, Absolute vs Relative

13m 2s

Formulas: Order of Operations, Absolute vs Relative in Excel 2010

Intro to Functions

Intro to Functions

Intro to Functions

Intro to Functions

8m 56s

Intro to Functions for Mastering Excel 2010

Financial Functions

Financial Functions

Financial Functions

Financial Functions

9m 52s

Financial Functions for Mastering Excel 2010

Date and Time Functions

Date and Time Functions

Date and Time Functions

Date and Time Functions

9m 7s

Date and Time Functions for Mastering Excel 2010

Formulas Tab: Text Functions

Formulas Tab: Text Functions

Formulas Tab: Text Functions

Formulas Tab: Text Functions

7m 48s

Formulas Tab: Text Functions in Excel 2010

Logical, Math, and Statistical Functions

Logical, Math, and Statistical Functions

Logical, Math, and Statistical Functions

Logical, Math, and Statistical Functions

8m 36s

Logical, Math, and Statistical Functions for Mastering Excel 2010

vLookup and More Functions

vLookup and More Functions

vLookup and More Functions

vLookup and More Functions

8m 32s

vLookup and More Functions in Excel 2010

Formatting Cells and Ranges

Formatting Cells and Ranges

Formatting Cells and Ranges

Formatting Cells and Ranges

8m 7s

Formatting Cells and Ranges in Excel 2010

Number Formatting

Number Formatting

Number Formatting

Number Formatting

10m 36s

Number Formatting in Excel 2010

Tables

Tables

Tables

Tables

12m 33s

Tables for Mastering Excel 2010

Sorting and Filtering

Sorting and Filtering

Sorting and Filtering

Sorting and Filtering

11m 51s

Mastering Excel 2010: Sorting and Filtering

Subtotals

Subtotals

Subtotals

Subtotals

6m 34s

Subtotals for Mastering Excel 2010

Creating Pivot Tables

Creating Pivot Tables

Creating Pivot Tables

Creating Pivot Tables

7m 48s

Creating Pivot Tables for Mastering Excel 2010

Customizing Pivot Tables

Customizing Pivot Tables

Customizing Pivot Tables

Customizing Pivot Tables

14m 33s

Customizing Pivot Tables for Mastering Excel 2010

Importing Data

Importing Data

Importing Data

Importing Data

8m 51s

Importing Data for Mastering Excel 2010

Intro to Charts

Intro to Charts

Intro to Charts

Intro to Charts

4m 24s

Intro to Charts for Mastering Excel 2010

Chart Design and Styles

Chart Design and Styles

Chart Design and Styles

Chart Design and Styles

5m 33s

Chart Design and Styles in Excel 2010

Optimizing Chart Data

Optimizing Chart Data

Optimizing Chart Data

Optimizing Chart Data

3m 46s

Optimizing Chart Data 2010 in Excel

Advanced Chart Formatting

Advanced Chart Formatting

Advanced Chart Formatting

Advanced Chart Formatting

11m 34s

Advanced Chart Formatting in Excel 2010

Pivot Charts

Pivot Charts

Pivot Charts

Pivot Charts

2m 54s

Pivot Charts for Mastering Excel 2010

Sparklines

Sparklines

Sparklines

Sparklines

5m 23s

Sparklines for Mastering Excel 2010

Customizing Your Worksheet View: Part 1

Customizing Your Worksheet View: Part 1

Customizing Your Worksheet View: Part 1

Customizing Your Worksheet View: Part 1

12m 45s

Customizing Your View: Part 1 in Excel 2010

Customizing Your Worksheet View: Part 2

Customizing Your Worksheet View: Part 2

Customizing Your Worksheet View: Part 2

Customizing Your Worksheet View: Part 2

3m 47s

Customizing Your View, Part 2 in Excel 2010

Advanced Worksheet Formatting

Advanced Worksheet Formatting

Advanced Worksheet Formatting

Advanced Worksheet Formatting

7m 43s

Advanced Worksheet Formatting in Excel 2010

Advanced Data Copy Techniques

Advanced Data Copy Techniques

Advanced Data Copy Techniques

Advanced Data Copy Techniques

8m 32s

Advanced Data Copy Techniques in Excel 2010

Transforming Data with the Clipboard

Transforming Data with the Clipboard

Transforming Data with the Clipboard

Transforming Data with the Clipboard

2m 50s

Transforming Data with the Clipboard for Mastering Excel 2010

Manipulating Text with Functions

Manipulating Text with Functions

Manipulating Text with Functions

Manipulating Text with Functions

8m 35s

Manipulating Text with Functions for Mastering Excel 2010

Printing Worksheets

Printing Worksheets

Printing Worksheets

Printing Worksheets

11m 34s

Printing Worksheets for Mastering Excel 2010

Working with Print Area

Working with Print Area

Working with Print Area

Working with Print Area

5m 27s

Working with Print Area for Mastering Excel 2010

Using Data Validation

Using Data Validation

Using Data Validation

Using Data Validation

10m 31s

Using Data Validation for Mastering Excel 2010

Analyzing Data: What-If and Scenario Manager

Analyzing Data: What-If and Scenario Manager

Analyzing Data: What-If and Scenario Manager

Analyzing Data: What-If and Scenario Manager

7m 28s

Analyzing Data: What-If and Scenario Manager in Excel 2010

Analyzing Data: What-If and Data Tables

Analyzing Data: What-If and Data Tables

Analyzing Data: What-If and Data Tables

Analyzing Data: What-If and Data Tables

7m 48s

Analyzing Data: What-If and Data Tables in Excel 2010

Analyzing Data: Goal Seek

Analyzing Data: Goal Seek

Analyzing Data: Goal Seek

Analyzing Data: Goal Seek

2m 59s

Analyzing Data: Goal Seek for Mastering Excel 2010

Text to Columns

Text to Columns

Text to Columns

Text to Columns

4m 35s

Text to Columns for Mastering Excel 2010

Consolidating Data

Consolidating Data

Consolidating Data

Consolidating Data

3m 37s

Consolidating Data for Mastering Excel 2010

Creating Macros

Creating Macros

Creating Macros

Creating Macros

8m 16s

Creating Macros for Mastering Excel 2010

Advance Macros

Advance Macros

Advance Macros

Advance Macros

5m 52s

Advanced Macros in Excel 2010

Creating Random Numbers and Custom Series

Creating Random Numbers and Custom Series

Creating Random Numbers and Custom Series

Creating Random Numbers and Custom Series

6m 46s

Creating Random Numbers and Custom Series for Mastering Excel 2010

External References

External References

External References

External References

3m 55s

External References for Mastering Excel 2010

Customizing the Ribbon and Quick Access Toolbar

Customizing the Ribbon and Quick Access Toolbar

Customizing the Ribbon and Quick Access Toolbar

Customizing the Ribbon and Quick Access Toolbar

9m 28s

Customizing the Ribbon and Quick Access Toolbar in Excel 2010

Desktop and Mobile
  • All Access

    Access anywhere, anytime

    Learn at work, at home or on the go. All of our courses our online and play well with desktops and mobile devices.

  • Certificate

    Certificate of Completion

    Upon completion of this Learning Path, you will be awarded a Certificate of Completion showing that you have gained the skills presented.

  • Support

    Support

    Have a question? We're here to help. We have detailed FAQs and resources as well as a support team ready to assist you.

  • Customization

    Customization

    We offer over 90 professionally hand-crafted learning paths to get you started, but we realized that not everyone wants to learn the same things. That's why we give you the flexibility to create your own, custom learning paths just for you and your team.

Mountains

Are you ready to become a Top Performer?

Our video lessons are built by industry experts, proven by learners who are no longer ordinary!

Free Trial