Soft Skills Ltd

Data Management and Analysis

Course Duration: 3 Days

Program Overview:

Microsoft Excel is one of the commonly used business intelligence tool. Many organizations import reports from their business operational systems for further analysis. It is at this point that Excel comes in to do the rest. We need to be equipped to use the data to our advantage.

By the end of the 2 days, participants should be able to:

  • Learn best practices in presentations and dynamic reporting
  • Interrogate and make logical business decisions from data sets
  • Understand how excel works and learn relevant shortcuts in navigating without the mouse.
  • Manipulate and handle any kind of data.

Who should attend: Accountants, Finance professionals, Research analysts, Data analysts, credit professionals, sales professionals and any person interested in improving their data analysis skills.

Course Content:

  • Understanding the Excel ribbon
  • Cell Referencing and Anchoring
  • Cell formatting
  • Excel Shortcuts
  • Data Sorting
  • Data Filtering
  • Freezing panes
  • What If Analysis (Scenario Manager, Solver, Goal Seek)
  • Look up & Reference Functions (Vlookup, Hlookup, Index, Match)
  • Text Functions (Concatenate, Text, Right, Left)
  • Handling errors in excel
    Logical Functions (IF, IFERROR, And, True, False)
  • Selected Financial Functions (PMT, PV, Loan amortization schedule)
  • Conditional formatting
  • Grouping and Totaling
  • Large data analysis using
  • Pivot Tables
  • Data in multiple sheets
  • Basic graphing principles
  • Dashboards
  • Designing Charts
  • Identifying appropriate
  • charts and best practices
  • Manipulating graphs
  • Trend lines
  • Formular auditing tools
  • Setting of printing layout
  • Excel workbook security and protection
Methodology:

This is a highly practical and interactive training and participants are expected to bring their laptops during the training.

Training Methodology:
  • Mini lectures
  • Role plays
  • Brain storming
  • Video presentations
  • Question and answer sessions
  • Demonstrations by the trainer
  • Practical group activities
  • Case-studies

Soft Skills Ltd © 2020| Powered By Soft Skills Ltd