Excel Tips – EXCEL POWER USER

How to Calculate The Percentage Discount in Excel

𝐉𝐨𝐢𝐧 𝐦𝐞 𝐄𝐕𝐄𝐑𝐘 𝐅𝐑𝐈𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐟𝐨𝐫𝐦𝐮𝐥𝐚𝐟𝐫𝐢𝐝𝐚𝐲 𝐚𝐧𝐝 𝐄𝐕𝐄𝐑𝐘 𝐌𝐎𝐍𝐃𝐀𝐘...

Excel Tip. Show Value And Percent In Same Report- No Formulas!

👍𝐌𝐲 𝐑𝐞𝐜𝐨𝐦𝐦𝐞𝐧𝐝𝐞𝐝 𝐏𝐢𝐯𝐨𝐭 𝐓𝐚𝐛𝐥𝐞...

Excel Find And Replace Trick. (Match Entire Cell Contents)

In Today's video, I show you how to use the Excel Find and Replace functionality to replace just the values you need to. Need to replace cells with just zero (0), but do not want to affect the cells...

Prevent Pivot Table Drill Down Into Data

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...

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...

Evil Halloween Excel Tip. Backwards Scrolling Worksheet

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...