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 amazing Excel course provides you with in depth knowledge of excel and makes you Zero to hero.
This is a comprehensive course on Microsoft Excel 2010. This Excel training program on Microsoft Excel 2010 starts with the basics and on through the advanced features. With over 100 excel video 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 stepbystep 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 easytouse 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.
Microsoft Excel is used in almost all fields like finance, statistics, marketing, engineering, human resources especially for the businesses which deal with large amounts of data (numbers, statistics). What we learn in academics is very theoretical aspects of business, but in practical life we want application based learning. Our Excel course is designed in such manner that it will give you practical approach and any person from any background can go ahead with it. Through this course and the practice material you will gain proficiency in Excel. Thus having detailed knowledge of Excel will be beneficial to you, whether you are a student, fresher or an employee.
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.
This Excel course provides in depth knowledge about following:
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  

1  05:50  
This video lecture gives you the details of the skill sets we would be covering during this whole course.  
Section 2: EXCEL 2010: GETTING STARTED  
2  Text  
All the downloadable files, excel templates for Basic Excel can be found in this lecture. Please download all of them and start doing in excel sheet along with the trainer.  
3  Text  
All the downloadable files, excel templates for Advanced Excel can be found in this lecture. Please download all of them and start doing in excel sheet along with the trainer. 

4  10:12  


5 
Getting Started  Ribbons & Quick Access Toolbar

2 questions  
6  11:08  


7 
Getting Started  Surfing Excel & HELP Function

1 question  
Section 3: CASE STUDY  
8  1 page  
XYZ Company Basic Excel Case Study 

9  02:00  
This video builds on a case which will help you to learn data entry in excel in an easy manner 

10 
Excel Case Study

1 question  
11  08:56  
This video explains : 1. How to write data in excel. 2. What are the different shortcuts in excel which will help to enter data easily. 3. The different number formating available in excel 

12 
Data Entry in Excel

3 questions  
13  07:42  
The video shows different ways of poulating the large data in excel from a word document 

14 
Populating the Case Study in Excel

1 question  
Section 4: CALCULATIONS  
15  07:29  
The video explains how to carry out calculations in excel. 

16 
Calculations  Addition Subtract Multiply Division

2 questions  
Section 5: FORMULAS  
17  09:58  
The video shows how can one calculate sum function, maximum function, minmum function and average function using different excel function 

18 
Formulas  SUM MAX MIN AVERAGE

3 questions  
Section 6: FORMATTING  
19  08:30  
This video explains :1. How to use different formatting? 2. How can one copy paste the format of one cell to other? 

20 
Formatting  Number Formats

3 questions  
21  07:37  


22 
Formatting  Table Formats

2 questions  
Section 7: UPDATING A CALCULATION  
23  02:41  
This video shows 1 .how can one add one more detail in the existing data 2. the effects of it on the calculation 

24 
Updating a Calculation

2 questions  
Section 8: PERCENTAGES & ABSOLUTE REFERENCES  
25  09:19  
The video explains:1. Normal referencing and absolute referencing 2.Its use in excel 

26 
Percentages and Absolute References

1 question  
Section 9: CONDITIONAL FORMATTING  
27  08:28  


28 
Conditional Formatting

2 questions  
Section 10: IF FUNCTION  
29  09:58  


30 
IF Function

1 question  
Section 11: COUNTIF AND SUMIF  
31  04:18  


32 
COUNTIF Function

2 questions  
33  08:22  


34 
SUMIF Function

2 questions  
Section 12: CHARTS AND GRAPHS  
35  08:32  
The video explains :1. How to Create Charts and Graphs in Excel? 2. How to do Formatting of those Charts and Graph? 

36 
Creating Charts and Graphs

2 questions  
37  11:24  
The Video Explains : 1. How to Create Pie Charts? 2. How to do Formatting to Pie Charts? 3. What are the different type of Charts? 

38 
Create Pie Charts

2 questions  
Section 13: SORTS AND FILTERS  
39  04:54  
This video explains of the following 1. What is sort option? 2. How to insert the sort option? 3. In large data how can one make work easy by using sort option? 

40 
Sorts

1 question  
41  04:50  


42 
Filter

1 question  
Section 14: FREEZE AND SPLIT  
43  06:21  
The video explains of the following:1. How can one freeze the rows and columns? 2.How can one split the rows and columns? 

Section 15: PRESENTATION  
44  05:42  


45 
Presentation  Table Formats

2 questions  
46  05:40  


47 
Presentation  Indents and Formatting Charts

3 questions  
Section 16: PRINT  
48  07:29  
This video explains the following:1. Print option.2. Features of Print option 

49 
Printing the Worksheet

2 questions  
50  06:53  
This video explains the following: 1.How to fit the entire data in a worksheet for print? 2. How to insert header and footer in an excel worksheet? 

51 
Printing  Headers and Titles

1 question  
Section 17: SHORTCUTS  
52  14:48  
The video explains : 1.How to Use Formatting Shortcut? 2.How to Navigate Excel worksheet? 3. How to use Workbook basic shortcut? 

53 
Shortcuts  Formatting and Navigation

1 question  
54  10:46  
The video explains the following shortcuts: 1.Selection 2.Working with Data 3.Formula shortcuts 

55 
Shortcuts  Selection, Data and Formula

1 question  
Section 18: COMMON ERRORS  
56  04:47  
The video explains: 1.Why does the error occur in excel? 2 . Which error occurs in respect to a specific mistake? 

57 
Common Errors

2 questions  
Section 19: KEY DIFFERENCE MS EXCEL 2007 VS 2010  
58  08:18  


59 
Office Button and Paste Function

1 question  
60  06:43  


61 
Sparklines, Custom Ribbons and Screenshots

3 questions  
62  05:54  


63 
Conditional Formatting and Equation Editor

1 question  
Section 20: USEFUL EXCEL FUNCTIONS  
64  02:08  


65 
Paste Special

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

67  05:21  


68  Text  
Logical Functions Quiz  without solutions 

69  Text  
Logical Functions Quiz  with solutions 

70 
Logical functions IF AND OR

1 question  
71  4 pages  
In this document various arithmetic function have been explained, such as ABS, INT, Large, Small, Max, Min, Etc 

72  08:28  


73 
Arithmetic functions MAX MIN ABS etc

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

75  05:57  


76 
COUNT COUNTIF COUNTA COUNTBLANK

2 questions  
77  08:42  


78 
Cell Information ISERROR ISBLANK etc

1 question  
Section 21: DATA FUNCTIONS  
79  1 page  
Choose function picks from a list of options based upon an Index value given to by the user. 

80  03:21  


81 
CHOOSE Function

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

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


84 
VLOOKUP Function

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

86  03:24  


87 
HLOOKUP Function

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

89  04:16  


90 
MATCH INDEX

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

92  07:42  


93 
Database functions DSUM DAVERAGE DCOUNT

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

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

96  04:41  


97 
FORECAST Function

2 questions  
Section 22: WHATIF ANALYSIS  
98  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. 

99  05:42  


100 
One Dimensional Data Tables

3 questions  
101  03:39  


102 
Two dimensional Data Tables

1 question  
103  06:17  


104 
Solver

3 questions  
105  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. 

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


107 
Goal Seek

1 question  
Section 23: ARRAYS  
108  05:56  


109 
Array Function Introduction

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


111 
Array Function Row and Columns

1 question  
112  10:15  


113 
Array Function TRANSPOSE

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


115 
Array Function FREQUENCY

1 question  
Section 24: FUNCTIONS FOR WORKING WITH TEXT  
116  05:23  


117 
PROPER UPPER LOWER LEFT RIGHT MID

1 question  
118  09:12  


119 
FIND CLEAN REPT CONCATENATE

1 question  
Section 25: PIVOT TABLES IN DEPTH  
120  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. 

121 
Pivot Tables

4 questions  
122  03:06  


123 
Pivot Table Filter Slicer

2 questions  
124  05:53  


125 
Pivot Charts

2 questions  
126  05:25  


127 
Naming Dynamic Ranges

1 question  
128  04:57  


129 
Naming a Cell and a Range

1 question  
Section 26: AUDITING AND TROUBLE SHOOTING FORMULAS  
130  07:58  
The video explains how can do an audit your worksheet formulas using  1. Trace Precedents. 2. Trace Dependents. 3. Remove Arrows. 

131 
Auditing Toolbar

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

133 
Watch Window

1 question  
Section 27: FORM CONTROLS  
134  05:08  


135 
Group Boxes and Options Button

1 question  
136  03:06  


137 
Check Boxes

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


139 
List Boxes and Combo Boxes

2 questions  
140  02:56  


141 
Scroll Bar and Spinners

1 question  
Section 28: IMPORTANT EXCEL TOOLS  
142  08:18  


143 
Text to Columns

1 question  
144  06:56  


145 
Grouping Tabs

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

147 
SUBTOTAL Function

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


149 
Hyperlinks

1 question  
150  07:27  


151 
Data Validation

1 question  
152  05:47  


153 
Random Numbers

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


155 
Custom View

1 question  
156  08:13  


157 
Protecting Worksheet and Workbook

3 questions  
Section 29: ADVANCED CHARTS  
158  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? 

159 
Excel 2010 Sparklines

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

161  04:42  


162 
Range Charts Type 1

1 question  
163  04:32  


164 
Range Charts Type 1 Continued

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

166  04:40  


167 
Range Charts Area Type 2

1 question  
168  06:30  


169 
Range Charts Area Type 2 Continued

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

171  04:18  


172 
Funding Graph

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

174  06:30  


175 
Two Axis Graphs

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

177 
Scenario Graphs Continued

1 question  
178 
Average Line

1 question  
179 
Bar to Pie chart

1 question  
180 
Combo Charts

1 question  
181 
Creating Histogram

1 question  
182 
Invert Negatives

1 question  
183 
Scrolling Chart

2 questions  
184 
Scrolling Chart Continued

1 question 
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
fine
everything explained, no too long and too short explanations; TONS of material to work with to redo the work in the video; nice tips for people with a corporate background (fancy charts); microphone quality could be improved..
great course
Learned so much. Thank you
yes, I am satisfied, the course is good for beginners
Nice lectures & materials which is used during whole lecture.
would like a certificate after completion.
Dynamic as it is
Excellent course with very simple & good communication that makes understanding even more easier. Thumbs Up!