|
We all want dashboards that look professional. But a dashboard that looks good and doesn't tell you much? That's more decoration. Your manager sees $2.3M in revenue displayed front and center. Okay. Now what? Is that good or bad? Better than last year? Did we hit target? Without context, that number means nothing. Power BI's new card visual (now generally available) lets you add that context right into your KPIs. Previous period comparisons. Target indicators. Professional design with meaningful insights. Plus, it's quite satisfying to create. βSee for yourself. Way more flexible than the old card visual. And way easier than building custom layouts from scratch. Lots of room to get creative. π€ Geeky NewsποΈ Notepad gets tablesWindows 11's Notepad now supports tables (currently available to Windows Insiders). Click the Table button in the formatting toolbar, pick your rows and columns, and you're done. You can add or remove rows and columns with a right-click. The once basic text editor has been adding more formatting options, like bold, italic, bullet points, since the beginning of the year. The good news is that it remains fairly lightweight. BTW, if you're using Notepad++ (a more powerful editor popular among developers), make sure you update to the latest version to fix a security bug. π¬ Word comments get a refreshWord for the web just updated its commenting interface. Cleaner design. New icons and buttons. Better layout. The useful part? Selected comments are highlighted while the rest fade to gray. Makes it easier to focus on the feedback you're dealing with. This got me thinking: Comments work across Word, Excel, and PowerPoint. The experience is similar but not identical. Each app develops them separately. So you get features in one that don't show up in the others. A bit frustrating when they could just keep them in sync. π Why We Canβt Quit ExcelBloomberg just published a feature on Excel's history, its dominance today, and where it might be heading. I got to contribute a few quotes alongside other Excel experts and the people who built the app. I talked about my relationship with Excel. When I first started working, it was definitely not a tool I'd open and think "Oh my God, I love this." But the more I learned what it could actually do, the more I appreciated it. That's how it works with most tools. You stop fighting the shortcomings and start seeing what's possible. And Excel is just always there. In every finance department, every business, every laptop. It's part of how we work. Forty years in. Read the full article here (Bloomberg subscription required). π Building What the Team Actually NeedsCongrats to Anton on completing Fast Track to Power BI π Here's what changed: he stopped building dashboards to show off cool features. Started building them to answer specific questions. His whole project team can now spot issues they'd never catch in raw data. Think about your own dashboards. Are they answering questions or just displaying data? See you next week, Leila Want more?βΆοΈ Subscribe on YouTubeβ ποΈ Follow us on LinkedInβ π₯ Join 400,000+ students in our coursesβ π£ Want to sponsor Between the Sheets? Get in touch here. π¨ If you were forwarded this message, you can get the free weekly email here. This newsletter contains affiliate links, which give us a small commission on any purchase made at no cost to you. This helps us run Between the Sheets and bring you updates like this. Thank you for your support! |
XelPlus is a leading online education company, providing training courses for Excel, Power BI, Finance, and Google Sheets. XelPlusβ bestselling courses are popular among financial analysts, CFOβs, and business owners. Technology is changing fast. We help our members turn confusion into confidence with every skill learnt.
You import a CSV in Power Query... Dates have errors. Numbers won't calculate. What just happened? Here's what's usually happening. Your computer is reading the file with your regional settings. So if your CSV uses commas as decimal separators (like 1,5) but your system expects dots (like 1.5), Power Query gets confused. Same with dates. Is 04/05/2025 April 5th or May 4th? Depends on where you are. The fix: Change Type Using Locale. But here's the part that trips people up - order matters....
Let's say you're waiting for colleagues to submit the latest data. You need to check if the files came in. And if the data is complete. So you start opening files one by one. It's tedious. And completely avoidable. When Microsoft released the new IMPORTCSV function, I wasn't ready to throw Power Query out the window. It still handles far more sources and does things this new function simply can't. But it got me thinking. What if you could peek at a CSV without fully loading it? Just enough to...
Excel's chart formatting menu is dangerous. Not because it's bad. Because it gives you too many options. And some of them have no place in a professional report. Take this social media trend: pasting images directly into your chart bars. Looks creative. Gets lots of views on YouTube. But would you put that in front of your manager? In just a few extra clicks, the same data can look like this: Same logos. Matching brand colors. Just used with intention. π Watch: How to build this chart in just...