Excel Tips Archives - Page 12 of 14

XLOOKUP and XMATCH Function Step by Step Tutorial

July 12, 2020September 16, 2024 PKComments Off

In this article, You will learn how to use XLOOKUP and XMATCH Function in Microsoft Excel. XLOOKUP is very powerful functions. This function is currently available to Microsoft 365 subscribers

Excel Tips and Tricks

Wildcard in Microsoft Excel

June 21, 2020October 3, 2024 PKComments Off

In this article, you will learn how to use Wildcard in Microsoft Excel. Wildcard is very useful in excel and can make your work very easy. What is Wildcard? Wildcards

Excel Tips and Tricks

Pivot Table Super Tips in Excel

February 16, 2020October 7, 2024 PKComments Off

In this article, we have used two excel super tips for pivot table. You can use this tips in your excel report wherein you use pivot table. Below are the

VBA

Shell Function in VBA

January 20, 2020October 8, 2024 PKComments Off

Shell Function in VBA can run executable program and returns a Variant (Double) representing the program's task ID if successful otherwise, it returns zero. Syntax Shell(pathname, [ windowstyle ]) pathname:

VBA

Goal Seek in Excel using VBA

October 25, 2019September 19, 2024 PKComments Off

In this article, we have used a Goal Seek Goal Seek in Excel using VBA to get required minimum sales to meet the Sales % target using VBA. You can

VBA

Loop Through in Worksheets, Sheets & Chart in VBA

September 30, 2019October 2, 2024 PKComments Off

In this article, we have explained the difference between Chart Sheet and Worksheet in Excel. We have also explained how to loop through the Charts, Sheets and Worksheets Loop Through

VBA

Create Auto Table of Contents in Excel Workbook

September 5, 2019September 24, 2024 PKComments Off

In this article, you will learn how to Create Auto Table of Contents in Excel for any active workbook using VBA. We have created VBA code which you can put in

Excel Tips and Tricks

Auto Bullet Points in Excel

August 16, 2019September 29, 2024 PKComments Off

In this article, you will learn how to add Auto Bullet Points in Excel using Custom formatting. To add the auto bullet point in excel range below are the steps-

Excel Tips and Tricks

Apply Same Format on other Charts

July 29, 2019October 2, 2024 PKComments Off

In this article, you will learn how to apply the Same Chart Format on the other Charts. Let’s say we have month-wise sales data chart and we do some formatting