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...
Happy Monday Excellers, welcome back to the next blog post in my 2019 #macromonday series. Today let's write a quick and easy Excel VBA macro to save an Excel chart as an image file. So, this macro...
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...