Offline Course Contents

• 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