BASIC MICROSOFT EXCEL


  • Spreadsheet basics
  • Creating, editing, saving and printing spreadsheets
  • Working with functions & formulae
  • Graphically representing data : Charts & Graphs
  • Analyzing data : Data Menu, Subtotal, Filtering Data
  • Working with functions & formulae Formatting worksheets ,
    Securing & Protecting spreadsheets

ADVANCED EXCEL CONTENTS


  • Formulas & Macros Formulas
  • Use the Function Wizard, Common functions (AVERAGE, MIN, MAX, COUNT, COUNTA, ROUND, INT)
  • Nested functions , Name cells /ranges /constants
  • Relative, Absolute, Mixed cell references
  • Logical functions using IF, AND, OR, NOT
  • The LOOKUP function, Date and time functions, Annotating formulas

DATA ANALYSIS


  • Sub Total Reports, Auto Filter
  • Password Protecting Worksheets
  • Linking Multiple Sheets
  • Sheet Referencing
  • Linking Between Word/Excel/Ppt

FUNCTIONS : LOOKUP, VLOOKUP, HLOOKUP, COUNT,IF, SUMIF


  • What-if-analysis
  • GOAL SEEK
  • NESTED IF
  • Reporting
  • Character Functions
  • Date Functions
  • Age Calculations
  • Consolidation of Data
  • Data Validation

PIVOT TABLES


  • Enter the Pivot Table Data
  • Create the Pivot Table
  • Adding Data to the Pivot Table
  • Filtering the Pivot Table Data
  • Change the Pivot Table Data
  • Analyze Data Columns in Pivot Tables
  • Adjust Data to Analyze

MACRO’S ( Int )

  • Macros
  • Definition and use, Record a macro
  • Assign a macro, Run a macro
  • Store a macro, Introduction to VBA Prog.

DEVELOP THE WORKSHEET

  • Plan a worksheet, Row and Column labels
  • Split worksheet/box/bar, Copy data and formulas
  • Display/move toolbars, enhance worksheet appearance

SPECIAL OPERATIONS

  • Use multiple windows : Copy/ paste between Worksheets
  • Link worksheets , Consolidate worksheets
  • Import and link from other Applications
  • Use AutoFormat : Create, use and modify styles and templates
  • Print features : Create /edit an outline
  • Graphic Operations Create charts , Enhance charts, Drawing toolbar features