EVERYTHING in Power BI Desktop Download the free hi-res CHEAT SHEET + QUICK START VIDEO and build your first Power BI report here: bit.ly/master-pbi 🚀Skills that get you noticed and promoted! #PowerBI #DataVisualization #BusinessIntelligence #DataAnalysis

ABS SIGN REPT TRUNC CELL Five of the most boring-sounding functions in Excel. Most people scroll right past them. But each one fixes a problem you've probably had, and they work in every version of Excel. Here's how they can help you: youtu.be/35i9IrVU_R8 #Excel

Did you know Excel can talk? It's surprisingly useful. See how, plus 8 more handy Excel tricks for the fiddly jobs you do every week. Watch the tutorial and get the free practice file: youtu.be/ImTFk0MZGrU #Excel

Your Excel file shouldn't need a guided tour. I built a navigation bar that lets you click straight to the sheet you need. The tabs stay visible as you scroll. Watch the build and download the free example file: youtu.be/WcYdFXnbzKA #Excel

Excel has a hidden data entry form. Enter records in one window without writing VBA. It even stops you typing over formula fields! Watch the demo: youtu.be/8rbGpU4zj5M Had you come across this before? #Excel

A whole table in one Excel cell. Excel's new Lists and Arrays look pretty cool. Filter items and calculate with data stored inside a cell. Microsoft 365 Insider Beta preview. Watch the video and get the example file: youtu.be/db90wKvunQA Would you use this?

Copilot in Excel is worth another look. Save your preferences, set workbook rules, reuse reporting instructions and connect to other data. Watch the walkthrough to see how: youtu.be/wZ8QAKiIfuo Are you still using Copilot, or did you give up on it? #Excel #Copilot

Your Excel forecast can be perfectly calculated and still be wrong. In this video, I show you how to choose the right method for each income/expense line and build a forecast that updates with new actuals. Watch: youtu.be/OWRFzcRbDTc #Excel

If your leaderboard needs to be sorted by hand, it is already out of date. I built one in Excel that rearranges the rankings whenever the data changes. You can change what to rank, switch the order, and compare groups. Build it with me: youtu.be/f6fP50eonZM #Excel

Still copying formulas down in Excel? Add a row and the formula may not follow. Edit one result and the formula can disappear. Modern Excel can fill a whole column from one formula and adjust as your data changes. I show you how here: youtu.be/vMB87w0C-Jk #Excel

Your Excel report can be wrong even when every formula works. Dates can be stored incorrectly. Extra spaces and duplicate rows can change the result. In this video, I show you how to find and fix the hidden problems before you trust your report: youtu.be/nVxV1KeBSco #Excel

I asked subscribers to send me their messiest Excel files. One looked fine until a new row broke the totals. I rebuilt it so you can add data and refresh the entire dashboard with one click. Watch the full fix and download both files: youtu.be/4Ltsjfps5K0 #Excel

I gave an AI agent 3 Excel files and asked it to do the month-end forecast. It came back with a model I could audit, then learned the process so next month runs itself. It got one thing wrong, and that was the useful bit. Watch what happened: youtu.be/D5pjDpNoKgA #Excel

Most repetitive Excel jobs aren’t hard. They’re just done one cell at a time. Ctrl+Enter changes that. Here are 7 ways to fill gaps, repair formulas and update multiple cells in seconds: youtu.be/d1AQXs3UqO4 #Excel

Excel printing usually gives you two choices: 6 pages for one table. Or font size 2. Neither makes a useful report. Here’s how to make it fit the page and stay readable: youtu.be/HTzHNucfk1E #Excel

A spreadsheet can be brilliant and still be the wrong interface. I asked AI to rebuild my 20-function Excel habit tracker as a mobile app. It kept the logic, then added reminders and ChatGPT insights. See what happened: youtu.be/C2-1HqAfuzQ #Excel #Zite

A habit tracker shouldn’t just record what you did. It should tell you what to work on next. This Excel build turns checkmarks into progress, streaks and a “needs attention” signal. See how it works + get the free template: youtu.be/MRN_W2Bv9sU #Excel #Productivity

ABS SIGN REPT TRUNC CELL Five of the most boring-sounding functions in Excel. Most people scroll right past them. But each one quietly fixes a problem you've probably had, and they work in every version of Excel. Here's what they actually do: youtu.be/35i9IrVU_R8 #Excel

You've been fixing the same Excel problem for years. Reformatting cells as text. Typing an apostrophe first. Clicking "Ignore Error" for the fiftieth time. None of it was necessary. There's a setting for every single one. 15 of them here: youtu.be/AWy6iVmsens #Excel

Someone sends you a general ledger. As a PDF. "Forecast this by Friday?" I gave it to AI instead. It cleaned the data, built the statements, showed its work, and forecast 6 months out. All traceable. 👉 See how Tracelight held up: youtu.be/uPw8lXC5Np4 #Excel #Tracelight

There's a function in Excel that looks completely pointless. One letter: N. Most people scroll right past it. The ones who know what it does never stop using it. Here's the trick: youtu.be/UKBpDL9eJMg #Excel