Six Common Mistakes Made When Using VLOOKUP Function In Excel
Hello Excellers and welcome back on this sunny evening to another #Excel #FormulaFriday blog post in my 2019 series. The VLOOKUP Excel formula or function is like a lightbulb going on when you...
Calculate Average Values Based On A Specific String In In Your Excel Data Using AVERGEIF
Hello Excellers and welcome to another #Excel #formulafriday blog post. Today let's look at how to calculate average values in Excel based on a specific text string. We need to calculate the...
Hello Excellers, it has been a short while since I shared some simple Excel tips. So today I want to share an Excel shortcut with you. So, today let's look at how to quickly box off cells in your...
Working With Time- Converting A Number Into Minutes And Seconds.
Hello Excellers welcome to another #formulafriday blog post where we will look at Excel time. Welcome back if you are a regular and a warm welcome if you are new. I invite you to follow me on...
Use SUMPRODUCT To Count Occurrences Of Specific Words In A RangeOf Cells
Hello, Excellers and Happy Friday!. Yes, Happy #formulafriday. It is time for some more Excel formula fun. Today let's look at how to use the fantastic SUMPRODUCT function to count the occurrences...
Happy Friday Excellers. Welcome back to my next Excel Formula tip or Excel tutorial in this #formulafriday 2019 blog post series. Today I want to share with you how to build on the real useful...