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>
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
We will learn the following -
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.
</p>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
</p>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.
</p>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
</p>The video Shows how to do numerical calculations in excel -
1) addition
2) subtraction
3) Multiplication
4) Division
We learnt the following in this video -
+ sign for Addition
- sign for Substraction
* sign for multiplication
/ sign for division
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.
</p>This video explains :-
1. Number Formats - Currency, Comma and Percentages
2. How can one copy paste the format of one cell to other
1) 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
</p>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
</p>This video shows
1 Adding an additional data and updating the calculations.
2) Understanding the auto calculation feature in excel
We learnt the following -
1.We can add additional data in the table
2.We note that the calculations gets updated automatically because of "auto calculation" feature in excel.
3.If it does not get automaically updated you can change the range of cells to include the updated cell manualy.
</p>The video explains -
1. Calculating Percentage
2. Normal referencing
3. Absolute referencing
We learnt 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.
</p>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
In this video we learnt to apply IF Function - IF(logical_test,value_if_true,value_if_false); It tests whether the logical_
test expression is TRUE or FALSE. If TRUE, the IF function uses the value_if_true argument and returns it to the cell. If FALSE, the IF function
uses the value_if_false argument and returns it to the cell.
</p>This module contains working files related to COUNTIF. It contains working files without solutions and with solutions. Please download both of them.
This video explains of the following
1. COUNTIF Function
2. When to use COUNTIF Function
We learnt the following in this video -
1) COUNTIF function that you can use to count cells in a range only when they meet a certain condition.
</p>This module contains working files related to SUMIF. It contains working files without solutions and with solutions. Please download both of them.
This video explains of the following
1. SUMIF Function
2. When to use SUMIF Function
We learnt the following in 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.
</p>We learnt the following -
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.
</p>We learnt 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)
</p>We learnt 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.
</p>We learnt 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
</p>We learnt the following -
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.
</p>We learnt the following -
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.
</p>This video explains of the following
1. How to use Table formats
2. Learn different ways to Present your data
2) Wrap text format.
We learnt the following in this video -
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
</p>We learnt the following in this video -
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
</p>We learnt the following -
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.
</p>We learnt 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
</p>We will learn the following -
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
Easy to follow and clear instructions.
he explains in detail but easly so beginners can understand.
It was a very good refresher. It enabled me to try the advance course.
★★★★★ 5 stars!! I loved it.. It Really helped me in my college excel course..
I found this course to be VERY informative, wish i had completed it a long time ago, it would have helped in my previous job!!
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