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  

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  
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.  
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 

4 
Office Button and Paste Function

1 question  
5  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 

6 
Sparklines, Custom Ribbons and Screenshots

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

8 
Conditional Formatting and Equation Editor

1 question  
Section 3: Useful Excel Functions  
9  02:08  


10 
Paste Special

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

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

13 
Logical functions  IF AND OR

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

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

16 
Arithmetic functions MAX MIN ABS etc

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

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

19 
COUNT COUNTIF COUNTA COUNTBLANK

2 questions  
20  08:42  


21 
Cell Information  ISERROR ISBLANK etc

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

23  03:21  


24 
CHOOSE Function

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

26  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? 

27 
VLOOKUP Function

2 questions  
28  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. 

29  03:24  


30 
HLOOKUP Function

1 question  
31  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. 

32  04:16  


33 
MATCH & INDEX

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

35  07:42  


36 
Database functions  DSUM DAVERAGE DCOUNT

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

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

39  04:41  


40 
FORECAST Function

2 questions  
Section 5: WhatIf Analysis  
41  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. 

42  05:42  


43 
One Dimensional Data Tables

3 questions  
44  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? 

45 
Two dimensional Data Tables

1 question  
46  06:17  


47 
Solver

3 questions  
48  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.  
49  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? 

50 
Goal Seek

1 question  
Section 6: Arrays  
51  05:56  


52  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. 

53 
Array Function  Row and Columns

1 question  
54  10:15  


55 
Array Function  TRANSPOSE

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

57 
Array Function  FREQUENCY

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


59 
PROPER UPPER LOWER LEFT RIGHT MID

1 question  
60  09:12  


61 
FIND CLEAN REPT CONCATENATE

1 question  
Section 8: Pivot Tables  
62  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. 

63 
Pivot Tables

4 questions  
64  03:06  


65 
Pivot Table Filter  Slicer

2 questions  
66  05:53  


67 
Pivot Charts

2 questions  
68  04:57  


69 
Naming a Cell and a Range

1 question  
70  05:25  


71 
Naming Dynamic Ranges

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

73 
Auditing Toolbar

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

75 
Watch Window

1 question  
Section 10: Form Controls  
76  05:08  


77 
Group Boxes and Options Button

1 question  
78  03:06  


79 
Check Boxes

2 questions  
80  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. 

81 
List Boxes and Combo Boxes

2 questions  
82  02:56  


83 
Scroll Bar and Spinners

2 questions  
Section 11: Important Excel Tools  
84  08:18  


85 
Text to Columns

2 questions  
86  06:56  


87 
Grouping Tabs

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

89 
SUBTOTAL Function

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

91 
Hyperlinks

2 questions  
92  07:27  


93 
Data Validation

1 question  
94  05:47  
The video explains the following : 

95 
Random Numbers

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

97 
Custom View

1 question  
98  08:13  


99 
Protecting  Worksheet and Workbook

3 questions  
Section 12: Advanced Charts  
100  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? 

101 
Excel 2010 Sparklines

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

103  04:42  


104 
Range Charts Type 1

1 question  
105  04:32  


106 
Range Charts Type 1 Continued

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

108  04:42  


109 
Range Charts Area Type 2

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

111 
Range Charts Area Type 2 Continued

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

113  04:18  


114 
Funding Graph

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

116  06:33  


117 
Two Axis Graphs

1 question  
118  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.  
119  03:40  


120  06:28  


121 
Scenario Graphs Continued

1 question  
122  03:54  


123 
Average Line

1 question  
124  05:20  


125 
Bar to Pie Chart

1 question  
126  03:02  


127 
Combo Charts

1 question  
128  07:55  


129 
Creating Histograms

2 questions  
130  06:37  


131 
Invert Negatives

1 question  
132  05:45  


133 
Scrolling Chart

2 questions  
134  07:30  


135 
Scrolling Chart Continued

1 question  
Section 13: CONCLUSION  
136  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
Good Overall Course  Good for Database functions
The course was good but could have gone into more detail surrounding Macros
It has been great learning experience by means of huge number of interesting videos. i like the way different functions are being explained. Overall a nice course
This course on advanced excel made me confident in excel. Now, I have started working efficiently in excel related office job. Thanks
great lectures
the teaching is so good and easy to follow..thanks a lot
finally know how to fully use Excel after 15 yrs..
many newfound tricks that i'll be able to implement immediately.