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/

Covers: excel, microsoft office, spreadsheet modeling, power query, data analysis, windows 11, copilot, python programming, personal finance, office productivity

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.

Recently on this show

Summary of recent videos, drawn from the publisher's feed.

This channel covers Excel, Power Query, Power BI, Python in Excel and finance, plus AI and how we work. Recent videos include connecting Power Query to OneDrive files, building interactive Excel dashboards, and auditing an unfamiliar workbook.

Report a problem with this summary

Cosmos

Rated alike

Similar in subject

  • excelisfun
    Both cover: power query, excel, data analysis

See the full Cosmos

Similar shows

See all Education shows

Explore more

Videos

  • Questions you've been asking me (marriage, Excel dying, AI, VBA)

    ยท 17 min

    ๐Ÿ”ฅ 400,000+ enrolled in our Excel & Power BI courses. Join them ๐Ÿ‘‰ https://link.xelplus.com/yt-d-all-courses AI is reshaping Excel. Do coaches still matter? Is VBA still worth learning? Is Excel still a smart bet? AMSR, Marriage - we covered it all. In this Q&A, Leila answers 31 rapid-fire questions on coaching, the skills that last, and how we run this channel. ๐Ÿ“จ 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 Leila mentioned in the video: The greatest Excel musical in the world: https://www.youtube.com/watch?v=RC3lJ-JRyj4 Copilot: You Wonโ€™t Believe What Excelโ€™s Copilot Can Do: https://youtu.be/YOeW8UIWJRQ Leila's Power Query course: https://www.xelplus.com/course/excel-power-query How to Use OneNote Effectively: https://youtu.be/Poepoh1b_3k 00:00 Are you still married? Do you have kids? 00:13 Why ASMR voice? 00:41 Meaning of โ€œLeilaโ€? 00:50 What hobbies do you have? 01:12 Why Austria over US? 01:39 Recognized in public? 02:08 Favorite board game? 02:13 Do you have a stylist? 02:45 Why Excel tutorials? 03:46 When did you learn Excel? 04:19 Monetized before YouTube? 04:38 Advice to younger self? 05:19 Turn talent into a living? 06:07 How tough a boss? 06:21 How long per video? Team size? 07:06 Are you the greatest MVP? 07:59 Future of Excel coaches in the AI era? 08:59 Thoughts on Copilot? 09:32 Will Excel stay relevant? 10:02 Core skills for new BI analysts? 10:44 Excel as side income for accountants? 11:32 Finance to data analytics path? 11:57 How to master Excel? 12:39 Non-IT route to Excel mastery? 13:18 One XelPlus course for career growth? 13:41 Is VBA still worth learning? 14:21 Excel or Power BI focus? 14:31 Why is Power Query overlooked? 15:08 Free YouTube vs paid courses? 16:07 Note-taking tools and tips? 16:24 Another lifestyle video? ๐Ÿ‘•โ˜• 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 #questionsandanswers

    Not rated yet
  • When you realize Excel can do this ๐Ÿ‘€ #excel40

    ยท 1 min

    ๐Ÿ‘‰ 400,000+ people took these courses. Check them out: https://link.xelplus.com/yt-d-all-courses Excel's new Copilot function can grab numbers from words. Get it done with one prompt instead of spending hours doing it manually. ๐Ÿ“จ 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 #excel40

    Not rated yet
  • The New Excel Trick: Instantly Convert Words โ†” Numbers

    ยท 6 min

    ๐Ÿ”ฅ 500,000+ enrolled in our courses. Join them ๐Ÿ‘‰ https://link.xelplus.com/yt-d-all-courses Turn numbers into words for invoices and checks. Flip spelled-out amounts back to digits. Even pull prices out of messy comments. All inside Excel with the new =COPILOT() function. What youโ€™ll learn - Convert prices to words in English - Convert spelled-out numbers back to digits - Return results in another language and currency - Extract prices from free-form text and comments - Write clear prompts and reference cells for accurate results Timestamps 00:00 Convert number to words Excel (No VBA) 00:21 Numbers to Words in Excel with COPILOT 01:28 Convert words to digits in Excel 01:53 Numbers to Words in Any Language 03:14 Extract numbers from text 05:24 Wrap up ๐Ÿ“จ 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: Convert NUMBERS to WORDS in Excel: https://youtu.be/1HVLSuAZEtQ New Excel COPILOT Function: Too Good to be True? https://youtu.be/CGxt_ENdsvE ๐Ÿ‘•โ˜• 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
  • Excel's Most Insane AI Function (Now Retired by Microsoft)

    ยท 12 min

    ๐Ÿ“Œ NOTE: Microsoft officially retired the Excel Copilot function on September 14, 2026. This video is kept for reference/archival purposes. ๐Ÿ”ฅ 400,000+ enrolled in our courses. Join them ๐Ÿ‘‰ https://link.xelplus.com/yt-d-all-courses In this video youโ€™ll see how I use COPILOT to understand the meaning behind the text and classify text into categories. For example to pull Next Steps from shift notes, split free text into Topic, Risk, Owner, Due Date, run sentiment analysis, and clean job titles to a standard list. Yes. You can do fuzzy text matching with copilot not based on the letters in words but based on the underlying meaning to text. Fast and practical. 00:00 New Excel COPILOT Function 01:37 Extract Next Steps from notes with COPILOT Function 03:38 Split free text into multiple columns 05:59 Sentiment analysis on customer reviews in Excel 09:38 Clean inconsistent data 11:04 COPILOT pros, cons, limits and best practices 11:45 Wrap up Who this helps Project managers. Analysts. HR and Ops teams. Anyone who deals with messy text and wants clean, useful output inside Excel. What youโ€™ll learn - Write short prompts that reference your cells - Turn notes into a structured table - Tag reviews with sentiment and categories - Normalize labels and get a confidence score - When to lock results by pasting Values - How to combine COPILOT with FILTER() and LEN() Availability and requirements - COPILOT is currently in Beta for Microsoft 365 Insider Beta Channel and requires a Microsoft 365 Copilot license. - Usage limits apply. Up to 100 COPILOT calls per 10 minutes. Results may change on recalculation. Review outputs before you rely on them. ๐Ÿ“จ 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: What's Python in Excel + Do You REALLY Need it?: https://youtu.be/5PB4yeZucUk You're ONE DOT Away from Cleaner Excel Reports: https://youtu.be/5h4wRTbmsSw ๐Ÿ‘•โ˜• 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
  • Thought It Was Gone. AutoSave Had Me. #Excel40 #Excel

    ยท 1 min

    Did you know Excel turns 40 on September 30th? And AutoSave was first introduced in 2016! ๐Ÿ”ฅ 400,000+ professionals trust our courses - start here ๐Ÿ‘‰ 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
  • BEST Pivot Table Hacks You're Not Using #Excel40 #Excel

    ยท 1 min

    Did you know Excel turns 40 on September 30th? And Excel PivotTables were first introduced in 1993! ๐Ÿ”ฅ 400,000+ professionals trust our courses - start here ๐Ÿ‘‰ 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 #Excel40

    Not rated yet
  • Excel's Secret Number Format Options #Excel40 #excel

    ยท 2 min

    Excel Custom number formatting was first introduced in 1985! ๐Ÿ”ฅ Join 500,000+ professionals in courses ๐Ÿ‘‰ 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 #Excel40

    Not rated yet
  • Power Query for Beginners: Automate Your Excel Work in 25 Mins

    ยท 27 min

    Learn Power Query in Excel: clean messy data, combine CSV files and reshape reports. โฌ‡๏ธ Sample files: https://www.xelplus.com/learn-power-query/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-pq&utm_content=learn-pq#download-section ๐ŸŽ“ 500,000+ enrolled in our courses. New to Power Query? Start with Power Query Foundations ๐Ÿ‘‰ https://courses.xelplus.com/p/power-query-foundations?utm_source=yt-video&utm_medium=vid-description&utm_campaign=pq-foundations&utm_content=learn-pq Three real scenarios, built with clicks in the ribbon and no formulas. Power Query records every step, so the next time new data arrives, just refresh. Download the sample files and follow along. 1. Messy data: blank rows, empty cells and double headers, cleaned and loaded as a table or PivotTable. 2. Multiple files: CSV files in a folder combined into one data set. Works for TXT and Excel files too. 3. Reports: months across columns turned into a proper data set with Unpivot, ready for PivotTables. Find Power Query on the Data tab, under Get & Transform Data. 00:00 Power Query for beginners: why use it 01:01 How to clean messy data in Excel 02:01 Where to find Power Query in Excel 03:09 How to connect to another Excel workbook 04:45 Power Query Editor and Applied Steps 06:42 How to remove top rows and promote headers 07:55 How to check data quality (Column Quality) 08:54 How to remove blank rows and fill down 10:13 How to replace values and change text case 11:59 How to add a calculated column 12:57 How to load and refresh Power Query data 15:50 How to combine multiple CSV files in Excel 19:12 How to filter files in a folder query 22:00 How to turn a report into a data set 24:06 How to unpivot columns in Power Query 25:22 PivotTable by quarter from Power Query ๐ŸŽ“ Full Power Query course: https://link.xelplus.com/yt-course-powerquery ๐ŸŽฌ How Power Query Will Change the Way You Use Excel: https://youtu.be/6lBqYInBldk ๐ŸŽฌ 10 hidden features in Power Query: https://youtu.be/8hjgmJk5RiA โžก๏ธ 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 #exceltips

    Not rated yet
  • Quick hello and letting you know about our new Python in Excel course

    ยท 26 sec

    ๐Ÿ”ฅ Link to Python in Excel course: https://www.xelplus.com/course/python-in-excel/ ๐Ÿ“จ 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 #python

    Not rated yet
  • Is Python in Excel Actually Useful? (What You Need to Know)

    ยท 8 min

    ๐Ÿ”ฅ New course: Learn Python in Excel โ€” already 3,000+ enrolled. Solve real data problems, right inside Excel ๐Ÿ‘‰ https://www.xelplus.com/course/python-in-excel Python is now built into Excel (Microsoft 365 version and Excel on the Web) and it's changing how people work with data. If you use Excel for reports, advanced data analysis, or dashboards, Python in Excel can save you hours. Because Python has so many different libraries, you don't need multiple helper columns to get to your results. Python also opens up new ways to analyze data and use machine learning tools like SciKit-learn to detect anomalies or perform clustering using KMeans. You can create visuals from the Seaborn library that are not possible with Excel charts. Find relationships between multiple variables easily. Deep analysis is not easy with standard Excel features - but Python now makes it easy. In this video, Iโ€™ll show you: - What Python in Excel actually does - Real-World Example: How to use Python to compare trading strategies - How to use tools like Copilot and ChatGPT to write Python code (even if you're not a programmer) - Is it worth learning Python in Excel? You'll see how easy it is to build powerful charts, run advanced analysis, and clean data โ€” right inside Excel. โœ… Perfect for Excel users in finance, project management, data analysis, or anyone who works with numbers. ๐Ÿ“จ 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 00:00 What is Python in Excel 00:57 Real Example: Comparing Investment Strategies 02:26 Python Inside Excel 03:46 Free vs Premium Python Versions in Excel 04:09 Why Learn Python in Excel 05:08 Using CoPilot for Python in Excel 07:01 How to Learn Python in Excel ๐ŸŽฌ LINKS to related videos: Introducing Python in Excel: https://youtu.be/FbBXtqtRnWU Python in Excel: 1-minute Hacks You Can Use Today: https://youtu.be/FicDbWkofnI ๐Ÿ‘•โ˜• 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 #python

    Not rated yet