loader image
Loading Details......
Business Data Analysis with Microsoft Excel and Power BI

Ms. Disha Garg

Program Coordinator

Course Overview

This program is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio and Power BI is now considered as an industry demand in the recent times for Data Analytics.

Register Now !

Register Now!

Watch INTRO VIDEO

Course Key Features
  • Application of Ms. Excel
  • Understanding the use of Ms. Excel in corporate world
  • Able to describe, predict & make informed decisions
  • Application in specific areas of human resource, finance and operations
  • Power BI
  • Create Impactful Reports with Power BI Desktop

Skills Covered

  • Data Validation
  • Excel Macro
  • Pivot Table
  • Graphs
  • Conditional Formatting
  • Lookup Table
  • Filters & Sorting
  • Power BI

Benefits

In this program, learners will solve a broad range of business problems as they apply the Excel skills and techniques they learn along the way. This specialization uses downloadable Excel workbooks and full data sets with applied examples and practical challenge exercises. This provides learners with countless opportunities to practice their Excel skills while discovering new and useful productivity features of Excel for a variety of business contexts and use Power BI for Data Analytics.

Course Curriculum

  • All BBA and MBA students are eligible

Prior knowledge of basic Ms-Excel

  1. The program requires students to maintain attendance percentage of 70% and above [One of the criteria for and eligibility for the issuance of Certificate]
  2. Apart from sessions including assessment, there shall be a MID-POINT and an END-POINT assessment. Any student needs to score an aggregate of 60% and above to be eligible for certification.

 

Topic to be covered

No of hours

Basic Ms. Excel Introduction

1

Filters- Name and text filters, Data Filters

2

Sorting- Sort by colour, reverse list

2

Conditional Formatting- Manage rules, data bars, colour scales

2

Use of graphs- trend lines, histogram, pie charts etc

2

Cleaning the data in Ms Excel- removing duplicates, use of max & min

1

Data Validation, removing duplicates, what-if analysis

2

Formulas in Ms. Excel (Financial, Logical, Text, Date and time)

3

V lookup and H lookup

2

Macros

2

Pivot table

2

Grouping and ungrouping

1

Use of Pivot table for HR Processes

2

Power BI Overview and Basics (By Industry Expert)

2

Excel and Power BI: Better Together

2

Create Impactful Reports with Power BI Desktop(By Industry Expert)

2

Course Instructor

Mr. Kapil Kumar

Mr. Kapil Kumar Bachelor’s in engineering with 6+ years’ experience in data analytics, reporting and process automation for Construction, Banking & Finance, and IT services industry.

▪ Passionate about new and emerging technologies in analytics and reporting.

▪ Proficient in Oracle/SQL and Power BI, Tableau; exposure to Power Apps and Python.

▪ Experienced in working directly with global clients in captive and 3rd party setting – and managing end-to-end projects

Ms. Disha Garg

Ms. Disha Garg is an Academician and Researcher. She has done her B.Tech (ECE) and MBA from GGSIPU. She holds couple of years of corporate experience as Deputy Manager in a reputable bank and currently working as an Assistant Professor at Rukmini Devi Institute of Advanced Studies as well as pursuing her doctorate from Jims, Delhi. Her specialization is Human Resource and she has a keen interest in Performance Management, Organizational Behavior, Employer Branding, Emotional Intelligence and Data Analytics.

 

Programme Fees

  1. The program requires students to deposit a refundable amount of INR 200/-, refundable only in case of the successful completion of the program.
  2. Refund is subjected to [both inclusive]
  • Student meeting the eligibility criteria w.r.t attendance and
  • Student scoring an aggregate of 60% and above in the program assessment.
Register Now !

Register Now!

SHARE THIS EVENT ON SOCIAL MEDIA

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn