Excel Tutorial: Excel 2013 Superhero Course

Skillfeed will be shutdown on September 30. Please view additional details here.

Lessons
Comments ()

Videos		Duration

Chapter 1: Working with Windows
Freezing Panes		5 min
Splitting Panes		5 min
Displaying Multiple Workbooks on One screen		4 min
Chapter 2: Sorting and Filtering
Sorting Lists		9 min
Filtering Lists		12 min
Sorting and Filtering by Cell Colour		5 min
Chapter 3: Getting Started with Formulas
Introduction to Writing Formulas		10 min
Calculating Percentages		5 min
Writing Functions		12 min
The COUNTBLANK and COUNTA Functions		5 min
COUNTIF and the Function Wizard		9 min
Absolute Cell References in your Formulas		6 min
Using Defined Names		8 min
Chapter 4: Logical Functions
The IF Function		13 min
Nesting Functions to Test Multiple Conditions		12 min
Chapter 5: Lookup Functions
The VLOOKUP Function		14 min
VLOOKUP for the Closest Match		7 min
The HLOOKUP Function		6 min
VLOOKUP with Nested MATCH Function		8 min
Using the INDEX and MATCH Functions		11 min
Handling the #N/A Error Message		9 min
Chapter 6: Conditional Formatting
Applying Conditional Formatting		10 min
Using Icon Sets		6 min
Managing Conditional Formatting Rules		6 min
Formatting the Entire Row		7 min
Chapter 7: Protecting and Sharing a File
Encrypting a File		3 min
Applying Workbook Protection		5 min
Protecting a Worksheet		10 min
Sharing a Workbook		6 min
Chapter 8: Validating Data Entry
Validating Text Length		3 min
Validating Date Entries		3 min
Validate using a Drop Down List		5 min
Create your own Input and Error Messages		6 min
Create Dependent Drop Down Lists		7 min
Chapter 9: Analysing Data
Insert Subtotal Rows		8 min
SUMIF Function		6 min
SUMIFS and COUNTIFS		6 min
SUBTOTAL Function		7 min
Chapter 10: Working with Charts
Recommended Charts		6 min
Create a Column Chart		10 min
Create a Pie Chart		11 min
Create a Combo Chart		8 min
Chart Filters		4 min
Create an Interactive Chart		15 min
Using Sparklines		6 min
Chapter 11: Formatting a Range as a Table
Format a Range as a Table		12 min
Using Structured References in a Formula		4 min
Convert a Table Back to a Normal Range		3 min
Chapter 12: Working with PivotTables
Create a PivotTable		12 min
Formatting Values and Changing the Values Function		5 min
Sorting PivotTable Fields		4 min
Grouping PivotTable Fields		7 min
Show Values as Percentage, Difference and Rank		6 min
Filtering PivotTable Data		4 min
Refreshing a PivotTable		6 min
Create a PivotChart		4 min
Using Slicers		8 min
The New Timeline Slicer		4 min
Chapter 13: Importing Data into Excel
From a Text File		7 min
From a Website		10 min
From an Access Database		5 min
Chapter 14: Cleaning and Preparing Data
Separating Text into Multiple Columns		6 min
The CONCATENATE Function		5 min
Extracting Text from a Cell		13 min
MID and FIND Functions		8 min
The VALUE Function		4 min
The Awesome Flash Fill Tool		9 min
Chapter 15: Macros
What is a Macro?		7 min
Record a Macro		8 min
Assign a Macro to a Toolbar Button		6 min
Customising the Ribbon		6 min
Using Relative References in Macros		10 min
Saving a Macro Enabled File		3 min
Adding a Button to a Worksheet		4 min
Editing Macro Code		12 min
Chapter 16: Using the Internal Data Model
Adding Tables to the Data Model		5 min
Relating Tables in the Data Model		4 min
Using the Data Model in a PivotTable		4 min

Overview

Become an Excel superhero. Learn the skills to be able to handle any Excel problem. This course starts with the basics of formulas and managing spreadsheets and quickly moves to advanced Excel techniques required for creating powerful dynamic and visually appealing spreadsheets. This course includes lessons on some of the new features in Excel 2013 including the IFNA function, the Timeline Slicer, Flash Fill and the internal data model. Use the files provided for practice.

Lessons:	78
Duration:	8 hr 33 min
Subject:	Business
Language:	English
Software:	Excel 2013
Level:	Intermediate
Keywords:	excel 2013 professional training , microsoft excel 2013 online course , online excel training , online excel course , excel 2013 online training , excel course , excel training more
Released:	12/03/14

Project Files:

About the Instructor

Alan Murray

Alan Murray is a Microsoft Office trainer and consultant. He has been training and consulting for the past 15 years for businesses around the world. He is the founder of Computergaga and regularly writes on the Computergaga blog to share tips and tutorials. Alan uses a fun and relaxed style of training that 'gets to the point', and uses real world practical examples uncovered from his experience of training and developing software for businesses.

Related Courses

Excel 2013 Superhero Course

Get unlimited access now