Course Description:-

INTRODUCTION:

Based on one of our most successful Microsoft Excel – Basic Excel Course, We have designed this course on Microsoft excel 2010 for you keeping in mind the feedback and suggestions from thousands of our Excel 2010 students. This Excel 2010 training course starts from scratch. So, even if you are a starter in Excel, you will get all of it in this course.

We will be covering the following modules in this course on Microsoft Excel 2010 Beginner:

• Overview of Microsoft Excel 2010
• Getting Started with Excel 2010
• Case Study to understand the entire course structure
• Calculations
• Formulas
• Formatting in Excel
• Updating a Calculation
• Percentages & Absolute References
• Conditional Formatting
• IF Function/COUNTIF/SUMIF
• Graphs & Charts in Excel 2010
• Sorts
• Filter Function
• Pivot table
• Freeze & Split
• Presentation
• Print
• Shortcuts
• Common errors in Excel 2010

 Pre-requisites for the Excel 2010 Basic Training Course

• Passion to learn.
• A computer with internet

What am I going to get from this course?

• Over 4.5 hours of content!
• To study what excel is and to know its importance in the current business world. The only requirement from you is to be passionate to learn, be committed to the training and invest your time.
• You will learn everything from data entry to calculations to formula
• Learn formatting, if, sum if, graphs and charts, sorts, pivot table, freeze and split etc
• Become awesome in Microsoft Excel 2010

Who should take up this course?

• Students, MBA’s, BBA’s, Gradates & Post- graduates, Working Professionals from any business domain., Entrepreneurs, Prospective Finance Analyst, Market Analyst, Research Analyst, Investment Banker
• Anyone Seeking Training with Excel 2010

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

CURRICULUM

Section 1: Excel for Beginners - Overview

1. Excel 2010 Beginner – Overview

Section 2: Excel 2010: Getting Started

1. Getting Started – Ribbons & Quick Access Toolbar
2. Getting Started – Surfing Excel & HELP Function

Section 3: Case Study

1. Excel Case Study
2. Data Entry in Excel
3. Populating the Case Study in Excel

Section 4: Calculations

1. Calculations – Addition Subtract Multiply Division

Section 5: Formulas

1. Formulas – SUM MAX MIN AVERAGE

Section 6: Formatting

1. Formatting – Number Formats
2. Formatting – Table Formats

Section 7: Updating a Calculation

1. Updating a Calculation

Section 8: Percentages & Absolute References

1. Percentages & Absolute References

Section 9: Conditional Formatting

1. Conditional Formatting

Section 10: IF Function

1. IF function

Section 11: COUNTIF and SUMIF

1. COUNTIF Function
2. SUMIF Function

Section 12: Charts and Graphs

1. Creating Charts and Graphs
2. Create Pie Charts

Section 13: Sorts and Filters

1. Sorts
2. Filters

Section 14: Pivot Tables

1. Pivot Tables

Section 15: Freeze and Split

1. Freeze and Split

Section 16: Presentation

1. Presentation – Table Formats
2. Presentation – Indents and Formatting Charts

Section 17: Print

1. Printing the Worksheet
2. Printing – Headers and Titles

Section 18: Shortcuts

1. Shortcuts – Formatting and Navigation
2. Shortcuts – Selection, Data and Formula

Section 19: Common Errors

1. Common Errors

Section 20: Concluding Lecture

1. Concluding Lecture

For any query feel free to call

Mob - 8587999769/9818826705