Data Transformation to Create Comma Separated List Automatically
Data transformation is an important aspect of data analysis and is often used to manipulate data in a way that suits our needs. One such manipulation is to Create Comma
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.
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
Comparative Analysis Dashboard in Excel
This is the Excel version of the Comparative Analysis Dashboard. We have used Power Pivot to create this dashboard. We have used Current Year Sales Vs Previous Year Same Period
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
In this article, we have create a full automatic excel dashboard with multiple excel source files. Each source file can have multiple worksheets. For data consolidation we have used Power
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
KPI in Power Pivot for dashboard and report
Key performance indicators (KPIs) are visual measures of performance. Based on a specific calculated field, a KPI in Power Pivot for dashboard is designed to help users quickly evaluate the