In this tutorial, we stepped up the level for data visualization in Excel. Features you never knew were possibe in Excel were explored to say the very least.
Link to dataset used: https://docs.google.com/file/d/1kEIkj...
Part 1 Topics covered:
How to import and transform data into an Excel Sheet
Data Cleaning and Preprocessing in Power Query
Exploration Data Analysis in Excel
Use of Pivot Table for building Charts in Excel
Part 2 Topics covered:
Excel Dashboard Structure
Sales Review Dashboard designing
How to use card visuals in Excel Dashboard
How to design Shapes in Excel for Data visualization
#dataanalytics #excel #analytics #channel #dashboard #data
#exceldashboardstutorial #excelforbeginners #exceltutorial #datascience #datavisualization #dataentry #jeksanalytics #beforeandafter