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  

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

Lecture 4  10:12  


Quiz 1 
Getting Started  Ribbons & Quick Access Toolbar

2 questions  
Lecture 5  11:08  


Quiz 2 
Getting Started  Surfing Excel & HELP Function

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

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

Quiz 3 
Excel Case Study

1 question  
Lecture 8  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 

Quiz 4 
Data Entry in Excel

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

Quiz 5 
Populating the Case Study in Excel

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

Quiz 6 
Calculations  Addition Subtract Multiply Division

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

Quiz 7 
Formulas  SUM MAX MIN AVERAGE

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

Quiz 8 
Formatting  Number Formats

3 questions  
Lecture 13  07:37  


Quiz 9 
Formatting  Table Formats

2 questions  
Section 7: UPDATING A CALCULATION  
Lecture 14  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 

Quiz 10 
Updating a Calculation

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

Quiz 11 
Percentages and Absolute References

1 question  
Section 9: CONDITIONAL FORMATTING  
Lecture 16  08:28  


Quiz 12 
Conditional Formatting

2 questions  
Section 10: IF FUNCTION  
Lecture 17  09:58  


Quiz 13 
IF Function

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


Quiz 14 
COUNTIF Function

2 questions  
Lecture 19  08:22  


Quiz 15 
SUMIF Function

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

Quiz 16 
Creating Charts and Graphs

2 questions  
Lecture 21  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? 

Quiz 17 
Create Pie Charts

2 questions  
Section 13: SORTS AND FILTERS  
Lecture 22  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? 

Quiz 18 
Sorts

1 question  
Lecture 23  04:50  


Quiz 19 
Filter

1 question  
Section 14: FREEZE AND SPLIT  
Lecture 24  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  
Lecture 25  05:42  


Quiz 20 
Presentation  Table Formats

2 questions  
Lecture 26  05:40  


Quiz 21 
Presentation  Indents and Formatting Charts

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

Quiz 22 
Printing the Worksheet

2 questions  
Lecture 28  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? 

Quiz 23 
Printing  Headers and Titles

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

Quiz 24 
Shortcuts  Formatting and Navigation

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

Quiz 25 
Shortcuts  Selection, Data and Formula

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

Quiz 26 
Common Errors

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


Quiz 27 
Office Button and Paste Function

1 question  
Lecture 33  06:43  


Quiz 28 
Sparklines, Custom Ribbons and Screenshots

3 questions  
Lecture 34  05:54  


Quiz 29 
Conditional Formatting and Equation Editor

1 question  
Section 20: USEFUL EXCEL FUNCTIONS  
Lecture 35  02:08  


Quiz 30 
Paste Special

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

Lecture 37  05:21  


Lecture 38  Text  
Logical Functions Quiz  without solutions 

Lecture 39  Text  
Logical Functions Quiz  with solutions 

Quiz 31 
Logical functions IF AND OR

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

Lecture 41  08:28  


Quiz 32 
Arithmetic functions MAX MIN ABS etc

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

Lecture 43  05:57  


Quiz 33 
COUNT COUNTIF COUNTA COUNTBLANK

2 questions  
Lecture 44  08:42  


Quiz 34 
Cell Information ISERROR ISBLANK etc

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

Lecture 46  03:21  


Quiz 35 
CHOOSE Function

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

Lecture 48  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?


Quiz 36 
VLOOKUP Function

2 questions  
Lecture 49  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. 

Lecture 50  03:24  


Quiz 37 
HLOOKUP Function

1 question  
Lecture 51  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. 

Lecture 52  04:16  


Quiz 38 
MATCH INDEX

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

Lecture 54  07:42  


Quiz 39 
Database functions DSUM DAVERAGE DCOUNT

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

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

Lecture 57  04:41  


Quiz 40 
FORECAST Function

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

Lecture 59  05:42  


Quiz 41 
One Dimensional Data Tables

3 questions  
Lecture 60  03:39  


Quiz 42 
Two dimensional Data Tables

1 question  
Lecture 61  06:17  


Quiz 43 
Solver

3 questions  
Lecture 62  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. 

Lecture 63  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?


Quiz 44 
Goal Seek

1 question  
Section 23: ARRAYS  
Lecture 64  05:56  


Quiz 45 
Array Function Introduction

1 question  
Lecture 65  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.


Quiz 46 
Array Function Row and Columns

1 question  
Lecture 66  10:15  


Quiz 47 
Array Function TRANSPOSE

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


Quiz 48 
Array Function FREQUENCY

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


Quiz 49 
PROPER UPPER LOWER LEFT RIGHT MID

1 question  
Lecture 69  09:12  


Quiz 50 
FIND CLEAN REPT CONCATENATE

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

Quiz 51 
Pivot Tables

4 questions  
Lecture 71  03:06  


Quiz 52 
Pivot Table Filter Slicer

2 questions  
Lecture 72  05:53  


Quiz 53 
Pivot Charts

2 questions  
Lecture 73  05:25  


Quiz 54 
Naming Dynamic Ranges

1 question  
Lecture 74  04:57  


Quiz 55 
Naming a Cell and a Range

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

Quiz 56 
Auditing Toolbar

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

Quiz 57 
Watch Window

1 question  
Section 27: FORM CONTROLS  
Lecture 77  05:08  


Quiz 58 
Group Boxes and Options Button

1 question  
Lecture 78  03:06  


Quiz 59 
Check Boxes

2 questions  
Lecture 79  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.


Quiz 60 
List Boxes and Combo Boxes

2 questions  
Lecture 80  02:56  


Quiz 61 
Scroll Bar and Spinners

1 question  
Section 28: IMPORTANT EXCEL TOOLS  
Lecture 81  08:18  


Quiz 62 
Text to Columns

1 question  
Lecture 82  06:56  


Quiz 63 
Grouping Tabs

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

Quiz 64 
SUBTOTAL Function

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


Quiz 65 
Hyperlinks

1 question  
Lecture 85  07:27  


Quiz 66 
Data Validation

1 question  
Lecture 86  05:47  


Quiz 67 
Random Numbers

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


Quiz 68 
Custom View

1 question  
Lecture 88  08:13  


Quiz 69 
Protecting Worksheet and Workbook

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

Quiz 70 
Excel 2010 Sparklines

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

Lecture 91  04:42  


Quiz 71 
Range Charts Type 1

1 question  
Lecture 92  04:32  


Quiz 72 
Range Charts Type 1 Continued

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

Lecture 94  04:40  


Quiz 73 
Range Charts Area Type 2

1 question  
Lecture 95  06:30  


Quiz 74 
Range Charts Area Type 2 Continued

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

Lecture 97  04:18  


Quiz 75 
Funding Graph

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

Lecture 99  06:30  


Quiz 76 
Two Axis Graphs

1 question  
Lecture 100  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. 

Quiz 77 
Scenario Graphs Continued

1 question  
Quiz 78 
Average Line

1 question  
Quiz 79 
Bar to Pie chart

1 question  
Quiz 80 
Combo Charts

1 question  
Quiz 81 
Creating Histogram

1 question  
Quiz 82 
Invert Negatives

1 question  
Quiz 83 
Scrolling Chart

2 questions  
Quiz 84 
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