ADVANCED MS EXCEL TRAINING FOR CORPORATES

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 who need to learn more complex functions, advanced IF conditions formulas, dashboards, pivot tables, pivot charts, goal seek, 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. We also teach you how to develop these advanced solutions on the worksheet and to assemble the proper Excel tools in ways you have never thought of before. Find out how you can utilise advanced ‘IF’ statements.

Syllabus & Training Details

Various Methods and Uses of Advance Excel Formulas

VLOOKUP, HLOOKUP, SUMIF, SUMIFS, SUMPRODUCT, COUNTIF, COUNTIFS, IF, IFERROR, ISERROR, ISNA, ISNUMBER, ISNONTEXT, ISBLANK, ISTEXT, GETPIVOTDATA, OR, AND, INDEX, MATCH etc,

Various Methods and Uses of IF Conditions
  • When should use the “IF” Conditions?
  • Creation of Multiple IF Conditions in One Cell
  • Use the IF Conditions with the Other Advance Functions
How to use nested IF statements in Excel with AND, OR Functions
  • Various Methods of Filter and Advance Filter options
  • Creating and Updating Subtotals
  • Various Methods of Text to Column options
  • Uses of Data Grouping and Consolidation options
  • Uses of Goal Seek and Scenarios Manager
  • Various Method of Sorting Data
  • Creating, Formatting and Modifying Chart
  • Data Validation, Creating drop down lists using different data sources
  • Linking Workbooks and Uses of Edit Link options
  • Excel Options, Customizing the Quick Access Tool Bar
Formula Auditing features and Trace formula error
Pivot Tables
  • Various Methods and Options of Pivot Table
  • Using the Pivot Table Wizard
  • Changing the Pivot Table Layout
  • Subtotal and Grandtotal Options
  • Formatting
  • Grouping items
  • Inserting calculated fields
  • Pivot Table Options
  • Display and hide data in fields
  • Select, Move & Clear  Pivot data
Creating and Modifying a PivotChart