excel - Easy Simple Smart

How to use VLOOKUP in Excel

Posted on February 7, 2023February 7, 2023 by Paul

Excel Vlookup is the most powerful formula in Excel. Also vlookup is one of the formulas that are least used because so many users are scared of it. In this tutorial you will learn: how...read more

How to use multiple conditions in the Excel IF function

Posted on January 19, 2020 by Paul

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 more conditions). All conditions evaluated...read more

Excel Formula: Get day name from a date in Excel

Posted on September 27, 2019 by Paul

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 TEXT formula The Excel Text...read more

What is Excel VBA

Posted on September 27, 2019 by Paul

Excel VBA refers to Visual Basic for Applications programming language. This is a variant of the Visual Basic programming language designed specifically for Office Applications. VBA can be used in Excel, Word, Outlook, Powerpoint and...read more

How to use a slicer in Excel

Posted on September 24, 2019 by Paul

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 slicers were a step forward...read more

Today’s date and time in Excel

Posted on September 23, 2019 by Paul

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. Today's Date To simply add...read more

Generating Random Numbers in Excel

Posted on September 21, 2019 by Paul

If you want to build a Random Number Generator in Excel, there are two functions to generate an Excel Random Number. The two functions are called RAND() and RANDBETWEEN(). The first function is generating a...read more

What is xlookup in Excel

Posted on September 18, 2019 by Paul

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 them both by performing the...read more

Multi-row and Multi-column Pivot Table

Posted on September 14, 2019 by Paul

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 a multi-row pivot table. In...read more

What is an Excel Pivot Table

Posted on September 12, 2019 by Paul

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 to create an Excel pivot...read more

Easy Simple Smart

Digital Products

Tag: excel