Excel LAMBDA - HOW & WHEN you Should use it Leila Gharani 2024-10-18 | Excel LAMBDA - HOW & WHEN you Should use it
Stop Wasting Time! 3 Easy Ways to Remove Blank Rows in Excel Leila Gharani 2024-10-17 | Join 400,000+ professionals in our courses 👉 link.xelplus.com/yt-d-all-coursesTired of deleting blank rows one by one? Learn how to quickly remove blank rows in Excel using three simple, time-saving methods!📈 Learn Excel the Easy Way! Start automating tasks and analyzing data faster with our step-by-step courses:Excel Power Query Course: Clean, transform, and automate your data 👉 xelplus.com/course/excel-power-queryExcel Pivot Table Essentials Course: Summarize and analyze your data effortlessly 👉 xelplus.com/course/excel-pivot-tablesJoin now and see how easy Excel can be!In this video, you'll discover:- Go To Special: A fast, under-20-second method to delete blank rows.- Filters & Formulas: Ideal when you want to ensure every cell in a row is empty before deleting.- Power Query: The best dynamic solution that updates automatically, perfect for large datasets.These tips will help you avoid manual work, speed up your workflow, and keep your spreadsheets clean. No more wasted time!Whether you need to remove blank rows or delete multiple rows with blank cells, this video has everything you need. Try these methods and see which one saves you the most time!⬇️ Download the practice file here 👉 https://xelplus.ck.page/remove-blank-rows-file00:00 How to Delete Blank Rows in Excel00:32 Go to Special: Fastest Solution02:13 Filter & Formula: Delete Only Completely Empty Rows04:29 Power Query: The Best Way to Handle Large or Changing Datasets📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:5 Excel Functions EVERYONE Needs: youtu.be/_EWcAR_HkvgHow Power Query Will Change the Way You Use Excel: youtu.be/6lBqYInBldk👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniLinkedIn: linkedin.com/company/xelplusThis 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
Are These Pivot Table Mistakes Costing You? Leila Gharani 2024-09-19 | Join the Excel Pivot Table Essentials course 👉 xelplus.com/course/excel-pivot-tablesMastering Pivot Tables is a valuable, time-saving skill, and I can’t wait to teach you from the ground up.In this video we address common pivot table related questions and how you can avoid them:How can I make sure my pivot table doesn't show outdated data? 🤔How can I connect a slicer to multiple pivot tables?How can I VLOOKUP on a pivot table? 😫Should I stick to the default look of pivot tables?I'm summarized these as the 3 most common Pivot Table mistakes that are slowing you down:1. Auto-Refresh Your Pivot Table – Learn how to make Excel update your data automatically!2. Use One Slicer for Multiple Pivot Tables – Easily filter several Pivot Tables with just one slicer.3. Stop Using VLOOKUP/XLOOKUP – Save time by combining data from multiple tables without writing any formulas.4. Bonus Tip: I’ll also show you how to give your Pivot Tables a clean, professional look in just one minute!00:00 Common Pivot Table Mistakes00:06 Auto-Refresh your Excel Pivot Table01:38 Use One Slicer for Multiple Pivot Tables03:46 Not Using Power Pivot07:07 Missing Formatting💡 Ready to master Pivot Tables?Click the link to join my course: Pivot Table Essentials: Basics to Mastery 👉 xelplus.com/course/excel-pivot-tablesWith practice files, templates, and quizzes, you’ll learn everything you need to become a Pivot Table pro!📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:Excel Pivot Table EXPLAINED in 10 Minutes: youtu.be/UsdedFoTA68Advanced Pivot Table Techniques: youtu.be/yHzT_BUggQk👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniLinkedIn: linkedin.com/company/xelplusThis 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 #pivottable
Common Excel Pivot Table Features People Miss (and you?) Leila Gharani 2024-09-05 | Join Excel Pivot Table Essential course here 👉 xelplus.com/course/excel-pivot-tablesWant to make your Excel Pivot Tables more powerful? In this video, we'll show you some of the best hidden features that most people miss. These simple tips will save you time and make your data analysis easier.We'll start with how to create a pivot table quickly with the help of recommended Pivot Tables. Then, we'll show you how to keep track of important numbers with Dynamic Formatting—even when your data changes.Learn how to highlight top and bottom performers using Conditional Formatting in pivot tables and discover how custom number formatting can make your Excel pivot table reports look professional and clear.Finally, we’ll share how to adjust your default pivot table settings and use report filters to automate your work.⬇️ Download the practice file here 👉 pages.xelplus.com/pivot-table-hidden-features00:00 Pivot Tables Hidden Features00:18 Recommended PivotTables02:02 In-built Dynamic Formatting03:24 Hidden Conditional Formatting Icon05:25 Custom Number Formatting08:26 Set Default Pivot Table Settings10:33 Report Filter Pages12:00 Wrap Up📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:Excel Pivot Table EXPLAINED in 10 Minutes: youtu.be/UsdedFoTA68Advanced Pivot Table Techniques: youtu.be/yHzT_BUggQkCrazy PIVOT TABLE Hacks: youtu.be/ZZRl7fALdjw👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniLinkedIn: linkedin.com/company/xelplusThis 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
Solving Excel COUNT Problems with COUNTIFS Function (practice file included) Leila Gharani 2024-08-08 | Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-coursesThe Excel COUNTIFS function is perfect for counting cells based on multiple criteria. What You’ll Learn:- How to use COUNTIFS- Differences between COUNTIF and COUNTIFS- Count cells with multiple conditions- Use COUNTIFS with OR conditions- Count cells not equal to a value- Count cells greater than a number- Handle blank and non-blank cells- Count cells between dates in Excel- Count cells with partial text using wildcards⬇️ Download the practice file here: pages.xelplus.com/countifs📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter00:00 COUNTIFS Function in Excel00:46 COUNTIF vs COUNTIFS01:21 COUNTIFS Function in Excel with Multiple Criteria03:37 Excel COUNTIFS OR05:17 Excel COUNTIFS Not Equal To06:20 Excel COUNTIFS Greater Than07:29 Excel COUNTIFS Not Blank08:42 Excel COUNTIFS Date Range09:59 Excel COUNTIFS Contains Partial Text11:42 Wrap Up➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:How to Use SUMIFS, COUNTIFS and AVERAGEIFS in Excel: youtu.be/AZuBNWMh7VMHow to SUMIFS With Multiple Criteria In the SAME Column in Excel: youtu.be/3BnvDPQk9o0👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniLinkedIn: linkedin.com/company/xelplusThis 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
Excel TRANSLATE Function (yes, its new and its pretty cool!) Leila Gharani 2024-07-11 | Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-coursesLearn how to use the amazing new Excel TRANSLATE function to translate text and instructions into over 100 languages. Perfect for business forms, input sheets, team instructions, and more!There is also a DETECTLANGUAGE function that detects the language of the text. ⬇️ Download the Excel practice file here: pages.xelplus.com/excel-translate-fileWhat You'll Learn:- How to add a language dropdown in Excel- Step-by-step guide to using the Translate function- Practical examples of translating text dynamically- Tips for using the Detect Language function00:00 How to Translate in Excel01:04 Excel TRANSLATE Function03:27 Detectlanguage Excel Function03:54 Practical uses of TRANSLATE Function05:58 Translate Data Entry Sheets08:13 Wrap UpWhy You'll Love The TRANSLATE Function:- Makes working with international teams easier- No more manual translation—save time and effort- Everything stays dynamic and up-to-dateAvailability: These functions are currently available to Beta Channel users running Windows version 2407 (Build 16.0.17808.20000) or later. 📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:How to Use Excel XLOOKUP: youtu.be/4c0CLUER6nw5 Excel Functions EVERYONE Needs: youtu.be/_EWcAR_Hkvg👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniLinkedIn: linkedin.com/company/xelplusThis 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
How to Use Microsoft To Do | Grocery Shopping List and much more Leila Gharani 2024-07-09 | Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-coursesDo you always forget your grocery list? 📋 Don't worry! Learn how to use the Microsoft To Do app to keep track of your shopping list effortlessly. In this video, I'll show you how to create, manage, and share your grocery list with ease.What You'll Learn:⩥ How to create a grocery list in Microsoft To Do⩥ Adding items and setting reminders⩥ Syncing your list across devices⩥ Sharing your list with othersMicrosoft To Do is part of the Microsoft 365 family. Use it as your shopping list app to make grocery lists simple and efficient. 📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:How to Use Microsoft To Do & Get Organized! youtu.be/uUvp0XgE--s👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniLinkedIn: linkedin.com/company/xelplusThis 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
How to Screenshot on Windows 11 📸 - Cool New Updates Leila Gharani 2024-06-20 | Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-coursesLearn how to take screenshots on Windows 11 quickly and easily. This video covers everything from basic shortcuts to advanced Snipping Tool features. No need for extra apps – it's all built-in and free! You now have the ability to add emojis in the Snipping tool. You can add arrows and shapes. You can also use the ruler using the shortcut keys Control R. It can also be found in more options (the three dots). Note: You might not see the new features in your version of Windows yet. These are still in Windows insider program.Quick Methods:⩥ Windows Key + Print Screen: Saves screenshot to clipboard and "Screenshots" folder. Paste with ⩥ Ctrl + V.⩥ Print Screen Button: Opens Snipping Tool. Capture area and save.⩥ Windows Key + Shift + S: Opens Snipping Tool for easy snipping.Snipping Tool Features:⩥ Screenshot Modes: Rectangular, Window, Full-Screen, Free-Form.⩥ Annotations: Add arrows, shapes, emojis, and text.⩥ Delay Timer: Capture disappearing elements.⩥ Text Actions: Extract text, black out sensitive information and open QR code links.Recording Videos:Windows Key + Shift + R: Record screen activity.Customize Settings:Adjust auto-save and Print Screen shortcuts via Snipping Tool settings.00:00 How to Take a Screenshot00:30 Screenshot Shortcuts02:22 How to Use Snipping Tool03:50 Take Screenshot with Delay04:35 Annotate Your Screenshot05:37 Add Shapes and Emojis to Screenshot07:22 Extract Text from Screenshot07:36 Extract Link from QR Code07:58 Redact Sensitive Information08:36 Visual Search / Reverse Image Search09:06 Take a Video Screenshot10:14 Important Settings for Snipping Tool11:07 Disabling Snipping Tool Opening with Print Screen11:19 Wrap Up📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 Amazing Windows Shortcuts: youtu.be/QKjV_GdkTTw👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniLinkedIn: linkedin.com/company/xelplusThis 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!#windows11 #screenshot
Introducing REGEX Excel Functions - Extract, Clean, and Format Data Easily! (NEW!) Leila Gharani 2024-05-22 | Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-coursesRegex, or regular expressions, is now available in Excel beta version! This makes it SO much easier to search, match, and manipulate text. (note: currently not all beta users have access. Microsoft is slowly rolling these out.)⬇️ Download the free RegEx workbook and cheat sheet: pages.xelplus.com/regex-excel-fileWith regex, you can quickly find all email addresses in a list, reformat dates, or correct typos in a large dataset. You can extract phone numbers from text or change the format of thousands of rows with just a few clicks. In this video we'll cover two new Excel functions:▶ REGEXEXTRACT: This Excel function extracts specific text from a string using patterns called regular expressions (regex). It can find and pull the first match, all matches, or parts of the first match.▶ REGEXREPLACE: This Excel function lets you replace parts of a text string using patterns called regular expressions (regex). This is useful for cleaning up data or making consistent changes across a dataset.00:00 Regular Expression Regex in Excel02:37 Extract Email Addresses with Excel REGEXEXTRACT07:37 Extract Text Inside Parentheses with Excel REGEXEXTRACT09:27 Extract Dates from Text with Excel REGEXEXTRACT10:56 Extract Multiple Dates from Text in Excel11:49 Extract Website URL from Text in Excel14:31 Split Combined Words in Excel14:59 Replace Leading Zeros with Excel REGEXREPLACE16:06 Replace Special Characters with Excel REGEXREPLACE17:30 Insert a Character at Specific Positions18:34 RegEx Cheat Sheet18:47 Wrap up📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:We FINALLY get the New Excel functions we've been Wanting! youtu.be/VWcLM6_Q_00New Excel GROUPBY & PIVOTBY Functions: youtu.be/mCJzhCxEQlM👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniLinkedIn: linkedin.com/company/xelplusThis 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 #regex #regularexpressions
How to Use VLOOKUP in Excel (free file included) Leila Gharani 2024-05-09 | Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-coursesExcel VLOOKUP is one of the most essential functions in Excel. In this tutorial for beginners you'll learn how to properly use Excel VLOOKUP without mistakes. You’ll learn how to quickly find information from different sheets, get exact or closest matches, and troubleshoot common errors. VLOOKUP Excel saves you time and reduces mistakes by automating data searches across your spreadsheets.⬇️ Download the free practice workbook here: pages.xelplus.com/vlookup-excel-file00:00 VLOOKUP Excel00:50 How to Do a VLOOKUP Formula05:29 VLOOKUP Across Sheets07:09 VLOOKUP Approximate Match09:14 VLOOKUP Not Working11:29 NA Error in VLOOKUP12:18 Get rid of NA Error in VLOOKUP14:31 XLOOKUP ExcelWe start with the basics: how to do a VLOOKUP to find related information, like a customer’s profession from another dataset. You’ll learn how to set up your data range correctly and discover the importance of fixing the table array to avoid shifting ranges when copying formulas. This practical VLOOKUP example shows you the essentials of how to use VLOOKUP effectively.We also dive into advanced VLOOKUP techniques, including how to use VLOOKUP across different sheets, how to find exact matches with the FALSE parameter, and how to handle approximate matches efficiently. Plus, we tackle common VLOOKUP errors and show you how to correct them using simple adjustments and functions like TRIM and IFNA.By the end of this video, you'll be equipped to use the VLOOKUP formula confidently. You’ll understand why it’s a go-to tool for Excel users seeking to streamline their data analysis tasks. 📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:How to Use the NEW & IMPROVED Excel XLOOKUP: youtu.be/4c0CLUER6nwHow to do a Left Lookup in Excel: youtu.be/Xz1KHEhqUCY👕 Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniLinkedIn: linkedin.com/company/xelplusThis 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
Fast & Easy! McKinsey Chart in Excel. Watch this... Leila Gharani 2024-04-16 | Join Business Charts in Excel course👉 link.xelplus.com/yt-d-pro-bizcharts-course Learn to quickly make professional charts in Excel. These are simple, modern Excel charts that communicate your data clearly and in an engaging way. This tutorial shows you how to design charts similar to those used in top industry reports. They fit in any corporate report or consulting presentation. The best part? We use a simple Excel function to create the chart. This is Excel's hidden Chart Function! The method is ideal for improving your business reports with effective visuals, without the need for complex software. Just with a few clicks you'll be able to create an impressive McKinsey chart in Excel. This McKinsey chart is often referred to as the lollipop bar chart or the pin horizontal chart. You can also use this Excel function to create a super fast bar chart in Excel. Tweak it to create a star bar chart or use any symbol you like. It's so flexible and easy, you'll love this simple Excel hack. Learn about:◊ Using the REPT function to customize chart bars with emojis and symbols.◊ Modifying charts dynamically to adapt to data changes instantly.For more detailed insights and advanced techniques, check out our full course on Business Charts in Excel. This course is designed to help you create charts that stand out in any professional setting, mimicking the sophisticated styles seen in publications like The Economist and McKinsey reports.00:00 Use THIS Excel function to Create a McKinsey chart00:30 Create a Excel McKinsey Chart in 90 seconds02:24 Customize the Chart06:49 New Course: Business Charts in ExcelJoin 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:Make Beautiful Excel Charts Like The Economist: youtu.be/wP8NWRR0Fdg👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniLinkedIn: linkedin.com/company/xelplusThis 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
Make Beautiful Excel Charts Like The Economist (file included) Leila Gharani 2024-03-14 | 🆓 Try think-cell for free: tinyurl.com/xelplusWant to make charts in Excel that look as good as the ones in The Economist magazine? This video shows you how. We cover three types of charts from The Economist: A special type of Bar Chart, Dumbbell Charts (also known as connected dot plot or before after chart), and Color-Coded Tables. These are professional Excel visuals you can add to your corporate presentation. You can also apply these Excel chart techniques to create other charts you come across from The Economist or elsewhere in news magazines or social media.👉 Business Charts in Excel course is now available 👉 link.xelplus.com/yt-d-eco-bizcharts-course. ⬇️ Download the free charts workbook: pages.xelplus.com/economist-charts-fileYou'll learn how to set them up step by step, making your data presentation clear and engaging. This guide is perfect for beginners and anyone looking to improve their Excel skills. By the end of this tutorial, you'll be able to create eye-catching charts that can help in any report or presentation.🔸 Easy-to-follow chart making in Excel🔸 Create professional-looking charts like The Economist Magazine quickly🔸 Tips for dynamic and clear data presentations in Excel00:00 How to Make a Graph in Excel like The Economist Magazine00:26 Bar Chart04:32 Dumbbell Chart11:07 Sponsor think-cell12:45 Color-Coded Table18:36 OutroJoin 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:Excel Charts & Graphs: Learn the Basics for a Quick Start: youtu.be/DAU0qqh_I-ACreate Impressive Infographics in Excel: youtu.be/8g9DK5noi1s👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniLinkedIn: linkedin.com/company/xelplusThis 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!Many thanks to think-cell for sponsoring this video.#Excel #theeconomist
Easy Trick for Sorting Columns in Power Query #shorts Leila Gharani 2024-02-25 | Did you know you can custom sort your columns in Power Query with this trick? It's a cool hidden Power Query feature in Excel.Join 400,000+ professionals in our courses: xelplus.com/coursesHere is a simple trick on how to automatically sort columns in Microsoft Excel Power Query. 🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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
Answering Uncomfortable Questions with Oz du Soleil Leila Gharani 2024-02-22 | Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-coursesToday's episode is unlike any other! We're delighted to welcome Oz du Soleil, a fellow Excel MVP from Las Vegas, to dive deep into some of the most intriguing and challenging topics you've been curious about. From overcoming life's hurdles to mastering Excel and sharing personal triumphs, Oz opens up like never before. Expect a blend of humor, wisdom, and actionable insights that you won't find anywhere else.What makes Oz's journey compelling? How does he tackle the complexities of Excel and life with equal finesse? We've got your questions covered, and trust us, you'll want to hear Oz's answers. Whether you're seeking inspiration, Excel hacks, or just a good story, this episode has something for everyone.Links to mentions in the video:🔗 Oz on YouTube: youtube.com/channel/UCZgOVykPoRbSZQfY9YysiRQ🔗 Oz on LinkedIn learning: linkedin.com/learning/instructors/oz-du-soleil🐎 Fiaker Baron in Vienna: fiakerbaron.info🐎 Information on animal protection and how horses are treated in Austria: fiaker.info🔗 Nellie Bly Kaleidoscope store: shop.nbscopes.com🔗 Kaleidoscopes by Mikio: https://mikio00sk.thebase.in/📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter00:00 Introduction00:54 Oz incoming02:18 How is Vienna?04:07 How do you become a Microsoft MVP?07:02 What personality is MVP life for?11:48 Oz's background21:56 What was your Plan B?26:47 Oz's personal struggles32:33 Experience with discrimination38:51 How to manage business ups and downs and persist?47:41 Are you married?48:31 Do you get recognized?49:34 Is Oz a dirty data assassin?50:06 The most evil Excel function?53:34 How to give your data a red mohawk?53:52 Oz's Excel improvement idea56:18 Oz and the kaleidoscope scene?59:20 Jumping on the horse (Fiaker)➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniLinkedIn: linkedin.com/company/xelplusThis 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
Use Slicers to Filter Excel Data #shorts Leila Gharani 2024-02-04 | This is a cool way of filtering tables using slicer buttons instead of filter buttons.Join 400,000+ professionals in our courses: xelplus.com/coursesSlicers create buttons that you can simply click to filter data. This works in Microsoft Excel tables, or PivotTables. They also show you quickly, which filters are set. This makes it easy to understand what exactly is currently displayed.🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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
How to Custom Sort a Pivot Table #shorts Leila Gharani 2024-01-28 | Join 400,000+ professionals in our courses: xelplus.com/coursesHere is a simple trick on how to custom sort your date in a Microsoft Excel Pivot Table. 🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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
How to freeze a row in Excel (& freeze multiple rows or columns with just one click) #shorts Leila Gharani 2024-01-21 | 🌍 Join 400,000+ professionals in our courses ► xelplus.com/courses📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletterStruggling to keep track of headers while scrolling through large datasets in Excel? Say goodbye to that frustration! In this video, we're diving into a simple yet impactful feature: Freezing Panes in Excel. You can free the top row so when you scroll, the top row is always visible. You can also freeze multiple rows or multiple columns in Excel with just one click. This is perfect for maintaining a clear view of your important data, no matter how big your spreadsheet is!📖 Full blog post: xelplus.com/how-to-freeze-a-row-in-excel📌 What You'll Discover:How to freeze a single row or multiple rows to keep headers visible.Steps to freeze panes for both rows and columns, allowing for easy navigation sideways and downwards.🔥 Key Takeaways:Enhance your data management skills in Excel with ease.Ideal for professionals dealing with extensive data reports.Learn to navigate large datasets without losing sight of key information.👥 Who Should Watch:Excel users at any level looking to improve their navigation skills.Professionals seeking efficient ways to manage large Excel reports.Non-native English speakers desiring straightforward, professional Excel tips.➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: 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
Excel GROUPBY & PIVOTBY Functions - All You Need to Know (do they BEAT Pivot Tables? 🤔) Leila Gharani 2024-01-12 | Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-coursesData analysis in Excel just got easier! Let me introduce you to the new Excel functions in Office 365: Excel GROUPBY and PIVOTBY functions. With these Excel functions you get to replace pivot tables with simple Excel formulas. In the video I cover the advantages of GROUPBY and PIVOTBY over pivot tables - for example the ability of GROUPBY to aggregate text values which pivot tables can't do. Also the ability to clean your data, for example remove total rows in the middle of your dataset or exclude certain rows with the Groupby and Pivotby functions. You also no longer need to refresh your data to get the latest result because formulas update automatically. ⬇️ Grab the workbook I use in the video here: pages.xelplus.com/groupby-pivotby-functionIn addition you'll learn about GROUPBY's optional arguments, like displaying headers, managing totals, and sorting data. A key highlight is its ability to process text values, offering unique text aggregations which is a notable advantage over Pivot Tables.See GROUPBY in action as it tidies and analyzes complex data sets, easily filtering out unnecessary information for clearer reports. I also demonstrate how it efficiently groups sales data by year or month.Finally, get to know PIVOTBY. This function is great for reducing vertical scrolling in reports, by shifting one or more of the categories to columns for a more concise and readable format.Availability: GOUPBY & PIVOTY are currently available for Microsoft Insider Beta Channel only. 00:00 Why these new Excel functions completely beat Pivot Tables!00:19 How to use Excel's GROUPBY function02:19 How to use GROUPBY Optional Argument Field Headers03:30 GROUPBY Optional Argument Total Depth04:43 GROUPBY Optional Argument Sort Order05:43 GROUPBY - How to Aggregate Text Values07:27 How to Exclude Unwanted Rows with Filter Array11:27 How to GROUPBY Years & Months12:57 How to Combine Different Columns13:57 How to use Excel's PIVOTBY function16:14 Wrap Up➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:Excel LAMBDA - HOW & WHEN you Should use it: youtu.be/Rm4y5UqauRwNew Excel Functions: youtu.be/VWcLM6_Q_00➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resources🚩Let’s connect on social: Instagram: instagram.com/lgharani LinkedIn: linkedin.com/company/xelplusThis 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
🔥 How to create a drop-down list in Excel in seconds! Leila Gharani 2024-01-07 | 🌍 Join 400,000+ professionals in our courses ► xelplus.com/courses📨 Subscribe to our "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletterIn this Excel tutorial, we're showing you a simple yet powerful way to improve your Excel reports: adding a dynamic, searchable drop-down list in Microsoft 365! Perfect for making your reports more interactive and user-friendly.🔍 What You'll Learn:How to create a drop-down list using data from a different sheet.Steps to implement the data validation feature in Excel.Duplicates are automatically removed and the drop-down is even searchable. 📈 Who Should Watch:Excel users looking to improve their report presentation.Anyone interested in making their data more accessible and interactive.Non-native English speakers in corporate roles, seeking clear and professional Excel guidance.➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: 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
Quick & Easy: Browser Shortcuts to Make Life Simpler #shorts Leila Gharani 2023-12-17 | Join 400,000+ professionals in our courses: xelplus.com/coursesLet's learn how you can surf the web a lot smoother with some handy keyboard shortcuts. 🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: 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!#windows
Master Excel Web Scraping - Learn How to Import Data AND Images (with ZERO Coding) Leila Gharani 2023-12-14 | Learn Power Query now with our Beginner to Pro course: link.xelplus.com/yt-pqweb📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletterWith the recent updates to the Power Query web connector you can grab data from pretty much any web page and bring it over to Microsoft Excel. Plus you'll have a connection to the webpage. Which means, just click the "refresh" button and pull over the latest information.🤔 One challenge I was excited to tackle was to import "clickable" URL links AND images with Power Query into Excel. Yes. It's possible to have clickable links in the Power Query extract. It's also possible to extract images from web pages! Check out the video to see my solution. 👉 What You'll Learn:How to use Excel's web connector for easy data import.Tips for importing data from web pages without HTML tables.Creating dynamic, clickable links and images in Excel with ease.📊 Excel Your Skills:Perfect for analysts, Excel enthusiasts, and anyone interested in data management.Step-by-step guidance, making it accessible for beginners and a time-saver for advanced users.🌍 Join 400,000+ professionals in our courses ► xelplus.com/courses🔍 Key Moments in This Video:00:00 - Introduction to Excel's Web Connector02:30 - Importing Data from Web Pages04:38 - Add Table Using Example09:10 - Creating Clickable hyperlinks in Power Query12:01 - Importing web images12:40 - Updating webpage to test13:28 - Wrap Up🎬 LINKS to related videos:How Power Query Will Change the Way You Use Excel: youtu.be/6lBqYInBldkYou WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query: youtu.be/8hjgmJk5RiA➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniLinkedIn: linkedin.com/company/xelplusThis 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
Dont Type the Dot! | How to Get Power Query Intellisense To Work #shorts Leila Gharani 2023-12-03 | Join 400,000+ professionals in our courses: xelplus.com/coursesFor the longest time, entering M-Functions in Microsoft Power Query was a frustrating exercise for me. Until I discovered the trick I'm sharing in this video. 🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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 #powerquery
Create an Excel Dashboard to Easily Track Budget and Actuals with Variances Leila Gharani 2023-11-30 | Get Zebra BI-Pro for free for 30 days: bit.ly/3GjXFKVIn this step-by-step Excel tutorial, we'll create a dynamic and interactive Excel dashboard from scratch. We'll be comparing Actuals to Budget and Previous year data. The Actual data is on another sheet in an Excel table and it has a different structure so we have to use an Excel formula that enables us to lookup values in three different columns and match them so we can find the correct row. You can use different formulas. I used XLOOKUP but you can also use Index and Match (youtu.be/ontXHp9cwOQ) in case you don't have XLOOKUP. Our next challenge is to bring over budget data from another sheet. This time we have to match the rows and the columns. Again, you can use Index Match or XLOOKUP (I show the XLOOKUP approach). ⬇️ DOWNLOAD the workbook here: pages.xelplus.com/actual-budget-fileI also show you how add a drop-down for months and use a formula to grab the current year. Then I move on to variance calculations (percentage change). Once we have the information we create a column chart to compare actual and previous year data and also add Excel bar charts to show the variance. We make sure that positive values (bars) are in green and negative bars are in red. We do this dynamically of course using "invert if negative" feature of Excel charts. Lots to cover, so get ready to transform your understanding of actual sales, budget figures, and variances into a visually stunning and informative dashboard.🌍 Join 400,000+ professionals in our courses: xelplus.com/courses🔍 What you'll discover:▶ Excel Dashboard Design: Receive detailed, step-by-step instructions on crafting an automatically updating sales dashboard.▶ Data Management in Excel: Learn effective techniques for extracting data from various sources and establishing intuitive user selections.▶ Advanced Excel Functions: Gain proficiency in XLOOKUP and other critical Excel functions for precise data analysis.▶ Variance Analysis: Understand the methods to calculate and visually present data variances.Excel Chart Visualizations: Acquire skills in adding dynamic column charts for a compelling visual data interpretation.➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join00:00 How to Setup an Interactive Dashboards in Excel from Scratch00:53 Setup of Data 02:20 Drop-Down for Month Selection07:49 Calculate Variance Actual to Previous Year/Budget09:37 Add Visual Insights 14:00 Zebra BI Add-in21:34 Wrap Up🎬 LINKS to related videos:How to Lock Cells 🔒in Excel: youtu.be/8ibe27Zuf0ACalculate Percentages the Right Way in Excel: youtu.be/UN5PckRADyQ➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resources🚩Let’s connect on social: Instagram: instagram.com/lgharani LinkedIn: linkedin.com/company/xelplusThis 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
How to NOT Get Promoted #shorts Leila Gharani 2023-11-26 | Join 300,000+ professionals in our courses: xelplus.com/coursesCareer advice reversed: Here is the Ultimate Guide to sabotaging your career growth and losing motivation at work. Follow these simple steps and you'll make sure that you never move up the career ladder. To be successful in your career and be motivated at work, do the opposite of what is shared or follow what I cover at the end of the video. That's the ultimate way to career growth and being happy at your job.🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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!#careeradvice #selfhelp #corporatelife
Excels NEW Checkboxes Are Incredibly Cool! Heres why Leila Gharani 2023-11-16 | Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-coursesIn this video, I'll introduce you to the brand-new checkboxes in Excel. They're simple and much better than the old ways we used to do things. I'll take you through different ways to use these checkboxes, not just for keeping track of your to-do list. In fact, we'll be creating an interactive Excel dashboard using with the checkboxes. ⬇️ Download the file: pages.xelplus.com/checkboxes-new-fileNote on availability: The new Excel checkboxes are currently available in Office 365 beta version.But first, I'll guide you step by step on how to use these checkboxes in Excel. You'll learn how to keep track of your tasks - then you'll learn how count the total number of checkboxes and also how to count the number of checked checkboxes and add it at the top of our Excel sheet. You'll then learn how to combine these checkboxes with formulas for smarter data analysis - I show the combination with the FILTER function in this example - Then you'll learn how to combine the state of the checkbox with conditional formatting, so that you can change the color and formatting of the entire row when an item is checked. Finally, you'll learn how to add a timestamp to a cell when a checkbox is checked. This is great for task and project management.This video is perfect for beginners and for those who want to discover new features in Excel and also learn some dashboard tricks. I've made sure everything is easy to understand, with no complicated terms – just simple, clear steps that you can follow along.🌍 My Online Courses ► xelplus.com/courses00:00 How to Insert Checkboxes in Excel00:19 New Checkboxes in Excel Basics03:23 Count Checked Checkboxes07:05 Combine Checkbox with Formulas08:39 Conditional Formatting with Checkboxes11:02 Bonus! Add a Timestamp when Checked14:00 Wrap Up➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:🆕 Best NEW Excel Features EVERYONE Needs: youtu.be/UnU81ITTsHU👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniLinkedIn: 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
Keep It Private 🤫 Instant Windows Shortcuts for Unexpected Interruptions #shorts Leila Gharani 2023-11-12 | Join 400,000+ professionals in our courses: xelplus.com/coursesIn this video I'll show you how you can quickly hide what you're doing on your computer. 🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: 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!#windows
How to Calculate Change / Variance in Pivot Tables #shorts Leila Gharani 2023-11-05 | Join 400,000+ professionals in our courses: xelplus.com/coursesYou'll learn how to calculate year over year variances in a Microsoft Excel Pivot Table. This works for calculating actual to budget variances as well. 🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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
Excel Time-Savers - 5 Hidden Features for Busy People Leila Gharani 2023-11-02 | 🌍 Dive deep into Power Query with our comprehensive course: link.xelplus.com/yt-d-timesaver-pq-course Discover our full range of courses tailored to help you succeed: xelplus.com/coursesYou'll learn 5 Excel features that are mega time-savers. Useful for beginners and advanced Excel users. All of these tips are easy to apply for any level. Here's what we cover:1. Quick-Jump Excel Bookmarks: Navigating across a large workbook can be challenging. If only there were built-in bookmarks in Excel. There's a trick to achieve the same result, though: use the Name Box.2. Analyze Data for instant insights: You need to quickly analyze an unfamiliar dataset? Why not outsource it to AI! There's an AI feature built into Excel that can do it for you. You'll find it on the Home tab, it's called Analyze Data. When you run it, it will auto-generate some ready-to-use insights in the form of pivot tables and pivot charts, or you can ask for something specific, like "give me 5 products with lowest customer ratings". It will interpret the question in data analyst terms and prepare a pivot table for you. You can then simply insert it into your report.3. One-Click Forecasting: Would you like to forecast your future sales revenues based on past data? Select the dataset, go to the Data tab and click on Forecast Sheet. Future sales data is automatically forecasted, even accounting for seasonality.4. Quick Analysis Tool: This one packs a whole bunch of features in a single shortcut. It's like your personal Excel assistant that you can ask for almost anything. Select the data you're working with, then press Ctrl+Q to bring up the Quick Analysis menu. It allows you to add conditional formatting, charts, totals, tables and sparklines based on your data.5. The ultimate timesaver - Power Query: I've saved the best for last. You probably know by now that Power Query is my favorite tool. It allows you to grab data from many different sources, like text/csv, web, pdf, and more. But it also allows you to do complex transformations on the data right there in your workbook in a couple of very simple clicks. In the video, I show you how to pivot a column, but there's a ton more that you can achieve with this amazing tool. And the best part? It's fully dynamic. When your data grows, all you have to do is refresh.00:00 Excel Timesaver features00:20 Excel Bookmarks02:16 How to delete a bookmark02:30 AI Powered Data Analysis04:29 One-Click Forecasting06:27 Quick Analysis Tool08:48 Power Query the ultimate timesaver09:42 Convert Rows to Columns with Power Query (pivot data)11:45 Learn Power Query from scratch13:37 Wrap UpOnline Courses to Help you Succeed ► xelplus.com/coursesRead the full blog post: xelplus.com/excel-useful-features➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resources🚩Let’s connect on social: Instagram: instagram.com/lgharani LinkedIn: linkedin.com/company/xelplusThis 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
Windows Magnifier to Make Things on the Screen Easier to See #shorts Leila Gharani 2023-10-29 | Join 400,000+ professionals in our courses: xelplus.com/coursesHere is a simple trick on how to use the Windows Magnifier to zoom in and out of your screen. Use the shortcut key for quick zooming in and zooming out.🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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!#windows
New Shortcut to Quickly Search the Menus in Excel #shorts Leila Gharani 2023-10-22 | Join 400,000+ professionals in our courses: xelplus.com/coursesHere is a simple trick on how to quickly search for anything in Microsoft Excel. 🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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
Quickly Rename Excel Tables with This Quick Access Toolbar Trick #shorts Leila Gharani 2023-10-15 | Join 400,000+ professionals in our courses: xelplus.com/coursesAdd table name to your quick access toolbar in Microsoft Excel today. 🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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
Proper Shutdown: Get a clean reboot every time you shutdown your PC #shorts Leila Gharani 2023-10-08 | Join 400,000+ professionals in our courses: xelplus.com/coursesWe've all seen the buttons for Shut down and Restart in Windows. But have you ever wondered what is the difference between a "shut down" and a "restart"? 🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: 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!#windows
How to Make Money with Excel Skills Leila Gharani 2023-10-05 | Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-coursesIn this video, we're diving deep into 6 powerful strategies that will help you turn your Excel skills into a money-making machine! I've personally tested most of these methods, and to make it even more exciting, I've brought in a special guest who will share some eye-opening insights: Jordan Goldmeier - digital nomad entrepreneur. We'll categorize each strategy by its difficulty and profit potential, so you can choose the perfect fit for you. We talk about corporate jobs, consulting (the consulting freedom ladder), books, online courses, speaking opportunities, workshops and social media. There are many ways you can use your Excel skills to make money working online, onsite or from home. These don't need to be full time jobs either, you can start any of them as a side-hustle.*********************🌍 The Global Excel Summit is back and better than ever, and I'm excited to announce that I'm your ambassador for the third time! Don't wait too long - in-person seats are limited. Secure your tickets on the official website: globalexcelsummit.com/?via=leilaUse discount code LEILA upon checkout to get an additional 20% off.📅 Save the Date: February 6-8, 2024📍 Location: Vue Cinemas, Angel Central, London, UK*******************🧑🎓 My Online Courses ► xelplus.com/courses00:00 Unlock Financial Freedom with these 6 Excel Strategies00:40 Corporate Jobs02:50 Consulting05:23 Online Courses07:19 Books09:03 Speaking & Workshops10:36 Social Media11:34 Summary➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resources🚩Let’s connect on social: Instagram: instagram.com/lgharani LinkedIn: linkedin.com/company/xelplusThis 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
How to Repeat and Center Labels in a PivotTable #shorts Leila Gharani 2023-10-01 | Join 400,000+ professionals in our courses: xelplus.com/coursesHere is a quick Excel Pivot Table tip to present your pivot table nicely and professionally. Learn how to repeat labels in the pivot table if you need the have a value on each cell or, if you want to present the pivot table a nice way you can center the labels.🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕 Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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
Great Power Query Tip ▶️ How to Import Entire File Content in Excel or Power BI #shorts Leila Gharani 2023-09-24 | Join 400,000+ professionals in our courses: xelplus.com/coursesYou can easily import entire file contents in Microsoft Excel Power Query by making the one crucial selection I'm sharing in this video. This is a great power query tip for anyone using Excel or Power BI.🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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 #powerquery #powerbi
Dont Use ChatGPT Until You Watch This Video Leila Gharani 2023-09-21 | Get access to "Quick Wins with ChatGPT" productivity course: link.xelplus.com/yt-chatgpt-improve-course 🔥use coupon code YTGPT at checkout to get 30% off - available for limited time 🔥or join 400k professionals in our other courses: xelplus.com/courses⬇️ Get your copy of our ChatGPT cheat sheet: pages.xelplus.com/chatgpt-cheat-sheetToday's video is all about Open AI's amazing language model ChatGPT. 99% of the people use ChatGPT in beginner mode. They don't know how to structure prompts and waste a lot of time going back and forth. I'll show you how you can engineer the perfect prompts to explore the full potential of ChatGPT. From custom instructions to your own writing style, to using ChatGPT as its own critic or prompt engineer and how to get different output formats other than text. Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses00:00 How to Create the Perfect ChatGPT Prompt 00:30 Remember Me - Custom Instructions04:33 Write Like You - Custom Writing Style06:28 Self-Critique07:27 Self-Prompting10:20 Make it Crisp11:30 Different Output Formats13:05 Wrap Up➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:Bring ChatGPT INSIDE Excel to Solve ANY Problem Lightning FAST ► youtu.be/kQPUWryXwagHow ChatGPT Can Help With Your Complex Excel Spreadsheets ► youtu.be/21bXQDXSxYs👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniLinkedIn: 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!#chatgpt #promptengineering
Useful Websites to Use Today #shorts Leila Gharani 2023-09-17 | Join 400,000+ professionals in our courses: xelplus.com/coursesIn this video, you'll discover 6 useful websites you probably didn't know existed. These websites are free to use (or at least have a free version) and they serve different purposes - from keeping you safe to making work fun. You're going to love these websites and tools. 🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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!#websites
Cool Excel Trick 💡Use Slicer Buttons With a Hidden Pivot Table #shorts Leila Gharani 2023-09-10 | Join 400,000+ professionals in our courses: xelplus.com/coursesHere is a simple Excel trick on how to use Pivot Table slicers in a formula based report. Basically you get to connect your formulas to slicer buttons. We'll use a hidden Microsoft Excel Pivot Table to get the slicer functionality and connect the pivot table outcome to the Excel formulas.🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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
Easiest Ways to Export Power BI to Excel Smoothly and Efficiently (new updates included 🪄) Leila Gharani 2023-09-07 | 👉 Join our popular FREE Power BI QuickStart course today: link.xelplus.com/yt-d-AI-powerbi-freecourseMicrosoft Power BI is one of the most used business intelligence tools in today's corporate world. In this video I'll show you how you can effortlessly use Power BI and Excel together. You'll learn how to insert a table or a pivot table in Excel that's linked to a Power BI dataset. We'll also take a look at how to export data from Power BI with Analyze in Excel and live connection. 🌍 Join 400,000+ professionals in our courses: xelplus.com/courses00:00 How to Link Excel to Power BI Data00:46 Create a Table in Excel Linked to Power BI Data04:26 Change Refresh Options for Linked Table04:51 Create a Pivot Table Linked to Power BI Data06:23 Export Power BI Data With Analyze in Excel08:17 Export Power BI Visual With Live Connection10:46 Requirements to Export Power BI to Excel11:18 Wrap Up🎬 LINKS to related videos:Should You Learn Power Bi? ► youtu.be/7ZMQZ0UUuTsHow To Create these useful Power Bi Visuals that Excel Lacks: ► youtu.be/GpP0EbSMRpg➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resources🚩Let’s connect on social: Instagram: instagram.com/lgharani LinkedIn: linkedin.com/company/xelplusThis 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 #powerbi
How to Check Formulas with Value Preview Tooltips - Debugging formulas got easier! #shorts #excel Leila Gharani 2023-09-04 | Join 400,000+ professionals in our courses: xelplus.com/coursesHere is a simple trick on how to use value preview tooltips to check your formula in Microsoft Excel. It's a great way to debug your larger Excel formulas and find out why you're getting wrong results (in case your formula isn't returning the correct answer).🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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
Copy Text From Videos or Images - Power Toys utility #shorts Leila Gharani 2023-08-27 | Join 400,000+ professionals in our courses: xelplus.com/coursesThe utility Text Extractor in Microsoft's Power Toys suite allows you to copy text from anywhere on your screen. Just capture of a region of the screen, and the text extractor will extract the text from the image and copy the content to the clipboard.🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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!#windows #powertoys
Introducing Python in Excel Leila Gharani 2023-08-22 | Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-coursesYou can use Python INSIDE Excel now 😱 In this video I'll introduce this game changing new functionality of working with Python inside Excel. Is Python in Excel for non-programmers? Can everyday data analysts make use of it? I'll answer these in the video.Plus checkout the announcement from Microsoft: techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/ba-p/3893439⬇️ Download the free Python Excel workbook: pages.xelplus.com/python-excel-file🐍 What You'll Learn:▪️ Entering Python Mode in Excel: Master the basics of switching to Python mode in your Excel environment.▪️ Data Frame Creation: Understand how to create and manipulate Data Frames from Excel data, providing a robust structure for analysis.▪️ Custom Python Formulas: Explore the power of custom Python formulas in Excel, expanding your analytical capabilities beyond traditional Excel functions.▪️ Advanced Charting: Dive into creating dynamic charts within Excel cells using Python, offering enhanced data visualization options.If you have this feature which is currently free to use in Microsoft 365 Insiders, you will find Python in the Insert tab in the Excel Ribbon. You get a few Python libraries already ready for you to use in Excel. These are the pandas, matplotlib, seaborn, statsmodels and NumPy. You can import other libraries as you need using the import statement - for example import re module for REGEX calculations. How can you use Python in Excel in practical terms? I share a few ideas in the videos. You can use the pandas library and turn your data into a dataframe which you can then use for more complex tasks, like query the data, unpivot the data with python, create charts using matplotlib - make a line, area or even small multiples. You can grab URLs from long text by using the regex library. You can also use python together with Power Query. We'll only scratch the surface and even that is pretty awesome.00:00 Python in Excel00:40 Enter Python Mode01:32 Send Excel Data to Python - Create Data Frame03:19 pandas Python Library03:43 Python Describe Data05:11 Assign Name to DataFrame05:51 Referencing Headers Shortcut06:26 Examples of pandas Functionalities07:29 Create Series Python Object09:35 Plot a Chart in an Excel Cell10:51 pandas Documentation11:16 Calculation Logic of Python Cells12:07 Examples from Default Libraries13:35 Plot Multiple Charts As Single Object14:49 Importing Libraries & Referencing Tables18:10 Python to Excel Power Query18:35 Wrap Up➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:Introduction to Office Scripts: ► youtu.be/fny4zUycp_wHow to Create & Use Excel Macros: ► youtu.be/An-2Nxf_Dms➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resources🚩Let’s connect on social: Instagram: instagram.com/lgharani LinkedIn: 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!#python #excel
Amazing Windows Shortcuts You Arent Using Leila Gharani 2023-08-10 | Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-coursesIn this video we'll cover my favorite Microsoft Windows keyboard shortcuts that will save you time and increase productivity. These essential shortcuts will make it much faster and more efficient to navigate and do your tasks on a Windows PC. I also share some cool shortcuts you can use in your internet browser. ⬇️ Windows 11 Shortcuts Cheat Sheet, available as a free PDF download 👉 pages.xelplus.com/windows-shortcuts-file▪️ Windows + D (Show Desktop):Function: Instantly view the desktop or return to your active window.Use Case: Handy for quickly clearing the screen or accessing desktop files.▪️ Windows + V (Clipboard History):Feature: Access a history of your copied items, not just the most recent.Benefit: Paste previously copied texts or images from an extended clipboard history.▪️ Windows + Period (Emoji Picker):Function: Easily insert emojis into your text.How-to: Use arrow keys for navigation or search for specific emojis.▪️ Windows + Plus (Magnifier):Utility: Zoom in on specific screen areas for better visibility.Customization: Adjust zoom levels and increments to suit your preference.▪️ Ctrl + K (Search in Browser):Shortcut: Jump directly to the browser's search bar.Efficiency: Saves time by avoiding the use of a mouse for searching.▪️ Ctrl + Shift + T (Reopen Tabs in Browser):Functionality: Quickly reopen accidentally closed browser tabs.Convenience: Tabs reopen in the same order they were closed.▪️ Windows + Tab (Task View):Feature: View all open apps and virtual desktops in an organized manner.Use Case: Efficiently switch between apps and manage virtual desktops.▪️ Windows + L (Lock Screen):Security: Secure your workstation when stepping away.Practicality: Prevent unauthorized access while keeping apps running.▪️ Windows + X, followed by U (Shutdown):Function: Quickly initiate the shutdown process.Tip: For a clean system start, disable Fast Startup in Power Options.00:00 Super Useful Windows Shortcuts00:18 Show Desktop00:52 Clipboard History01:47 Emoji Picker02:08 Magnifier02:47 Search in Browser03:02 Reopen Tabs03:22 Task View03:47 Lock Screen04:08 Shutdown04:34 Wrap Up🌍 My Online Courses ► xelplus.com/courses➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resources🚩Let’s connect on social: Instagram: instagram.com/lgharani LinkedIn: linkedin.com/company/xelplusThis 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!#windows #productivitytips
How to Use TOCOL | TOROW Function in Excel #shorts Leila Gharani 2023-08-06 | Join 300,000+ professionals in our courses: xelplus.com/coursesYou're going to love the new TOCOL & TOROW functions in Microsoft Excel! TOCOL lets you dynamically combine cells across multiple columns and rows into a single column. The TOROW function is very similar - you can combine data from different cells into a single row. In this video I'll show you how it works.Requires Microsoft 365. The TOCOL & TOROW functions will not be available in Excel 2021 and earlier versions. 🌍 My Online Excel Courses ► xelplus.com/courses👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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
Excel Esports on ESPN8, August 4 - Ill be your host with Bill & Oz 🔥 Leila Gharani 2023-07-29 | Tune in at 7 AM (ET), August 4, 2023 to watch the full battle on ESPN8 The Ocho: espnpressroom.com/us/press-releases/2023/07/mas-ocho-espns-biggest-boldest-edition-of-espn8-the-ocho-returns-with-43-straight-hours-of-seldom-seen-sports-august-3-5 Excel Esports Takes the Spotlight on "ESPN8: The Ocho"!Mark your calendars for 7 AM (ET), August 4, 2023, as we gear up for an adrenaline-pumping Excel Esports Elimination Battle - a completely new Excel Esports game format will be revealed!8 Excel enthusiasts will be competing in a fierce 30-minute battle, but every 5 minutes one of them will be eliminated: Andrew Ngai, Isaac Lee, Diarmuid Early, David Brown, Alana Reid, Brittany, Michael, EmilyHosted by Leila Gharani, Bill Jelen, Oz du Soleil!Join 400,000+ professionals in our courses: xelplus.com/courses🌍 My Online Courses ► xelplus.com/courses➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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
Best NEW Excel Features EVERYONE Needs Leila Gharani 2023-07-27 | Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-coursesHere is my list of the best new features and improvements in Microsoft Excel that can really make a difference for you. This includes the new Search the menus feature, the new navigation pane for large workbooks, how to check your formula with the value preview tooltip, dynamic arrays and more. ⬇️ Get your copy of the Cheat Sheet for the best New Excel features here: pages.xelplus.com/new-features-cheat-sheet🔍 Highlights of the Video:- Discover Excel's right-click search feature for effortless command access.- Explore the new Navigation pane, your key to managing complex spreadsheets.- Learn about Excel's latest keyboard shortcuts, including one for Power Query and quick value pasting.- Get introduced to the Automate tab for creating and running Office Scripts.- See the Value Preview tooltip in action, simplifying formula debugging.- Find out how to use Dynamic Arrays as a source in Power Query and in charts.💡 Takeaways:- Leverage new features to simplify and enhance your Excel projects.- Discover innovative ways to manage and analyze data.- Stay current with the evolving landscape of Excel functionalities.00:00 Best New Excel Features You Need to Know About00:17 Easy Search in Excel01:39 Navigation Pane in Excel03:02 New Excel Keyboard Shortcuts03:54 Automate Tab05:56 Value Preview Tooltip06:41 Dynamic Arrays in Power Query08:23 Dynamic Arrays as Charts Source08:51 Wrap Up🎬 LINKS to related videos:Introduction to Office Scripts ► youtu.be/fny4zUycp_wAutomatically Move Completed Tasks to an Archive ► youtu.be/Y7PoYlZUMgoDo You Need to SWITCH from Excel VBA Macros to Office Scripts? ► youtu.be/DOvHqukAGTY➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resources🚩Let’s connect on social: Instagram: instagram.com/lgharani LinkedIn: linkedin.com/company/xelplusThis 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
How to Split Cells to Rows and Columns with TEXTSPLIT in Excel #shorts Leila Gharani 2023-07-23 | Join 300,000+ professionals in our courses: xelplus.com/coursesSometimes you might receive data with data all in the same cell. With Microsoft's new TEXTSPLIT function in Excel you can now split cells in rows and columns. This way you can create proper data table for further data analysis. Requires Microsoft 365. The TEXTSPLIT function will not be available in Excel 2021 and earlier versions. 🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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
Secret FREE Windows Tools Nobody Is Talking About Leila Gharani 2023-07-13 | Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-coursesYour Window experience is about to change. Discover a free set of more than 70 tools and utilities by Microsoft that will give you more control over you PC. You'll be able to troubleshoot, diagnose, manage and monitor your Windows device like never before. You'll be able to test for malware, prioritize certain operations (good for gamers), annotate your screen and a lot more. These free Windows apps have been around since 1996 (!) and yet, not many know about them. They're perfect for developers and IT. Microsoft is still maintaining these tools and even new features are being added. There are free tools there for power users, for real techies but also for anyone who wants to get the most out of their Windows experience.🌍 My Online Courses ► xelplus.com/coursesWhat You'll Explore:▪️ How to Download and Use Sysinternals Suite▪️ Deep Dive into Key Utilities: ZoomIt, Process Monitor, Autoruns, Process Explorer▪️ Techniques for Optimizing Your Windows ExperienceKey Highlights:▪️ ZoomIt: Magnify, Annotate, Record Screen Sessions▪️ Process Monitor (ProcMon): Real-Time System Event Tracking▪️ Autoruns: Identify and Manage Auto-Start Software▪️ Process Explorer: Advanced Task Manager Capabilities⯆ DOWNLOAD Sysinternals on Microsoft: learn.microsoft.com/en-us/sysinternals/downloads 00:00 FREE Windows Power Tools We Can't Live Without00:53 Where to Download01:43 ZoomIt04:22 Process Monitor08:00 Autoruns09:41 Process Explorer11:32 Wrap Up➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resources🚩Let’s connect on social: Instagram: instagram.com/lgharani LinkedIn: linkedin.com/company/xelplusThis 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!#freetools #windows
Create Pivot Tables Like NEVER Seen Before! (include images and data types) Leila Gharani 2023-07-06 | Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-coursesDiscover how to add images and use data types in Excel PivotTables in this tutorial. Perfect for visually enhancing your Excel reports, this guide is a must-watch for anyone looking to elevate their data presentation skills. Here's what you'll learn:🖼️ Adding Images to PivotTables▪️ Learn how to insert images directly into Excel cells using the new 'Place in Cell' feature.▪️ See how images can be included in PivotTables, with the ability to adjust their size for better visualization.🌍 Incorporating Data Types in PivotTables▪️ Understand how to convert data to geographical data types, offering rich information about countries right in Excel.▪️ Discover how to add flags and other country-specific details to your PivotTables for a more informative report.Excel Pivot Tables just got a major upgrade: You can now include IMAGES in Excel PivotTables!I'll also show you how you can make PivotTables more visually appealing by integrating Excel data types like stocks, currencies and geography. I'll also show you how you can even insert your own custom data types. Availability: Microsoft 365 currently only in Beta Insiders channel. 🌍 My Online Courses ► xelplus.com/courses00:00 How to Use Images and Data Types in Your Excel PivotTables01:02 Use Images in Pivot Tables02:35 Using Data Types in Pivot Tables06:02 How to Use Custom Data Types in Pivot Tables08:08 Wrap Up➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:How to Use Excel's NEW Lookup of Images: youtu.be/-BiZjkqgaHcHow to Create Custom Data Types in Excel: youtu.be/sVrtkxjfDkc 👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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
Choose Certain Columns as Output in Excel | CHOOSECOLS & FILTER Combo Leila Gharani 2023-06-25 | Join 300,000+ professionals in our courses: xelplus.com/coursesSometimes you might want to choose only certain columns from your filtered dataset. For example you could apply a FILTER function on your entire data but only have selected columns from this dataset in the output. With a combination of Microsoft's new CHOOSECOLS function together with FILTER you can do just that. Requires Microsoft 365. The CHOOSECOLS function will not be available in Excel 2021 and earlier versions. 🌍 My Online Excel Courses ► xelplus.com/courses🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resourcesMore resources on my Amazon page: amazon.com/shop/leilagharani🚩Let’s connect on social:Instagram: instagram.com/lgharaniTwitter: twitter.com/leilagharaniLinkedIn: at.linkedin.com/in/leilagharani👉 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
How to Use Excels NEW Lookup of Images 👉 Professional Dashboards Just Got Easy ➕ Bonus Reveal Leila Gharani 2023-06-22 | Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-coursesMicrosoft just released a new feature in Excel to insert pictures inside cells. It's called "Place in Cell". This allows us to create more advanced and professional looking Excel dashboards without the need for complex solutions. Inserting images in cells makes it easy to use functions like XLOOKUP or FILTER to return an image. You can now also lookup a picture and return the corresponding information on the same row. So that pictures can be provided as a lookup value to lookup formulas like XLOOKUP. ⬇️ Download the workbook here: pages.xelplus.com/image-in-cell-fileAvailability: Microsoft 365 currently only in Beta Insiders channel. 🌍 My Online Courses ► xelplus.com/courses00:00 How to Insert Pictures Into a Cell in Excel00:32 Insert Images in Excel Cell02:20 Return Images With Formulas04:00 Bonus - Lookup Images05:58 Wrap Up➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:Breaking News! We FINALLY get the Excel functions we've been Wanting!: youtu.be/VWcLM6_Q_00How to Use Excel's New TAKE Function: youtu.be/z66-6WVZSFY➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz🎥 RESOURCES I recommend: xelplus.com/resources🚩Let’s connect on social: Instagram: instagram.com/lgharani LinkedIn: linkedin.com/company/xelplusThis 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
