Posts

Showing posts from November, 2020

How to Create a Beautiful Interactive Dashboard in Microsoft Excel | 2021

Image
In this topic, we’ll discuss  How to Create a Beautiful Interactive Dashboard in Microsoft Excel using multiple PivotTables , Pivot Charts  and PivotTable tools to create a dynamic dashboard.  You can create a beautiful Dashboard in 4 simple steps: 1. Create Individual charts 2. Create Dashboard Background 3. Create Dashboard 4. Add Slicers Today we will be building a dashboard which looks beautiful and professional. All you need is Excel and PowerPoint.  This is an interconnected dashboard where you can select from the bottom and the chart changes. You can even multi select the options and you can see it it's gonna change after you select and we can even select by country as well. I have provided the timestamps in the description.  Alright, so let's get started. I have the data here with me all the data is from 2013 to 2016. It is divided into different categories over here. So the first thing that we need to do is create a table from this data the way you do that is by select

Popular posts from this blog

How to create Easy Data Entry Forms in Excel

Build Site Inspection App | PowerApps

Build an inventory management app using Microsoft Powerapps