eduCBA is globally recognized training firm, providing blend of instructor-led and online financial training programs in 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 Trainings 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.
</p>
Take your courses with you and learn anytime, anywhere.
Learn and practice real-world 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. What-if-analysis 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
The video explains about what are the differences in excel sheet of 2010 and 2007:- 1. Office and file button 2. Paste function
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
The video explains about the differences in excel sheet of 2007 and 2010:-
1. Conditional formatting 2. Equation editor
This Video Explain about following : 1. What is Paste Special Function? 2. Feature of Paste Special Function 3. How to Use Paste Special Function? |
This category contains Logical functions like: AND , FALSE , IF , NOT , OR , TRUE .
The video explains the following:- 1. If function 2. AND function 3.OR function
In this document various arithmetic function have been explained such as ABS, INT, Large, Small, Max, Min, Etc
This Video Explain about following Arithmetic Functions like : 1. ABS 2. INT 3. LARGE 4. MAX 5. MIN 6. SMALL 7. TRUNC
This Function Counts the number of numeric entries in a list. It will ignore blanks, text and errors.
This video explain the following functions:
1. COUNT
2. COUNTIF
3. COUNTA
4. COUNTBLANK
The video explains about various cell information functions like :- 1. ISBLANK 2. ISERROR 3. ISNONTEXT 4. ISNUMBER 5. ISTEXT 6. ISNA 7. ISREF |
Choose function picks from a list of options based upon an Index value given to by the user.
Through this video we are going to learn the following - 1. What is a CHOOSE Function? 2. How can one put condition and make proper use of Choose Function! |
VLOOKUP Function: Looks in the first column of an array and moves across the row to return the value of a cell
The video explains the following -
1. What is VLOOKUP Function?
2. How VLOOKUP is used to find the data from a large database?
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.
This Video explains the following - 1. What is HLOOKUP Function ? 2. What are its functionalities ? |
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.
This Video Explains the following - 1. What is MATCH Function in Excel ? 2. What is INDEX Function in Excel ? |
This Win Zip file contains all With and Without Solution files for practice. Please download them.
This video explain Database functions like : 1. DAVERAGE 2. DSUM 3. DCOUNT |
We will learn about:-
1. What is offset function?
2. Features of offset function?
We will learn about:- How can we use offset function and sum function together?
The video explains the following :- 1. How to do the forecasting using a mathematical formula through excel? 2. How to do the forecasting using the FORECAST function? |
To create a one-variable data table to perform what-if 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 one-variable 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.
This Video Explain about What IF Analysis i.e. Data Tables. We are going to look at: 1. One Dimensional Data Tables 2. Usage of Dimensional Data Tables |
The video explains of the following :-
1. What is two dimensional data table?
2. How do we prepare two dimensional sensitivity analysis table?
The video explains of the following :- 1. What is a Solver? 2. How can we use solver option to make calculations easy? |
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?
The Video Explains of the Following - 1. What is an Array Function? 2. How to use and apply Array Function in Excel? 3. What are the benefit of using Array Function In Excel? |
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.
The video explains the following - 1. What is TRANSPOSE Function? 2. How to use and apply TRANSPOSE function in Excel? 3. What are shortcut keys to use Transpose Function In Excel? |
The Video explains the following -
1. What is FREQUENCY function?
2. How to use and apply frequency function in excel?
The video explains how can we use different text & string functions like :- 1. Proper 2. Upper 3. Lower 4. Left 5. Right 6. Mid |
The video explains how we use text & string functions like :- 1. Find 2. Clean 3. Rept 4. Concatenate |
The video explains the following in detail :-
1. What is pivot table?
2. Features of the pivot table is explained in detail.
3. Uses of those features to make data presentation more effectively.
The video explains the following : 1. How to create a pivot chart based on an existing pivot table in a worksheet? 2. How to navigate different option of pivot chart in excel. 3. Different formatting Styles of Pivot Chart in Excel. |
The video explains the following: 1. How to create a Pivot chart based on an existing pivot table in a worksheet? 2. How to navigate different options of Pivot chart in excel? 3. Different Formatting style of Pivot chart in excel. |
The video explains the following : 1. What is Name Range? 2. Feature of Name range to cell |
The video explain followings : 1. How to give names to dynamic ranges? 2. Purpose of dynamic ranges 3. How to use offset function in excel? |
The video explains how can do an audit your worksheet formulas using -
1. Trace Precedents.
2. Trace Dependents.
3. Remove Arrows.
This video explains the following :
1. What is Watch Window?
2. How to use Watch Window in excel?
The video explains the following :- 1. What is Group Boxes and Options Button? 2. How can one insert a Group Box and Options Button in an excel sheet? 3. Use of Group Box and Options Button. |
The video explains the following :- 1. What is check box? 2. How to insert a check box in an excel sheet? 3. How to put conditions and make proper use of check box? |
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.
This video explains the following :- 1. What is Scroll Bar and Spinner? 2. How can one insert a Scroll Bar and Spinner in an excel sheet? 3. How can one put condition and make proper use of Scroll Bar and Spinners? |
The Video explains the following: 1. What is text to Column Function? 2. How to use Text to Column Function? |
The video explains the following:- 1. What is grouping tab? 2. How can we group tabs? 3. What are the effects of grouping tabs? 4. How can we ungroup the tab? |
This video explains the following:
1) SUBTOTAL function
2) Why SUBTOTAL function is useful?
This video explains the following:
1) What are Hyperlinks?
2) How to insert Hyperlinks?
This video explains about :- 1. What is data validation? 2. What are the different features of data validation? 3. How can you use data validation function in large data? |
The video explains the following :-
1. RAND() function.
2. RANDBETWEEN function
The video explains about :-1.How can one make changes and add different views
The video explains the following:- 1. What is the use of protecting a worksheet? 2. What are the different things that we can protect? 3. What are the effects of protecting a worksheet? 4. How can we unprotect the sheet? |
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?
This Document explains Advance Charting for Business analysts - Range Charts
This Video Explains the following : 1. Data table 2. Which is the most appropriate graph to show the data? 3. Overview of Range Chart. |
This video explains the following : 1. How to Create Range Chart? 2. Interpretation of Range Chart 3. Formatting of Range Chart. |
This Document explains Advance Charting for Business analysts - Area Range Charts
The video explains the following :- 1. How can we prepare the range chart? 2. How can we analyse the graph? |
The video explains the following :-1. How can we prepare the range chart 2. How can we analyse the graph?
Learn how to implement Funding Graph chart in Excel
The video explains about :- 1. What is funding graph? 2. How do we prepare funding graphs? 3. How can we analyse the funding graph? |
This Document explains Advance Charting for Business analysts - Two Axis Graph
The video explains about :- 1. What is two axis graph? 2. How do we prepare two axis graphs? 3. How can we analyse the two axis graph? |
The video explains the following:- 1. What is scenario graph ? 2. What are the uses of scenario graph? |
The video explains the following:- 1. How do we prepare scenario graph? 2. How do we analyse this kind of graph? |
This Video explains:- 1. How to add average line to column chart or bar chart? 2. How to draw average line in excel 2010? |
This video explains:- 1. Steps to create bar to pie chart 2. Requirements of these charts while presenting cases and its use. |
This explains all about combo charts, how to create combo charts, use of various types of charts in combo charts.e.g.Area charts. |
The video explains the following:- 1. What are Histograms? 2. How to install Data Analysis Tool pack? 3. How to create Histograms? |
The video explains about - 1. How to create invert negative chart? 2.How can one make the changes in color of invert negative chart? |
The video explains the following:- 1.What are Scrollbars? 2. Why they are required? 3.How Scrolling charts can be made? |
The video explains the following:- 1. Making X-axis and Y-axis using the OFFSET function. 2.Use of Name Function. 3. Inserting the line chart using the Name range |
The course was good but could have gone into more detail surrounding Macros
This course on advanced excel made me confident in excel. Now, I have started working efficiently in excel related office job. Thanks
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
the teaching is so good and easy to follow..thanks a lot
many new-found tricks that i'll be able to implement immediately.