4.41 out of 5
4.41
2331 reviews on Udemy

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
Instructor:
Infinite Skills
75,302 students enrolled
English
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.

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.

Getting Started With This Excel Course

1
Working Files - Download These First
2
How Advanced Does The Advanced Get?
3
Using The Included Excel Files
4
New In Excel 2010 - The Sparkline

The Excel IF Function

1
The Syntax Of IF
2
Nesting The IF Statement In Excel
3
Use The AND Operator To Reduce Quantity Of Nested IFs
4
Use The OR Operator To Reduce Quantity Of Nested IFs
5
The NOT Operator Within AND And OR Statements
6
SUMIF For Selective Adding Up
7
COUNTIF For Selective Counting
8
AVERAGEIF For The Mean Of Cells That Meet Our Criteria
9
Multiple Criteria Within The Same SUM AVERAGE And COUNT Functions

Performing Lookup in Excel

1
VLOOKUP Explained
2
Applied Examples for VLOOKUP
3
HLOOKUP Explained
4
HLOOKUP In Action
5
Looking For A Near Match In A Lookup
6
Checking For Missing Data In A Lookup
7
Extending The Size Of A Lookup Table
8
Nested LOOKUPs In Excel

Excel Data Functions

1
The MATCH Function Explained
2
The INDEX Function Syntax
3
How To Stop Nonexistent Row Or Column Lookups In INDEX
4
The CHOOSE Lookup Function

Excel Math Functions

1
Working With TIME
2
Rounding To Fractional Values
3
MOD For Working Out Remainders
4
Generating A Random Number
5
Pick A List Item At Random
6
Calculating Loan Repayments Using PMT
7
Excel - Investment Calculations Using PMT
8
Working Out Depreciation
9
Working Out Different Parts Of A Loan Calculation

Arrays In Excel

1
What Is An Array And An Array Formula
2
Creating And Using An Array Formula
3
Conditional Evaluation In An Array Formula
4
The Very Clever TRANSPOSE Array Function

Excel Functions For Working With Text

1
LEN And TRIM Two Very Useful Text Functions
2
Using LEFT And RIGHT For String Extraction
3
FIND And MID Working Together To Extract Parts Of Strings
4
Build Strings From Multiple Cells
5
Excel - Changing The Case Of Text In Cells
6
REPLACE And SUBSTITUTE In Action
7
Formatting Numeric Values With A Text String Using TEXT
8
Extracting The Values From The Text Functions We Have Used

Other Useful Excel Functions

1
Welcome To IS Functions
2
Error Checking With ISERR ISERROR ISNA And IFERROR
3
The OFFSET Formula Explained
4
Dynamic Named Ranges Using The OFFSET Function
5
Use The INDIRECT Function To Build Dynamic Formulas
6
Dealing With INDIRECT Errors
7
Use Formulas To Determine An Excel Filename And Or Sheet Name

Sparklines

1
Creating A Sparkline In Excel
2
Change The Design Of Sparklines
3
Dealing with Empty Cells
4
Comparing One Sparkline To Another by Altering Vertical Scale
5
Removing Sparklines From A Sheet

Outlining

1
Outlining Explained
2
Creating An Outline Automatically
3
Creating An Outline Manually
4
Manually Removing Data From An Outline
5
Removing The Outlining From A Worksheet
6
Adjusting A Grouping Created By Automatic Outlining

Custom Views In Excel

1
Creating A Custom View Of A Worksheet
2
Changing From One Custom View To Another
3
Editing A Custom View
4
How To Delete A Custom View

Scenario

1
Setting Up A Scenario And Entering Values
2
Display The Scenario Values
3
Editing The Values Of A Scenario
4
Deleting A Scenario
5
Merge Scenarios From Different Sheets
6
Getting A Summary Of All Scenarios

Auditing And Troubleshooting Formulas

1
Description Of Tracer Arrows
2
Tracing Precedents And Dependents
3
Remove Tracer Arrows
4
Error Checking Using Auditing Tools
5
Step By Step Processing Of Formula To Help With Troubleshooting
6
Excel - Utilizing The Watch Window

Pivot Tables In Excel

1
What Is A Pivot Table
2
Steps To Create A Pivot Table In Excel
3
Rearranging Fields In A Pivot Table
4
Changing The Math Of The Data Summary
5
Number Format Control Of The Summary Area
6
Creating A Second (Or More) Pivot Table On The Same Data
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.4
4.4 out of 5
2331 Ratings

Detailed Rating

Stars 5
1256
Stars 4
775
Stars 3
248
Stars 2
25
Stars 1
27
9178e79556210d983e0e7cf6f0e4e5a6
30-Day Money-Back Guarantee

Includes

8 hours on-demand video
1 article
Full lifetime access
Access on mobile and TV
Certificate of Completion