Conditional Formatting Archives - PK: An Excel Expert

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

Automated Attendance Sheet

Templates

Automated Attendance Sheet in Excel

December 6, 2020December 6, 2020 PKComments Off

Dynamic Data Bar

Charts and Visualization

Multicolor Filling Bars in Excel Cells Without using Chart

August 16, 2020August 16, 2020 PKComments Off