S-Tek Certified Diploma in Advanced Excel & MIS

Course Objective

To Understand the leadership role of Management Information Systems in achieving business competitive advantage through informed decision making.
To analyze and synthesize business information and systems to faciliate evaluation of strategic alternatives.
Effectively communicate strategic alternatives to facilitate decision making.

Basic Excel
  • What is a Spreadsheet Package
  • Concept of Cell Referencing
  • Editing Cell entries with Edit Command
  • Spell Checking
  • Working with Functions
  • Working with Charts
Advanced Excel
  • Lookup and Reference Functions
  • Statistical Functions
  • Financial Functions
  • Pivot Tables
  • Power query and Power Pivot
  • Sparklines
  • Dashboards
MIS
  • Creating Dashboards using Excel
  • Graphical representation of data using charts and sparklines
  • Use of power pivots for data analysis
  • Use of power queries
  • Exporting data from Excel to other formats
  • Creating reports in excel
  • Sample case studies
VBA Macros
  • Basic of Excel VBA
  • Sub Procedure and User Defined Function
  • Developer tab – Essential Buttons
  • Macros – Record and Run.
  • Ways to Run a Macro..
  • Customise Macro code
Tableau
  • Environment setup
  • Tableau Data Sources
  • Tableau Worksheets
  • Tableau Calculations
  • Tableau Sort and Filter
  • Tableau Charts
  • Tableau Dashboards
PowerBI
  • PowerBI installation
  • PowerBI data modelling
  • PowerBI Dashboards
  • PowerBI Visualisation Options
  • PowerBI Excel Integration
  • PowerBI Report Sharing
  • DAX Basics in PowerBI