Have you ever needed to count the rows in a data set?. There are several methods you can use with Power Query. This blog post demonstrates three ways to check how many rows Excel imports into Power...
Recent Posts
Welcome back to another article in my Power Query series. Let's get back to basics today and answer a common question. Just what is Power Query?. Power Query for Excel is an excellent tool for data...
Are you looking for a way to simplify your data analysis in Excel? If so, then you need to heck out Power Query. Power query is Microsoft's Data Connectivity and Data Preparation technology. This...
𝐉𝐨𝐢𝐧 𝐦𝐞 𝐄𝐕𝐄𝐑𝐘 𝐅𝐑𝐈𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐟𝐨𝐫𝐦𝐮𝐥𝐚𝐟𝐫𝐢𝐝𝐚𝐲 𝐚𝐧𝐝 𝐄𝐕𝐄𝐑𝐘 𝐌𝐎𝐍𝐃𝐀𝐘...
Excel Tip. Show Value And Percent In Same Report- No Formulas!
👍𝐌𝐲 𝐑𝐞𝐜𝐨𝐦𝐦𝐞𝐧𝐝𝐞𝐝 𝐏𝐢𝐯𝐨𝐭 𝐓𝐚𝐛𝐥𝐞...
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...