Course Details

Workshop on MS Excel is available here. This is basically a single day learning program. They are highly dedicated professionals, always present here for the overal guidance of the students, in respect of the course.

Contents:

• Module 1: Overview of Excel Basics features
  • What’s New in Excel 2010
  • Formatting Data using Shortcut Keys
  • Inserting Header & Footer
  • Using Paste Special
  • Formatting table
• 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 & Consolidating data
  • 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, Trim & Concatenate
  • Math : Sum & SumIF
  • Logical : IF Condition with Multiple IFs