Happy #formulafriday Excellers. Today we are going a little left of field, and looking at the really useful LEFT Function in Excel. This a a really useful function to have in your Excel toolbox...
Tag: Blog
Formula Friday – Shhhhh…Want To Hide Your Excel Formulas?????….
Hello Excellers, and welcome back to another blog post in my #Excel series. So, something a little different for today's #formulafriday blog. Instead of showing our Excel formulas, I...
Formula Friday – Use The SubTotal Function To Number Rows In An Excel Table.
Hello Excellers time for some handy #formulafriday tips. This week let's take a look at using the SUBTOTAL Function to easily number our rows in an Excel Table. You may want to number...
Formula Friday – Full Marks! Calculating Weighted Exam Percentages…For The Final Grade.
Hello and time for some more #formulafriday fun. Today we are going to look at calculating some weighted average percentages. I looked up the meaning of weighted average and according to...
Formula Friday – Count How Many Cells In My Range Have A Greater Value Than Another Range Of Cells.
Welcome Excellers to another #formulafriday. Today let's look at a scenario which uses the COUNTIF Function in Excel to find the number of cells we have in one range that are greater than another...
Macro Mondays – Create A Macro To Copy Column Headers To All Other Worksheets In My Workbook
Want to do some coding? Me too of course you.. do it is #macromondays after after all. Today let's look at a creating a tiny Excel Macro to remove a lot of work. I always like to share my time...