In today's video, I show you how to turn OFF the option of a user Double Clicking in your Excel Pivot Table to drill down into the data. You may not always want users to have access to the...
Posts by BARBARA
How To Remove Duplicates In Excel With Power Query & Create A Unique List Of Values.
Power Query (previously called Get & Transform) in Excel 2016 is a really easy way to manage your data, and removing duplicate records is one of those easy tasks. Follow the easy steps below to...
Want to prank a Colleague?. Make sure they have a sense of humour first. 😬 Learn how to set the Excel Worksheet to scroll backwards or the wrong way. Join me EVERY FRIDAY for #formulafriday and...
Learn how to fit longer text into Excel. Wrap text in an Excel cell. Do you ever have a long line of text in Excel? Sometimes if you have a free text notes column or even longer names or addresses...
Learn how to use the COUNTIF function to count how many positive and negative numbers in an Excel data set. Join me EVERY FRIDAY for #formulafriday and EVERY MONDAY for #macromondays on the...
You may need to change the name of one of your Excel Macros. Don't forget to change the name of your macro if it is attached to a button on is referenced in another Macro. Join me EVERY FRIDAY for...