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
23 reviews
TAUGHT BY
  • Infinite Skills High Quality Training

    InfiniteSkills is a Canadian based company that offers an ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples. The emphasis is on teaching real life skills that are essential in today's commercial environment. All InfiniteSkills courses are taught by experts who have a true passion for teaching.

WHAT'S INSIDE
  • Lifetime access to 128 lectures
  • 9+ hours of high quality content
  • A community of 26900+ students learning together!
  • 60+ discussions
SHARE

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
23 reviews

HOW UDEMY WORKS?

Discover courses made by experts from around the world.

Take your courses with you and learn anytime, anywhere.

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.

    • Microsoft Excel 2013, Windows 8, 7, Vista or XP
    • 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
    • Users with a basic knowledge of Excel
    • Users who have completed our Beginners / Intermediate Excel title

THE UDEMY GUARANTEE

30 day money back guarantee
Lifetime access
Available on Desktop, iOs and Android
Certificate of completion

CURRICULUM

  • SECTION 1:
    Getting Started
  • 1
    Working Files - Download These First
    Text
  • 2
    0101 Will I Be Able To Keep Up?
    03:57
  • 3
    0102 Using The Included Files
    01:17
  • 4
    0103 New For 2013: Its All In The Cloud
    04:03
  • 5
    0104 The Very Clever Flash Fill
    04:13
  • SECTION 2:
    Using Mathematical Functions
  • 6
    0201 The Basic SUM, COUNT, MIN, And MAX
    03:39
  • 7
    0202 AVERAGE, MODE, MEAN, And MEDIAN
    04:04
  • 8
    0203 SUMIF For Selective Adding Up
    06:30
  • 9
    0204 COUNTIF For Selective Counting
    03:18
  • 10
    0205 AVERAGEIF For The Mean Of Selected Cells
    03:29
  • 11
    0206 Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF
    07:06
  • 12
    0207 Area And Volume Calculations
    04:09
  • SECTION 3:
    IF Functionality
  • 13
    0301 IF Syntax And Uses
    07:55
  • 14
    0302 Nesting The IF Statement
    07:26
  • 15
    0303 Use Of The AND Operator Within An IF
    06:29
  • 16
    0304 Use Of The OR Operator Within An IF
    04:03
  • 17
    0305 The NOT Operator Within AND And OR Statements
    04:28
  • 18
    0306 Display Cell Formulas In Another Cell
    04:11
  • SECTION 4:
    Performing Data Lookups
  • 19
    0401 VLOOKUP: Syntax And Usage
    04:51
  • 20
    0402 VLOOKUP In Live Action
    06:53
  • 21
    0403 HLOOKUP: Variation On A Theme
    04:42
  • 22
    0404 Using A Near Match In The Lookup
    03:44
  • 23
    0405 Dealing With Missing Data In A Lookup
    04:55
  • 24
    0406 Managing The Lookup Table
    05:03
  • 25
    0407 Lookups Nested Within Lookups
    06:29
  • SECTION 5:
    Sparklines
  • 26
    0501 Creating A Sparkline
    04:58
  • 27
    0502 Altering The Design Of Sparklines
    04:26
  • 28
    0503 Dealing With Empty Cells
    02:24
  • 29
    0504 Comparing Sparklines Within A Sparkline Group
    04:18
  • 30
    0505 Removing Sparklines From A Worksheet
    02:14
  • SECTION 6:
    Further Mathematical Functions
  • 31
    0601 Working With Time In Excel
    10:20
  • 32
    0602 Calculations Using Time
    03:58
  • 33
    0603 Useful Time And Date Functions
    04:45
  • 34
    0604 Rounding Decimal Places
    04:32
  • 35
    0605 MOD And INT Functions And Uses
    04:42
  • 36
    0606 Generate And Use A Random Number
    05:36
  • 37
    0607 Loan And Investment Calculations
    05:58
  • 38
    0608 Loan Calculation Elements And Functions
    04:04
  • SECTION 7:
    Outlining
  • 39
    0701 Create An Outline Automatically
    03:47
  • 40
    0702 Adding An Outline Manually
    03:22
  • 41
    0703 Editing And Removing Outlining
    06:39
  • SECTION 8:
    Scenarios
  • 42
    0801 Setting Up A Set Of Scenarios
    06:59
  • 43
    0802 Displaying And Editing The Different Scenarios
    03:12
  • 44
    0803 How To Work Out Which Scenario You Are Displaying
    04:06
  • 45
    0804 Merging And Deleting Scenarios
    03:41
  • 46
    0805 Producing A Summary Of Scenarios
    03:52
  • SECTION 9:
    Custom Views
  • 47
    0901 Custom Views Explained
    03:03
  • 48
    0902 Use Of Outlining To Help Setup Custom Views
    03:56
  • 49
    0903 Editing And Deleting Custom Views
    04:25
  • 50
    0904 Add Quick Access To Custom Views
    03:30
  • SECTION 10:
    Functions For Manipulating Text
  • 51
    1001 LEFT And RIGHT: Text Manipulation
    04:28
  • 52
    1002 LEN And TRIM: String Extractions
    06:34
  • 53
    1003 FIND And MID: Text Functions Working Together
    06:53
  • 54
    1004 CONCATENATE: Building Strings From Multiple Cells
    05:23
  • 55
    1005 Changing Case Functions
    04:03
  • 56
    1006 REPLACE And SUBSTITUTE: Two More String Manipulation Functions
    04:42
  • 57
    1007 Use Of CHAR Function For More Obscure Characters
    06:12
  • 58
    1008 Formatting Numeric And Date Values Using TEXT
    05:01
  • 59
    1009 Keeping The Values Created By String Manipulation
    03:21
  • SECTION 11:
    Arrays
  • 60
    1101 Arrays And Creating A New Array Formula
    05:27
  • 61
    1102 Array Formulas With IF Statements
    04:57
  • 62
    1103 Conditional Evaluation With No IFs
    07:21
  • 63
    1104 The Array-Only TRANSPOSE Function
    06:16
  • SECTION 12:
    Useful Data Functions
  • 64
    1201 Using The MATCH Function
    06:58
  • 65
    1202 How The INDEX Function Works
    05:01
  • 66
    1203 Handling Out Of Range Index Requests
    03:12
  • 67
    1204 The CHOOSE Lookup Function
    03:34
  • 68
    1205 MATCH And INDEX Functions Working Together
    05:04
  • SECTION 13:
    Some Other Useful Functions
  • 69
    1301 Introducing IS Functions
    03:23
  • 70
    1302 Error Checking Using ISERR, ISERROR, And IFERROR
    06:28
  • 71
    1303 OFFSET Function Syntax
    03:55
  • 72
    1304 OFFSET Function: Creating A Dynamic Named Range
    04:53
  • 73
    1305 INDIRECT Function To Build Dynamic Formulas
    04:16
  • 74
    1306 Dealing With INDIRECT Errors
    03:25
  • 75
    1307 The CELL Function And Determining File Or Sheet Names
    07:39
  • SECTION 14:
    Auditing And Troubleshooting Formulas
  • 76
    1401 What Are Tracer Arrows
    04:20
  • 77
    1402 Adding And Removing Tracer Arrows
    02:58
  • 78
    1403 Auditing Tools: Error Checking And Tracing
    06:26
  • 79
    1404 Step-By-Step Formula Processing
    03:41
  • 80
    1405 Using The Watch Window In Troubleshooting
    04:11
  • SECTION 15:
    PivotTables
  • 81
    1501 What Is A PivotTable?
    04:13
  • 82
    1502 The New Recommended PivotTable Route
    04:27
  • 83
    1503 Creating Your Own PivotTables
    06:24
  • 84
    1504 Changing The Formatting And Formulas In PivotTable Summaries
    04:21
  • 85
    1505 Creating Multiple PivotTables On The Same Dataset
    05:03
  • 86
    1506 Moving And Deleting PivotTables
    03:52
  • 87
    1507 Making Use Of The Report Filter Options
    05:07
  • 88
    1508 Sorting The PivotTable Columns
    05:16
  • 89
    1509 Refreshing A PivotTable
    02:51
  • 90
    1510 Drilling Down Behind The Pivot Numbers
    02:44
  • 91
    1511 Multiple Fields In Row, Column, Or Data Sections
    05:18
  • 92
    1512 Controlling Grand Totals And Subtotals
    04:52
  • 93
    1513 Dealing With Empty Cells And Other Additional Options
    05:08
  • 94
    1514 PivotTable Styles
    05:04
  • 95
    1515 Creating Your Own PivotTable Styles
    04:35
  • 96
    1516 Creating And Using Calculated Fields
    03:50
  • 97
    1517 Using The New Timeline Filter Option
    04:36
  • 98
    1518 Adding And Using The Data Slicer
    05:31
  • 99
    1519 Using Data From An SQL Server In A PivotTable
    04:51
  • 100
    1520 Managing The External Connection To SQL Server
    02:44

UDEMY BY THE NUMBERS

5,200,000
Hours of video content
19,000,000
Course Enrollments
5,800,000
Students

RATING

  • 21
  • 2
  • 0
  • 0
  • 0
AVERAGE RATING
NUMBER OF RATINGS
23

REVIEWS

  • Jimmy Fikes
    Exceptional training

    Guy is the greatest. He is easy to understand and his material is well organized. He does not go too fast and he repeats necessary comments to reinforce the learning. I plan to take all of the courses he offers!

  • Eddie Thomas
    Outstanding

    Guy is so talented as a teacher. His pace is perfect and he's very articulate. This is an outstanding course.

  • Jorge Zayas
    Advanced Microsoft Excel 2013

    Great training. Easy to understand and well explained by Mr. Vaccaro. Excellent tool for the excel users.

  • Mark Cohen
    Great Pace & Clarity

    I found this course went at a nice steady, easy to follow pace & everything was explained with great clarity. Each step was repeated several times, allowing for the information to be remembered. Unfortunately, it appears to be Infinite Skills that answer questions; rather than the course tutor. Their responses often don't seem to be of much use - too generic. However, the course material itself is highly recommended.

  • Bruno Brito
    A great in-depth approach to Excel's most advanced features

    This is just what I was looking for! Guy is a great trainer, explaining everything in great detail and providing relevant, "real world" examples for most of the things you will learn. With all his timing and thorough explanations, Guy made it very easy to learn some of Excel's most daunting features such as Macros or Data Lookups. I now feel I know what can be achieved in Excel and I definitely recommend this course to anybody who wants to master Excel's exciting advanced features.

  • 30 day money back guarantee!
  • Lifetime Access. No Limits!
  • Mobile Accessibility
  • Certificate of Completion