You can learn anything on Udemy. Start today with one of our 10,000+ online courses

Microsoft Excel - Advanced Excel 2010 Training

Master Advanced Excel 2010 Features. Become A Expert And Learn To Use Excel Like A Pro With This Advanced Excel Training
245 reviews
WHAT'S INSIDE
  • Lifetime access to 136 lectures
  • 8+ hours of high quality content
  • Closed captioning enabled
  • A community of 61700+ students learning together!
  • 530+ discussions
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.

SHARE

Microsoft Excel - Advanced Excel 2010 Training

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

A Verifiable Certificate of Completion is presented to all students who undertake this Excel course.

This Excel 2010 advanced training course, follows up from the Beginners Excel 2010 course by delving even deeper into the features and functions of this powerful spreadsheet software.

Microsoft Excel 2010 is much more than a quick way to add up numbers. In this online course, you will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and more. You will learn about performing lookups with HLOOKUP and VLOOKUP. This tutorial also covers Sparklines, and goes in-depth with Pivot Tables and Charts. Finally, you will learn how to create and record your own Macros.

This advanced Excel video course is not for beginners. You should have a firm grasp of the basics before taking this Advanced Excel training course. By the conclusion of this advanced computer software tutorial for Microsoft Excel 2010, you will have mastered the advanced features and functions of this software. Working files are included to allow you to follow along with the same Excel files the author trains you with.

    • Over 136 lectures and 8.5 hours of content!
    • Learn Advanced Microsoft Excel 2010 from a professional trainer from your own desk.
    • 136 lectures (8.5 hours of content) teaching you lookups, advanced IF statements, Macros, Sparklines, and much more!
    • Suitable advanced Excel users. ideal for users who learn faster when shown.
    • Visual training method, offering users increased retention and accelerated learning.
    • Breaks even the most complex applications down into simplistic steps.

CURRICULUM

  • SECTION 1:
    Getting Started With This Excel Course
  • 1
    Working Files - Download These First
    Text
  • 2
    How Advanced Does The Advanced Get?
    04:57
  • 3
    Using The Included Excel Files
    01:41
  • 4
    How to obtain your Certificate of Completion.
    Text
    All Users of this course are eligible for a Certificate of Completion. Each certificate is issued with a unique number which allows verification that the user has undertaken a course. To obtain your certificate just visit http://www.infiniteskills.com/cert/01625
  • 5
    New In Excel 2010 - The Sparkline
    03:36
  • SECTION 2:
    The Excel IF Function
  • 6
    The Syntax Of IF
    06:02
  • 7
    Nesting The IF Statement In Excel
    06:45
  • 8
    Use The AND Operator To Reduce Quantity Of Nested IFs
    04:09
  • 9
    Use The OR Operator To Reduce Quantity Of Nested IFs
    03:17
  • 10
    The NOT Operator Within AND And OR Statements
    02:47
  • 11
    SUMIF For Selective Adding Up
    05:04
  • 12
    COUNTIF For Selective Counting
    03:52
  • 13
    AVERAGEIF For The Mean Of Cells That Meet Our Criteria
    02:34
  • 14
    Multiple Criteria Within The Same SUM AVERAGE And COUNT Functions
    07:17
  • SECTION 3:
    Performing Lookup in Excel
  • 15
    VLOOKUP Explained
    03:43
  • 16
    Applied Examples for VLOOKUP
    10:03
  • 17
    HLOOKUP Explained
    03:01
  • 18
    HLOOKUP In Action
    06:37
  • 19
    Looking For A Near Match In A Lookup
    04:51
  • 20
    Checking For Missing Data In A Lookup
    05:45
  • 21
    Extending The Size Of A Lookup Table
    04:14
  • 22
    Nested LOOKUPs In Excel
    04:28
  • SECTION 4:
    Excel Data Functions
  • 23
    The MATCH Function Explained
    08:14
  • 24
    The INDEX Function Syntax
    05:06
  • 25
    How To Stop Nonexistent Row Or Column Lookups In INDEX
    02:41
  • 26
    The CHOOSE Lookup Function
    02:37
  • SECTION 5:
    Excel Math Functions
  • 27
    Working With TIME
    05:55
  • 28
    Rounding To Fractional Values
    03:35
  • 29
    MOD For Working Out Remainders
    02:18
  • 30
    Generating A Random Number
    02:33
  • 31
    Pick A List Item At Random
    03:05
  • 32
    Calculating Loan Repayments Using PMT
    02:55
  • 33
    Excel - Investment Calculations Using PMT
    02:59
  • 34
    Working Out Depreciation
    04:21
  • 35
    Working Out Different Parts Of A Loan Calculation
    04:58
  • SECTION 6:
    Arrays In Excel
  • 36
    What Is An Array And An Array Formula
    03:00
  • 37
    Creating And Using An Array Formula
    03:29
  • 38
    Conditional Evaluation In An Array Formula
    03:42
  • 39
    The Very Clever TRANSPOSE Array Function
    03:32
  • SECTION 7:
    Excel Functions For Working With Text
  • 40
    LEN And TRIM Two Very Useful Text Functions
    02:44
  • 41
    Using LEFT And RIGHT For String Extraction
    03:36
  • 42
    FIND And MID Working Together To Extract Parts Of Strings
    04:15
  • 43
    Build Strings From Multiple Cells
    03:58
  • 44
    Excel - Changing The Case Of Text In Cells
    02:56
  • 45
    REPLACE And SUBSTITUTE In Action
    05:12
  • 46
    Formatting Numeric Values With A Text String Using TEXT
    05:09
  • 47
    Extracting The Values From The Text Functions We Have Used
    03:00
  • SECTION 8:
    Other Useful Excel Functions
  • 48
    Welcome To IS Functions
    02:45
  • 49
    Error Checking With ISERR ISERROR ISNA And IFERROR
    08:06
  • 50
    The OFFSET Formula Explained
    03:17
  • 51
    Dynamic Named Ranges Using The OFFSET Function
    05:48
  • 52
    Use The INDIRECT Function To Build Dynamic Formulas
    05:59
  • 53
    Dealing With INDIRECT Errors
    01:46
  • 54
    Use Formulas To Determine An Excel Filename And Or Sheet Name
    05:43
  • SECTION 9:
    Sparklines
  • 55
    Creating A Sparkline In Excel
    03:06
  • 56
    Change The Design Of Sparklines
    03:38
  • 57
    Dealing with Empty Cells
    01:57
  • 58
    Comparing One Sparkline To Another by Altering Vertical Scale
    02:57
  • 59
    Removing Sparklines From A Sheet
    01:35
  • SECTION 10:
    Outlining
  • 60
    Outlining Explained
    02:35
  • 61
    Creating An Outline Automatically
    02:34
  • 62
    Creating An Outline Manually
    02:58
  • 63
    Manually Removing Data From An Outline
    03:25
  • 64
    Removing The Outlining From A Worksheet
    00:55
  • 65
    Adjusting A Grouping Created By Automatic Outlining
    03:54
  • SECTION 11:
    Custom Views In Excel
  • 66
    Creating A Custom View Of A Worksheet
    02:48
  • 67
    Changing From One Custom View To Another
    01:34
  • 68
    Editing A Custom View
    01:14
  • 69
    How To Delete A Custom View
    01:20
  • SECTION 12:
    Scenario
  • 70
    Setting Up A Scenario And Entering Values
    04:17
  • 71
    Display The Scenario Values
    02:01
  • 72
    Editing The Values Of A Scenario
    01:32
  • 73
    Deleting A Scenario
    01:06
  • 74
    Merge Scenarios From Different Sheets
    02:13
  • 75
    Getting A Summary Of All Scenarios
    04:28
  • SECTION 13:
    Auditing And Troubleshooting Formulas
  • 76
    Description Of Tracer Arrows
    01:00
  • 77
    Tracing Precedents And Dependents
    02:56
  • 78
    Remove Tracer Arrows
    01:54
  • 79
    Error Checking Using Auditing Tools
    04:23
  • 80
    Step By Step Processing Of Formula To Help With Troubleshooting
    02:55
  • 81
    Excel - Utilizing The Watch Window
    03:48
  • SECTION 14:
    Pivot Tables In Excel
  • 82
    What Is A Pivot Table
    04:19
  • 83
    Steps To Create A Pivot Table In Excel
    06:56
  • 84
    Rearranging Fields In A Pivot Table
    03:50
  • 85
    Changing The Math Of The Data Summary
    03:03
  • 86
    Number Format Control Of The Summary Area
    03:17
  • 87
    Creating A Second (Or More) Pivot Table On The Same Data
    03:01
  • 88
    Moving A Pivot Table
    03:05
  • 89
    Removing A Pivot Table
    01:55
  • 90
    Making Use Of The Report Filter Option
    05:47
  • 91
    Sorting A Pivot Tables Columns
    03:30
  • 92
    Displaying Values As A Percentage
    05:00
  • 93
    Refreshing A Pivot Table Manually Or Semi-Automatically
    02:56
  • 94
    Drilling Down Behind The Pivot Table Summaries
    04:06
  • 95
    Applying Pivot Table Styles
    03:14
  • 96
    Creating Your Own Custom Pivot Table Style
    03:39
  • 97
    Copying A Pivot Table Style Between Workbooks
    02:13
  • 98
    Using More Than One Field In Row And Column Headings
    05:01
  • 99
    Disabling And Enabling Grand And Sub Totals
    05:53
  • 100
    Filtering Columns And Rows Within A Pivot Table
    06:08

RATING

  • 172
  • 56
  • 8
  • 2
  • 7
AVERAGE RATING
NUMBER OF RATINGS
245

REVIEWS

  • Tracey Simpson
    Very well explained - each topic demonstrated several times

    This was my first course on udemy and I have to say I'm impressed! Great instructor, pace and detail is spot on. This course is a must!!!

  • Ken Sturgeon
    Great course! Excellent delivery.

    The content of this course is quite full and the instructor does a very clear job explaining all of the available functionality covered by the course. Over half of the courses I've taken through Udemy have been from Infinite Skills. I'm quite impressed with this organization's educational offerings and encourage others to engage them.

  • Howard E. Hillman
    Best Excel training ever!!

    Lectures are short, but in-depth enough to get a good understanding of the the material covered. I love having the ability to go to the working files and practice what I've learned. Best of all, I can go at my own pace and go back to review information later. Great course!

  • John Gorman
    Loved this course!!!

    Logical structure, great coverage of topics, everything was fully explained. Everything a good course should be. Thanks!

  • Jeff Buford
    In Depth, great examples

    I really enjoyed this course as it provided a ton of depth and great examples from working files. It was a little heavier on the Pivot Tables for my tastes which I think is more of an Intermediate skill rather than advanced, but still excellent information.