Business Intelligence with MS Excel 2016


 

Armenian-Indian Center for Excellence in ICT (AITC) and Enterprise Incubator Foundation are pleased to announce a new training of Business Intelligence with MS Excel 2016.

The course will be covered with Real-World Industry examples and will be delivered by highly qualified expert Artak S. Danielyan who has extensive experience of teaching and consulting in IT and educational spheres.

 

KNOWLEDGE TO BE GAINED

This 36-hour “BI with MS Excel 2016” training program will teach you flexible and powerful ways to organize, manage, analyze and present information. The objective is to get students and young professionals engaged in real life situations, so after the training you can take the skills learned and apply them to everyday scenarios. 

 

The course covers the skills starting from creating spreadsheets using MS Excel 2016, up to Data Analysis & Business Intelligence Automation Systems, Sorting, Filtering, PivotTable, Power Query, Power Pivot, DAX Calculations, Power BI, and Crating Dynamic superior Visualization Dashboards.

 

This will be an outstanding opportunity to start Excel from scratch and go beyond up to Business Intelligence Tools.

 

Participants do not need prior knowledge of MS Excel.

 

The Entire Course comprises of TWO Cycles: 

 

DESCRIPTION

Upon completion of BI with MS Excel 2016 course, participants will learn the following skills:

 

First Cycle

  • Excel Fundamentals: Efficiency, Data, Data Sets, Number & Style Formatting
  • Excel Fundamentals for Data Analysis & Business Intelligence: Sort, Filter, PivotTable, Power Query, Power Pivot
  • Date Functions
  • Data Validation
  • Conditional Calculations with Excel Formulas: AND & OR Criteria
  • Text Formulas and Text Functions
  • References: Relative, Absolute, Mixed, Sheet, Workbook, 3-D Cell Reference

PRE-REQUISITES

Participants should be comfortable in the Windows environment and be able to use Windows to manage information on the computer.

 

TRAINING DETAILS

Start day: February 5, 2018       

Duration: 18 hours / 9 days

Timing & Days: Monday, Thursday at 19:00 to 21:00

Fee:  33 000 AMD (for the entire course)

 

Second Cicle 

  • Lookup Functions & Formulas, Comprehensive Lessons VLOOKUP & More
  • Introduction To Array Formulas
  • Conditional Formatting to Visualize Data: Built-in & Logical Formulas
  • Charts to Visually Articulate Data
  • Power Query
  • Data Modeling & DAX formulas
  • Power BI Desktop to Create Data Model & Visualization
  • Financial Functions: PMT, RATE, NPER and FV
  • Round Functions: ROUND, MROUND, ROUNDUP, CEILING, and more…
  • Macro Recorder Basics


TRAINING DETAILS

Start day: December, 2017        

Duration: 18 hours / 9 days

Timing & Days: Monday, Thursday at 19:00 to 21:00

Fee:  36 000 AMD (for the entire course)


 

HOW TO APPLY?

As the number of participants is limited the selection will be made on "first come - first served" basis. The selected students will be notified additionally. For more information please call us at 010/93 55 68 10.