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/
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.
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 in subject
- excelisfun
Both cover: power query, excel, data analysis
Similar 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 yetWhen 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 yetThe 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 yetExcel'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 yetThought 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 yetBEST 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 yetExcel'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 yetPower 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 yetQuick 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 yetIs 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