Course Overview
About Free Online Excel 2010 Training Course:
eduCBA brings you the Free Online Excel 2010 Training Course. Excel is used everywhere, hence we want that everyone should have the knowledge of basic excel. Through this training you will get access to video tutorials, pdf documents, excel sheets on excel 2010. This is a Case study based course where we have taken a case study of employee details and applied it in the formulas and tools to learn about various excel functions. The step by step understanding of the examples after the concepts will help you understand each function and formula in much detail. So before starting with the course let’s see what exactly is Excel 2010 and why we use it and what are the benefits.
Microsoft Excel 2010 is the basic thing that everyone should know. It is thoroughly used in almost all fields be it finance, statistics, marketing, engineering, human resources. It is especially used for the businesses which deal with large amounts of data (numbers, statistics). What we learn in academics is very theoretical aspects of business and does not have that much of practical application attached to it. But in practical life everyone wants application based learning. Excel has a spread sheet that has a grid of cells arranged in numbered rows and letter. The cells are named and there are many cells in an excel spreadsheet for the calculations and data entering. Excel 2010 has functions to answer statistical, engineering and financial calculations. Excel helps you in displaying data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. Excel 2010 also allows allows sectioning of data to view its dependencies on various factors for different perspectives, you may make use of pivot tables and the scenario manager for the same. Excel 2010 has a programming aspect which is known as the Visual Basic for Applications. This basically allows the user to employ a wide variety of numerical methods which can be used for solving differential equations of mathematical physics. It can also be then reporting the results back to the spreadsheet.
Our Free Online Excel 2010 Training Course is designed in such manner that it will give you practical approach and any person from any background will be able to apply it to his work. Through this course and the practice material you will gain proficiency in Excel 2010. Thus having detailed knowledge of Excel will be beneficial to you. This course on Free Online Excel 2010 Training Course is suitable for anyone, whether you are a student, fresher or an employee.
Benefits of the Free Online Excel 2010 Training Course:
- Learn Excel 2010 basics from Scratch using an Excel Case Study Approach that will help you to understand each example in a very easy way.
- Learn the conditional formatting concepts in Excel once you have mastered Basic formatting concepts in Excel
- Get a very good understanding of the more powerful features and functions in Excel
- Learn to Use Excel in a Professional Environment by applying the various tools and functions that you have learned in this Free Online Excel 2010 Training Course
- Become Awesome by this Free Online Excel 2010 Training Course.
Course curriculum:
Following is the course curriculum and its details for the Free Online Excel 2010 Training Course:
Section 1: EXCEL 2010: GETTING STARTED
- Getting Started – Ribbons & Quick Access Toolbar
The video explains the following things about getting started: 1. How to go about with Surfing an excel worksheet 2. You will also learn how to use HELP in MS Excel 2010
- Getting Started – Surfing Excel & HELP Function
In this video tutorial we will be learning about: 1.How to start with the excel 2010 software. 2. Then we will move forward and see the familiarity with excel interface. 3. Learn about Ribbons 4. Get to know about the Quick Access toolbar. 5. Surfing an excel worksheet 6. Know in detail about the Help option
Section 2: CASE STUDY
- Excel Case Study
This video builds on a small case study which will help you to learn data entry in excel 2010 in an easy manner
This video explains : 1. How to write or input data in excel from the case study. 2. We will also understand the different shortcuts in excel which will help to enter data easily. 3. Then we will move forward and look at the different types of number formatting available in excel
- Populating the Case Study in Excel
The video shows different ways of populating the large data in excel from a word document, we are going to look at some 3-4 ways of inputting row and column data, then finally we will see how to copy the entire table into excel.
Section 3: CALCULATIONS
The video explains how to carry out calculations in excel and thus we are going to learn various calculations like addition, subtraction, multiplication and division with help of some examples which will make it quite easy to understand.
Section 4: FORMULAS
The video shows how we can make use of functions like sum function, maximum function, minimum function and average function for different excel calculations.
Section 5: FORMATTING
This video explains the following topics in details: 1. How to use different formatting functions in various cases 2. How can one copy paste and do the format of one cell to other?
This video explains us about how to format tables. We are going to learn in detail about: 1) How to format tables using various options 2) Detail explanation of Formatting text using excel tools.
- Updating a Calculation
This video shows how can we add one more detail in the existing data and see the effects of it on the calculation.
- Percentages and Absolute References
The video explains the concepts of Normal referencing and absolute referencing. It also talks about its use in excel
- Conditional Formatting
The video explains in detail of the following about Conditional formatting. We are also going to learn about the different ways to do conditional formatting on a given set of data. Then we will further see how we can give different colors to highlight the data required.
Target Audience
- This Free Online Excel 2010 Training Course is suitable for students pursuing Degree, Diploma, Engineering, commerce and all general studies.
- Free Online Excel 2010 Training Course is also very useful for MBA, BBA students from all specializations
- Charted Accountant can also take up this course
- Free Online Excel 2010 Training Course will be very much useful for the Working professionals
- Anyone who wants to work as Finance Analyst, Market Analyst, Research Analyst, Investment Banker can take up this Free Online Excel 2010 Training Course.
Pre-requisites
- Passion to learn about Microsoft Excel 2010
- A PC with Internet connection
- The Free Online Excel 2010 Training Course start from scratch, hence no initial knowledge for the same is required.
Where do our learners come from? |
Professionals from around the world have benefited from eduCBA’s Free Online Excel 2010 Training courses. Some of the top places that our learners come from include New York, Dubai, San Francisco, Bay Area, New Jersey, Houston, Seattle, Toronto, London, Berlin, UAE, Chicago, UK, Hong Kong, Singapore, Australia, New Zealand, India, Bangalore, New Delhi, Mumbai, Pune, Kolkata, Hyderabad and Gurgaon among many. |