Cancel entry

Hi, Dave here from Exceljet So, today we’re going to tackle the question Why Pivot Tables? And this question comes up a lot when people first run into Pivot Tables, because they’re wondering…why should they care? And you’re trying to explain that pivot tables are really fast, that you can summarize …

Excel has a simple function called LEN, for length, that calculates the number of characters in a text string which is a surprisingly useful function. Let’s take a look. The LEN function takes just one argument: the text you want to count. If I supply the address B5, which contains the text “Susan,” …

In this video, we’ll look at shortcuts for editing cells. First, the keyboard shortcut for editing a cell is F2 on Windows, and Control + U on a Mac. With Excel’s default settings, this will put your cursor directly in the cell, ready to edit. You can also double-click a cell to edit. If you want to …