Skip to main content
AmigoFish

Leila Gharani

Leila GharaniVideo

Format:
YouTube channel
New videos:
Weekly
Typical length:
about 9 minutes, not counting Shorts
Latest video:
Not rated yet

About this show

Why does everything get taught more complicated than it needs to be? Excel, Power BI, Power Query, Python in Excel, Finance, I cover it all here and go deeper in my courses. I'm excited about AI and the impact it's having on how we work.

I'm not a fan of being restricted to specific topics. I love understanding things deeply, and I love sharing what I find. That's why you'll even find a Rubik's Cube video on this channel.

🎓 My background: MA in economics / Economist / Business Consultant / Accounting Systems Expert / Oracle & SAP implementations (for Finance) / Teacher & Microsoft MVP

500,000+ professionals have taken my courses at XelPlus.

Join here 👉 https://www.xelplus.com/courses/

Videos come from the channel's public YouTube feed. The artwork is the newest video thumbnail. Last updated . Names, artwork and text belong to their publishers.

Cosmos

Similar by topic and creator

See the full Cosmos

Videos

  • Stop Connecting Power Query to OneDrive Files Like This

    · 4 min

    Connect Power Query to OneDrive and SharePoint files so refresh works for everyone. 👉 Black Friday is coming up. Our best offer of the year goes to newsletter subscribers first. Sign up here so you don’t miss it: https://link.xelplus.com/yt-d-newsletter 🎓 Master Excel Power Query (500,000+ enrolled in our courses): https://www.xelplus.com/course/excel-power-query/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=power-query&utm_content=power-query-onedrive-links When you connect through File Explorer, Power Query saves the path on your computer. Your colleague's path is different, so their refresh fails. I show you how to connect with the web link instead, for Excel files and text files, and how to switch queries you already built. ✅ Good to know Use Copy Path, not Copy Local Path. Then delete ?web=1 at the end of the link. This works for OneDrive for work or school and SharePoint. Personal OneDrive links work differently. In the SharePoint Details pane, press End to jump straight to Path. If the copied link ends in ?web=1, delete that too. The first time you connect, sign in with your work account. ⏱️ Chapters 00:00 Why refresh fails for your colleague 00:31 Copy the OneDrive or SharePoint link 00:44 Connect to the Excel file with the link 00:59 Delete ?web=1 from the link 01:35 Fix queries you already connected 01:51 Change Source in Data Source Settings 02:17 Connect to a text or CSV file on SharePoint 02:31 Copy the direct link from the Details pane 02:49 Paste the link into From Text/CSV 03:44 Fix "credentials are invalid" after a password change 🎓 Power Pro Bundle (Power Query, Power Pivot & DAX, and Automate): https://www.xelplus.com/course/power-excel-bundle/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=power-pro-bundle&utm_content=power-query-onedrive-links 🏢 Training your team? https://www.xelplus.com/business-customers/ ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join ✉️ Get one practical Excel tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter 🚩 Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani #excel #powerquery #sharepoint

    Not rated yet
  • 3 Modern Excel Dashboards Your Boss Has Never Seen

    · 12 min

    Excel's new interactive canvas builds Excel dashboards with filters, sliders and a play button. 👉 Copilot course insider pre-sale: https://www.xelplus.com/course/copilot/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=copilot&utm_content=copilot-interactive-canvas With Excel's new interactive canvas skill powered by Copilot in Excel, I describe the report I want, and Copilot builds it on its own sheet, connected to my Excel data. First, a travel expense report with KPI cards, charts, filters and commentary that updates. Then I make it interactive: click a bar to cross-filter, add a slider for a minimum amount, and click a number to drill into the details. Change the data and the report updates. No refresh needed. Then I combine four sheets into a project status report for the steering committee, with a Gantt chart, RAG status, risk matrix and budget versus actual. A play button replays how the project unfolded. And to finish, a race chart of my top 10 customers. Copilot at Work covers Copilot in Excel first, then the rest of Microsoft 365. You'll learn how to train Copilot on your own process with skills, so you don't type the same prompt every month. Join the insider list to hear first when it opens: https://www.xelplus.com/course/copilot/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=copilot&utm_content=copilot-interactive-canvas-body ✅ Good to know: Interactive canvas is rolling out in preview, so you may not see it yet. You need Copilot in Excel. The canvas sits on its own sheet and works like a small web page that reads your data. You can't see the formulas or right-click to edit. Ask Copilot to explain a number, change the design or add a calculation sheet. The skill is under Manage plugins and skills. If it's off, @mention it in your prompt. ⏱️ Chapters: 00:00 Excel dashboards with a play button 00:50 Travel expense data and the prompt 01:23 Turn on the interactive canvas skill 01:46 The finished report: KPIs, charts, commentary 02:36 Filter by month 02:59 How the canvas works 03:26 Ask Copilot how a number is calculated 03:45 Limits: no right-click editing 04:00 Add cross-filtering and a slider 04:25 Test the minimum amount slider 04:54 Hover and cross-filter by clicking a bar 05:42 Drill down to the details behind a number 06:26 Does it update when the data changes? 07:02 Play button: a tour of the findings 07:34 Combine several sheets into a project report 08:56 Interactive Gantt chart 09:44 RAG status, risk matrix and budget vs actual 10:13 Replay the project history 10:59 Bonus: race chart of the top 10 customers ➡️ Join this channel: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👉 Get one practical Excel tip each week in our newsletter: https://link.xelplus.com/yt-d-newsletter 🚩 Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani #excel #copilot #microsoft365

    Not rated yet
  • Behind the Scenes: Building the Copilot Course #excel #copilot

    · 1 min

    More info about the Copilot at Work course: https://www.xelplus.com/course/copilot/

    Not rated yet
  • 8 Hidden Excel Tools to Understand Any Spreadsheet

    · 11 min

    Inherited a huge Excel file? Here are 8 practical ways to audit the workbook. 📥 Download the practice file: https://www.xelplus.com/audit-excel-workbook/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-audit-workbook&utm_content=audit-excel-workbook#download Start with Workbook Statistics and the Navigation pane to understand how the file is organized. Use Focus Cell and Freeze Panes to navigate large sheets without getting lost. Then follow calculations across sheets with Trace Precedents and Trace Dependents. Use the Watch Window to see how KPIs change when you adjust an input, and Go To Special to find hard-coded numbers and inconsistent formulas hiding in a column. You'll also see why spilled formulas are less vulnerable to accidental changes, and how Copilot can help explain a workbook you didn't build. 🎓 500,000+ enrolled in our courses. Learn the Excel features you use every day with Excel Essentials 👉 https://www.xelplus.com/course/learn-excel-essentials/?utm_source=yt-video&utm_medium=vid-general&utm_campaign=essentials&utm_content=audit-excel-workbook 👥 Training a team? Buy seats and track progress in an admin dashboard: https://www.xelplus.com/business-customers/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=business-seats&utm_content=audit-excel-workbook **Excel shortcuts:** Ctrl+[ selects precedent cells. Ctrl+] selects dependent cells. These shortcuts may not work as expected on some European keyboard layouts. If you've found a workaround, share it in the comments. **Good to know:** Focus Cell and the Navigation pane are available in Microsoft 365. Copilot availability depends on your Microsoft 365 plan and organization settings. **Chapters:** 00:00 Auditing someone else's Excel file 00:15 Workbook Statistics: what's in the file 00:40 Navigation pane: every sheet in one view 01:05 Focus Cell: see your row and column 01:31 Freeze Panes: keep headers in view 02:19 Trace Precedents: where numbers come from 03:07 Follow references to other sheets 03:46 Shortcut: Ctrl+[ to jump to precedents 04:14 Shortcuts on European keyboards 05:18 Trace Dependents: what a change affects 05:42 Watch Window: track KPIs while you edit 07:24 Name cells for a clearer Watch Window 08:00 Go To Special: find hard-coded numbers 08:55 Filter the flagged cells by color 09:26 Why spilled formulas are safer 09:55 Let Copilot explain the workbook 🎬 I gave ChatGPT a messy Excel file. Here's what happened: https://youtu.be/0PzmVXPdkuk ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join ✉️ Get one practical Excel tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter 🚩 Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani #excel #exceltips #excelaudit

    Not rated yet
  • Microsoft Blocked the Local Account Trick (Do THIS Instead)

    · 7 min

    Microsoft blocked BypassNRO. Here's the official way to switch Windows 11 to a local account. 🎓 FREE COURSE: Windows 11 Essentials for Work: https://www.xelplus.com/course/windows-essentials-for-work/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=windows-essentials&utm_content=local-account 📥 Quick Reference: Download the free Windows 11 Keyboard Shortcuts PDF 👉 https://www.xelplus.com/windows-11-keyboard-shortcuts-pdf-download/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-windows-shortcuts&utm_content=local-account#download You don't need a Microsoft account to use Windows 11. On an existing PC, go to Settings → Accounts → Your info and select "Sign in with a local account instead". This is Microsoft's own documented option, and you can switch back any time. Before you switch, back up your BitLocker recovery key. It's saved in your Microsoft account, and if Windows ever asks for it, your PC won't start without it. If you want no Microsoft account at all, the free tool Rufus can create an installer that skips it. Keep the PC offline during setup, or it won't work. On a new PC, the old Command Prompt workarounds keep disappearing. Microsoft removed BypassNRO from preview builds in March 2025. The reliable route is to finish setup with a Microsoft account, then switch to a local account in Settings. If you want no Microsoft account at all, the free tool Rufus can create an installer that skips it. A local Windows login doesn't stop you from using Microsoft 365, Excel or OneDrive. You just sign in to them separately. What you give up is Windows Backup, Find My Device and online password reset. 00:00 Do you need a Microsoft account for Windows 11? 00:32 Where to find the local account option 01:06 Back up your BitLocker recovery key first 02:15 Switch to a local account in Settings 03:20 Setting up a new PC 03:38 Why BypassNRO no longer works 04:03 The reliable route for a new PC 04:38 No Microsoft account at all: Rufus 05:36 Will you lose Excel and Microsoft 365? 05:58 3 things you lose with a local account 06:57 Wrap up 🎬 Stop OneDrive From Hijacking Your Desktop and Documents: https://youtu.be/WStd5PtsFb0 🎬 Windows 11 Settings You Should Change NOW!: https://youtu.be/Kx3H8BolgaI ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join ✉️ Get one practical tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter 🚩 Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani #windows11 #windows #privacy

    Not rated yet
  • Stop OneDrive From Hijacking Your Desktop and Documents

    · 11 min

    Stop OneDrive backup and move your Desktop and Documents back to your PC without losing files. 📥 Free Windows 11 shortcuts PDF: https://www.xelplus.com/windows-11-keyboard-shortcuts-pdf-download/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-windows-shortcuts&utm_content=stop-onedrive-backup#download 🎓 500,000+ enrolled in our courses. Start with our free Windows 11 Essentials for Work course 👉 https://www.xelplus.com/course/windows-essentials-for-work/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=windows-essentials&utm_content=stop-onedrive-backup Green ticks on your Desktop icons, or OneDrive warning that your storage is full? When you set up Windows 11 with a Microsoft account, your Desktop, Documents and Pictures folders are often backed up to OneDrive by default. Turning it off has one risky screen. The option selected by default, Only in OneDrive, removes the files from your PC. Pick Only on my PC instead. Before that, download every file with Always keep on this device, check you have enough free space, make an extra backup and close any open Office files. Already picked the wrong option? Your files aren't lost. They're in OneDrive, and you can bring them back. 00:00 Why your files ended up in OneDrive 01:02 How to tell if a folder moved to OneDrive 01:30 Open OneDrive settings and Manage backup 02:20 Turn off backup for a folder 02:45 The risky default: Only in OneDrive 03:25 Only on my PC and online-only files 04:21 Why your files aren't really on your PC 04:36 OneDrive status icons: green circle, blue cloud, hollow tick 05:39 Check 1: enough free space on your drive 06:18 Check 2: Always keep on this device 06:51 Checks 3 and 4: extra backup, close Office files 07:24 Stop backup and keep files only on your PC 07:53 Check that it worked 08:20 Storage still full? Empty the OneDrive recycle bin 08:43 What happens on your other PCs 09:00 Picked the wrong option? How to get your files back 09:41 Moving files off OneDrive is not a backup 10:20 Why Microsoft turns this on (the 5 GB free tier) 🎬 Use Windows 11 with a local account instead of a Microsoft account: https://youtu.be/T2MH5z2ZjNU 🎬 Windows 11 finally fixed the taskbar: https://youtu.be/YXX0bHnho3c ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join ✉️ Get one practical Excel tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter 🚩 Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani #windows11 #onedrive #windowstips

    Not rated yet
  • What Actually IS a Pivot Table?

    · 3 min

    What is a Pivot Table in Excel? It's a tool that turns rows of raw data into a summary you can change with drag and drop. No formulas needed. 📘 New to Pivot Tables? Start with Pivot Table Foundations: https://courses.xelplus.com/p/introduction-pivot-tables?coupon_code=YT_MEMBER The video starts with a quick test: which of these is a Pivot Table? Then it uses your bank statement and banking app to show what a Pivot Table does. It takes individual transactions and gives you an overview you can look at from different angles. Next, you'll see a Pivot Table built from hundreds of sales transactions. Drag fields to Rows and Columns, switch from total to average sales, and show what percentage each category contributes to the total. Double-click any number to see the rows behind it. That's the Drill Down. Last, a comparison with the formula route: SUMIFS, COUNTIFS and the newer GROUPBY function. Every new question means a new formula. With a Pivot Table, it's a few clicks. GROUPBY is available in Excel for Microsoft 365 and Excel for the web. Want to build your own Pivot Tables with confidence? Pivot Table Foundations walks you through it step by step: https://courses.xelplus.com/p/introduction-pivot-tables?coupon_code=YT_MEMBER ★ 500,000+ professionals learn Excel with our courses: https://link.xelplus.com/yt-d-all-courses ✉️ Get one practical Excel tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter 00:00 Is this a Pivot Table? Quick test 00:43 Bank statement analogy: what summarizing means 01:36 Why Pivot Tables beat fixed reports 02:04 Build a Pivot Table from sales data 02:29 Average, % of total and Drill Down 02:54 Pivot Table vs SUMIFS, COUNTIFS and GROUPBY 03:16 Recap and what to watch next 🎬 Build your first Pivot Table step by step: https://youtu.be/UsdedFoTA68 🎬 Make your Pivot Tables look like a polished report: https://youtu.be/7eqGp_K4hIE 🔓 Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 🚩 Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani #excel #pivottable #exceltips

    Not rated yet
  • Everything You Knew About Excel Cells Just Changed

    · 9 min

    Excel cells can now hold lists. Press Ctrl+J and use HAS, HASALL, HASANY and FLATTEN. 📥 Download the practice file: https://www.xelplus.com/excel-lists-in-cells/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-lists-in-cells&utm_content=excel-lists-in-cells#download 🎓 Modern Excel Functions: https://www.xelplus.com/course/new-excel-functions-course/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=modern-functions&utm_content=excel-lists-in-cells (500,000+ enrolled in our courses) Note: lists in cells are in preview for Microsoft 365 Insiders on the Beta Channel (Windows and Mac). They're rolling out gradually. For 40 years, a cell held one value. Now it can hold a list. I take a project tracker where the whole team sits in one cell, turn it into lists with Ctrl+J, and filter so "Ann" no longer matches "Anna". Formulas you already know, like COUNTA, SUM, SORT and XLOOKUP, work with lists too. Then I use the four new functions. HAS, HASALL and HASANY check who's on which project. FLATTEN splits lists into rows. GROUPBY builds a report of projects per person and per department. ✅ Good to know: Ctrl+J is a toggle. Press it again to turn a list back into text. You can also go to Insert, List. Separate items with your Excel separator: a comma or a semicolon, depending on your regional settings. To keep a formula result in one cell, wrap it in curly braces: ={SORT(B2)}. Microsoft may still change the feature before release, so don't build important workbooks on it yet. ⏱️ Chapters: 00:00 One cell, one value: the old problem 00:30 Convert text to lists with Ctrl+J 00:51 Filter by list items 01:05 COUNTA counts the items in a list 01:28 Turn a list back into text 01:57 Lists of numbers with SUM and COUNT 02:23 Create a list from Insert, List 03:00 Sort a list and keep it in one cell 03:29 List separator: comma or semicolon 03:46 XLOOKUP returns the whole team 04:17 Sort the result inside one cell 04:46 HAS: check if a list contains a value 05:30 HASALL: check for all values 05:52 HASANY: check for any value 06:09 FLATTEN: split lists into rows 06:51 GROUPBY: count projects per person 07:55 GROUPBY with UNIQUE: projects per department 🎬 Related videos: GROUPBY and PIVOTBY explained: https://youtu.be/mCJzhCxEQlM GROUPBY tricks for better reports: https://youtu.be/yhppTEj5wqs BYROW and BYCOL with practical examples: https://youtu.be/YqaEJiwJj2I ➡️ Join this channel: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👉 Get one practical Excel tip each week in our newsletter: https://link.xelplus.com/yt-d-newsletter 🚩 Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani #excel #exceltips #excelfunctions

    Not rated yet
  • Windows 11 Finally Fixed the Taskbar (And Added These Useful Settings)

    · 6 min

    Windows 11 can move the taskbar again. Plus a cleaner Start menu and Search without web results. 🎓 Free course: Windows 11 Essentials for Work: https://www.xelplus.com/course/windows-essentials-for-work/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=windows-essentials&utm_content=windows-taskbar (500,000+ enrolled in our courses) 👉 Get one practical Excel tip each week in our newsletter: https://link.xelplus.com/yt-d-newsletter I move the taskbar to the side and pair it with "never combine" so every window gets its own labeled button. Then I go through what doesn't work yet, explain why I keep mine on the right, and clean up the Start menu so it only shows my pinned apps. I also hide my name for screen sharing, turn off web results in Search, and let Windows index the folders I use most. ✅ Good to know: Taskbar position is under Settings, Personalization, Taskbar, Taskbar behaviors. It's rolling out gradually with the monthly updates. To get it sooner, go to Windows Update and turn on "Get the latest updates as soon as they're available". On a work laptop, your IT department can hold updates back. The small size and autohide only work with the taskbar at the bottom (small also works at the top). ⏱️ Chapters: 00:00 Move the Windows 11 taskbar: left, right or top 00:15 Open taskbar settings 00:33 Never combine taskbar buttons (show labels) 01:13 New small taskbar size 01:28 What doesn't work yet: size, autohide, monitors 02:02 My taskbar setup 02:41 New Start menu size options 03:08 Remove Recent and All apps from Start 03:31 Hide your name and picture for screen sharing 03:55 Turn off web results in Windows Search 04:24 Let Windows index your most used folders 04:51 Check your Windows version (winver) 05:20 Get new features sooner 05:38 Work laptop? IT can hold updates back 🎬 Related videos: 🎬 The most important Windows keyboard shortcuts: https://youtu.be/QKjV_GdkTTw ➡️ Join this channel: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👉 Get one practical Excel tip each week in our newsletter: https://link.xelplus.com/yt-d-newsletter 🚩 Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani #windows11 #windows #productivity

    Not rated yet
  • Stop Copying Data Between Excel Sheets! (Do This Instead)

    · 10 min

    Combine data from multiple Excel sheets with one formula. 6 VSTACK tips, no copy and paste. 📥 Download the practice workbook: https://www.xelplus.com/excel-vstack-function/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-vstack&utm_content=vstack-tips#download 🎓 Modern Excel Functions: https://www.xelplus.com/course/new-excel-functions-course/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=modern-functions&utm_content=vstack-tips (500,000+ enrolled in our courses) I start simple: stack two Excel tables with VSTACK so new rows show up on their own. Then I stack ranges from different sheets, remove the zeros with the dot trick, and summarize the result with GROUPBY. For monthly sheets I use a 3D reference with FILTER, and finally I add Start and End sheets so any month you drop in between is included. 🏢 Training a team? We have team licenses: https://www.xelplus.com/business-customers/ ✅ Good to know: The dot trick is called a trim reference: A2:.D40 trims empty rows from the end of the range. It's Microsoft 365 only and doesn't work with 3D references, so use FILTER there. VSTACK works in Microsoft 365 and Excel 2024. GROUPBY needs Microsoft 365. The one-formula version (VSTACK inside GROUPBY) is in the download file. ⏱️ Chapters: 00:00 Combine data from different sheets with one formula 00:24 Tip 1: VSTACK Excel tables 01:09 Format the result and test new rows 01:38 Tip 2: Stack ranges across sheets 02:59 Tip 3: Remove zeros with the dot trick 04:02 Tip 4: Summarize with GROUPBY 04:28 Use CHOOSECOLS with the spilled range 05:43 Test it: add a new product 06:41 Tip 5: Consolidate monthly sheets with a 3D reference 07:39 Remove blank rows with FILTER 08:25 Why a new month isn't picked up 08:58 Tip 6: Dynamic 3D ranges with Start and End sheets 🎬 Related videos: 🎬 VSTACK function basics: https://youtu.be/qNz35j5ZevQ 🎬 3D formulas across sheets: https://youtu.be/7T3i-RiuBBU ➡️ Join this channel: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👉 Get one practical Excel tip each week in our newsletter: https://link.xelplus.com/yt-d-newsletter 🚩 Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani #excel #vstack #excelformulas

    Not rated yet
  • Excel finally stopped hiding this button

    · 1 min

    Microsoft just added the "Center Across Selection" button directly to the Excel ribbon! Stop using Merge & Center. It breaks your formulas and messes up your data sorting. Now you can get the exact same look while keeping your spreadsheets perfectly functional. What bad data habit do you wish your coworkers would stop doing? Let me know in the comments! 500,000+ people have taken our courses so far. If you want to go deeper: 👉 https://link.xelplus.com/yt-d-all-courses 📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter 🔓 Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 📲 Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani #Excel

    Not rated yet
  • The 1-Formula Fix for Excel’s Messiest Tables

    · 1 min

    Learn Python in Excel: https://www.xelplus.com/course/python-in-excel/ Sales data split across monthly columns? Here's how to reshape it into one clean table, with month, sales, and units each in their own column, using Python inside Excel. =PY pd.wide_to_long(sales_data, stubnames=["sales","units"], i="sales rep", j="month", sep="_", suffix=".+").reset_index() - Type =PY and press Tab to activate Python mode - wide_to_long turns repeated column groups (like sales_Jan, units_Jan) into rows - stubnames lists the values you're tracking - i is your identifier column, like sales rep - j names the new column that holds the month - sep matches the separator in your source headers - suffix=".+" means the leftover text can be anything - reset_index() keeps everything aligned - Right-click the Python output and choose "Excel Value" to drop it into cells Add a new month to your source data and the table updates on its own. Uses the pandas wide_to_long function. Check the pandas docs for the full reference. 📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter 🔓 Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 📲 Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani #Excel

    Not rated yet
  • The Excel function nobody reaches for... 🤯

    · 50 sec

    Got lists spread across multiple columns? Here's the formula that flattens them into one clean, sorted, duplicate-free list, and updates itself when you add new names. =SORT(UNIQUE(TOCOL(range,1))) - TOCOL flattens your columns into a single column - The "1" ignores blanks so you don't get gaps - UNIQUE removes duplicates - SORT puts everything in order - Extend your range so new entries show up automatically No copy-paste. No manual updates. One formula that stays live as your data changes. Works in Excel 365 and Excel 2021+. 500,000+ people have taken our courses so far. If you want to go deeper: 👉 https://link.xelplus.com/yt-d-all-courses 📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter 🔓 Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 📲 Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani #Excel

    Not rated yet
  • Every Analyst Should Run This Check on Their Excel Report

    · 9 min

    How to find hard-coded numbers hidden inside Excel formulas, using REGEXTEST and conditional formatting. No VBA, no add-ins. ⬇️ Download the practice file: https://www.xelplus.com/find-hardcoded-values-excel/#download 📊 Learn to read financial reports and use Excel the way finance teams do: Fundamentals of Financial Analysis: https://www.xelplus.com/course/learn-financial-analysis/ Go To Special finds numbers typed into cells. But it can't see a number hidden inside a formula, like a +200 someone added and forgot. You'll see how to pull each formula out as text with FORMULATEXT, check it against a pattern with REGEXTEST, and highlight every match with conditional formatting. You'll also learn how to skip numbers you use on purpose (like dividing by 12) and how to switch between patterns with a dropdown. At the end, you'll see how Copilot handles the same check. Note: REGEXTEST is available in Microsoft 365 and Excel for the web. ★ 500,000+ professionals learn Excel with our courses: https://link.xelplus.com/yt-d-all-courses ✉️ Get one practical Excel tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter 00:00 The report that looks clean but isn't 00:18 Find hard-coded numbers typed into cells (Go To Special) 00:40 Why Go To Special misses numbers inside formulas 01:36 Not every number in a formula is a problem 02:32 The two regex patterns explained 03:30 FORMULATEXT: pull the formula out as text 03:58 REGEXTEST: check the formula against a pattern 04:38 Highlight them all with conditional formatting 05:55 Add exceptions for numbers you use on purpose 06:26 Switch patterns with a dropdown and XLOOKUP 07:49 What regex won't catch (and how AI can tune it) 08:16 Find hard-coded numbers with Copilot 09:02 What's the worst one you've found? 🎬 Introducing the Excel REGEX functions: https://youtu.be/YFnXV2be9eg 📄 Excel regex functions guide: https://www.xelplus.com/regex-in-excel/ 🚩 Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/leilagharani #excel #exceltips #regex

    Not rated yet
  • Modern Formula to Switch Wide Data to Long Format (Python melt)

    · 1 min

    Start with Python Foundations: https://courses.xelplus.com/l/pdp/python-in-excel-foundations (apply coupon YTPY for 60% off for a limited time) Need to turn month columns into rows in Excel? Do not restructure the data manually. Use Python in Excel and the pandas melt function to unpivot the entire table in seconds. In this example, we keep Region, Country, and Channel, then convert the monthly columns into two clean fields: Month and Sales. The result is dynamic too. Add another month to the Excel Table and the output updates automatically. Power Query can do this as well, but this method takes just one formula. Topics covered: - Excel columns to rows - Unpivot data in Excel - Python in Excel - Pandas melt - Wide to long data transformation 500,000+ people have taken our courses so far. If you want to go deeper: 👉 https://link.xelplus.com/yt-d-all-courses 📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter 🔓 Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 📲 Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani #Excel #PythonInExcel #ExcelTips

    Not rated yet
  • I Gave ChatGPT a Messy Excel File. Here's What Happened

    · 10 min

    How to analyze Excel data with ChatGPT, using a workflow and prompts that help you check the answers before you trust them. ⬇️ Download the prompt template: https://www.xelplus.com/ai-excel-prompts/#download 🎓 Learn to build the data model used to check ChatGPT's answers: Power Pivot & DAX course: https://www.xelplus.com/course/excel-power-pivot-dax/ Most people drop a file into ChatGPT and type "Analyze this." The answer might look right, but would you put it in front of your manager? In this test, ChatGPT gets a sales workbook with several related sheets and only codes in the main table. You'll see how to set guardrail rules, ask ChatGPT to inspect the file first, check basic numbers in Excel, and compare its answers with a Power Pivot data model. Note: don't upload sensitive company data. Anonymize it first and follow your company's AI guidelines. 00:00 Why "Analyze this" isn't enough 00:35 The test file: related sheets with only codes 02:12 Prompt 1: guardrail rules and file inspection 03:09 Be careful what you upload 03:30 What ChatGPT found in the file 04:35 Prompt 2: check numbers you can verify in Excel 05:18 Free vs. paid ChatGPT and Thinking mode 06:06 Test 1: sales by region and channel 07:09 Checking the answer with Power Pivot 07:28 Test 2: products with a negative profit margin 08:49 Test 3: will ChatGPT make up an answer? 09:32 Verdict and the 4-step workflow ★ 500,000+ professionals learn Excel with our courses: https://link.xelplus.com/yt-d-all-courses ✉️ Get one practical Excel tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter 🎬 Related videos: Don't use ChatGPT until you watch this video: https://youtu.be/wBAnCMA98ls Copilot in Excel finally lets you personalize it: https://youtu.be/si61bqW4AEo 10 Copilot Chat prompts I use every week: https://youtu.be/oAbLb-K8VZo 🚩 Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani #excel #chatgpt #dataanalysis

    Not rated yet
  • Change This One Copilot Setting for Better Excel Reports

    · 5 min

    Personalize Copilot in Excel so it formats your tables, dates, and numbers your way, automatically. Microsoft just added personalization to Copilot in Excel, and in this video I show you exactly how to set it up. I'm building a full Copilot course around real tasks like this one, starting with Excel. Join the insider list (free) to get the first lessons early, at the lowest price 👉 https://www.xelplus.com/copilot Tired of reformatting everything Copilot hands you? You can teach it once how you like things, and it remembers across every workbook. I walk through the four settings I use, then test them live (honest result included), and finish with a list of other preferences worth adding. ⏱️ CHAPTERS 0:00 What Copilot Gets Wrong by Default 0:28 The Formatting I Fix Every Time 1:09 New: Copilot in Excel Personalization 1:32 The 4 Settings I Changed 2:27 Testing It on a Fresh Table 2:44 What Copilot Got Right (and Didn't) 4:03 More Personalization Ideas Worth Stealing 5:10 Wrap Up 📚 Want to actually master Excel? Our courses are built for people who work with data every day in corporate 👉 https://link.xelplus.com/yt-d-all-courses ▶️ Why I prefer center across selection over merge & center: https://youtu.be/cnCvn6CmP2k 🔓 Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter 📲 Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: www.linkedin.com/in/leilagharani #Excel #microsoftcopilot

    Not rated yet
  • It's not the sound of your voice.

    · 2 min

    🔥 500,000+ enrolled in our courses. Join them 👉 https://link.xelplus.com/yt-d-all-courses 📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter 🔓 Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 📲 Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: www.linkedin.com/in/leilagharani

    Not rated yet
  • Power Query Remove Duplicates Keeps the WRONG Record

    · 8 min

    🔥 Get our brandnew Power Query exercise pack (including the GroupBy method): https://www.xelplus.com/course/power-query-challenge-pack/ Remove duplicates in Power Query, sort by date, keep the latest record. Logical, right? On a large file it can quietly hand you the wrong number, and nothing breaks to tell you. That's the trap in this video. You sort newest-first, remove duplicates to keep the top row, and the result looks fine. Then you run it on a bigger dataset and the count is wrong. No error. No warning. Just bad data going into your report. The cause is lazy evaluation. Power Query tries to be efficient and skips the full sort before removing duplicates, so it keeps an older record instead of the most recent one. I'll show you exactly how to spot it, how to check your work against the source, and the one-line fix: wrapping your sort step in Table.Buffer() so the whole table sorts in memory first. There's also a second method using Group By that doesn't rely on sort order at all. I cover that one in our Power Query exercise pack. 📂 Get the practice workbook: https://www.xelplus.com/power-query-keep-latest-record/#download 📘 Master Excel Power Query (full course): https://www.xelplus.com/course/excel-power-query/ ⏱️ Chapters 00:00 The "Remove Duplicates" Power Query Trap 00:31 The task: finding the latest stock count 02:28 The "logical" way (sort + remove duplicates) 04:10 Checking the result against the CSV 05:03 Why Power Query kept the wrong record 06:10 The fix: Table.Buffer 07:41 A second method: Group By 📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter 🔓 Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 🎬 LINKS to related videos: Learn to Automate Everything with Power Query: https://youtu.be/x7mzOYEn0XA You WON'T BELIEVE These 10 HIDDEN Features in Power Query: https://youtu.be/8hjgmJk5RiA 📲 Let’s connect on social: LinkedIn Leila: www.linkedin.com/in/leilagharani LinkedIn XelPlus: https://www.linkedin.com/company/xelplus Instagram: https://www.instagram.com/lgharani #Excel #powerquery

    Not rated yet
  • Stop Using Bullet Points (Do This Instead)

    · 44 sec

    🔥 500,000+ enrolled in our courses. Join them 👉 https://link.xelplus.com/yt-d-all-courses 📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter 🔓 Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👕 Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🧭 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🧰 Resources I recommend: https://www.xelplus.com/resources/ 🛒 More resources on my Amazon page: https://www.amazon.com/shop/leilagharani 📲 Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #powerpoint

    Not rated yet

More in Education

See all Education shows