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:
My latest video covers all of the best new features in Microsoft Excel. These could make a huge difference to your workflow!
If you’re not already using these features, give them a try!
There’s more in-depth information in my video.
Scraping public web data is a challenge, and without the right tools scraping data at scale is almost impossible.
That’s why I’m introducing you to the world's leading web data platform Bright Data, who have developed the revolutionary Scraping Browser!
It manages all website unlocking operations under the hood, and automatically adjusts to handle IP blocks, CAPTCHA solving, fingerprints and more. You can run hundreds of Scraping Browsers asynchronously so you can get the data you need in minutes!
Thank you to Bright Data for sponsoring this issue. 🙏
👩🎨 Office has a new default theme (Currently Insiders)
Excel (and the rest of the Office suite) now has a new theme. Here are some of the biggest changes:
📊 Excel - Share a section of your Excel file (Desktop Current Channel & Excel Web)
You can now link directly to a section of your workbook, instead of sharing the whole thing. This is often safer and more efficient.
Here’s how to do it in Excel for Desktop:
📱Microsoft 365 - Insert photos from Android phone into Word, Excel, and PowerPoint for Windows files
You can now transfer images to a Word, Excel, or PowerPoint file from your Android phone using a wireless connection! No more emailing or multiple steps.
But there are two requirements:
🎰 I’m Hosting an Excel Gameshow on ESPN8
Something very exciting is coming your way…
At 7 AM (ET), August 4, Excel Esports takes the Spotlight on "ESPN8: The Ocho"!
The show is an adrenaline-pumping Excel Esports Elimination Battle: 8 Excel enthusiasts will be competing in a fierce 30-minute battle, but every 5 minutes one of them will be eliminated.
You can watch the teaser trailer here. The show is hosted by myself and my wonderful MVP friends Bill Jelen (aka MrExcel) and Oz du Soleil!
Thank you to Maria for this lovely review of my Master New Excel Functions in Office 365 course. She’s right, there are a lot of new functions to keep track of, but they’re very powerful once mastered!
Happy to be your data-manipulating guru Maria 💚
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 400,000+ students 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...