Microsoft office

Tally courses in coimbatore

Overview:

Our Excel Advanced training will really show you how to make Excel work for you. The course is aimed at fairly experienced Excel users whom need to learn more complex functions, nesting, data manipulation and protect data using the security features. You will gain an insight into data tables and using excel advanced look up features to automate worksheets and analysis tools to forecast figures based on a range of scenarios and use consolidation to bring together information. Find out how you can utilise advanced ‘If’ statements.

Duration:16 Hours

Course Content:

  • Difference between Excel 2003, 2007 and 2010, Use of Excel, its boundaries & features
  • Formulae that Add/Subtract/Multiply/Divide • BODMAS/Formula Error Checking • The Sum Function
  • Problems with Absolute/Relative Cell Referencing, Creating Absolute/Mixed References
  • The VLOOKUP/HLOOKUP Functions
  • Creating, Formatting Simple PivotTables • Page Field in a PivotTable • Formatting a PivotTable • Creating/Modifying a PivotChart
  • IFs and Nested IF Functions • Using AND/OR/NOT Functions
  • Using The SUMIF/COUNTIF Functions • Using The AVERAGE/COUNT/LARGER/SMALLER Functions
  • Adding new calculated Fields / Items • Changing the Summary Function • Consolidate Pivot table
  • MATCH with VLOOKUP Functions • INDEX & MATCH Functions • OFFSET/ INDIRECT functions
  • Importing Data from Database/ Text Files/ Web • Exporting Data • Changing External Data Range