Excel - Basic Excel Course

This MS excel training tutorial teaches you basics of MS Excel 2010 using practical excel case studies
  • Lectures 50
  • Video 4 Hours
  • Skill level beginner level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

Course Description

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 & non-finance 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

What are the requirements?

  • The course starts from Scratch and hence does not require any pre-requirements.

What am I going to get from this course?

  • Over 50 lectures and 4 hours of content!
  • The objective of the course is to introduce power of excel to you and to enable a participant of working on an excel sheet using different tools and techniques.

What is the target audience?

  • This is a very basic course on Excel. This course will introduce you to the power of excel. The target audience for this course is anyone interested in excel
  • students, accountants, finance & non-finance professionals

What you get with this course?

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

Curriculum

Section 1: Excel for Beginners - Overview
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
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.

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

Getting Started Quiz
4 questions
Section 3: Case Study
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.

Excel Case Study Quiz
1 question
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.

Data Entry Quiz
4 questions
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.
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 (CTR-C) and paste (CTR-V) 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.

Populating the Case Study in Excel Quiz
1 question
Section 4: Calculations
Text

This module contains working files related to Calculations. It contains working files without solutions and with solutions. Please download both of them.

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

Calculations Quiz
2 questions
Section 5: Formulas
Text
This module contains working files related to Formulas. It contains working files without solutions and with solutions. Please download both of them.
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.

Formulas Quiz
3 questions
Section 6: Formatting
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.
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

Formatting - Number Formatting Quiz
3 questions
Text
This module contains working files related to Formatting (Table). It contains working files without solutions and with solutions. Please download both of them.
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

Formatting - Table Format Quiz
2 questions
Section 7: Updating a Calculation
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.
02:41

This video shows

1) Adding an additional data and updating the calculations.

2) Understanding the auto calculation feature in excel

Updating a Calculation Quiz
2 questions
Section 8: Percentages & Absolute References
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.
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.

Percentage and Absolute References Quiz
1 question
Section 9: Conditional Formatting
Text
This module contains working files related to Conditional Formatting. It contains working files without solutions and with solutions. Please download both of them.
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

Conditional Formatting Quiz
2 questions
Section 10: IF Function
Text

This module contains working files related to IF Function. It contains working files without solutions and with solutions. Please download both of them.

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?

IF Function Quiz
1 question
Section 11: COUNTIF and SUMIF
Text

This module contains working files related to COUNTIF. It contains working files without solutions and with solutions. Please download both of them.

04:18

This video explains of the following

1. COUNTIF Function

2. When to use COUNTIF Function?

COUNT IF Quiz
2 questions
Text

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

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.

SUMIF Function Quiz
2 questions
Section 12: Charts and Graphs
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.

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.

Charts and Graphs Quiz I
1 question
Text
This module contains working files related to Pie Charts. It contains working files without solutions and with solutions. Please download both of them.
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)

Charts and Graphs Quiz II
1 question
Section 13: Sorts and Filters
Text

This module contains working files related to Sorts. It contains working files without solutions and with solutions. Please download both of them.

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.

SORT Quiz
1 question
Text
This module contains working files related to Filters. It contains working files without solutions and with solutions. Please download both of them.
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 drop-down 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

Filter Quiz
1 question
Section 14: Pivot Tables
Text
This module contains working files related to Pivot Table. It contains working files without solutions and with solutions. Please download both of them.
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.

Pivot Table Quiz
4 questions
Section 15: Freeze and Split
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.
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.

Freeze and Split Quiz
1 question
Section 16: Presentation
Text

This module contains working files related to Presentation I. It contains working files without solutions and with solutions. Please download both of them.

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

Presentation Quiz I
2 questions
Text
This module contains working files related to Presentation II. It contains working files without solutions and with solutions. Please download both of them.
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

Presentation Quiz II
3 questions
Section 17: Print
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.

Printing the Worksheet Quiz
2 questions
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

Print Quiz
2 questions
Section 18: Shortcuts
Text
This module contains working files related to Excel Shortcuts. It contains shortcut formulas in excel. Please download.
14:48

The video explains :-

1. How to Use Formatting Shortcut?

2. How to Navigate Excel worksheet?

3. How to use Workbook basic shortcut?

Shortcut Part I Quiz
1 question
10:46
The video explains of the following shortcuts:-
1.Selection 
2.Working with Data 
3.Formula shortcuts
Shortcut Part II Quiz
1 question
Section 19: Common Errors
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

Common Error Quiz
3 questions
Section 20: Concluding Lecture
02:32

In this lecture, the trainer gives us the summary of the entire learning in this course.

Instructor Biography

eduCBA Academy for Investment Banking Training , Global Online Training Experts in Investment Banking

eduCBA is globally recognized training firm, providing blend of instructor-led 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.

Join the biggest student community

5,900,000

Hours of video content

22,000,000

Course Enrollments

6,500,000

Students

Reviews

Average Rating
4.5
Details
  1. 5 Stars
    64
  2. 4 Stars
    21
  3. 3 Stars
    7
  4. 2 Stars
    3
  5. 1 Stars
    1
    • Bill Desjarlais

    Excellent introduction to Excel

    I picked up many gold nuggets from this well organized course.

    • Carlos Arias

    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.

    • Jordan Tim

    Very good presentation, simple explanation and extremely useful tips and tricks. It has made me more confident in excel.

    • Anjum Pillai

    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.

    • Lynnelle Mays

    Great course

    Easy to follow and clear instructions.

Show more reviews
Ready to start learning?
Preview this course