To provide participants with an in-depth knowledge with different types of excel functions and applications that are needed to prepare spread sheets. 

• •    Concepts and data analysis and dashboards
  •    Tips and tricks 
  •    Manage rules
  •    Data validation 
  •    Combine values from multiple ranges into one new range
  •    Remove duplication
  •    Text to columns
  •    Analysis toolpack
  •    Statistical analysis: function 
  •    Get & transform data 
  •    Queries and connection 
  •    Data types 
  •    Sort & filter 
  •    Forecast
  •    Using file manager, define name & create from selection in excel to prepare spread sheets 
  •    Scenario analysis 
  •    Goal seeking & back solving 
  •    Functions: ABS, If, Sum if, Round, Round Up, Round Down, And, If and, Or , If or , Match, Index, Index Match, Sum product, Int , Mod , Average If, If Error, aggregate
  •    VLOOKUP, HLOOKUP, XLOOK & LOOKUP for Business/Finance/Accounting tasks
  •    Preparation of reports
  •    Conditional formatting formulas 
  •    Using excel in prepare financial statements: Statement of financial position, Statement of comprehensive income and Statement of cash flows  
  •    Financial statements and ratios 
  •    Excel & visual basic application (VBA) 
  •    Recording Macros
  •    Excel functions in calculating depreciations: SLN, DB, DDB, SYD
  •    Break–even point
  •    Laying out the pivot table
  •    Modifying the pivot table
  •    Pivot table examples 
  •    Grouping pivot table items
  •    Creating a calculated field or calculated item
  •    Referencing cells within a pivot table – GETPIVOTDATA 
  •    Producing a report with a pivot table 
  •    Pivot charts power 
  •    Pivot power 
  •    Query
  •    Loan amortization scheduled 

This programme is designed for all administrative, Accountants, financials and secretarial employees