Advanced Excel 2010 training program

Topics Covered

Excel Framework File conversation & compatibility File management Charts & Graphics Conditional formatting Filtering & Sorting Formulas List of worksheet functions Compatibility functions Database functions Information functions Logical functions Lookup & Reference functions Introducing Lookup Formulas Functions Relevant to Lookups Basic Lookup Formulas The VLOOKUP function The HLOOKUP function The LOOKUP function Combining the MATCH and INDEX functions Specialized Lookup Formulas Looking up an exact value Looking up a value to the left Performing a case-sensitive lookup Looking up a value from multiple lookup tables Determining letter grades for test scores Calculating a grade-point average Performing a two-way lookup Performing a two-column lookup Determining the cell address of a value within a range Looking up a value by using the closest match Math & Trigonometry functions Text functions Statistics functions User defined functions – UDFs Analyzing Data What-if Analysis Pivot Table reports Importing & Exporting data Validating Data

Who should attend

Anyone can join this training who want to learn advanced excel and make his career in the field of MIS, Data Analytics & Business Intelligence.

Pre-requisites

Beginner knowledge of Excel

What you need to bring

Not mandatory - Laptop or Notepad & Pen

Key Takeaways

Expert knowledge in excel