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>
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
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.
This video explains about the
1) SUBTOTAL function 2) Why SUBTOTAL funciton is useful
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 |
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.
Now I can use more appropriate tools instead of trying only basic tools. This course explains many of the excel actions that I use regularly use in a different manner. This course was everything I was hoping for. Walk through is thorough and at a pace that is easy to follow. I highly recommend this course. The best part of the course in 2007 and 2010 comparison. Even, at the very end they have given similar functions in excel 2007 as add-ons which I liked. You easily see how differently we use 2007 and 2010 for different functions.
Good job, good course, recommended for excel enthusiasts
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