Formula Archives - PK: An Excel Expert

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

January 30, 2023October 9, 2024 PKComments Off

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

Excel Tips and Tricks

5 awesome formulas in Excel

January 9, 2023August 6, 2024 PKComments Off

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

Excel Tips and Tricks

IMAGE function in Excel to insert the image in Excel Cells

September 25, 2022August 9, 2024 PKComments Off

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

Charts and Visualization

Multi-color Data bar with REPT function

July 12, 2022March 2, 2025 PKComments Off

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

VBA

COUNTIF by cells background color in Excel

May 10, 2022August 12, 2024 PKComments Off

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

Templates

Send WhatsApp and Email without VBA

January 17, 2022February 18, 2025 PKComments Off

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