Loading Details......
CloseClose
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.
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.
Prior knowledge of basic Ms-Excel
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 |
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 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.
