Hello, Excellers. So, welcome back to another Excel blog post in my #Excel Formula Friday 2020 series. Today, we deal with a formula error. Let me show you how to deal with the #DIV/0!, divide by zero error in Excel. We have all been there I am sure, all is going well when you have written your Excel formula. You have dragged it down your column of data and there it is, one big ugly divide by zero formula error. Some Excel users do not mind the #DIV/0!, divide by zero error. I am not … [Read more...]
Hide Excel Formulas And Lock Cells To Avoid Editing.
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...]
- 1
- 2
- 3
- …
- 39
- Next Page »
Recommended Excel Resources
