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.
As the industry standard for spreadsheet software, Microsoft Excel comes with many advantages to the new user. This awesome Excel 2010 for Beginners online course on MS Excel deals with the tools, techniques and functions of Excel 2010. This course will introduce you to different powerful tools of excel 2010.
The “Excel 2010 Beginner: ZERO to HERO in just 1 day“ course content is developed based on feedback from students and professionals with a blend of our years of experience in providing excel training. This program is suitable for housewives, entrepreneurs, marketing and sale professionals, students, accountants and finance & nonfinance professionals and anyone looking to learn excel 2010. The objective of the course is to increase the productivity and efficiency by introducing participants to numerous tools and techniques available in Excel.
This Excel 2010 Beginner course is hands on practical course. While instructing, the trainer actually performs the operations over an excel sheet for a better learning. Completion of this course, a participant will be capable of working on an excel sheet using different tools and techniques.
This Excel 2010 Beginner Course has 80 lectures with 6 hours of videos along with 27 quizzes. We have provided 100+ working files for participants to download along with SUBTITLE. We have also shown functions in excel 2003 and 2007 to compare with excel 2010. Take this Excel 2010 Beginner course and learn how to use Microsoft Excel with numerous tools and techniques.
Note: Microsoft Excel 2010 Beginner (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 basic
Be a part of the learning community onFacebook orTwitter
You may also find awesome resources at our Excel blog
Section 1: Excel for Beginners  Overview  

1  04:42  
This lecture talks about the modules that are covered in this course, the target audience for this course. It also talks about the power of excel function and how useful this is for professionals from the finance industry. 

Section 2: Excel 2010: Getting Started  
2  10:12  
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 We will learn the following through this tutorial : Ribbon: Most Excel commands are contained in the Ribbon. They are arranged into a series of tabs ranging from Home through View. Quick Access toolbar: You can click the Save, Undo, and Redo buttons to perform common tasks to save your work and undo and redo editing changes. You can also click the Customize Quick Access Toolbar button Formula bar: This displays the address of the current cell along with the contents of that cell. 

3  11:08  
The video explains: 1.Surfing an excel worksheet 2.How to use HELP in MS Excel In this video, we will learn the following  1) Worksheet area contains all the cells of the current worksheet identified by column headings, using letters along the top, and row headings, using numbers along the left edge, with tabs for selecting new worksheets. 2) You use a horizontal scroll bar on the bottom to move left and right through the sheet and a vertical scroll bar on the right edge to move up and down through the sheet. 3) HELP command or F1 can be used to find syntax of a formula or relevant information about an excel tool 

4 
Getting Started Quiz

4 questions  
Section 3: Case Study  
5  02:00  
1. We will learn Basic Excel functionalities using case study methodology. 2. This video tutorial introduces us to an Organization's employees data case study that will be referred to when we will learn excel. 

6 
Excel Case Study Quiz

1 question  
7  08:56  
This video highlights the followings: 1. How to input number, text, date in excel. 2. Helpful shortcuts to enter data easily. 3. Different kinds of number formatting options in excel Information entered into a cell is understood either as a text entry, a value or a formula 1) Use F2 to EDIT data in a cell 2) Text entries or labels can contain any combination of letters, numbers and spaces. 3) Numbers and text are treated differently. The default alignment for text is left whereas for numbers, it is right. 

8 
Data Entry Quiz

4 questions  
9  Text  
This module contains excel sheets related to populating the case study on excel sheet. It contains sheets without solutions and with solutions. Please download both of them.  
10  07:42  
The video shows 1) how to populate the large data in excel from MS word document 2) Shortcuts to data population The video explains about : 1. We can Copy (CTRC) and paste (CTRV) the table available in word document competely in one go instead of copying individually. 2. While copying and pasting, "Keep source formatting" retains the original format, however , "Match destination formatting" updates with the new destination format. 

11 
Populating the Case Study in Excel Quiz

1 question  
Section 4: Calculations  
12  Text  
This module contains working files related to Calculations. It contains working files without solutions and with solutions. Please download both of them. 

13  07:29  
The video Shows how to do numerical calculations in excel  1) Addition 2) Subtraction 3) Multiplication 4) Division We will learn the following through this video  + sign for Addition  sign for Substraction * sign for multiplication / sign for division 

14 
Calculations Quiz

2 questions  
Section 5: Formulas  
15  Text  
This module contains working files related to Formulas. It contains working files without solutions and with solutions. Please download both of them.  
16  09:58  
The video explains the following  1. SUM Function 2) MAX Function 3) MIN Function 4) AVERAGE Function This video teaches us: 1) SUM function computes the total value of the selected numbers. 2) The MAX and MIN functions simply compute the highest and lowest values in the cell range used as the number argument. 3) The AVERAGE function computes the arithmetic mean of the values in this range by summing them and then dividing them by the number of values in the range. 

17 
Formulas Quiz

3 questions  
Section 6: Formatting  
18  Text  
This module contains working files related to Formatting  Number Formats. It contains working files without solutions and with solutions. Please download both of them.  
19  08:30  
I. This video explains : 1. Number Formats  Currency, Comma and Percentages 2. How can one copy paste the format of one cell to other II. We discussed 3 different currency formats  a) Accounting Format  Sets the number format to the Currency style format and displays left aligned dollar sign in the cell. b) Comma Format  uses commas to separate thousands, displays two decimal places, and encloses negative values in a closed pair of parentheses c) Percent Style  Formats your cell selection using the Percent Style number format, which multiplies the values by 100 and adds a percent sign with no decimal places 2) We noted that Format painter helps to copy paste the format from one cell to another cell 

20 
Formatting  Number Formatting Quiz

3 questions  
21  Text  
This module contains working files related to Formatting (Table). It contains working files without solutions and with solutions. Please download both of them.  
22  07:37  
This video explains us 1) How to format tables? 2) Formatting text using excel tools? The video explains in detail the following  1) Borders, alignment, fill color can be used to format the table and text 2) Excel provides inbuilt Table formats via Table Styles gallery that can also be used to format the table 

23 
Formatting  Table Format Quiz

2 questions  
Section 7: Updating a Calculation  
24  Text  
This module contains working files related to Updating a Calculation. It contains working files without solutions and with solutions. Please download both of them.  
25  02:41  
This video shows 1) Adding an additional data and updating the calculations. 2) Understanding the auto calculation feature in excel 

26 
Updating a Calculation Quiz

2 questions  
Section 8: Percentages & Absolute References  
27  Text  
This module contains working files related to Percentages and absolute references. It contains working files without solutions and with solutions. Please download both of them.  
28  09:19  
The video explains  1. Calculating Percentage 2. Normal referencing 3. Absolute referencing We will learn the following  1. While copying and pasting a formula, Normal referencing updates the relative cell references and adjust the row and/or column as per the paste function 2. Sometimes, however, where Excel should not adjust one or more parts of the cell reference in the copied formula, we use Absolute Referencing. 

29 
Percentage and Absolute References Quiz

1 question  
Section 9: Conditional Formatting  
30  Text  
This module contains working files related to Conditional Formatting. It contains working files without solutions and with solutions. Please download both of them.  
31  08:28  
The video explains in detail of the following: 1. About Conditional formatting. 2. Different ways to do conditional formatting on a given set of data 3.how can one give different colors to highlight the data required. We learnt the following  1) Conditional Formatting feature enables us to format a range of values so that unusual or important values, or values outside certain limits, are formatted in such a way as to call attention to them. 2) We can create NEW formatting rules or select from the already created rules from the toolbar 

32 
Conditional Formatting Quiz

2 questions  
Section 10: IF Function  
33  Text  
This module contains working files related to IF Function. It contains working files without solutions and with solutions. Please download both of them. 

34  09:58  
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? 

35 
IF Function Quiz

1 question  
Section 11: COUNTIF and SUMIF  
36  Text  
This module contains working files related to COUNTIF. It contains working files without solutions and with solutions. Please download both of them. 

37  04:18  
This video explains of the following 1. COUNTIF Function 2. When to use COUNTIF Function? 

38 
COUNT IF Quiz

2 questions  
39  Text  
This module contains working files related to SUMIF. It contains working files without solutions and with solutions. Please download both of them. 

40  08:22  
This video explains of the following 1. SUMIF Function 2. When to use SUMIF Function We will learn the following through this video  1) SUMIF function enables us to tell Excel to add together the numbers in a particular range only when those numbers meet the criteria that you specify. 

41 
SUMIF Function Quiz

2 questions  
Section 12: Charts and Graphs  
42  Text  
This module contains working files related to Charts and Graphs. It contains working files without solutions and with solutions. Please download both of them. 

43  08:32  
The Video Explains  1. The concept of Graphs and Charts in Excel 2. Creation of Graph and Charts 3. Formatting of Charts& graphs i.e title,Grid lines color Etc. We will learn the following through this video 1) Charts present the data from your worksheet visually by representing the data in rows and columns as bars on a chart or Pie Charts 2) In a column chart, categories appear horizontally and values appear vertically, whereas in a bar chart, categories appear vertically. 

44 
Charts and Graphs Quiz I

1 question  
45  Text  
This module contains working files related to Pie Charts. It contains working files without solutions and with solutions. Please download both of them.  
46  11:24  
The Video Explains  1. Creation of pie Charts 2. Formatting of Pie Charts i.e title,Gridlines, color, Size Etc. 3. About Doughnut graph We will learn the following  1) A pie chart shows the relationship of the parts to the whole. 2) A doughnut chart is similar to a pie chart except for its ability to display more than one data series (pie charts always graph just a single data series) 

47 
Charts and Graphs Quiz II

1 question  
Section 13: Sorts and Filters  
48  Text  
This module contains working files related to Sorts. It contains working files without solutions and with solutions. Please download both of them. 

49  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? We will learn the following  1) Sort & Filter Data command button are on the Ribbon’s Home tab 2) We can sort the records in our data list by sorting its rows, and sort the fields in the data list by sorting its columns 3) In sorting, we can specify either ascending or descending sort order for the data. 

50 
SORT Quiz

1 question  
51  Text  
This module contains working files related to Filters. It contains working files without solutions and with solutions. Please download both of them.  
52  04:50  
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? We will learn the following  1) When we only need to sort the data list on one particular field (such as the S. No, Name or Department), we simply click that field’s AutoFilter button and then click the appropriate sort option on its dropdown list. 2) We can Sort A to Z or Sort Z to A in a text field 3) We can Sort Smallest to Largest or Sort Largest to Smallest in a number field 4) We can Sort Oldest to Newest or Sort Newest to Oldest in a date field 

53 
Filter Quiz

1 question  
Section 14: Pivot Tables  
54  Text  
This module contains working files related to Pivot Table. It contains working files without solutions and with solutions. Please download both of them.  
55  11:53  
The video explains in detail of the following : 1. What is a Pivot table? 2. Features of the pivot table. 3. Uses of those features to make data presentation more effectively. We will learn the following through this tutorial : 1) Pivot tables are great for summarizing particular values in a data list or database without creating formulas to perform the calculations. 2) pivot tables allows us to change the arrangement of the summarized data — even after we have generated the table. 

56 
Pivot Table Quiz

4 questions  
Section 15: Freeze and Split  
57  Text  
This module contains working files related to Freeze and Split. It contains working files without solutions and with solutions. Please download both of them.  
58  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? We will learn the following through this tutorial : 1) Freeze Panes feature, enables us to keep pertinent information, such as column and row headings, on the worksheet window as you scroll other columns and rows of data into view. 2) We can split the worksheet window into panes so that we can view two disparate regions of the spreadsheet together in the same window and compare their data. 

59 
Freeze and Split Quiz

1 question  
Section 16: Presentation  
60  Text  
This module contains working files related to Presentation I. It contains working files without solutions and with solutions. Please download both of them. 

61  05:42  
This video explains of the following 1. How to use Table formats? 2. Different ways to Present the data 3. Wrap text format. We will learn the following through this tutorial : 1. Use Table Style Gallery to make the table professional. These are inbuilt style gallery provided by MS Excel 2. We can format the table by provinding separate borders, fonts etc from the "Font" tab 3. Wrap Text Wraps all entries in your cell selection that spill over their right borders onto multiple lines within the current column width 

62 
Presentation Quiz I

2 questions  
63  Text  
This module contains working files related to Presentation II. It contains working files without solutions and with solutions. Please download both of them.  
64  05:40  
The video explains in the following : 1. The concept of Increase Indent function. 2. Different ways of formatting Charts and Graphs. We will learn the following through this tutorial : 1) Increase Indent  Increases the margin between the entries in your cell selection and their left cell borders by one tab stop 2) Charts and Graphs titles can be formatted and resized for better presentation 

65 
Presentation Quiz II

3 questions  
Section 17: Print  
66  07:29  
The video teaches us of the following : 1. What is Print option? 2. How to use print option? 3.The features of print option! 4. Use Print Sheet in One Page. We will learn the following through this tutorial : 1) Print panel can be opened by clicking File > Print or pressing Ctrl+P. 2) Page Layouts can be of two types a) Portrait (the default), where the printing runs parallel to the short edge of the paper b) Landscape, where the printing runs parallel to the long edge of the paper 3) You can preview the document before printing using in the Excel Backstage View, on the right side of the Print panel, which shows you the pages of the report more or less as they appear on the printed page. 

67 
Printing the Worksheet Quiz

2 questions  
68  06:53  
This video explains in detail of the following: 1. How can one fit using different options, the entire data in a worksheet for print. 2. How can one copy paste the title of the table easily. 3. How can one insert header and footer in an excel worksheet We will learn the following in this video  1) Excel’s Print Titles enable you to print particular row and column headings on each page of the report. 2) You can add Headers and footers in the worksheet that appears on every page of the report using Print Options 

69 
Print Quiz

2 questions  
Section 18: Shortcuts  
70  Text  
This module contains working files related to Excel Shortcuts. It contains shortcut formulas in excel. Please download.  
71  14:48  
The video explains : 1. How to Use Formatting Shortcut? 2. How to Navigate Excel worksheet? 3. How to use Workbook basic shortcut? 

72 
Shortcut Part I Quiz

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

74 
Shortcut Part II Quiz

1 question  
Section 19: Common Errors  
75  04:47  
We will learn the following through this tutorial : 1) #DIV/0  Division by zero  The division operation in your formula refers to a cell that contains the value 0 or is blank. 2) #REF!  Invalid cell reference  This error can be caused by an invalid argument in an Excel function or a formula that produces a number too large or too small to be represented in the worksheet. 3) #VALUE!  Wrong type of argument in a function or wrong type of operator  This error is most often the result of specifying a mathematical operation with one or more cells that contain text. 4) #NAME?  Excel doesn’t recognize a name  This error value appears when you incorrectly type the range name, refer to a deleted range name, or forget to put quotation marks around a text string in a formula 

76 
Common Error Quiz

3 questions  
Section 20: Concluding Lecture  
77  02:32  
In this lecture, the trainer gives us the summary of the entire learning in this course. 
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.
30 day money back guarantee
Lifetime access
Available on desktop, iOS and Android
Certificate of completion
Hours of video content
Course enrollment
Students
Excellent introduction to Excel
I picked up many gold nuggets from this well organized course.
Curso de Excel 2010 Básico
El curso está bien organizado, las explicaciones son claras pero el acento del instructor es muy molesto y hace que el curso se vuelva tedioso por este motivo.
Very good presentation, simple explanation and extremely useful tips and tricks. It has made me more confident in excel.
Excellent EXCEL course
I realized how easy Excel can be from this course. Now, I am not scared of excel. rather, I have started enjoying it. This course has helped me a lot.
Great course
Easy to follow and clear instructions.