Tag: excel

What is Excel VBA? A Beginner’s Guide to Macros and Automation

Posted on October 20, 2024October 20, 2024 by DevPaulC

Excel VBA refers to Visual Basic for Applications, a programming language that helps automate tasks in Microsoft Excel. VBA is a powerful tool for creating macros and customizing Excel functionalities....read more

Generating Random Numbers in Excel

Posted on October 10, 2024October 10, 2024 by DevPaulC

How to Generate a Random Number in Excel Using RAND and RANDBETWEEN Functions If you’re wondering how to generate a random number in Excel, there are two main functions that...read more

5 simple Excel XLOOKUP examples

Posted on May 5, 2024May 5, 2024 by DevPaulC

Let's put the new XLOOKUP in Excel to the test with these 5 simple examples. The data below represents a list of serial numbers shipped in boxes to various companies...read more

What is xlookup in Excel

Posted on May 5, 2024May 5, 2024 by DevPaulC

XLOOKUP is the newest addition to the lookup formulas in Excel. If VLOOKUP is a Vertical lookup function and HLOOKUP is a Horizontal lookup function, XLOOKUP is capable of replacing...read more

What is an Excel Pivot Table

Posted on October 21, 2023 by DevPaulC

Pivot tables are Excel's most powerful feature. A pivot table lets you summarize detailed data automatically. In this tutorial you will learn what is an Excel Pivot table and how...read more

Today’s date and time in Excel

Posted on October 21, 2023 by DevPaulC

Use Excel to calculate today's date and today's date and time with the functions TODAY() and NOW() plus variations and keyboard shortcuts. These guides work for Google Sheets as well....read more

Multi-row and Multi-column Pivot Table

Posted on October 21, 2023 by DevPaulC

In the previous tutorials for Pivot Tables we looked at the simple Pivot tables with one row and one column, then we added a category to the data-set to create...read more

How to use a slicer in Excel

Posted on October 21, 2023 by DevPaulC

Slicers in Excel are filters that help slice the data in a modern and dynamic way. Before slicers, filters were the only way to "slice" a pivot table data. The...read more

How to use multiple conditions in the Excel IF function

Posted on October 21, 2023 by DevPaulC

If you want to use multiple conditions in an IF function in Excel, you have to use the AND or the OR function to evaluate all the conditions (two or...read more

Excel Formula: Get day name from a date in Excel

Posted on October 21, 2023 by DevPaulC

Here are a few methods to get a day name (Monday, Tuesday, Wednesday etc) from a date field in Excel. If you prefer video, see the tutorials below. Use Excel...read more