Business Basics

The Complete Mastering Excel 2013 Learning Path

With expert instruction.

Get Started

74 skill-based courses

In 1 Skill Sets

Learning Path Duration

10H 02M

What Will I Learn?

Learning Path

About Mastering Excel 2013

Mastering Excel 2013 Skills

Looking At Excel 2013

Looking At Excel 2013

Looking At Excel 2013

Looking At Excel 2013

8m 58s

Mastering Excel 2013: Looking At Excel 2013

Navigating The Worksheet

Navigating The Worksheet

Navigating The Worksheet

Navigating The Worksheet

6m 49s

Mastering Excel 2013: Navigating The Worksheet

Worksheet Navigation: Part 2

Worksheet Navigation: Part 2

Worksheet Navigation: Part 2

Worksheet Navigation: Part 2

8m 15s

Mastering Excel 2013: Worksheet Navigation, Part 2

Sheet Tab Options

Sheet Tab Options

Sheet Tab Options

Sheet Tab Options

6m 40s

Mastering Excel 2013: Sheet Tab Options

The Excel Interface

The Excel Interface

The Excel Interface

The Excel Interface

9m 35s

Mastering Excel 2013: The Excel Interface

The Status Bar

The Status Bar

The Status Bar

The Status Bar

9m 53s

Mastering Excel 2013: The Status Bar for Mastering Excel 2013

Keyboard Shortcuts

Keyboard Shortcuts

Keyboard Shortcuts

Keyboard Shortcuts

10m 10s

Mastering Excel 2013: Keyboard Shortcuts for Mastering Excel 2013

File Types

File Types

File Types

File Types

9m 48s

Mastering Excel 2013: File Types for Mastering Excel 2013

Open, Save, and Autosave

Open, Save, and Autosave

Open, Save, and Autosave

Open, Save, and Autosave

14m 44s

Mastering Excel 2013: Open, Save, and Autosave for Mastering Excel 2013

Templates

Templates

Templates

Templates

7m 50s

Mastering Excel 2013: Templates for Mastering Excel 2013

Autocorrect

Autocorrect

Autocorrect

Autocorrect

5m 48s

Mastering Excel 2013: Autocorrect for Mastering Excel 2013

Undo and Redo

Undo and Redo

Undo and Redo

Undo and Redo

4m 43s

Mastering Excel 2013: Undo and Redo for Mastering Excel 2013

Text Formatting: Part 1

Text Formatting: Part 1

Text Formatting: Part 1

Text Formatting: Part 1

9m 2s

Mastering Excel 2013: Text Formatting, Part 1

Text Formatting: Part 2

Text Formatting: Part 2

Text Formatting: Part 2

Text Formatting: Part 2

9m 26s

Mastering Excel 2013: Text Formatting, Part 2

Adding Hyperlinks

Adding Hyperlinks

Adding Hyperlinks

Adding Hyperlinks

4m 31s

Mastering Excel 2013: Adding Hyperlinks for Mastering Excel 2013

Scientific Equations

Scientific Equations

Scientific Equations

Scientific Equations

6m 45s

Mastering Excel 2013: Scientific Equations for Mastering Excel 2013

The Windows Clipboard

The Windows Clipboard

The Windows Clipboard

The Windows Clipboard

12m 16s

Mastering Excel 2013: The Windows Clipboard

Microsoft Office Clipboard

Microsoft Office Clipboard

Microsoft Office Clipboard

Microsoft Office Clipboard

6m 32s

Mastering Excel 2013: Microsoft Office Clipboard

Find and Replace

Find and Replace

Find and Replace

Find and Replace

8m 9s

Mastering Excel 2013: Find and Replace for Mastering Excel 2013

Spellcheck and References

Spellcheck and References

Spellcheck and References

Spellcheck and References

9m 12s

Mastering Excel 2013: Spellcheck and References for Mastering Excel 2013

Shapes: Part 1

Shapes: Part 1

Shapes: Part 1

Shapes: Part 1

11m 19s

Mastering Excel 2013: Shapes, Part 1

Shapes: Part 2

Shapes: Part 2

Shapes: Part 2

Shapes: Part 2

8m 42s

Mastering Excel 2013: Shapes, Part 2

Pictures

Pictures

Pictures

Pictures

11m 13s

Mastering Excel 2013: Pictures

Pictures + Shapes = Awesome

Pictures + Shapes = Awesome

Pictures + Shapes = Awesome

Pictures + Shapes = Awesome

4m 4s

Mastering Excel 2013: Pictures + Shapes = Awesome

ClipArt and SmartArt

ClipArt and SmartArt

ClipArt and SmartArt

ClipArt and SmartArt

10m 10s

Mastering Excel 2013: ClipArt and SmartArt for Mastering Excel 2013

Text Boxes

Text Boxes

Text Boxes

Text Boxes

6m 2s

Mastering Excel 2013: Text Boxes for Mastering Excel 2013

Highlighting and Navigating in a Workbook

Highlighting and Navigating in a Workbook

Highlighting and Navigating in a Workbook

Highlighting and Navigating in a Workbook

11m 52s

Mastering Excel 2013: Highlighting and Navigating in a Workbook

Entering Data in Series

Entering Data in Series

Entering Data in Series

Entering Data in Series

8m 54s

Mastering Excel 2013: Entering Data in Series for Mastering Excel 2013

Flash Fill

Flash Fill

Flash Fill

Flash Fill

6m 43s

Mastering Excel 2013: Flash Fill

Formulas

Formulas

Formulas

Formulas

13m 4s

Mastering Excel 2013: Formulas

Intro to Functions

Intro to Functions

Intro to Functions

Intro to Functions

8m 58s

Mastering Excel 2013: Intro to Functions for Mastering Excel 2013

Financial Functions

Financial Functions

Financial Functions

Financial Functions

9m 54s

Mastering Excel 2013: Financial Functions for Mastering Excel 2013

Date and Time Functions

Date and Time Functions

Date and Time Functions

Date and Time Functions

9m 8s

Mastering Excel 2013: Date and Time Functions for Mastering Excel 2013

Text Functions

Text Functions

Text Functions

Text Functions

7m 48s

Mastering Excel 2013: Text Functions

Logical, Math, and Statistical Functions

Logical, Math, and Statistical Functions

Logical, Math, and Statistical Functions

Logical, Math, and Statistical Functions

8m 33s

Mastering Excel 2013: Logical, Math, and Statistical Functions for Mastering Excel 2013

vLookup and Misc Functions

vLookup and Misc Functions

vLookup and Misc Functions

vLookup and Misc Functions

8m 35s

Mastering Excel 2013: vLookup and Misc Functions

New Functions

New Functions

New Functions

New Functions

6m 33s

Mastering Excel 2013: New Functions in 2013

Formatting Cells and Ranges: Part 1

Formatting Cells and Ranges: Part 1

Formatting Cells and Ranges: Part 1

Formatting Cells and Ranges: Part 1

8m 7s

Mastering Excel 2013: Formatting Cells and Ranges: Part 1

Formatting Cells and Ranges: Part 2

Formatting Cells and Ranges: Part 2

Formatting Cells and Ranges: Part 2

Formatting Cells and Ranges: Part 2

10m 36s

Mastering Excel 2013: Formatting Cells and Ranges: Part 2

Tables

Tables

Tables

Tables

12m 33s

Mastering Excel 2013: Tables for Mastering Excel 2013

Sorting and Filtering

Sorting and Filtering

Sorting and Filtering

Sorting and Filtering

11m 51s

Mastering Excel 2013: Sorting and Filtering for Mastering Excel 2013

Quick Analysis and Slicers

Quick Analysis and Slicers

Quick Analysis and Slicers

Quick Analysis and Slicers

9m 17s

Mastering Excel 2013: Quick Analysis and Slicers for Mastering Excel 2013

Subtotals

Subtotals

Subtotals

Subtotals

6m 33s

Mastering Excel 2013: Subtotals for Mastering Excel 2013

Creating Pivot Tables

Creating Pivot Tables

Creating Pivot Tables

Creating Pivot Tables

7m 46s

Mastering Excel 2013: Creating Pivot Tables for Mastering Excel 2013

Recommended Pivot Tables

Recommended Pivot Tables

Recommended Pivot Tables

Recommended Pivot Tables

3m 53s

Mastering Excel 2013: Recommended Pivot Tables for Mastering Excel 2013

Customizing Pivot Tables

Customizing Pivot Tables

Customizing Pivot Tables

Customizing Pivot Tables

14m 33s

Mastering Excel 2013: Customizing Pivot Tables

Importing Data

Importing Data

Importing Data

Importing Data

8m 50s

Mastering Excel 2013: Importing Data

Intro to Charts

Intro to Charts

Intro to Charts

Intro to Charts

4m 24s

Mastering Excel 2013: Intro to Charts for Mastering Excel 2013

Choosing the Right Charts

Choosing the Right Charts

Choosing the Right Charts

Choosing the Right Charts

5m 33s

Mastering Excel 2013: Choosing the Right Charts

Chart Data

Chart Data

Chart Data

Chart Data

3m 46s

Mastering Excel 2013: Chart Data

Optimizing Charts

Optimizing Charts

Optimizing Charts

Optimizing Charts

10m 56s

Mastering Excel 2013: Optimizing Charts

New Chart Formatting Options

New Chart Formatting Options

New Chart Formatting Options

New Chart Formatting Options

12m 14s

Mastering Excel 2013: New Chart Formatting Options

Pivot Charts

Pivot Charts

Pivot Charts

Pivot Charts

5m 14s

Mastering Excel 2013: Pivot Charts

Sparklines

Sparklines

Sparklines

Sparklines

5m 22s

Mastering Excel 2013: Sparklines

Customizing Your View: Part 1

Customizing Your View: Part 1

Customizing Your View: Part 1

Customizing Your View: Part 1

12m 44s

Mastering Excel 2013: Customizing Your View: Part 1

Customizing Your View: Part 2

Customizing Your View: Part 2

Customizing Your View: Part 2

Customizing Your View: Part 2

3m 47s

Mastering Excel 2013: Customizing Your View: Part 2

Advanced Formatting

Advanced Formatting

Advanced Formatting

Advanced Formatting

7m 43s

Mastering Excel 2013: Advanced Formatting

Advanced Data Copy Techniques

Advanced Data Copy Techniques

Advanced Data Copy Techniques

Advanced Data Copy Techniques

8m 31s

Mastering Excel 2013: Advanced Data Copy Techniques

Transforming Data with the Clipboard

Transforming Data with the Clipboard

Transforming Data with the Clipboard

Transforming Data with the Clipboard

2m 50s

Mastering Excel 2013: Transforming Data with the Clipboard

Manipulating Text with Functions

Manipulating Text with Functions

Manipulating Text with Functions

Manipulating Text with Functions

8m 35s

Mastering Excel 2013: Manipulating Text with Functions

Printing Worksheets

Printing Worksheets

Printing Worksheets

Printing Worksheets

11m 34s

Mastering Excel 2013: Printing Worksheets

Working with Print Area

Working with Print Area

Working with Print Area

Working with Print Area

5m 27s

Mastering Excel 2013: Working with Print Area

Using Data Validation

Using Data Validation

Using Data Validation

Using Data Validation

10m 31s

Mastering Excel 2013: Using Data Validation

Analyzing Data: Scenario Manager

Analyzing Data: Scenario Manager

Analyzing Data: Scenario Manager

Analyzing Data: Scenario Manager

7m 27s

Mastering Excel 2013: Analyzing Data: Scenario Manager

Analyzing Data: Data Tables

Analyzing Data: Data Tables

Analyzing Data: Data Tables

Analyzing Data: Data Tables

7m 47s

Mastering Excel 2013: Analyzing Data: Data Tables

Analyzing Data: Goal Seek

Analyzing Data: Goal Seek

Analyzing Data: Goal Seek

Analyzing Data: Goal Seek

2m 59s

Mastering Excel 2013: Analyzing Data: Goal Seek

Text to Columns

Text to Columns

Text to Columns

Text to Columns

4m 35s

Mastering Excel 2013: Text to Columns

Consolidating Data

Consolidating Data

Consolidating Data

Consolidating Data

3m 37s

Mastering Excel 2013: Consolidating Data

Creating Macros

Creating Macros

Creating Macros

Creating Macros

8m 16s

Mastering Excel 2013: Creating Macros

Advanced Macros

Advanced Macros

Advanced Macros

Advanced Macros

5m 49s

Mastering Excel 2013: Advanced Macros

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

Mastering Excel 2013: Creating Random Numbers and Custom Series

External References

External References

External References

External References

3m 55s

Mastering Excel 2013: External References

Customizing The Ribbon and Toolbar

Customizing The Ribbon and Toolbar

Customizing The Ribbon and Toolbar

Customizing The Ribbon and Toolbar

9m 28s

Mastering Excel 2013: Customizing The Ribbon and Toolbar

Power View

Power View

Power View

Power View

7m 50s

Mastering Excel 2013: Power View

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