Macro Mondays – Write A Macro To Set All Pivot Table Data Items To Sum
Hello, welcome to Macro Monday, and it is time for some more Macro fun. Have you noticed that when you create a Pivot Table, Excel by default will either SUM or Count your items. To read more...
Formula Friday – Sum Formula Not The Best Solution? Try Subtotal!
Today's Formula Friday will be looking at the Sum Function vs the Subtotal Function. If you want to download the Formuala Friday examples you can so so here [wpdm_package id='10703'] Even...
Formula Friday – 2 Ways to Switch First And Last Names In Cells In Excel
Today's blog post was actually a question from one of my colleagues at work earlier this week, they had a list of first and surnames of employees, separated by a comma, with the surname first and the...
Formula Friday – Using Keyboard Shortcuts To See Precedent or Dependent Cells In Excel
Today let's look at how to use Excel keyboard shortcuts to see Precedent or Dependent Excel cells in an Excel workbook. I use these two commands to easily audit my Excel formulas. Cells that are...
Formula Friday – Whats The Difference Between An Excel Formula and A Excel Function?
Let's get back to basics today in #formulafriday and discuss something I am asked quite frequently about...... What is the difference between a Formula and a Function in Excel? If you use Excel as...
Hello Excellers, Friday again and I have a really quick, easy and really useful way to use named ranges you have already created into your formulas. If you need more details on creating named...