Learn from the real world scenario and Practice Data
Ms Excel Advance crash course
27 & 28 May
th
th
11:00 AM - 01:30 PM
About Excel Advanced Crash Course
In this crash course you will be introduced to Power Query and Power BI, powerful tools for converting, analyzing, and presenting data. You will learn how to automate the steps involved in importing and getting data ready for analysis with Power Query. Finally, we will leave Excel and introduce Power BI, a tool that also makes use of the Power Query and Power BI architecture and that enables us to build spectacular interactive reports and dashboards.
Course Timeline
Day 1 Power Query
-
Introduction to the power query tab, power query as an alternative to text to column
-
Import multiple excel files and combine them into the proper data set
-
Combined multiple tables in the same excel workbook with the help of blank query
-
Merge, Append, and Unpivot features
Day 2 Power BI
-
Introduction to Power BI
-
Import Of Data from Web
-
Import of data from Excel workbook
-
Creation of a data table
-
Creation of relationship
-
Creation of an interactive dashboard
-
KPI and AI visual
-
Power BI Service
Who should enroll?
Students
Marketers
Aspiring Accountants
Anyone interested in upgrading themselves
Data Enthusiasts
Early career starters
Aspiring CAs
Anyone who works with numbers and data
.png)
Course Highlights
Live Sessions
Doubt clearance on the go
5 hours of rigorous training
Practice Sheets
Common finance-industry modeling best practices
Why Enroll for MS Excel Basic Crash Course?
Competitive advantage among your peers
Increase your value in the job market
Get Certified
Hot Offer 90% OFF
Resume Cheat Sheets
.png)
Bonuses
Excel Practice Sheets
.png)
Access to Private Community
