Advanced Filter
Macros
Pivot tables
Text Functions
About Us


MS-Excel Training for managers

  • Analyze information
  • Manage your analysis and insight
  • Share info with coworkers, customers, and partners
  • Make more informed decisions


    • "One cannot learn anything so well as by experiencing it oneself." - Albert Einstein

    If you wish to learn Excel through movies and step by step, then follow this link else select any topic below:
    Note: Several examples have been outlined below for Windows XP/Excel 2003.
    You will get best results if you keep your Excel program open during the study!
  • Entering text, numbers & formulas
  • Consequences of bad data entry in Excel
  • Validating number and text data entered
  • Sorting data
  • Auto filter - get specific details quickly and easily
  • Advanced Filter - find information - based on multiple criteria
  • Vlookup - finding information quickly in large work sheets
  • Creating charts - a picture is worth a thousand words!
  • Integrating charts with PowerPoint presentations
  • Using various functions to perform calculations
  • Edit, correct and proofread text using formulas
  • Date Functions
  • Using simple 'IF' and multiple 'IFs'
  • Goal Seek
  • Solver & Scenario Management
  • Swing into action using Pivot tables and reports
  • Importing database files into Excel
  • Integrating Excel with VBA
  • Macros
  • Creating templates
  • Many criteria, one function - dsum
  • Using Named Ranges in Excel
  • Quicker calculations in Excel using array formulas
  • Conditional Formatting in Excel can highlight interesting aspects of a spreadsheet
  • Data entry and validation using lists
  • Date entry and validation using the right messages
  • Numbers entry and validation of predefined values
  • A 'do while' macro in VBA that can be expanded with a little intuition
  • A flash movie on creating a pie chart in Excel
  • A flash demo on recording a Macro in Excel
  • Accessing the VBA code of the Macro recorded above
  • A flash demo on reusing the VBA code recorded in the above Macro
  • A flash demo on importing text files into Excel
  • Combining Excel with Accounting software like Tally
    		•


    Family Computer Club, no.9, Savitri Cinema Commercial Complex, Greater Kailash-2,
    New Delhi-110048 Ph: 29213339 Mobile: 9810081867
    Contact person: Dr. Dinesh K Takyar
    Any Queries?
    Good learning solutions!
    Excel & VBA
    Importing files
    Excel & Tally
    Excel Templates
    About Us