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

LAMBDA function in Excel
Excel Tips and Tricks

LAMBDA Function in Excel with Example

December 19, 2022December 19, 2022 PKComments Off on LAMBDA Function in Excel with Example
Image Function in Excel
Excel Tips and Tricks

IMAGE function in Excel to insert the image in Excel Cells

September 25, 2022September 25, 2022 PKComments Off on IMAGE function in Excel to insert the image in Excel Cells
Quick Productive Tips in Excel
Excel Tips and Tricks

Quick Productive Tips in Microsoft Excel

August 8, 2022August 8, 2022 PKComments Off on Quick Productive Tips in Microsoft Excel
TEXT Function in Excel
Excel Tips and Tricks

TEXT Function Use Cases in Excel

April 11, 2021April 11, 2021 PKComments Off on TEXT Function Use Cases in Excel
XLOOKUP
Excel Tips and Tricks

XLOOKUP and XMATCH Function Step by Step Tutorial

July 12, 2020July 12, 2020 PKComments Off on XLOOKUP and XMATCH Function Step by Step Tutorial
Word Count in Excel
VBA

UDF to get the frequency of specific word in a Paragraph

August 22, 2019August 22, 2019 PKComments Off on UDF to get the frequency of specific word in a Paragraph
Evaluate Formula
VBA

UDF for Evaluate a Formula in Excel

April 18, 2019April 18, 2019 PKComments Off on UDF for Evaluate a Formula in Excel
VBA

VLOOKUP by cell background color

May 13, 2018May 13, 2018 PK0

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