Profit Analysis Dashboard using What-if Parameter
In this article, we have created a Profit Analysis using What-if Parameter in Microsoft Power BI. You can use this trick in your Sales dashboard. Profit Analysis Dashboard using What-if
Power Pivot
This category offers detailed tutorials on using Power Pivot to build powerful data models and perform complex data analysis tasks in Excel. From importing and organizing data to creating relationships between tables and writing advanced DAX, our tutorials cover a range of topics to help you work more efficiently with large datasets. Each tutorial comes with a free practice file for download and tutorial videos to help you understand the concepts better. Start exploring this category now and take your Excel skills to the next level. Impress your colleagues and boss with your proficiency in Power Pivot by exploring this category today.
Excel Comparative Analysis Dashboard with Power Pivot
This Excel comparative analysis dashboard uses Power Pivot to compare current-year sales with the same period in the previous year, and actual sales with budget. Three tables supply the data:
Price Fetching Tool from Amazon and Flipkart
In this article, we have created a price fetching tool from Amazon and Flipkart. You can input your search keyword and click on Search button. First it will open WWW.Amazon.in
Power Gantt Chart (Project Planner) for Project Management
In the article, we have created the Power Gantt Chart (Project Planner) for Project Management in Microsoft Excel with Power Pivot. You can use this template for your Project Management
Smart Chart with Laptop Shape in Excel
In this article, we have created a beautiful and smart chart with Conditional formatting in Microsoft Excel. We have create a laptop shape also using Excel shapes. We have placed
Email Data Consolidation Tool in Excel
Now a days businesses rely more heavily on email communication. Managing data from multiple sources can become a real challenge. Fortunately, there is a solution: an email data consolidation tool
Fully Automated Excel dashboard with multiple source files
This Excel dashboard combines data from multiple source workbooks and worksheets in a folder using Power Query. It presents the consolidated results in a dashboard and a tabular view, with
User level security in Excel Workbook for different worksheets
In this article, we have created User level security in Excel workbook. If you have multiple worksheets in your excel file and you want to protect/hide the data according to
Power Pivot KPIs in Excel: Create, Edit and Delete
A Power Pivot KPI compares a base measure with a target and displays a status using defined thresholds. This Excel tutorial shows how to create, display, edit and delete a
SUMX Function in Power Pivot: Revenue Measure with RELATED
The SUMX function in Power Pivot lets you calculate revenue with a single measure, without adding any helper columns to your data. In this tutorial you load an Orders table