Hello Excellers, welcome back to another #FormulaFriday, in my Excel 2020 series. Today it is a somewhat zippy quick Formula tip. I will show you how to move your formula quickly around your Excel worksheet without changing cell references. Relative cell referencing in Excel is one of it's most powerful features. But, when you copy a formula to a new location in your worksheet or workbook, then all of the relative cell addresses also change. I dont always want this to happen. Sometimes … [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 is … [Read more...]
Formula Friday – Calculating A Rolling Or Moving Average Using The OFFSET Function
Hello Excellers and welcome to another #Excel #FormulaFriday blog post in my 2020 series. Today I want to share how to calculate a rolling or moving average in Excel. Calculating moving averages can be a really useful way to look at trends in data. For example, I want to know the last 3 months average sales of my Beanie Hats. I always want to analyze the last or latest three months, even when my new monthly sales data is added into my spreadsheet. I, therefore, need the calculations to … [Read more...]
Formula Friday – 3 Ways To Protect Your Excel Formulas
Hi Excellers, this is a different #formulafriday in my Excel 2020 series. I want to share with you 3 ways to protect your Excel formulas. So, you have spent a long time preparing your Excel spreadsheet solution, and I bet you don't want anyone to mess up it up. So there are a few ways to protect some of those most vulnerable parts of your Excel spreadsheet. Here are my top 3 ways to protect your Excel Formulas!! Hide them Lock Cells Hide The Formula Bar With Some Simple VBA. 1.Hide … [Read more...]
Formula Friday- Generate Unique User Names In Excel Using The COUNTIF Function
Happy Friday Excellers. Today let's look at how to generate unique usernames in Excel using the COUNTIF function, even when you have duplicates!. Welcome back for another #FormulaFriday in my #Excel 2020 series of Excel blog posts. I have used this formula to generate usernames for a database. Sometimes there are more than one person with the same name. This great formula in Excel will helps us get over this issue. Here is a list of usernames that has been recently updated with new users. … [Read more...]
- 1
- 2
- 3
- …
- 38
- Next Page »
Recommended Excel Resources
