MS Excel 2010 Manager

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


 
Student Community Apply online FAQ Course Calendar
  • Will be updated soon...

  • Will be updated soon...

  • Will be updated soon...

  • Will be updated soon...


+971 4 396 44 55