Beautiful 3D Visualization in Excel
In this article, we have created a beautiful 3D visualization in Excel using 3D Column charts and Excel Shapes. You can use this visualization in your business dashboard or business
Blogs
Automated Bulk Emails Form in Excel VBA
In this article, we have created an Automated Bulk Email User form to send the bulk emails using Microsoft Outlook. We have taken two different type of emails – Customer
Smart Attendance Manager in Excel VBA
In this article, we have developed a Smart Attendance Manager in Excel Using VBA using VBA User forms. You can use this form to manage the attendance of your team or
Calculate Ratio in Excel
In this article, we have explained how to Calculate Ratio between two number in Excel. We have used the Excel formula as well as the User defined function in VBA to
Shell Function in VBA
Shell Function in VBA can run executable program and returns a Variant (Double) representing the program's task ID if successful otherwise, it returns zero. Syntax Shell(pathname, [ windowstyle ]) pathname:
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
SUMX Function in Power Pivot
In this article, we have explained how to use Measure in Pivot Pivot data model. We have taken the example of SUMX function to calculate the revenue. On the base
Calculated Column in Power Pivot (LOOKUPVALUE Vs RELATED)
In this article, we have explained how to use calculated column in Power Pivot Data Model. We have taken the example of Orders data wherein we have product level Unit
Drill Down/Drill Up Feature in Pivot Chart
In this article, we have created a Drill Down/Drill Up Feature functionality in a Pivot chart. We have created a hierarchy in Power Pivot data model to create this. Below are
Create Relationship in Power Pivot
In this article, we have explained, how to create relationship in Power Pivot data model. We have taken 2 dimension table and once fact table. What is Power Pivot? Power