This is a online course is to gain comprehensive understanding of the Excel 2010. The aim is to learn about the fundamentals functions in Excel 2010 and how it should be used. The tutorials will help you learn about Getting Started, Data Entry, Populating the Case Study in Excel, Formulas, formatting, Conditional Formatting, Charts and Graphs, Pivot Tables, Presentation, Prints, Short cuts and common errors.
Course Description:-
INTRODUCTION:
Online Excel 2010 – Beginners training
This course is specially designed for those for who Excel completely a new concept. But these people need not worry as you just require one day, yes you read right ONE DAY of your life to learn this awesome course.
What else you need is your sure shot commitment and you will become proficient in Microsoft Excel. Having detailed knowledge of Excel will be beneficial for you, whether you are a student, fresher or working professional.
Excel Training 2010-Basic course highlights:
- This course provides you with basic understanding of what excel is and important functions of excel that anyone needs to be understand. It also provides you with practical case study for better understanding. This course covers:
- Excel Case study- In this Case study learn basic excel functionalities using case study methodologies.
- Learn Populating case study in Excel-This video tutorial explains How to populate large data in excel.
- Basic Calculations within Excel-Learn how to do basic calculations in excel like addition, subtraction, multiplication, division etc.
- Basic Formulas-Lean basic excel formulas such as MAX, MIN, SUM, AVERAGE.
Formatting in excel sheet-
- This Video tutorial explains tricks of formatting.
- Percentages Absolute References
- This tutorial explains calculating Percentage, Normal referencing, absolute referencing.
- Important Excel Functions-also apart from above function you will learn different excel function used in practical life such as Conditional Formatting, IF Function, COUNTIF and SUMIF, Charts and Graphs, Sorts and Filters, Pivot Tables, Freeze and Split, and many more.
- Shortcuts-Learn different types of shortcut used in excel.
Target Audience:
- Students
- Working Professionals(HR, Marketing, Sales, Operation)
- Entrepreneurs
- People who want to work as Finance Analyst, Market Analyst, Research Analyst, Investment Banker for them Excel is the language that they should speak
Pre-requisites:
- Passion to learn
- Computer with Internet connection.
Benefits of online course:
- High Quality Content
- Learn Anywhere Anytime & at Your Pace
- 24X7 Customer Support
- Complete Student Support Throughout The Program
- Course Completion Certificate
- Lifetime course access
For any query feel free to call
Mob - 8587999769/9818826705
CURRICULUM
Section 1: Getting Started
- Getting Started Ribbons Quick Access Toolbar
- Getting Started Surfing Excel HELP Function
Section 2: Case Study
- Excel Case Study
Section 3: Data Entry
- Data Entry in Excel
Section 4: Populating the Case Study in Excel
- Populating the Case Study in Excel
Section 5: Calculations
- Calculations Addition Subtract Multiply Division
Section 6: Formulas
- Formulas SUM MAX MIN AVERAGE
Section 7: Formatting
- Formatting Number Formats
- Formatting Table Formats
Section 8: Updating a Calculation
- Updating a Calculation
Section 9: Percentages Absolute References
- Percentages and Absolute References
Section 10: Conditional Formatting
- Conditional Formatting
Section 11: IF Function
- IF Function
Section 12: COUNTIF and SUMIF
- COUNTIF Function
- SUMIF Function
Section 13: Charts and Graphs
- Creating Charts and Graphs
- Create Pie Charts
Section 14: Sorts and Filters
- Sorts
- Filter
Section 15: Pivot Tables
- Pivot Table
Section 16: Freeze and Split
- Freeze and Split
Section 17: Presentation
- Presentation Table Formats
- Presentation Indents and Formatting Charts
Section 18: Print
- Printing the Worksheet
- Printing Headers and Titles
Section 19: Shortcuts
- Shortcuts Formatting and Navigation
- Shortcuts Selection Data and Formula
Section 20: Common Errors
- Common Errors
Here is a sample for the course completion certificate which you will receive after complete the course. This certificate is widely accepted across industries and will boost your chances to grab the job opportunities.
Mail us at: [email protected] with below details to receive your certificate:
- Name
- Course Name
- Date of Completion
- Address
