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: Excel Tips
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...
Macro Mondays – A Quick Macro To Open A Spreadsheet To A Particular Sheet And Cell
This really is a very quick #macromonday tip for you. Have you got a large Excel workbook with lots of worksheets?. It's sometimes really handy to be able to open your workbook straight to the...
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 – Quickly Convert Formulas To Cells Values In Excel
Happy Friday Excellers, and welcome back to some more #formulafriday fun. Today let's take a look at how to easily display only cells values and not the Excel formulas that you have...
Formula Friday – Calculating The Percentage Of A Target Yet To Be Achieved.
Hello Excellers time for more #formulafriday fun. Ever need to know how much you need to score on your last assessment to reach your target score so you know exactly how far away you really are...