Conditional Formatting Archives - PK: An Excel Expert

Paste Special in Microsoft Excel

Excel Tips and Tricks

Paste Special in Microsoft Excel

November 22, 2022November 22, 2022 PKComments Off

Quick Analysis Tool

Charts and Visualization Excel Tips and Tricks

Quick Analysis Tool in Microsoft Excel

October 2, 2022October 2, 2022 PKComments Off

Multicolor data bar with REPT function

Charts and Visualization

Multi-color Data bar with REPT function

July 12, 2022July 12, 2022 PKComments Off

Conditional formatting in Excel Chart

Charts and Visualization

Conditional formatting in Excel Chart

May 3, 2022 PKComments Off

Sales Analysis Heat Map

Charts and Visualization

Sales Analysis Heat Map by Time and Day

March 27, 2022March 27, 2022 PKComments Off

Dynamic Calendar with Task List

Templates

Dynamic Calendar with Single formula

March 13, 2022May 10, 2022 PKComments Off

Send WhatsApp and Email without VBA

Templates

Send WhatsApp and Email without VBA

January 17, 2022January 17, 2022 PKComments Off

Final Report

Charts and Visualization Excel Tips and Tricks

Conditional Formatting in a Pivot Table with Example

December 6, 2021December 6, 2021 PKComments Off

Dashboard

Annual Sales Calendar for Sales Dashboard in Excel

September 5, 2021September 5, 2021 PKComments Off

10 Productivity Tips in Excel

Excel Tips and Tricks

10 Super useful Productivity Tips in Excel

March 7, 2021March 7, 2021 PKComments Off