learn microsoft excel

Offline Course Contents

Excel 2007
Excel 2003
Macros Excel 2007
Macros Excel 2003
Excel 2010
About Us
Free Ebook
Offline Training
Blog
Interactive Training

  • Which version of Excel is installed on your computer? Which add-ins are installed?
  • Starting Excel and understanding the properties of a workbook
  • Worksheet properties and its manipulations. Comparing the properties of Excel worksheets in versions 2003, 2007 and 2010
  • Different kinds of data you use in Excel
  • Formulas in Excel
  • Functions like Sum, Average, Max, Min, Autofilter, Advanced filter, Dsum, IF, etc
  • How to use library functions properly. Getting help in Excel
  • What-if functions like Goal seek and Solver
  • Custom functions - creation and use
  • Data forms
  • Vlookup and Hlookup functions
  • Sensitivity analysis using tables and Solver scenario manager
  • How to cobmine the above knowledge to solve financial problems in the corporate environment
  • Using Microsoft Excel with accounting software like Tally
  • Macros: How to create macros using Visual Basic for Applications VBA to automate your calculations in Excel
Contact person: Dr. Dinesh Kumar Takyar
Mobile: 9810081867
Email: takyar@familycomputerclub.com
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010
About Us Free Ebook Offline Training Blog Interactive Training