Excel Tutorial Archives - PK: An Excel Expert

Excel form controls turn a static sheet into an interactive tool that anyone can use with a click. In this tutorial we solve three real business problems with the three

Power Query

Merge Queries in Power Query in Excel: Combine Two Tables Without VLOOKUP

September 13, 2026September 13, 2026 PKComments Off

Merge queries in Power Query in Excel to combine two tables in a few clicks instead of writing VLOOKUP formulas. In this tutorial we merge a 350-row Sales Data table

Excel Tips and Tricks

TYPE Function in Excel with Examples

December 24, 2024October 10, 2026 PKComments Off

Are you curious about what kind of data is hiding in your Excel cells? The TYPE Function in Excel with Examples is here to help! This function allows you to

Excel Tips and Tricks

How to use FACT Function in Excel with Examples

December 18, 2024October 10, 2026 PKComments Off

If you’re delving into Excel's mathematical functions, the FACT function is an interesting one to explore. This post will break down how to use the FACT function, covering all you

Excel Tips and Tricks

RANDBETWEEN Function For Decimal Number in Excel

December 8, 2024October 10, 2026 PKComments Off

Welcome aboard! Today, we're diving into the wonderful world of Excel to uncover the secrets of using the RANDBETWEEN function for decimal numbers. Whether you’re a curious beginner, a seasoned

Excel Tips and Tricks

How to use Replace with Wildcard in Excel

December 5, 2024October 10, 2026 PKComments Off

Ever found yourself dealing with messy data in Excel, wishing there was a magic wand to clean it up? If you’re nodding your head, you’re in for a treat! In

Excel Tips and Tricks

TEXTJOIN Function in Excel

November 26, 2024October 10, 2026 PKComments Off

Have you ever wanted to combine data from multiple cells into a single cell but didn’t know the easiest way to do it? Well, you’re in luck because Excel’s TEXTJOIN

Excel Tips and Tricks

VLOOKUP vs XLOOKUP Function in Excel with Examples

November 24, 2024October 10, 2026 PKComments Off

If you’ve ever worked with large datasets in Excel, you’ve likely encountered a situation where you needed to look up specific information based on a unique identifier. That’s where functions

Excel Tips and Tricks

EXACT Function in Excel with Examples

November 23, 2024October 10, 2026 PKComments Off

If you've ever needed to compare two text values in Excel to check for exact matches, regardless of capitalization, the EXACT function is here to help! In this guide, we'll

Excel Tips and Tricks

Filter Function in Excel with Examples

November 18, 2024October 10, 2026 PKComments Off

Excel’s Filter Function in Excel is a game-changer when it comes to working with data. It enables you to quickly locate and display specific records based on your chosen criteria,