Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice realworld skills and achieve your goals.
This advanced online course on Microsoft Excel 2010 is not for beginners. This awesome course is ideal for those seeking to enhance their Excel 2010 knowledge, it even goes deeper into the features and functions of the powerful excel spreadsheet. The course is perfect for those already having a good knowledge of Microsoft Excel 2010 basics. In this online course, you will learn advanced features. You will learn about performing lookups with HLOOKUP and VLOOKUP. 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 author. The course starts with an explanation to show the differences between excel 2007 and excel 2010. It begins with useful functions like Paste Special, Logical, countif goes on to explain advanced features like HLOOKUP, VLOOKUP, Match, Offset, Forecast etc. Whatifanalysis in one dimension, two dimension table, solver, Goal seek have been done beautifully taking examples. Pivot Tables in details, range, excel tools, advanced charts have been dealt beautifully in details. The objective of this online program is to make you awesome in Advanced Excel 2010.
This course is best viewed on HD 720p. The same option is given in Udemy Video Screen Bottom Right.
Note: Microsoft Excel 2010 Advanced (this course) is also a part of Excel  Excel Course (Basic and Advanced). If you are looking for both Beginner and Advanced Excel 2010, Please go for Comprehensive program.
Instructor: Mr. Dheeraj V. (CFA, FRM, IIML, IITD)
Dheeraj, A financial wizard, His relentless pursuit of knowledge and financial acumen has made him one of the most sought after individual in the training circles. He was associated with J.P Morgan Chase Equity Research Group as an analyst and later moved to CLSA India (Asia’s #1 Broking Firm) in the field of Equity Research and Investment Banking domain.
Website:  edu CBA
Course Page – excel training 2010 advanced
Be a part of the learning community onFacebook orTwitter
You may also find awesome resources at our Excel blog
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
Section 1: Introduction to the Course  

Lecture 1  02:54  
This introduction lecture to the course gives you the details to be covered in the course.  
Section 2: Key Difference MS Excel 2007 vs 2010  
Lecture 2  Text  
All the working Files are in this Lecture. Please download these first. Please note that In most of the lectures, you have working files with solution and without solution. Download these files and do as the trainer does in the without solution files for a better understanding.  
Lecture 3  08:18  
The video explains about what are the differences in excel sheet of 2010 and 2007: 1. Office and file button 2. Paste function 

Quiz 1 
Office Button and Paste Function

1 question  
Lecture 4  06:43  
The video explains about what are the new options available in excel sheet of 2007 and excel sheet 2010: 1. Sparkline 2.Custom Ribbon 3. Screenshot 

Quiz 2 
Sparklines, Custom Ribbons and Screenshots

3 questions  
Lecture 5  05:54  
The video explains about the differences in excel sheet of 2007 and 2010: 1. Conditional formatting 2. Equation editor 

Quiz 3 
Conditional Formatting and Equation Editor

1 question  
Section 3: Useful Excel Functions  
Lecture 6  02:08  


Quiz 4 
Paste Special

1 question  
Lecture 7  2 pages  
This category contains Logical functions like: AND , FALSE , IF , NOT , OR , TRUE . 

Lecture 8  05:21  
The video explains the following: 1. If function 2. AND function 3.OR function 

Quiz 5 
Logical functions  IF AND OR

2 questions  
Lecture 9  4 pages  
In this document various arithmetic function have been explained such as ABS, INT, Large, Small, Max, Min, Etc 

Lecture 10  08:28  
This Video Explain about following Arithmetic Functions like : 1. ABS 2. INT 3. LARGE 4. MAX 5. MIN 6. SMALL 7. TRUNC 

Quiz 6 
Arithmetic functions MAX MIN ABS etc

2 questions  
Lecture 11  3 pages  
This Function Counts the number of numeric entries in a list. It will ignore blanks, text and errors. 

Lecture 12  05:57  
This video explain the following functions: 1. COUNT 2. COUNTIF 3. COUNTA 4. COUNTBLANK 

Quiz 7 
COUNT COUNTIF COUNTA COUNTBLANK

2 questions  
Lecture 13  08:42  


Quiz 8 
Cell Information  ISERROR ISBLANK etc

1 question  
Section 4: Data Functions  
Lecture 14  1 page  
Choose function picks from a list of options based upon an Index value given to by the user. 

Lecture 15  03:21  


Quiz 9 
CHOOSE Function

1 question  
Lecture 16  1 page  
VLOOKUP Function: Looks in the first column of an array and moves across the row to return the value of a cell 

Lecture 17  08:31  
The video explains the following  1. What is VLOOKUP Function? 2. How VLOOKUP is used to find the data from a large database? 

Quiz 10 
VLOOKUP Function

2 questions  
Lecture 18  1 page  
Hlookup function scans across the column headings at the top of a table to find a specified item. When the item is found, it then scans down the column to pick a cell entry. 

Lecture 19  03:24  


Quiz 11 
HLOOKUP Function

1 question  
Lecture 20  2 pages  
This function looks up for the values in a reference or array. It can be used with text and numbers. It can look for an exact match or an approximate match. 

Lecture 21  04:16  


Quiz 12 
MATCH & INDEX

1 question  
Lecture 22  3 pages  
This Win Zip file contains all With and Without Solution files for practice. Please download them. 

Lecture 23  07:42  


Quiz 13 
Database functions  DSUM DAVERAGE DCOUNT

1 question  
Lecture 24  06:14  
We will learn about: 1. What is offset function? 2. Features of offset function? 

Lecture 25  04:45  
We will learn about: How can we use offset function and sum function together? 

Lecture 26  04:41  


Quiz 14 
FORECAST Function

2 questions  
Section 5: WhatIf Analysis  
Lecture 27  2 pages  
To create a onevariable data table to perform whatif analysis in Excel 2010, you enter a series of input values either across columns of a single row or down the rows of a single column. The formulas in a onevariable data table refer to only one input cell: a row input cell for input values entered across a row or a column input cell for input values entered down a column. 

Lecture 28  05:42  


Quiz 15 
One Dimensional Data Tables

3 questions  
Lecture 29  03:39  
The video explains of the following : 1. What is two dimensional data table? 2. How do we prepare two dimensional sensitivity analysis table? 

Quiz 16 
Two dimensional Data Tables

1 question  
Lecture 30  06:17  


Quiz 17 
Solver

3 questions  
Lecture 31  2 pages  
Excel's Goal Seek feature allows you to alter the data used in a formula in order to find out what the results will be. The different results can then be compared to find out which one best suits your requirements.  
Lecture 32  06:03  
The Video explains the following: 1. What is Goal Seek Function? 2. Use of Goal Seek Function? 3. How to find the value of one cell by adjusting another cell using Goal Seek? 

Quiz 18 
Goal Seek

1 question  
Section 6: Arrays  
Lecture 33  05:56  


Lecture 34  03:40  
The Video Explains the following  1. How array function which will help us to save time? 2. Difference between selecting Row Arrays, Column Arrays and Table Arrays. 

Quiz 19 
Array Function  Row and Columns

1 question  
Lecture 35  10:15  


Quiz 20 
Array Function  TRANSPOSE

1 question  
Lecture 36  07:47  
The Video explains the following  1. What is FREQUENCY function? 2. How to use and apply frequency function in excel? 

Quiz 21 
Array Function  FREQUENCY

2 questions  
Section 7: Functions for working with Text  
Lecture 37  05:23  


Quiz 22 
PROPER UPPER LOWER LEFT RIGHT MID

1 question  
Lecture 38  09:12  


Quiz 23 
FIND CLEAN REPT CONCATENATE

1 question  
Section 8: Pivot Tables  
Lecture 39  11:53  
The video explains the following in detail : 2. Features of the pivot table is explained in detail. 3. Uses of those features to make data presentation more effectively. 

Quiz 24 
Pivot Tables

4 questions  
Lecture 40  03:06  


Quiz 25 
Pivot Table Filter  Slicer

2 questions  
Lecture 41  05:53  


Quiz 26 
Pivot Charts

2 questions  
Lecture 42  04:57  


Quiz 27 
Naming a Cell and a Range

1 question  
Lecture 43  05:25  


Quiz 28 
Naming Dynamic Ranges

1 question  
Section 9: Auditing and Trouble Shooting formulas  
Lecture 44  07:58  
The video explains how can do an audit your worksheet formulas using  1. Trace Precedents. 2. Trace Dependents. 3. Remove Arrows. 

Quiz 29 
Auditing Toolbar

2 questions  
Lecture 45  05:01  
This video explains the following : 1. What is Watch Window? 2. How to use Watch Window in excel? 

Quiz 30 
Watch Window

1 question  
Section 10: Form Controls  
Lecture 46  05:08  


Quiz 31 
Group Boxes and Options Button

1 question  
Lecture 47  03:06  


Quiz 32 
Check Boxes

2 questions  
Lecture 48  04:10  
This video explains the following : 1. What is list and combo box? 2. How can one insert a list and combo box in an excel sheet? 3. Use of list and combo box. 

Quiz 33 
List Boxes and Combo Boxes

2 questions  
Lecture 49  02:56  


Quiz 34 
Scroll Bar and Spinners

2 questions  
Section 11: Important Excel Tools  
Lecture 50  08:18  


Quiz 35 
Text to Columns

2 questions  
Lecture 51  06:56  


Quiz 36 
Grouping Tabs

1 question  
Lecture 52  09:31  
This video explains the following: 1) SUBTOTAL function 2) Why SUBTOTAL function is useful? 

Quiz 37 
SUBTOTAL Function

1 question  
Lecture 53  04:30  
This video explains the following: 1) What are Hyperlinks? 2) How to insert Hyperlinks? 

Quiz 38 
Hyperlinks

2 questions  
Lecture 54  07:27  


Quiz 39 
Data Validation

1 question  
Lecture 55  05:47  
The video explains the following : 

Quiz 40 
Random Numbers

1 question  
Lecture 56  04:40  
The video explains about :1.How can one make changes and add different views 

Quiz 41 
Custom View

1 question  
Lecture 57  08:13  


Quiz 42 
Protecting  Worksheet and Workbook

3 questions  
Section 12: Advanced Charts  
Lecture 58  08:16  
The Video explains following: 1. What is Excel Sparkline? 2. How it is use of Sparkline function in Excel 2010? 3.What is the advantage of Sparkline function in Excel? 

Quiz 43 
Excel 2010 Sparklines

1 question  
Lecture 59  1 page  
This Document explains Advance Charting for Business analysts  Range Charts 

Lecture 60  04:42  


Quiz 44 
Range Charts Type 1

1 question  
Lecture 61  04:32  


Quiz 45 
Range Charts Type 1 Continued

1 question  
Lecture 62  1 page  
This Document explains Advance Charting for Business analysts  Area Range Charts 

Lecture 63  04:42  


Quiz 46 
Range Charts Area Type 2

2 questions  
Lecture 64  06:30  
The video explains the following :1. How can we prepare the range chart 2. How can we analyse the graph? 

Quiz 47 
Range Charts Area Type 2 Continued

1 question  
Lecture 65  1 page  
Learn how to implement Funding Graph chart in Excel 

Lecture 66  04:18  


Quiz 48 
Funding Graph

1 question  
Lecture 67  1 page  
This Document explains Advance Charting for Business analysts  Two Axis Graph 

Lecture 68  06:33  


Quiz 49 
Two Axis Graphs

1 question  
Lecture 69  1 page  
To set up a chart that is automatically updated as you add new information to an existing chart range in Microsoft Excel, create defined names that dynamically change as you add or remove data.  
Lecture 70  03:40  


Lecture 71  06:28  


Quiz 50 
Scenario Graphs Continued

1 question  
Lecture 72  03:54  


Quiz 51 
Average Line

1 question  
Lecture 73  05:20  


Quiz 52 
Bar to Pie Chart

1 question  
Lecture 74  03:02  


Quiz 53 
Combo Charts

1 question  
Lecture 75  07:55  


Quiz 54 
Creating Histograms

2 questions  
Lecture 76  06:37  


Quiz 55 
Invert Negatives

1 question  
Lecture 77  05:45  


Quiz 56 
Scrolling Chart

2 questions  
Lecture 78  07:30  


Quiz 57 
Scrolling Chart Continued

1 question  
Section 13: CONCLUSION  
Lecture 79  03:00  
The conclusion video summarizes the learning we had from this course. 
eduCBA is globally recognized training firm, providing blend of instructorled and online Investment Banking and Other Financial training programs such as Excel, Advanced Excel, VBAs, Macros, Equity Research, Wealth Management, Technical Analysis, Investment Banking, Private Equity, Fundamental Analysis, Investment Research, Credit Research etc and preparatory courses like CFA Level I & II and FRM Level I & II, Campus Placement Training for students in Finance domain etc.
eduCBA Online training Learning Management System provides access to high end excel videos, valuation tutorials, online tests, downloadable templates and models that are prepared by Research Analysts & Investment Bankers.
Hours of video content
Course Enrollments
Students