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

Rated alike

Similar by topic and creator

See the full Cosmos

Videos

  • Microsoft Quietly Added Email to Excel - Here's How to Use It

    ยท 13 min

    ๐Ÿ”ฅ 500,000+ enrolled in our courses. Join them ๐Ÿ‘‰ https://link.xelplus.com/yt-d-all-courses Stop wasting hours manually saving, naming, and emailing Excel reports! In this tutorial, we unlock the power of Office Scripts to automate your entire reporting workflow. You will learn how to build a 1-click button that converts specific sheets to PDF and sends them via Outlook instantly. All with the help of Office Scripts in Excel. โฌ‡๏ธ DOWNLOAD the workbook with the code here: https://www.xelplus.com/office-scripts-pdf-email-excel/#download Unlike traditional VBA macros, this solution is online-ready and works perfectly in Excel for the Web, Microsoft Teams and Microsoft 365 - and of course also on desktop. Weโ€™ll walk through the TypeScript code, set up a dynamic data table for your recipients, and show you how to customize the script for your own dashboards. Microsoft Learn page: https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/save-as-pdf-email-as-pdf What You'll Learn: - How to use the convertToPdf and sendMail APIs in Office Scripts. - Setting up a recipient table (Name, Email, Sheet Name) for bulk processing. - Connecting a script to a "Run" button for a professional UI. - Why Office Scripts are the modern, secure alternative to VBA for report distribution. ๐Ÿ• Timestamps 00:00 The Manual Reporting Problem (And the 1-Click Solution) 01:15 Setting Up Your Dashboard: The Data Table Structure 02:45 Introduction to Office Scripts & The Automate Tab 04:10 Script Walkthrough: Understanding convertToPdf & sendMail 06:30 Customizing the Code for Multiple Recipients 08:20 Adding the Automation Button to Your Sheet 09:50 Live Demo: Bulk Emailing PDF Reports 11:05 Troubleshooting & Common Script Errors 12:30 Final Tips: Moving from VBA to Office Scripts ๐Ÿ“จ 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: Introduction to Office Scripts: https://youtu.be/fny4zUycp_w Create Cool Buttons to Run Office Scripts from ANYWHERE: https://youtu.be/djf3tBIYmCw ๐Ÿ‘• 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! #Excel #officescripts

    Not rated yet
  • Work hard and you'll be noticed

    ยท 2 min

    ๐Ÿ”ฅ 500,000+ enrolled in our courses. Join them ๐Ÿ‘‰ https://link.xelplus.com/yt-d-all-courses Work hard and you'll be noticed. Best or worst career advice? Here's what I've learnt. ๐Ÿ“จ 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! #Excel

    Not rated yet
  • Stop Copying & Pasting Like This! ๐Ÿ›‘

    ยท 42 sec

    Use this underrated function instead. ๐Ÿ”ฅ 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! #Excel

    Not rated yet
  • Stop Sending Ugly Pivot Tables to Your Boss

    ยท 16 min

    Format Excel Pivot Tables so they look like a finished report. No copying data out, no formatting cells by hand. Everything stays dynamic when you refresh. โฌ‡๏ธ Download the practice file (includes the custom style and color codes): https://www.xelplus.com/format-pivot-table-excel/#download ๐Ÿ“˜ Pivot Tables course mentioned in the video: https://www.xelplus.com/course/excel-pivot-tables/ You'll build a budget vs actual report for a fast food chain. Start with a standard Pivot Table and add a Variance calculated field (Budget minus Actual). Then clean up the layout: blank rows, compact form, no +/- buttons and no field headers. Rename Grand Total to anything you like, and replace the "Sum of" headers with a simple space trick. Next, create a custom Pivot Table style. You format Pivot Table elements instead of cells, so the design holds when the data changes. Then add green and red variance icons with custom number formatting. No conditional formatting needed. Finish with the Pivot Table options that keep column widths and formatting in place on refresh. You'll also see how to copy your custom style into any other workbook. Source number formatting carrying over into the Pivot Table is a Microsoft 365 feature. If your Excel is in another language, replace Green and Red in the number format with the color names in your language. โ˜… 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 Ugly vs report-ready Pivot Tables 00:48 Build the budget vs actual Pivot Table 02:02 Microsoft 365: source number formatting carries over 02:24 Add a Variance calculated field 03:06 Blank rows and report layout 03:49 Remove +/- buttons and field headers 04:09 Rename Grand Total and Sum of headers 05:18 Create a custom Pivot Table style 07:35 Apply the custom style 08:50 Cleaner borders with a white vertical separator 10:28 Variance icons with custom number formatting 12:30 Softer icon colors: Color43 and Color53 13:15 Pivot Table options: keep column widths on refresh 14:09 Before vs after, then add new data 15:03 Copy your custom style to another workbook ๐ŸŽฌ You Won't Believe These Crazy PIVOT TABLE Hacks: https://youtu.be/ZZRl7fALdjw ๐ŸŽฌ You Can Put Images Inside Pivot Tables Now: https://youtu.be/WNrB1Q9Rry0 ๐Ÿ”“ 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
  • Stop scrolling through your data for 4-digit codes

    ยท 1 min

    Join me at the Global Excel Summit in London May 19-20 2026: https://globalexcelsummit.com/?via=leila ๐Ÿ‘‰ use code LEILA for 20% off. ๐Ÿ”ฅ 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 ๐ŸŽฌ LINK to detailed REGEX video: https://youtu.be/YFnXV2be9eg?si=wKKm8gGlxlqAeN_t ๐Ÿ‘• 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! #Excel

    Not rated yet
  • Better Excel Progress Charts in 3 EASY STEPS

    ยท 53 sec

    ๐Ÿ”ฅ 500,000+ enrolled in our courses. Join them ๐Ÿ‘‰ https://link.xelplus.com/yt-d-all-courses Better Excel Progress Bars in 3 Easy Steps Here is the pro way to visualize progress and make your reports stand out: 1๏ธโƒฃ Select your percentages. 2๏ธโƒฃ Conditional Formatting - Data Bars. 3๏ธโƒฃ Set Min to 0 and Max to 1 for a perfect scale. Change a number, and the bar follows. Thatโ€™s it. Easy as that. ๐Ÿ“จ 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! #Excel

    Not rated yet
  • The New Excel Trick to Link CSV Files Instantly

    ยท 14 min

    Link CSV files to Excel with one formula. The new IMPORTCSV function pulls in CSV data without opening the files. No Power Query, no VBA. โฌ‡๏ธ Download the practice files: https://www.xelplus.com/excel-importcsv-function/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-importcsv&utm_content=importcsv#download-section ๐Ÿ“˜ Combine and clean CSV files at scale with Power Query: https://www.xelplus.com/course/excel-power-query/ Six regions send a CSV file every month. You need to know who submitted, what the revenue looks like, and whether any data is missing. Instead of opening each file, you'll build a small dashboard that checks all of them from one workbook. Copy the file paths, then point IMPORTCSV at them. Add a drop-down and XLOOKUP to switch between regions. Use the take_rows argument with XMATCH and ISNA to check whether each file has the selected month, then color-code the result with conditional formatting. CHOOSECOLS and SUM total the revenue. LEN and SUMPRODUCT count blank cells, because COUNTBLANK doesn't work on arrays returned by a formula. You'll also see five things to know before using IMPORTCSV: SharePoint and OneDrive links, refreshing with Data โ†’ Refresh All, skipping and taking rows, the locale argument for regional formats, and IMPORTTEXT for semicolon-delimited files. Plus a custom number format that shows a link icon instead of a long file path. IMPORTCSV is currently available to Microsoft 365 Insiders (Beta Channel, Excel for Windows, Version 2502, Build 18604.20002 or later). โ˜… 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 0:00 Check CSV files without opening them 1:32 The scenario: monthly CSV files from six regions 2:08 Copy file paths with Copy as Path 2:35 IMPORTCSV: load a CSV file with one formula 3:23 Switch files with a drop-down and XLOOKUP 4:43 5 things to know: SharePoint, refresh, rows, locale 6:28 IMPORTTEXT for semicolon-delimited files 7:02 Hide file paths with custom number formatting 8:39 Month drop-down to check submissions 9:45 XMATCH and ISNA: flag missing months 11:11 Color-code results with conditional formatting 12:00 Total revenue with CHOOSECOLS and SUM 12:27 Count missing data with LEN and SUMPRODUCT 13:36 IMPORTCSV vs Power Query: when to use which ๐ŸŽฌ XLOOKUP explained: https://youtu.be/4c0CLUER6nw ๐ŸŽฌ Custom number formatting: https://youtu.be/68Tet_8BNB8 ๐ŸŽฌ Learn Power Query: https://youtu.be/x7mzOYEn0XA ๐Ÿ”“ 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 #importcsv #exceltips

    Not rated yet
  • So you want to make your chart "more visual"? #excel

    ยท 1 min

    ๐Ÿ”ฅ 500,000+ enrolled in our courses. Join them ๐Ÿ‘‰ https://link.xelplus.com/yt-d-all-courses There is this social media trend going around to paste in images inside the bars. This can easily end up distorting your data. The video shows a better way of making your chart easier to read without distorting the data. ๐Ÿ“จ 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! #Excel

    Not rated yet
  • Stop Manually Comparing Lists in Excel!

    ยท 1 min

    ๐Ÿ”ฅ 400,000+ enrolled in our courses. Join them ๐Ÿ‘‰ https://link.xelplus.com/yt-d-all-courses You want to quickly find missing data in Excel? You're comparing two lists and want to know what's missing? Like in this example we're looking for uninvited guests! ๐Ÿ“จ 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! #Excel

    Not rated yet
  • Stop Using Pie Charts (Do THIS Instead)

    ยท 9 min

    ๐Ÿ”ฅ Create charts that wow your audience. Learn the secrets now, start today! ๐Ÿ‘‰ https://link.xelplus.com/yt-bizcharts-course Still using a pie chart for lots of categories? Even if your boss asks for a pie chart, thereโ€™s a better option in Excel. โฌ‡๏ธ DOWNLOAD the workbook here: https://pages.xelplus.com/better-pie-charts In this video, youโ€™ll learn how to build a clean, professional bar chart thatโ€™s better than a pie chart, while keeping all the same info people love about pies (including percent of total). Youโ€™ll also make it auto-update and auto-sort with a simple formula setup, so your chart stays readable even when the data changes. Timestamps: 00:00 Stop sending messy pie charts 00:59 Build the better chart: linked data + bar chart 03:15 How to show % on the bar chart 04:48 Auto-sort the chart with SORT 06:47 Add a dynamic total to the chart title 08:34 Final comparison: pie chart vs readable chart What youโ€™ll learn: - Why pie charts fall apart with too many slices - A faster, cleaner chart you can actually present - How to add currency labels and percent labels to a bar chart - The โ€œduplicate seriesโ€ trick to show percentages without clutter - How to keep your source data intact, but make the chart sorted automatically using SORT() - How to add a dynamic total to the chart title (updates as data changes) If you want to create charts that look like they belong in real reports (and not in a spreadsheet from 2006), this oneโ€™s for you. ๐Ÿ“จ 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: Fast & Easy! McKinsey Chart in Excel: https://youtu.be/-Pi68IkutaQ The Excel Timeline chart you'll actually keep using: https://youtu.be/GP1W4fKWUrA ๐Ÿ‘• 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! #Excel

    Not rated yet
  • Stop Renaming Files Manually! ๐Ÿ›‘

    ยท 1 min

    ๐Ÿ”ฅ 400,000+ enrolled in our courses. Join them ๐Ÿ‘‰ https://link.xelplus.com/yt-d-all-courses Bulk rename files in Windows Explorer without a third-part tool. Just use this code inside PowerShell. ๐Ÿ“จ 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! #Excel

    Not rated yet
  • The AI productivity trap nobody talks about

    ยท 1 min

    ๐Ÿ”ฅ 400,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! #Excel #copilot

    Not rated yet
  • Make Excel Feel Like an App (4 Secret Navigation Tricks)

    ยท 9 min

    Stop scrolling through big Excel files. Here are 4 ways I jump to any sheet in seconds. ๐Ÿ“ฅ Download the practice workbook: https://www.xelplus.com/navigate-excel-workbooks/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-navigate-excel&utm_content=navigate-excel-workbooks#download ๐ŸŽ“ Build solid Excel skills with Excel Essentials (500,000+ enrolled in our courses): https://www.xelplus.com/course/learn-excel-essentials/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=essentials&utm_content=navigate-excel-workbooks ๐Ÿข Team licenses: https://www.xelplus.com/business-customers/ In this video, I show you 4 ways to move around large Excel workbooks. You'll see the hidden right-click sheet list, the Navigation Pane, a clickable navigation menu built with hyperlinks, and Name Box bookmarks. The clickable menu is my favorite. I add a back to summary link on every sheet, then build a flag sidebar that makes the file feel like an app. โœ… Good to know: The Navigation Pane is available in Excel for Microsoft 365 on Windows and Mac. In the video I say Ctrl + Page Up moves down. To be clear: Ctrl + Page Up goes to the previous sheet, and Ctrl + Page Down goes to the next sheet. Name Box names can't have spaces or look like a cell address (UK1, for example). Use an underscore to join words. โฑ๏ธ Chapters: 00:00 Navigate big Excel workbooks without scrolling 00:40 Secret right-click sheet list 01:12 Navigation Pane (Microsoft 365) 01:47 Open the Navigation Pane from the status bar 02:06 Clickable navigation menu with hyperlinks 03:38 Add a back to summary link on every sheet 04:37 Build a navigation sidebar with flag icons 08:03 Name Box bookmarks 09:12 Edit or delete names in Name Manager ๐ŸŽฌ Related videos: Create an Excel Dashboard to Easily Track Budget and Actuals with Variances: https://youtu.be/lHk6MdGAfw8 Learn to Automate Everything with Power Query in Excel: https://youtu.be/x7mzOYEn0XA โžก๏ธ Join this channel to get access to perks: 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 #exceltricks

    Not rated yet
  • That weird ### in Excel might look like an error...

    ยท 53 sec

    ๐Ÿ”ฅ 400,000+ are taking our courses. Join them ๐Ÿ‘‰ https://link.xelplus.com/yt-d-all-courses That weird ### in Excel might look like an error but itโ€™s a warning sign that your columns canโ€™t breathe ๐Ÿ˜ฎโ€๐Ÿ’จ Hereโ€™s the shortcut to give them all enough space - at once. ๐Ÿ“จ 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 ๐ŸŽฌ LINK to related video: https://youtu.be/lkG1283Ev78 ๐Ÿ‘•โ˜• 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! #Excel

    Not rated yet
  • 10 Copilot Chat Prompts I Use Every Week

    ยท 13 min

    10 Copilot Chat prompts I use every week for email, planning and files. ๐Ÿ“ฅ Download the free Copilot prompt cheat sheet: https://www.xelplus.com/copilot-chat-prompts/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-copilot-chat&utm_content=copilot-prompts#download ๐ŸŽ“ Get early access to my Copilot at Work course (500,000+ enrolled in our courses): https://www.xelplus.com/course/copilot/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=copilot-course&utm_content=copilot-prompts These prompts triage unread email, catch you up on a colleague, build a weekly action plan in Word, find lost files (even inside Excel sheets), summarize and compare documents, and prep you for tough questions. At the end, I turn a long chat into one reusable prompt. The Copilot at Work course starts with Excel. โœ… Good to know Copilot Chat is free with a Microsoft 365 work or school account, but the free version works from the web. Most prompts here search your email, chats and files, which needs a Microsoft 365 Copilot license. Work mode is now the Work IQ button at the top right of Copilot Chat. To add a person or a file to a prompt, type / (forward slash). Scheduling a prompt also needs a Microsoft 365 Copilot license. The prompt library is called the Prompt Gallery: See more, then Prompt Gallery. Saved prompts are under Your prompts. โฑ๏ธ Chapters 00:00 Where to find Copilot Chat 00:44 Free vs paid: what each version can do 01:08 Work mode vs Web mode 01:30 Prompt 1: Turn unread emails into tasks 02:46 Prompt 2: Focused Inbox only 03:44 Prompt 3: Catch up on a person 04:17 Save and schedule a prompt 04:55 Prompt 4: Build a weekly action plan in Word 06:04 The weekly action plan result 06:47 Prompt 5: Find files in OneDrive and SharePoint 08:20 Prompt 6: Deep search inside Excel files 09:28 Prompt 7: One-paragraph file summary 10:03 Prompt 8: Compare two files 11:08 Prompt 9: Prep for tough questions 12:09 Microsoft's Prompt Gallery and your saved prompts 12:39 Prompt 10: Turn a chat into a reusable prompt ๐ŸŽฌ What Copilot in Excel can do: https://youtu.be/YOeW8UIWJRQ ๐ŸŽฌ Copilot in OneDrive: https://youtu.be/6WEqOrx6_Rg โžก๏ธ 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 #copilot #microsoft365 #copilotprompts

    Not rated yet
  • Stop explaining your spreadsheet to coworkers. Do this instead.

    ยท 50 sec

    ๐Ÿ”ฅ 400,000+ enrolled in our courses. Join them ๐Ÿ‘‰ https://link.xelplus.com/yt-d-all-courses Add discreet pop-up instructions to Excel cells using Data Validation โ†’ Input Message. They appear only when someone clicks the cell (no comment marker). To remove, go to Data Validation โ†’ Clear All, and use F4 to repeat the last action across other cells. ๐Ÿ“จ 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: https://youtu.be/lkG1283Ev78 ๐Ÿ‘•โ˜• 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! #Excel

    Not rated yet
  • How to Design Professional KPI Cards in Power BI

    ยท 15 min

    Power BI card visual tutorial: build clean KPI cards with reference labels, conditional formatting and custom layouts. โฌ‡๏ธ Free Power BI Quick Start Course: https://www.xelplus.com/power-bi-starter-course ๐ŸŽ“ Learn Power BI from beginner to expert with Fast Track to Power BI: https://www.xelplus.com/course/fast-track-to-power-bi/ The new card visual lets you show several KPIs in one visual and add context to each number. You'll compare sales with the previous year and budget, color the variance red or green, and change the layout to tiles, a table or a grid. You'll also build a manager card with photos using hero images. โ˜… 500,000+ professionals learn with our courses: https://link.xelplus.com/yt-d-all-courses โœ‰๏ธ Get one practical tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter 00:00 The new Power BI card visual 00:17 Add a card and show multiple KPIs in one visual 01:02 How the formatting options are organized 02:16 Size, padding and background 03:10 Multi-card layout: tiles, table or grid 03:58 Card shape, rounded corners, accent bar and shadow 05:28 Callout size, labels and images 06:47 Reference labels: add previous year and budget 08:23 Show variance with conditional formatting 10:04 Reference label layout 11:10 Change the card order and divider 11:59 Add categories to cards 12:13 Hero image: build a manager card with photos 15:11 Wrap-up ๐ŸŽฌ Related videos: Power BI tutorial for beginners: https://youtu.be/c7LrqSxjJQQ 10 Power BI tips for better dashboards: https://youtu.be/mYpOSfqgTvY ๐Ÿšฉ Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus #powerbi #datavisualization #kpi

    Not rated yet
  • I was so wrong about how much Excel I actually knew

    ยท 2 min

    โšก BLACK FRIDAY Bundles through Dec 2nd ๐Ÿ‘‰ https://link.xelplus.com/yt-bf-savings Special bundles on Excel, Python, Power BI, Power Query - everything a modern analyst needs. Hi - in case we haven't met, I'm Leila. I started my career as an Economist, then switched to business consulting. I've worked in operations, finance, IT and project management for over 15 years. For the past 10 years, I've been running XelPlus.com where I teach corporate professionals how to better leverage spreadsheets and data tools like Power BI to make an impact in their life and work. #Excel

    Not rated yet
  • The Excel Timeline chart you'll actually keep using (free template included)

    ยท 10 min

    Build a dynamic timeline chart in Excel that updates when your dates change. ๐Ÿ“ฅ Download the free timeline template: https://www.xelplus.com/excel-timeline-chart/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-charts&utm_content=timeline#download-section ๐ŸŽ“ 500,000+ enrolled in our courses. Build a whole library of clean business charts in Business Charts in Excel ๐Ÿ‘‰ https://www.xelplus.com/course/business-excel-charts/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=business-charts&utm_content=timeline No add-ins and no VBA. Put your dates and milestones in an Excel table, add a helper column, and turn a line chart with markers into a timeline with vertical error bars. Data labels show the date and milestone on separate lines. Change a date, add a row or delete one, and the timeline updates. A short formula staggers the labels above and below the axis so they don't overlap. To always start the pattern on the first row of the table, wherever it sits: =CHOOSE(MOD(ROW()-ROW(TableTime[#Headers])-1,4)+1,10,-10,12,-30) 00:00 A dynamic timeline chart in Excel 00:29 Set up the data as an Excel table 00:46 Add a helper column for chart levels 01:17 Insert a line chart with markers 01:39 Add vertical error bars (Minus, No Cap, 100%) 02:15 Style the error bars and markers 02:53 Why the labels need different heights 03:41 Stagger labels with CHOOSE, MOD and ROW 04:47 Fix the axis start and end dates 05:13 Remove tick marks and axis labels 05:35 Style the axis with arrows 06:10 Add data labels: date and milestone 06:55 Put the date on a new line 07:42 Highlight an important milestone 08:13 Change a date and the timeline follows 08:37 Change the label pattern 08:53 Start the pattern on the table's first row ๐ŸŽฌ McKinsey chart in Excel: https://youtu.be/-Pi68IkutaQ ๐ŸŽฌ Make Excel charts like The Economist: https://youtu.be/wP8NWRR0Fdg โžก๏ธ 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 #excelcharts #exceltips

    Not rated yet
  • 8 Excel Features Every Office Worker Should Know

    ยท 11 min

    8 simple Excel features most beginners miss. Each one replaces a manual task with a shortcut or a few clicks. ๐Ÿ“ฅ Download the practice file: https://pages.xelplus.com/overlooked-features-download?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-overlooked-features&utm_content=overlooked-features ๐ŸŽ“ Go from Excel beginner to confident with Excel Essentials (500,000+ enrolled in our courses): https://link.xelplus.com/yt-excel-essentials-tips Add or multiply a whole range at once with Paste Special. Pull initials out of text with Flash Fill (Ctrl+E). Find every formula cell with Go To Special, repeat formatting with F4, and add pop-up instructions to input cells. Fix #### with AutoFit, swap header formatting across a whole workbook, and email your file without leaving Excel. โœ… Good to know: F4 on a laptop: if it doesn't repeat your action, press Fn+F4. Ctrl+Y does the same. Email button: if you use new Outlook for Windows, it may still open classic Outlook. Microsoft is rolling out support for new Outlook from November to December 2026. Until then, attach the file from inside new Outlook. โฑ๏ธ Chapters: 00:00 8 Excel features beginners miss 00:17 Paste Special: add values in bulk 01:38 Paste Special: multiply by 1,000 02:16 Flash Fill (Ctrl+E) to extract text 03:27 Go To Special: highlight formula cells 04:36 Go To Special: highlight input cells 05:43 F4: repeat your last action 06:46 Cell tips with Data Validation input messages 07:40 AutoFit all columns and fix #### 08:43 Find and Replace formatting 09:46 Why Find Format can miss some cells 10:50 Email a file straight from Excel โžก๏ธ 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 #excelforbeginners

    Not rated yet

More in Education

See all Education shows