Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
Excel Named Ranges is a vast topic that includes some simple techniques that we all can and should use to make our spreadsheets easier to build and maintain. Plus, some more advanced techniques like relative named ranges, which are good to know. Especially for that occasion when you inherit a workbook from an Excel Superuser …
An Excel Named Range is a powerful tool and something we should all be using to make our formulas quick and easy to write and read. I’m not going to cover the basics of creating a named range as I’ve done that elsewhere. However I want to remind you of the different types of names …
I get a lot of questions from members and visitors to our site asking for help with formulas. It’s not surprising given they are one of the most useful Excel features. However, one of the repeating problems I’ve noticed recently are formulas that are not written efficiently. When I say ‘efficient’ I mean efficient for …
How much time do you spend editing the ranges referenced in your formulas because you’ve added new data to your source? This is what I’m talking about; let’s say you have some data in columns A:E: And in columns G and H you have a summary of the data, in this example, sales by Salesperson: …
Excel Named Ranges enable you to give one, or a group of cells a name other than the default D3 for a single cell, or E3:F50 for a range of cells. Let's look at a simple example of how you might use a Named Range. Say you had a range of cells containing sales figures, …
