profile

Leila Gharani - XelPlus

Navigate the new File Explorer with ease πŸ—‚οΈ

Published 5 months agoΒ β€’Β 5 min read

This issue of Between the Sheets has been inspired by the XelPlus community, as I go back to one of my older videos to highlight the most rewatched topics and answer questions raised in the comments.

In focus today:

  • Best features of Windows File Explorer
  • Great resource to elevate your PowerPoint skills
  • The importance of mental health

By the way, if you were forwarded this message, you can get the free weekly email here.

πŸ“‚ Best features of Windows File Explorer revealed

File explorer received some major upgrades last year, including the long-awaited tabs.

I've recorded a video, and, surprisingly, the tabs weren't the most popular topic covered but rather an older feature that not many people knew about.

There are many useful and often overlooked features under "See more" (the ellipsis), including selection options.

There's "Select all" and "Select none", and there's also Invert selection.

It allows you to easily select multiple non-consecutive files and exclude others. You start by selecting the files you want to exclude (hold down Ctrl if you select more than one). Then go to More > Invert selection. Magic πŸͺ„

You can now copy or delete the selected files, or - another great hidden feature - copy as path (there's also a shortcut for that: Ctrl + Shift + C).

πŸ’‘ You can paste the copied file paths into Excel and use them for various operations, like bulk renaming, batch image processing, automating data import in Power Query, automating backups, or creating hyperlinks in documents.

πŸ€” What other uses can you think of? If you have a cool idea, why not reply to this email with your suggestion - perhaps you'll inspire a future video? 😊

Coming back to the file explorer video, many commenters pointed out that the tabs would be more useful if you could also move them between windows.

Guess what? Microsoft has since updated the experience and it's now possible. πŸ₯³

If you want to move the tab to a brand new window, just drag and drop the tab outside the Explorer window and it will open in a new window!

One option still missing from Explorer is the ability to easily duplicate a tab. Hopefully it will be added soon. Until then, here's a workaround.

Use these shortcuts:

  • Alt + D to activate the address bar,
  • Ctrl + C to copy,
  • Ctrl + T to open a new tab,
  • Alt + D to activate the address bar,
  • Ctrl + V to paste the copied address,
  • Finally Enter πŸ’¦

If you're fluent with your keyboard shortcuts, you can do this quickly (with less sweat).

Still, would be nice to get it done with a single click... A girl can dream πŸ’­πŸ˜‰

​

​Elevate Your Presentations with this Insightful Best Practices eBook by think-cell​
​

Are you ready to take your PowerPoint presentations to the next level?

We're excited to introduce think-cell's comprehensive eBook, designed specifically for professionals seeking to enhance their presentation abilities.

This resource is not just a guide; it's a transformative tool for creating compelling, data-driven presentations.

​
πŸ” Inside the eBook:

  • Practical Insights: Gain insights into creating engaging, persuasive presentations with practical examples.
  • Expert Tips: Learn shortcuts, advanced transition techniques, and the art of effective imagery to captivate your audience.
  • Data Storytelling: Master the skill of integrating data into compelling narratives.

Boosting your presentation skills is a key way to advance your career. It provides you with the opportunity to offer great ideas to leadership teams and present yourself as the person to lead those efforts.

So if you're ready to transform your presentation skills, then get the eBook today and start your journey to excellence: πŸ‘‰ Download your copy.
​

🌟 A Special Thanks to think-cell for sponsoring this newsletter.

​
πŸ€“ Geeky News

πŸ’» Windows app for Mac and iOS

​Microsoft is launching a new Windows App, enabling users to remotely connect to a Cloud PC from various platforms, including macOS, iOS, iPadOS, Windows, and web browsers.

The app acts as a portal to Windows 365, Azure Virtual Desktop, Microsoft Dev Box, and Microsoft's Remote Desktop Services. It's currently available as a preview for Microsoft work or school accounts.

This should make it easier for Mac users to access Windows-exclusive applications like Power BI Desktop.

🎨 AI art in Paint

A few months ago, Microsoft announced Cocreator - a DALL-E 3 integration in Paint. Now the feature is finally rolling out.

Similar to the Image Creator experience in Bing and DALL-E 3 in ChatGPT Plus, it allows you to generate images by describing what you want to see.

You may have to sign up for the waitlist before you start getting creative.

πŸ€– Deep Search in Bing - more comprehensive answers to complex search queries

If you're struggling to come up with good, detailed prompts for AI, this might be something for you. Microsoft Bing is testing Deep Search, a new feature utilizing OpenAI's GPT-4.

Deep Search enhances Bing's existing web search by expanding queries into detailed descriptions and delving deeper into the web to find relevant results often missed in typical searches.

Currently in an experimental phase, Deep Search will be a significant upgrade for users requiring detailed and specific information​.

​

πŸ’š Mental health for long-term growth

Mental health forms the core of a productive, balanced life.

When we're driving somewhere and need gas, we automatically pull over to fill up, no second thoughts. But when it comes to taking a break during a busy work day, somehow it's harder to remember to take time to recharge. We may not visually see our "tank" hitting red, but that doesn't mean it's not happening. Specially during busy days. Those pauses are super important! But all too often they take the backseat to the daily grind.

It was a struggle for me, especially when I was creating the first XelPlus courses and developing my business. It was stressful, but I kept going. The work wasn't about to do itself.

Only with time, I realized the toll it was taking on me and my physical as well as mental health.

All too often, we prioritize work over anything else. And that doesn't apply just to business owners. It's true in any job, role, or profession. You can't derive your self-worth from your work.

Ever since that belated realization, I do take the time to prioritize my well-being.

So, it's been a privilege and a pleasure to be featured in Forbes, in their latest installment of Growth *Not* At All Costs series.

In the article, I got to share some of my struggles, as well as the coping strategies and wellness techniques I adopted since. I took up coaching, as well as meditation, journalling and (self-)hypnosis.

The article features other female business owners who dealt with the same pressure of constant growth and had to find their own mindfulness strategies, like workouts, dance classes, yoga, time spent with family and friends.

None of these are particularly groundbreaking. You'll find similar suggestions in every wellness book, blog, podcast, or doctor's rant πŸ˜‰. But still not enough people actually make time for those simple activities that can make a world of difference.

Trust me, your mind and body will thank you. As will your business, or career, in the long term.

​

πŸ‘ Power Stories

Lukas's story has been inspiring. You should never stop learning and developing new skills.

If you're considering a career change, or wish to move up in your current role, keep your mind open to new opportunities, experiences, and knowledge.

I'm happy to have contributed in a small part to Lucas's journey with the Master Power Query course. Power Query is an incredible tool that can simplify and automate so many processes (freeing up your time to focus on your well-being).

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.

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

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.

Read more from Leila Gharani - XelPlus

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...

5 days agoΒ β€’Β 4 min read

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...

12 days agoΒ β€’Β 4 min read

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...

about 1 month agoΒ β€’Β 4 min read
Share this post