Leila Gharani
Leila GharaniVideo
- Format:
- YouTube channel
- New videos:
- Weekly
- Typical length:
- about 9 minutes, not counting Shorts
- Latest video:
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
- AI Daily: Claude News
Often rated the same way. - Digital Trends
Often rated the same way. - Design Better
Often rated the same way.
Similar by topic and creator
- Unstoppable Gadgets
Shares the topics Education and Technology. - Microsoft Azure
Shares the topics Education and Technology. - Great Learning
Shares the topics Education and Technology.
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 yetWork 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 yetStop 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 yetStop 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 yetStop 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 yetBetter 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 yetThe 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 yetSo 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 yetStop 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 yetStop 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 yetStop 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 yetThe 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 yetMake 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 yetThat 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 yet10 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 yetStop 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 yetHow 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 yetI 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 yetThe 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 yet8 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