Hello Excellers and welcome back to another #Excel #FormulaFriday blog post in my Excel 2020 series. Today I want to show you how to not only hide your Excel formula from users but lock those cells. This will prevent any user from attempting to edit your formulas. Keep your hard work away from prying eyes right?. Note. I am not claiming this is 1oo% foolproof but will prevent the average Excel Joe user busting out your Excel Dashboard, or worksheet solution. If you have created a great … [Read more...]
Is Your Deadline Approaching?. Get A Reminder In Excel.
Hello Excellers and welcome back to another #Excel tip in my #FormulaFriday 2020 series. Need to get a reminder in Excel?. Today, let's look at using the NETWORKDAYS function to get a reminder in Excel if your task deadline is approaching. This approach would be very useful for projects and reporting schedules. Do you need to know or reminded that your deadline day is approaching fast or you have a little bit of wriggle room left and are ahead of schedule?. Well, it is one date that … [Read more...]
Using A Dynamic Column Reference With VLOOKUP
Hello Excellers and welcome back to another #Excel #FormulaFriday blog post in my 2020 series. Today I will show you to use a dynamic column reference with the VLOOKUP formula. Working with large data sets you may need your VLOOKUP to dynamically update the COLUMN argument as you copy or drag your formula across. If you do then you need to know how to use VLOOKUP with the COLUMN function. Step Back. The VLOOKUP Formula Syntax. Let’s take … [Read more...]
Using Column And Row Labels As Named Ranges
Hello, Excellers. Welcome back to another #FormulaFriday #Excel blog post in my Excel 2020 series. Today I will show you two ways in which you use Column and Row labels as named ranges. About Named Ranges. A named range is simply a name that refers to either a cell, a range of cells, a constant value or a formula. These names can then be used in a formula to replace a constant value or a cell reference. If you want to read more about named ranges I have a blog post right … [Read more...]
Absolute References With Excel Tables.
Hello, Excellers. Welcome back to another #FormulaFriday #Excel blog post in my 2020 Excel series. Today's blog will show you all you need to know about how to use Absolute (and Relative) references when you are using an Excel table and structured references. Absolute Cell References. I think one of the most useful and first thing we learn when using Excel is the value of using the $ symbol. (Or the F4) key. This allows you to freeze a column or row, so when dragging a formula down a … [Read more...]
- 1
- 2
- 3
- …
- 32
- Next Page »
Recommended Excel Resources
