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.
3 things we’re covering today:
I was looking at my YouTube analytics for the first half of 2022, and my most-watched video was this one: 7 Things You’re Doing Wrong in Excel.
So I figured I’d give you a refresher!
Here are 3 of the important ones that resonated most with our viewers:
There is a time and place to use merge cells - usually at the top of your report.
But never merge cells in the middle of your datasets!
It looks good, but makes selecting just the right-hand column a real hassle, because you end up selecting all of your cells.
Instead, use Format Cells → Alignment → Center Across Selection. This gives you the same visual effect, but you can select cells as normal.
Have you ever encountered a situation where your text is getting too long for a single cell? Instead of manually cutting and pasting the content into multiple cells, there's a simpler way to handle this:
That's it! By following these steps, Excel will automatically adjust the text within the cells, accommodating the desired split.
No manual cutting, pasting, and realigning required.
Do you find yourself manually updating charts, formulas, and formatting when new data is added? Converting your data into an Excel table can save you time and effort while ensuring automatic updates.
The steps:
Voila! The formatting is automatically applied to your data.
To customize the table further, select "None" from the format options and apply your desired formatting manually (if you’ve watched my videos, you’re probably not surprised by this move 😊).
For the other four mistakes, watch my video!
I’m thrilled to introduce Numerous.ai - an AI plugin for Excel and Google Sheets that’s here to revolutionize your workflow!
It lets you use ChatGPT as a formula inside of Excel and Google Sheets to automate repetitive tasks.
Just type AI=() then describe what you want:
Use Numerous.ai to automate busywork like:
Anything you can do for one thing with ChatGPT, you can now do for a thousand things at once by simply dragging down the =AI() formula!
And it’s hassle-free: no macros, rate limits, or API keys.
Get Numerous.ai for free right now, either for Excel (numerous.ai/excel) or for Sheets (numerous.ai/sheets).
Thank you to Numerous.ai for sponsoring this issue 🙏
📊 Excel - Formula Suggestions (only Excel web for now)
Talking about AI, Formula Suggestions is now available to all Excel web users with English set as their primary language. It streamlines your formula creation process by offering relevant suggestions based on your data and context.
Just type "=" at the beginning of a cell, and Formula Suggestions will show you different formulas that you can apply, along with a specified range.
📊 Excel - Formula by Example (also available only in Excel for the web for now)
Formula by Example is the dynamic version of Flash Fill. It looks for patterns as you enter data in the worksheet, and offers a formula to fill the rest of the column if it recognizes a pattern.
This feature currently supports tables only but Microsoft plans to roll it out to non-table ranges as well.
📊 Excel - New Guided Reapply Feature
Let’s say you’re in an Excel file together with two of your colleagues… and your connection gets interrupted. You’re then prompted to either “Save as” or “Discard” your changes so you can get back to the file. But with the new Guided Reapply feature, you can review the changes and return to the file without worrying that some changes might have gotten lost!
👥 Teams - New Animated Backgrounds
You can now have a dynamic animation behind you in Teams meetings, for a more immersive experience! Before a meeting starts, on the pre-join screen, select Effects and Avatars>Video effects and select your background.
Only pre-defined animated backgrounds from Microsoft are supported at the moment.
A friend sent me this Excel ad from 1990. It’s unbelievable how things have changed. Although not everyone in the YouTube comments feels the same. 😆
Another person just completed my new Automate with Power Query course! Thank you for the kind feedback Peter 💚
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
▶️ Subscribe on YouTube
🖇️ Follow me on LinkedIn
🥇 Join 300,000+ people in our courses
📣 Want to sponsor XelPlus Weekly? Get in touch 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 XelPlus Weekly and bring you updates like this. Thank you for your support!
Helping you easily overcome data challenges with Excel & Power BI
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.
Thinking VLOOKUP is dead now that we have XLOOKUP? Think again. It's still used across thousands of spreadsheets. It has some limitations, but if you're aware of them and use it correctly, you'll get the job done quickly. Also, this edition of Between the Sheets includes: Power tools making a difference Better technical answers from ChatGPT Solution for tab hoarders If you were forwarded this message, you can get the free weekly email here. 🎬 Master VLOOKUP for effortless reporting In my...
Today, we're diving deeper into Excel's View tab to show you some lesser-known, yet incredibly handy features that will change the way you manage your workbooks. Also in focus: sharing views in Excel for the web AI writing assist in any online text box OneDrive offline capabilities If you were forwarded this message, you can get the free weekly email here. Master the Window options in Excel's View tab A while ago we covered the magic of Freeze Panes. But there are other buttons in the View...
We’re almost done with our New Excel Business Charts Course and it’s looking great! I'm currently reviewing the final videos. Meanwhile, the team is busy finalizing the cheat sheets, lesson notes, and quick guides. This morning, I reviewed the lecture "How to Pick the Right Chart". And wow! It took me right back to my corporate job, staring at the screen, wondering, "How on earth do I make this data tell a story?!". There was SO MUCH to show. Picking the right chart might seem easy, but...