We asked over 800 users about their favorite Excel shortcuts in a survey. In this video, Dave shows you more than 30 of the most popular Excel shortcuts in action. Also see this video onShortcut Recipes. The practice file is attached below. Resources to help you Learn Excel shortcuts

In the worksheet, cell E2 is named “date”. Here is another article onConditional formatting based on a different cell. If both return TRUE, AND returns TRUE and the conditional formatting is triggered. The formula looks like this: There are two main parts of the formula. On the right, the same thing happens with the date in date ($E$2). Effectively, this ignores day completely by making it the same for each date....

I just want to give you some ideas about how you could use pivot tables with your own data. First, you might want an overview of your time by week. The website is a portal that provides product information to partners. You open up the data and take a look. There are more than 30,000 users in there! The data looks something like this: Lots of user data. Emails are fictitious, of course!...

Let’s take a look. First and foremost is the worksheet. Each Excel workbook can have an unlimited number of worksheets. Worksheets appear as tabs at the bottom of an Excel workbook window. The worksheet is the main work area in Excel. Worksheets are made up of cells, displayed in a grid created by the intersection of rows and columns. At the bottom and right edges of worksheets, are scroll bars....

The ribbon contains every command you’ll ever need in Excel, grouped by logical function into tabs. It’s a great way to explore what Excel can do. Let’s take a look. The ribbon is divided into tabs. Each tab contains logically grouped commands, further sub-divided into Groups. Clicking this arrow brings up more related commands. The first tab is called File. The file tab allows you to go “backstage”, in Microsoft’s parlance....

The File tab is also sometimes referred to as “backstage”. Let’s take a look. Next is the Info pane. On the left side of the Info pane is file property information. This includes the date the file was created and last modified, as well as author information. The Recent pane gives you access to recently opened workbooks and recently used folders. We cover the Recent pane in detail in an upcoming lesson....

The article below explains 3 ways to do this. The first two methods require a current version of Excel. The last (and more complex method) is an array formula that will work in Excel 2019. Next, theLEFT functionextracts the first character from each word in the array created by TEXTSPLIT. The final result is an array of the first letters of each word. The result is an array of ASCII numbers....

Because we are using VLOOKUP, the full name must be in the first column. For simplicity, the table has been named “states”. The final argument, range_lookup, has been set to zero (FALSE) to force an exact match. VLOOKUP locates the matching entry in the “states” table, and returns the corresponding 2-letter abbreviation. This same approach can be used to lookup and convert many other types of values. For example, you could use VLOOKUP to map numeric error codes to human readable names....

Excel is an incredibly powerful utility, but it’s also complicated. I love finding simpler ways to solve tricky Excel problems, then explaining those solutions clearly and concisely. Exceljet is exactly the resource I wish I’d had when I first started learning Excel. 100% human It’s 2025, and we suddenly find ourselves competing with AI-generated content everywhere. Each week, I take a detailed look at a specific Excel formula or function....

ABS converts negative numbers to positive numbers. Positive numbers and zero (0) are unaffected. The ABS function takes just oneargument,number, which must be a numeric value. Ifnumberis not numeric, ABS returns a #VALUE! However, when A1 is greater than B1, the result will be negative. Square root of negative number TheSQRT functioncalculates the square root of a number. If you give SQRT a negative number, it will return a #NUM!

Unlike arelative reference, an absolute reference refers to an actual fixed location on a worksheet. To create an absolute reference in Excel, add a dollar sign before the row and column.

About This Shortcut This shortcut will accept and apply the controls in the dialog box. Related videos The videos below demonstrate this shortcut.

About This Shortcut This shortcut will accept a function suggested by autocomplete. Related videos The videos below demonstrate this shortcut.