Excel Tips and Tricks VBA Calculate Ratio in Excel January 23, 2020January 23, 2020 PKComments Off on Calculate Ratio in Excel
Power Pivot KPI in Power Pivot for dashboard and report January 15, 2020January 15, 2020 PKComments Off on KPI in Power Pivot for dashboard and report
Power Pivot SUMX Function in Power Pivot January 13, 2020January 13, 2020 PKComments Off on SUMX Function in Power Pivot
Power Pivot Calculated Column in Power Pivot (LOOKUPVALUE Vs RELATED) January 9, 2020January 9, 2020 PKComments Off on Calculated Column in Power Pivot (LOOKUPVALUE Vs RELATED)
Charts and Visualization Power Pivot Drill Down/Drill Up Feature in Pivot Chart January 6, 2020January 6, 2020 PKComments Off on Drill Down/Drill Up Feature in Pivot Chart
Power Pivot Create Relationship in Power Pivot January 3, 2020January 3, 2020 PKComments Off on Create Relationship in Power Pivot
Charts and Visualization Sales Dashboard Power View in Excel 2013 December 30, 2019December 30, 2019 PKComments Off on Sales Dashboard Power View in Excel 2013
Power BI Dynamic Conditional Formatting in Power BI December 26, 2019December 26, 2019 PKComments Off on Dynamic Conditional Formatting in Power BI
Templates VBA Smart Data Entry form with minimum VBA December 23, 2019December 23, 2019 PKComments Off on Smart Data Entry form with minimum VBA
