New: NextGenTemplates Academy - video courses on Excel formulas with AI and Pivot Tables & dashboards. Early-bird: 20% off with code EARLYBIRD20 - first 20 orders only. See the courses →
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Tag: Formula

Excel Tips and Tricks

How Chat GPT can help to write Complex Excel Function, VBA code and DAX for Power BI

January 30, 2023October 10, 2026 PKComments Off on How Chat GPT can help to write Complex Excel Function, VBA code and DAX for Power BI
Introduction Have you ever tried to write a complex Excel function, VBA code, or DAX using natural language? It can be challenging and time-consuming. If this is your situation, then
Read More
Awesome formula tricks in Excel
Excel Tips and Tricks

5 awesome formulas in Excel

January 9, 2023October 10, 2026 PKComments Off on 5 awesome formulas in Excel
In this article, we will explain you 5 awesome formulas in Excel. You will learn 5 new formulas in Excel. we have explained WRAPROWS, WRAPCOLS, TOROW, TOCOL and ARRAYTOTEXT function
Read More
Image Function in Excel
Excel Tips and Tricks

IMAGE function in Excel to insert the image in Excel Cells

September 25, 2022October 10, 2026 PKComments Off on IMAGE function in Excel to insert the image in Excel Cells
Image function is used to insert the image from a website into Excel cells. It can be the part of an Excel Table so you can use the sort and
Read More
Multicolor data bar with REPT function
Charts and Visualization

Multi-color Data bar with REPT function

July 12, 2022March 2, 2025 PKComments Off on Multi-color Data bar with REPT function
In this article, we have created multi-color Data bar with REPT function in Excel. We have used the conditional formatting to change the color based on certain criteria. Multi-color Data
Read More
Countif by Cell Background Color
VBA

COUNTIF by cells background color in Excel

May 10, 2022October 10, 2026 PKComments Off on COUNTIF by cells background color in Excel
COUNTIF is an extremely useful function in Microsoft Excel. We use this function to get the count based on some conditions. Here in this article, we have created a user-defined
Read More
Send WhatsApp and Email without VBA
Templates

Send WhatsApp and Email without VBA

January 17, 2022February 18, 2025 PKComments Off on Send WhatsApp and Email without VBA
In today's fast-paced world, communication has become an integral part of our lives. We need to stay connected with our colleagues, friends, and family. WhatsApp and Email are two of
Read More
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy