• Advanced Excel
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
    • Find and Replace
  • VBA Course
  • Products
    • Restaurant Management
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • AMS V1.0
    • AMS V2.0
    • Sale/Purchase Software
    • PK’s Function Kit
  • Blogs
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Templates
  • Excel Dashboard
    • Sales Dashboard
    • Process Dashboard
    • Performance Dashboard
    • Project Management
    • Outbound Dashboard
    • Incentive Dashboard
    • Zonal Dashboard in Excel
    • Quick Dashboard
  • Free Templates
  • Power BI
  • About Us
  • Contact Us

PK: An Excel Expert

Excel, VBA and Power BI tutorials

Tag: Conditional Formatting

Paste Special in Microsoft Excel
Excel Tips and Tricks

Paste Special in Microsoft Excel

November 22, 2022November 22, 2022 PKComments Off on Paste Special in Microsoft Excel
Quick Analysis Tool
Charts and Visualization Excel Tips and Tricks

Quick Analysis Tool in Microsoft Excel

October 2, 2022October 2, 2022 PKComments Off on Quick Analysis Tool in Microsoft Excel
Multicolor data bar with REPT function
Charts and Visualization

Multi-color Data bar with REPT function

July 12, 2022July 12, 2022 PKComments Off on Multi-color Data bar with REPT function
Conditional formatting in Excel Chart
Charts and Visualization

Conditional formatting in Excel Chart

May 3, 2022 PKComments Off on Conditional formatting in Excel Chart
Sales Analysis Heat Map
Charts and Visualization

Sales Analysis Heat Map by Time and Day

March 27, 2022March 27, 2022 PKComments Off on Sales Analysis Heat Map by Time and Day
Dynamic Calendar with Task List
Templates

Dynamic Calendar with Single formula

March 13, 2022May 10, 2022 PKComments Off on Dynamic Calendar with Single formula
Send WhatsApp and Email without VBA
Templates

Send WhatsApp and Email without VBA

January 17, 2022January 17, 2022 PKComments Off on Send WhatsApp and Email without VBA
Final Report
Charts and Visualization Excel Tips and Tricks

Conditional Formatting in a Pivot Table with Example

December 6, 2021December 6, 2021 PKComments Off on Conditional Formatting in a Pivot Table with Example
Dashboard

Annual Sales Calendar for Sales Dashboard in Excel

September 5, 2021September 5, 2021 PKComments Off on Annual Sales Calendar for Sales Dashboard in Excel
10 Productivity Tips in Excel
Excel Tips and Tricks

10 Super useful Productivity Tips in Excel

March 7, 2021March 7, 2021 PKComments Off on 10 Super useful Productivity Tips in Excel

Posts navigation

1 2 … 4 Next

Top Categories

  • Charts and Visualization (126)
  • Dashboard (8)
  • Excel Tips and Tricks (52)
  • Power BI (19)
  • Power Pivot (14)
  • Power Point Visualization (5)
  • Predictive Analytics (3)
  • Templates (49)
  • VBA (75)

Read More about..

  • Advanced Excel
  • VBA Course
  • Dashboard
  • Chart and Visualization
  • VBA Tips
  • Excel Tips and Trics
  • Our Excel Products
  • About US
  • Contact Us

 

Subscribe to our Newsletter



Download Free Dashboards

  • Project Management Dashboard
  • Zonal Dashboard
  • Sales Dashboard
  • Outbound Dashboard
  • A Quick Dashboard
  • C-SAT Dashboard
  • Performance Dashboard
  • Process Dashboard
  • Incentive Dashboard

Recent Posts

  • Power BI dashboard with 3D Glass Chart
  • Use of Symbols and Emojis in Excel Drop-down List and Excel Charts
  • Five awesome formulas in Excel
  • Quick 3D Container chart in Excel
  • TEXTSPLIT function with three use cases in Excel
  • LAMBDA Function in Excel with Example
  • Data Transformation to create Comma Separated List automatically
  • Inventory Management Template for Multiple Locations
  • Paste Special in Microsoft Excel
  • Fill Series in Excel
Copyright © 2018 PK-AnExcelExpert.com - Privacy Policy