Happy Friday Excellers. Time for some more Formula Fun. Today I want to show you how to use SUMIF in Excel to sum only the POSITIVE numbers in your data set. Let's take an...
Tag: Excel Tips
IHello Excellers, welcome back to today's #excel #macromonday blog post in this 2019 series. Today I will show you how to add your own Excel macros you have written to the ribbon. With Excel...
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...