Course Details

For Managers, MS Excel training course is available here. Teachers here have very high level of proficiency in tutoring. They are highly dedicated professionals, always present here for the overal guidance of the students, in respect of the course. Meticulously designed notes are provided to each of the students, for after-class study purpose.

Contents :

Module 1: Overview of Excel features & Validation

• What's New in Excel 2010
• Formatting Data using Shortcut Keys
• Using Paste Special
• Header & Footer
• Page Setup
• Formatting table
• Freeze Panes
• Creating Drop down in Cells

Module 2: Conditional Formatting

• Formatting data on Conditions
• Highlight Duplicate & Unique Values
• Finding top 5 / 10 Items in the Data
• Formatting data using Data Bars & Icons
• Clearing & Managing rules

Module 3: Summarizing & Consolidating data

• Creating Sub Totals
• Sorting data with Multiple Level Sorts
• Advance Filtering on more than 1 Criteria
• Extracting Unique Values with Filtering
• Tips of copying Filtered data to New File

Module 4: Summarizing data with Pivot

• Creating Pivot table & Analyzing data
• Understanding 4 areas of Pivot
• Refreshing & Changing PivotTable Range
• Creating sheets from Pivot table

Module 5: Charts

• Creating Column, Line & Pie Charts
• Shortcuts of Creating Charts
• Changing Chart type
• Adding Target Line in chart
• Method of pasting chart into PowerPoint

Module 6: Functions

• Statistical : Count, CountA, CountIF, CountBlank, Average & Average IF
• Lookup : Vlookup & Hlookup
• Text : Upper, Lower, Proper, Roman, Trim & Concatenate
• Math : Sum, SumIF& SumIFs
• Logical : IF Condition with Multiple IFs