Microsoft Excel 2013 Advanced. Online Excel Training Course

Master Advanced Excel 2013 Features. Become A Expert And Learn To Use Excel Like A Pro With This Advanced Excel Training

Video Error

We tried several times to play your video but there was an unforeseen error. We have notified our engineers.

Visit https://helpx.adobe.com/flash-player.html to check that Flash is enabled on your browser.

With Flash enabled, please try again in a few minutes or contact support.

  • Lectures 128
  • Video 10 Hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

Course Description

Learn the expert features and functions in Microsoft Excel 2013, alongside our expert author, to help you get you beyond the basics and have advanced-level proficiency within the Excel 2013 suite

Whilst in this course we’ll cover the basics of Excel, including SUM, MIN, MAX and other conditional statements, we’ll quickly move onto more advanced-level topics including:

  • IF statements
  • VLOOKUP and HLOOKUP
  • Sparklines
  • Pivot Tables and Charts
  • Macro Operations

The Ability to Master Excel

By the completion of this computer based advanced Excel training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer.

With the ability to handle advanced tasks in Excel, you’ll be able to get more power out of your worksheets and be able to dramatically shorten your task times and increase your efficiency in the process.

Content and Overview

Suitable for beginners with Microsoft Excel (as we’ll cover the basics early on) but also for those who wish to cover the advanced topics in Excel. Through the course of 128 lectures and 10+ hours of content, you’ll learn all of the basic and advanced items of Excel, which will enable you to use Excel expertly within in a personal or commercial environment.

Complete with working files and code samples, you’ll be able to follow along with the author throughout the lessons, and will receive a verifiable certificate of completion upon finishing the course.

What are the requirements?

  • Microsoft Excel 2013, Windows 8, 7, Vista or XP

What am I going to get from this course?

  • Over 128 lectures and 10 hours of content!
  • To take your basic Excel skills to the next level
  • To gain a solid understanding of the more powerful features and functions in Excel
  • To be able to use Microsoft Excel in a commercial environment

What is the target audience?

  • Users with a basic knowledge of Excel
  • Users who have completed our Beginners / Intermediate Excel title

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started
Working Files - Download These First
Text
0101 Will I Be Able To Keep Up?
03:57
0102 Using The Included Files
01:17
0103 New For 2013: Its All In The Cloud
04:03
0104 The Very Clever Flash Fill
Preview
04:13
Section 2: Using Mathematical Functions
0201 The Basic SUM, COUNT, MIN, And MAX
Preview
03:39
0202 AVERAGE, MODE, MEAN, And MEDIAN
04:04
0203 SUMIF For Selective Adding Up
Preview
06:30
0204 COUNTIF For Selective Counting
03:18
0205 AVERAGEIF For The Mean Of Selected Cells
03:29
0206 Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF
07:06
0207 Area And Volume Calculations
04:09
Section 3: IF Functionality
0301 IF Syntax And Uses
07:55
0302 Nesting The IF Statement
Preview
07:26
0303 Use Of The AND Operator Within An IF
06:29
0304 Use Of The OR Operator Within An IF
04:03
0305 The NOT Operator Within AND And OR Statements
Preview
04:28
0306 Display Cell Formulas In Another Cell
04:11
Section 4: Performing Data Lookups
0401 VLOOKUP: Syntax And Usage
Preview
04:51
0402 VLOOKUP In Live Action
06:53
0403 HLOOKUP: Variation On A Theme
04:42
0404 Using A Near Match In The Lookup
03:44
0405 Dealing With Missing Data In A Lookup
Preview
04:55
0406 Managing The Lookup Table
05:03
0407 Lookups Nested Within Lookups
06:29
Section 5: Sparklines
0501 Creating A Sparkline
04:58
0502 Altering The Design Of Sparklines
04:26
0503 Dealing With Empty Cells
02:24
0504 Comparing Sparklines Within A Sparkline Group
04:18
0505 Removing Sparklines From A Worksheet
02:14
Section 6: Further Mathematical Functions
0601 Working With Time In Excel
10:20
0602 Calculations Using Time
03:58
0603 Useful Time And Date Functions
04:45
0604 Rounding Decimal Places
04:32
0605 MOD And INT Functions And Uses
04:42
0606 Generate And Use A Random Number
05:36
0607 Loan And Investment Calculations
05:58
0608 Loan Calculation Elements And Functions
04:04
Section 7: Outlining
0701 Create An Outline Automatically
03:47
0702 Adding An Outline Manually
03:22
0703 Editing And Removing Outlining
06:39
Section 8: Scenarios
0801 Setting Up A Set Of Scenarios
06:59
0802 Displaying And Editing The Different Scenarios
03:12
0803 How To Work Out Which Scenario You Are Displaying
04:06
0804 Merging And Deleting Scenarios
03:41
0805 Producing A Summary Of Scenarios
03:52
Section 9: Custom Views
0901 Custom Views Explained
03:03
0902 Use Of Outlining To Help Setup Custom Views
03:56
0903 Editing And Deleting Custom Views
04:25
0904 Add Quick Access To Custom Views
03:30
Section 10: Functions For Manipulating Text
1001 LEFT And RIGHT: Text Manipulation
04:28
1002 LEN And TRIM: String Extractions
06:34
1003 FIND And MID: Text Functions Working Together
06:53
1004 CONCATENATE: Building Strings From Multiple Cells
05:23
1005 Changing Case Functions
04:03
1006 REPLACE And SUBSTITUTE: Two More String Manipulation Functions
04:42
1007 Use Of CHAR Function For More Obscure Characters
06:12
1008 Formatting Numeric And Date Values Using TEXT
05:01
1009 Keeping The Values Created By String Manipulation
03:21
Section 11: Arrays
1101 Arrays And Creating A New Array Formula
05:27
1102 Array Formulas With IF Statements
04:57
1103 Conditional Evaluation With No IFs
07:21
1104 The Array-Only TRANSPOSE Function
06:16
Section 12: Useful Data Functions
1201 Using The MATCH Function
06:58
1202 How The INDEX Function Works
05:01
1203 Handling Out Of Range Index Requests
03:12
1204 The CHOOSE Lookup Function
03:34
1205 MATCH And INDEX Functions Working Together
05:04
Section 13: Some Other Useful Functions
1301 Introducing IS Functions
03:23
1302 Error Checking Using ISERR, ISERROR, And IFERROR
06:28
1303 OFFSET Function Syntax
03:55
1304 OFFSET Function: Creating A Dynamic Named Range
04:53
1305 INDIRECT Function To Build Dynamic Formulas
04:16
1306 Dealing With INDIRECT Errors
03:25
1307 The CELL Function And Determining File Or Sheet Names
07:39
Section 14: Auditing And Troubleshooting Formulas
1401 What Are Tracer Arrows
04:20
1402 Adding And Removing Tracer Arrows
02:58
1403 Auditing Tools: Error Checking And Tracing
06:26
1404 Step-By-Step Formula Processing
03:41
1405 Using The Watch Window In Troubleshooting
04:11
Section 15: PivotTables
1501 What Is A PivotTable?
04:13
1502 The New Recommended PivotTable Route
04:27
1503 Creating Your Own PivotTables
06:24
1504 Changing The Formatting And Formulas In PivotTable Summaries
04:21
1505 Creating Multiple PivotTables On The Same Dataset
05:03

Instructor Biography

Infinite Skills, High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Join the biggest student community

14,000,000

Hours of video content

42,000,000

Course Enrollments

10,000,000

Students

Reviews

Average Rating
4.7
Details
  1. 5 Stars
    145
  2. 4 Stars
    34
  3. 3 Stars
    3
  4. 2 Stars
    1
  5. 1 Star
    3
Ready to start learning?
Preview This Course