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>
CFA Institute, USA has approved this Microsoft Excel Training program, offered by Corporate Bridge, for 3 CE credit hours. If you are a CFA Institute member, CE credit for your participation in this Microsoft Excel Training program will be automatically recorded in your CE tracking tool.
This is a comprehensive course on Microsoft Excel 2010. This training program on Microsoft Excel 2010 starts with the basics and on through the advanced features. With over 100 lectures, approximately 11 hours of Videos, 150+ worksheets, quizzes, Subtitles etc. edu CBA helps both the beginner and advanced user visualize what they are learning with step-by-step instruction from a Microsoft Excel Professional. Watch as the instructor performs progressive operations in each video starting with the Basics of Worksheets. Then moving onto Formatting, Formulas, Illustrations and Charts, Printing, HLOOKUP, VLOOKUP, Array, Solver, database, forecast, goal seek and many more advanced functions. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Take this course to learn all about Microsoft Excel 2010 and be awesome in Excel 2010.
Note: Microsoft Excel 2010: A Comprehensive Program Advanced (this course) consists of both Microsoft Excel 2010 Beginner and Microsoft Excel 2010 Advanced. If you have taken this course, No need to take Beginner and Advanced Courses separately.
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 basic and advanced
Be a part of the learning community onFacebook orTwitter
You may also find awesome resources at our Excel blog
The
video explains 1.Surfing an excel worksheet 2.How to use HELP in MS Excel |
The video explains :-1.Starting excel software.2. Familiarity with excel interface.3.Ribbons 4.Quick Access toolbar.5.Surfing an excel worksheet 6.Help |
XYZ Company Basic Excel Case Study
The video shows different ways of poulating the large datain excel from word document
This
video explains us 1) how to format tables 2) formatting text using excel tools |
The video explains in detail of the following:-1. About Conditional formating.2. Different ways to do conditional formating on a given set of data 3.how can one give different colors to highlight the data required. |
The video explains in detail of the following :-1. how can one use if function. 2. what data actually needs to be inserted in IF function to get the right calculation 3. How iF function has made the calculation easy |
This
video explains of the following 1. COUNTIF Function 2. When to use COUNTIF Function |
This
video explains of the following 1. SUMIF Function 2. When to use SUMIF Function |
This video explains of the following 1. what is filter option 2. How to insert the filter option.3. In large data how can one make work easy by using filter option |
This
video explains of the following 1. How to use Table formats 2. Learn different ways to Present your data 2) Wrap text format. |
The video explains in the following :-1. The concept of Increase Indent function. 2. Different ways of formatting a Charts and Graphs. |
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 not avaialble in excel sheet 2010:- 1. Sparklines 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 |
The video explains of the following:- 1. If function 2. AND function 3.OR function |
Logical Functions Quiz - without solutions
Logical Functions Quiz - with solutions
This Video Explain about following Arithmatic Functions Such as : 1. ABS 2. INT 3. LARGE 4. MAX 5. MIN 6. SMALL 7. TRUNC |
This video explain the following functions 1. COUNT 2. COUNTIF 3. COUNTA 4. COUNTBLANK |
The video explains about various cell information function like :- 1. ISBLANK 2. ISERROR 3.ISNONTEXT 4.ISNUMBER 5. ISTEXT 6.ISNA 7) ISREF |
Through this video we are going to learn the following - 1. What is CHOOSE Function. 2. How can one put condition and make proper use of Choose Function |
The
video explains the following - 1. What is VLOOKUP Function 2.How Vlookup is used to find the data from a large database |
This Video Explain the following - 1. What is HLOOKUP Function in Excel 2. What are its functionalities |
This Video Explains the following - 1. What is MATCH Function in Excel 2. What is INDEX Function in Excel |
This video explain Database functions - 1. DAVERAGE 2. DSUM 3. DCOUNT |
The video explains the following :-How to do the forecasting using a mathematical formula through excel 2. how to do the forecasting using the FORECAST function |
This Video Explain about What IF Analysis i.e. Data Tables 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 solver 2. How do 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 of The Following - 1. The array function which wil help us to save time 2. Difference Between Selecting Row Arrays, Column Arrays and Table Arrays. |
The Video Explains Array Functions of the following - 1. What is TRANSPOSE Function. 2. How to use and apply TRANSPOSE function in Excel. 3. What are Shortcut key 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 in detail of the following :- 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 followings: 1. create a pivot chart based on an existing pivot table in a worksheet 2. Navigating different option of pivot chart in Excel. 3. Different formating Style of Pivot Chart in Excel. |
The video explains followings: 1.create a Slicer based on an exisiting pivot table in a worksheet. 2. Navigating different option of slicer in Excel 3. Different Formatting style of Slicer in Excel |
The video explain followings : 1. how to give names to dynamic ranges 2. Purpose of dynamic ranges 3. how to use off set Function in Excel |
The video explains followings : 1. What is Name Range. 2. Feature of Name range to cell. |
The video explains how can do an audit of your worksheet formulas using - 1. Trace Precedents. 2. Trace Dependents. And 3. Remove Arrows. |
This Video Explains about Following : 1. What is Watch Window. 2. how do we use Watch Window In Excel. |
The video explains of 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 of 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 |
The video explains of 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 explain followings: 1. What is text to Column Function. 2. How to use Text to Column Function. |
The video explains of the following:- 1. what is grouping tab.2.how can one group tabs3. what are the effects of grouping tabs .4.How can we ungroup the tab. |
This
video explains about the 1) SUBTOTAL function 2) Why SUBTOTAL funciton is useful |
This Video Explain about following : 1. What is Hyperlinks 2. What is create Hyperlink In Excel |
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 about the following :-1. RAND() function. 2. RANDBETWEEN function |
The video explains about the following :-1. RAND() function. 2. RANDBETWEEN function |
The video explains of the following:- 1. What are the uses 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 Video Explains about Following : 1. Explains the data table .2.Which is the most appropriate graph to show the data 3. Overview of Range Chart. |
This Video Explain about Following : 1.How to Create Range Chart 2. Interpetation of Range Chart 3. Formatting of Range Chart. |
The video explains the following 1) What are the different charts and graphs through which we can show large tabular data .2). Which is the most appropriate Range Chart to show the data |
The video explains the following :-1. How can we prepare the range chart 2. How can we analyse the graph |
The video explains about :- What is funding graph 2. how do we prepare funding graphs 3. How can we analyse the funding graph |
The video explains about :- 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:-What is scenario graph 2. what are the uses of scenario graph |
The video explains the following:-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. The steps to create bar to pie chart 2. requirement of these charts while presenting cases and use of this bar to pie chart in such cases. |
This explains all about combo charts,and also explain how to create combo charts.also use various types of charts in combo charts.e.g.Area charts. |
The video explains of the following:- 1. What are Histograms? 2. How to install Data Analysis Toolpack? 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 of the following:- 1.What are Scrollbars? 2. Why they are required? 3.How Scrolling charts can be made? |
The video explains of 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 |
I'm really glad that I signed up for this course. The course was very well organized and the instructor was very clear in his speech. The thing that impressed me most was the depth of this course. Took almost a month for me, but it was worth it. I would definitely recommend this course to anyone.
The only setback here is the forum, which seems to me like a barren wasteland. I didn't receive a single reply to any of my queries and I didn't see many replies on other posts too. Still, 5 stars from me!
Pleasantly surprised! nicely built great course. Complex functions are dealt with easy to understand explanation. No hype, just to the point course. Go for it.
Very simple to understand. Great style of explanation. Superb!!
I enjoyed the ease of understanding. I highly recommend the course to anyone looking to learn the MS Excel 2010.
Easy to comprehend. The lectures are logically connected, tremendously easy but equally impactful. I have seen a few courses in Excel. This one is just the best I have come across.
Join thousands of passionate instructors who are building their brand, and making money, by teaching on Udemy.
Learn MoreUdemy for your team. Access 400 courses for $29/mo. Create your own private courses. Bring corporate learning to life. Free Trial
Learn More