Microsoft Excel 2010: Advanced Training

Master Advanced Excel 2010 Features. Become A Expert And Learn To Use Excel Like A Pro With This Advanced Excel Training
  • Lectures 136
  • Video 9 Hours
  • Skill level all level
  • Languages English , captions
  • 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

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.

What am I going to get from this course?

  • 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
Working Files - Download These First
Text
How Advanced Does The Advanced Get?
Preview
04:57
Using The Included Excel Files
Preview
01:41
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
New In Excel 2010 - The Sparkline
Preview
03:36
Section 2: The Excel IF Function
The Syntax Of IF
Preview
06:02
Nesting The IF Statement In Excel
Preview
06:45
Use The AND Operator To Reduce Quantity Of Nested IFs
Preview
04:09
Use The OR Operator To Reduce Quantity Of Nested IFs
Preview
03:17
The NOT Operator Within AND And OR Statements
Preview
02:47
SUMIF For Selective Adding Up
Preview
05:04
COUNTIF For Selective Counting
Preview
03:52
AVERAGEIF For The Mean Of Cells That Meet Our Criteria
Preview
02:34
Multiple Criteria Within The Same SUM AVERAGE And COUNT Functions
Preview
07:17
Section 3: Performing Lookup in Excel
VLOOKUP Explained
Preview
03:43
Applied Examples for VLOOKUP
Preview
10:03
HLOOKUP Explained
Preview
03:01
HLOOKUP In Action
Preview
06:37
Looking For A Near Match In A Lookup
Preview
04:51
Checking For Missing Data In A Lookup
Preview
05:45
Extending The Size Of A Lookup Table
Preview
04:14
Nested LOOKUPs In Excel
Preview
04:28
Section 4: Excel Data Functions
The MATCH Function Explained
08:14
The INDEX Function Syntax
05:06
How To Stop Nonexistent Row Or Column Lookups In INDEX
02:41
The CHOOSE Lookup Function
02:37
Section 5: Excel Math Functions
Working With TIME
05:55
Rounding To Fractional Values
03:35
MOD For Working Out Remainders
02:18
Generating A Random Number
02:33
Pick A List Item At Random
03:05
Calculating Loan Repayments Using PMT
02:55
Excel - Investment Calculations Using PMT
02:59
Working Out Depreciation
04:21
Working Out Different Parts Of A Loan Calculation
04:58
Section 6: Arrays In Excel
What Is An Array And An Array Formula
03:00
Creating And Using An Array Formula
03:29
Conditional Evaluation In An Array Formula
03:42
The Very Clever TRANSPOSE Array Function
03:32
Section 7: Excel Functions For Working With Text
LEN And TRIM Two Very Useful Text Functions
02:44
Using LEFT And RIGHT For String Extraction
03:36
FIND And MID Working Together To Extract Parts Of Strings
04:15
Build Strings From Multiple Cells
03:58
Excel - Changing The Case Of Text In Cells
02:56
REPLACE And SUBSTITUTE In Action
05:12
Formatting Numeric Values With A Text String Using TEXT
05:09
Extracting The Values From The Text Functions We Have Used
03:00
Section 8: Other Useful Excel Functions
Welcome To IS Functions
02:45
Error Checking With ISERR ISERROR ISNA And IFERROR
08:06
The OFFSET Formula Explained
03:17
Dynamic Named Ranges Using The OFFSET Function
05:48
Use The INDIRECT Function To Build Dynamic Formulas
05:59
Dealing With INDIRECT Errors
01:46
Use Formulas To Determine An Excel Filename And Or Sheet Name
05:43
Section 9: Sparklines
Creating A Sparkline In Excel
03:06
Change The Design Of Sparklines
03:38
Dealing with Empty Cells
01:57
Comparing One Sparkline To Another by Altering Vertical Scale
02:57
Removing Sparklines From A Sheet
01:35
Section 10: Outlining
Outlining Explained
02:35
Creating An Outline Automatically
02:34
Creating An Outline Manually
02:58
Manually Removing Data From An Outline
03:25
Removing The Outlining From A Worksheet
00:55
Adjusting A Grouping Created By Automatic Outlining
03:54
Section 11: Custom Views In Excel
Creating A Custom View Of A Worksheet
02:48
Changing From One Custom View To Another
01:34
Editing A Custom View
01:14
How To Delete A Custom View
01:20
Section 12: Scenario
Setting Up A Scenario And Entering Values
04:17
Display The Scenario Values
02:01
Editing The Values Of A Scenario
01:32
Deleting A Scenario
01:06
Merge Scenarios From Different Sheets
02:13
Getting A Summary Of All Scenarios
04:28
Section 13: Auditing And Troubleshooting Formulas
Description Of Tracer Arrows
01:00
Tracing Precedents And Dependents
02:56
Remove Tracer Arrows
01:54
Error Checking Using Auditing Tools
04:23
Step By Step Processing Of Formula To Help With Troubleshooting
02:55
Excel - Utilizing The Watch Window
03:48
Section 14: Pivot Tables In Excel
What Is A Pivot Table
04:19
Steps To Create A Pivot Table In Excel
06:56
Rearranging Fields In A Pivot Table
03:50
Changing The Math Of The Data Summary
03:03
Number Format Control Of The Summary Area
03:17
Creating A Second (Or More) Pivot Table On The Same Data
03:01
Moving A Pivot Table
03:05
Removing A Pivot Table
01:55
Making Use Of The Report Filter Option
05:47
Sorting A Pivot Tables Columns
03:30
Displaying Values As A Percentage
05:00
Refreshing A Pivot Table Manually Or Semi-Automatically
02:56
Drilling Down Behind The Pivot Table Summaries
04:06
Applying Pivot Table Styles
03:14
Creating Your Own Custom Pivot Table Style
03:39
Copying A Pivot Table Style Between Workbooks
02:13
Using More Than One Field In Row And Column Headings
05:01
Disabling And Enabling Grand And Sub Totals
05:53
Filtering Columns And Rows Within A Pivot Table
06:08

Instructor Biography

O'Reilly Media , High Quality Training

O'Reilly spreads the knowledge of innovators through its technology books, online services, magazines, research, and tech conferences. Since 1978, O'Reilly has been a chronicler and catalyst of leading-edge development, homing in on the technology trends that really matter and galvanizing their adoption by amplifying "faint signals" from the alpha geeks who are creating the future. An active participant in the technology community, O'Reilly has a long history of advocacy, meme-making, and evangelism.

Reviews

Average Rating
4.6
Details
  1. 5 Stars
    179
  2. 4 Stars
    56
  3. 3 Stars
    8
  4. 2 Stars
    2
  5. 1 Stars
    7
    • Luz Garay

    Great course!

    This course was very inclusive of a wide variety of topics. I have watched several courses on Excel and this is one of my top 2. The instructor went at a great pace, and it was easy to understand the things he was doing in the videos. His voice was almost a little too soothing though, and I caught myself zoning out a few times. Overall, this was a great course for anyone looking to get more exposure to some more advanced Excel topics.

    • Hassan Raza

    Excellent Course,it help me to update my working in Excel 2010

    • Eric Martin

    Extremely well instructed and great new content. Well Done!

    Extremely well instructed and great new content. Well Done!

    • Kelly Middleton

    Excellent

    The course helped me to advance my skills. My favorite instructor so far. Guy's teaching is clear and concise. Look forward to more classes that he teaches, as I know I will glean a lot. Already improved skills, and was provided with new information that I could put to use right away! The videos are clear and understandable. There isn't any instructor/student interaction which could be useful but if you dig you can find the answers for your self which helps a person retain the information anyway.

    • Faraz Akhtar

    Great Course!!! Must Take.

    I learned a lot about excel from this course and I consider my background in excel to be advanced. Highly Recommend!

Show more reviews

What you get with this course

30 day money back guarantee

Lifetime access

Available on desktop, iOS and Android

Certificate of completion

Join the biggest student community

5,900,000

Hours of video content

22,000,000

Course enrollment

6,500,000

Students

Ready to start learning?
Preview this course