Hello, Excellers welcome back to another #Exceltips blog post in my 2021 series. Today let's look at using the Paste Special Function in Excel. Have you a worksheet with the % (percentage)...
Tag: Excel
Hello, Excellers. Welcome to another Excel Tips post in my 2021 series. In this blog post, I will share with you how to quickly remove blanks or spaces from your data set. This super quick method...
Formula Friday – Calculating A Rolling Or Moving Average Using The OFFSET Function
Hello Excellers and welcome to another #Excel #FormulaFriday blog post in my 2021 series. Today I want to share how to calculate a rolling or moving average in Excel. Calculating...
Hello Excellers, welcome back to another #FormulaFriday #Excel blog post in my Excel 2021 series. Do you need to know how what discount has been applied to a product?. If you need to calculate the...
Hello Excellers welcome back to another #Excel #FormulaFriday in my 2021 series. Today I want to show you how to extract the first letter of a first and second name without using Excel formulas. We...
Hello Excellers, welcome back to another #Excel #FormulaFriday blog post in my 2021 series of Excel formula tips. So, due to a colleague asking about the GETPIVOTDATA function (which seemed to cause...