• 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: VBA Function

Countif by Cell Background Color
VBA

COUNTIF by cells background color in Excel

May 10, 2022May 10, 2022 PKComments Off on COUNTIF by cells background color in Excel
Ratio Calculation in Excel
Excel Tips and Tricks VBA

Calculate Ratio in Excel

January 23, 2020January 23, 2020 PKComments Off on Calculate Ratio in Excel
Shell in VBA
VBA

Shell Function in VBA

January 20, 2020January 20, 2020 PKComments Off on Shell Function in VBA
RandBetweenText Function
VBA

RandBetweenText Formula in Excel

December 4, 2019December 16, 2019 PKComments Off on RandBetweenText Formula in Excel
Word Count in Excel
VBA

UDF to get the frequency of specific word in a Paragraph

August 22, 2019February 6, 2023 PKComments Off on UDF to get the frequency of specific word in a Paragraph
Shell Function in VBA
VBA

Shell Function in VBA with Example

June 14, 2019June 14, 2019 PKComments Off on Shell Function in VBA with Example

Top Categories

  • Charts and Visualization (126)
  • Dashboard (8)
  • Excel Tips and Tricks (54)
  • 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

  • Common Errors in Excel formulas and how to fix them
  • How Chat GPT can help to write Complex Excel Function, VBA code and DAX for Power BI
  • 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
Copyright © 2018 PK-AnExcelExpert.com - Privacy Policy