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.
COUNTIFS secrets
|
Analyzing data is all about sums and percentages. Hold on! Sometimes you need a good old count. For example:
You get the idea. Well, there's a simple Excel function that can do all this. ๐งฎ COUNTIFS - Are You Doing it Right?The COUNTIFS function counts the number of cells in a range that meet one or more conditions. COUNTIFS has been around for a while. But do you know all its secrets? Watch the video to review the basics and learn:
You can follow along with me by downloading this file. ๐ฅ Pivot Table Masterclass: 64% videos recordedFor the past weeks, I've been busy recording videos for our new pivot table masterclass. Pivot tables are amazing. You don't need to worry about getting your formulas right. Or even about that dollar sign. They're like pre-made tables that come with all the answers. Counts included. ๐ There's a lot more to them though than most realize. And a lot that can go wrong. That's why this course, which began as a mini course, became a master class. We're aiming for a September release date. So, if you haven't signed up to our interest list to be notified as soon as the course is live, you can do it ๐ here. ๐ค Geeky News๐ Built-in document editor on ZoomThe video conferencing platform Zoom is launching a word processor. Zoom Docs is built into Zoom Meetings to allow taking notes without switching apps. It includes many meeting-related templates, like brainstorming, meeting agenda, project tracker, and more. Zoom's AI Companion helps you get started. It brings access to AI-generated meeting summaries and transcripts. Zoom Docs is seen as a rival to Word and Google Docs. But it has some spreadsheet-like features too. You can create data tables with filters, sorting, and grouping. You can import .docx, .xlsx, .txt, and .csv files. It's not a direct replacement for the familiar Office tools, though. For example, Zoom Docs are not really intended for printing. The focus is on features that are useful in online collaboration. In that sense, it's more like Microsoft Loop. It has similar formatting options and content blocks that you call up with the / key. Enter / and start typing the command. It lets you embed images, video, and other media. You can also @ mention other users. A free Zoom Workplace account lets you create up to 10 docs without charge. A paid account offers unlimited access. ๐ Draw straight shapes in WordMeanwhile, Word is getting some features from OneNote. Namely, Draw and Hold, which allows you to draw neat shapes with your mouse or digital pen. Draw the shape in a single stroke and wait for a second. Your uneven squiggles get converted into straight lines. Word - and other Office apps - already have the Ink to Shape feature. But this new option doesn't require activating any buttons. You just draw - and hold. Draw and Hold is available from Version 2406 (Build 17726.20016). ๐๏ธ Noise suppression and background removal in ClipchampMicrosoft's video editor, Clipchamp, has two new AI-enhanced features:
Both features are available in the free version for personal and work accounts. ๐ Power StoriesCongrats to Ora on completing Business Charts in Excel! ๐ I'm glad we've helped to remove some of the frustration out of chart creation in Excel. Wishing you many successful presentations to the top management. ๐ Got a success story about using your XelPlus skills? Iโd love to hear it! Hit reply to share the details, and inspire other students ๐ 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! |
Leila Gharani - XelPlus
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.
What do you do when your data goes wide? Picture a sales table with one row per rep, but then Sales_Jan, Units_Jan, Sales_Feb, Units_Feb, and so on, all the way to December. It just keeps growing wider with every month you add. Try to filter by month, or build a pivot table around it, and you're stuck. Month isn't a value in this table. It's baked into the column headers. You need a way to turn the wide into long so that it's ready for analysis. And there's a Python function that does exactly...
Budget versus actual is one of those reports that follows you around if you're in Controlling, FP&A or creating any type of management report for your company. I built versions of it for years. The numbers were never the difficult part. Putting it together so it actually communicated something was the tricky bit. Management always wants to see things from different angles, so it had to work by month and by region. How could I fit it all on one page? Actuals, plan, previous year, variances,...
When I worked in finance, the reports I had to build almost always needed data from different tables. Sales figures sitting in one. Product details in another. And the report needed both. So I did what most people still do. I used VLOOKUP to pull everything into the sales table until it turned into one mega giant table. Ok, these days you'd reach for XLOOKUP, but it's still the same move. It worked, but it was slower and more work than it needed to be. I had no clue there was a cleaner way. I...