How To Import & Clean Messy Accounting Data in Excel | Use Power Query to Import SAP Data Leila Gharani 2024-10-18 | How To Import & Clean Messy Accounting Data in Excel | Use Power Query to Import SAP Data
Dont Use ChatGPT Until You Watch This Video Leila Gharani 2023-09-21 | Join 400,000+ professionals in our courses: xelplus.com/coursesToday'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. 🌍 My Online Courses ► xelplus.com/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/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!#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 | Get Access to the Bestselling Power BI course: xelplus.com/course/fast-track-to-power-biMicrosoft 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➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 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👕☕ 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 #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: xelplus.com/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/3893439If 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.🌍 My Online Courses ► xelplus.com/courses00: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👕☕ 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!#python #excel
Amazing Windows Shortcuts You Arent Using Leila Gharani 2023-08-10 | In 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. Join 400,000+ professionals in our courses: xelplus.com/courses00: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🎬 LINKS to related videos:► Do NOT Shut Down Your Computer! youtu.be/a83EmWtZMfg► Cool Free Windows Utilities to Use EVERYDAY youtu.be/ZlyxesiiC6U👕☕ 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 #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: xelplus.com/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. 🌍 My Online Courses ► xelplus.com/courses00: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➡️ 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_wAutomatically Move Completed Tasks to an Archive ► youtu.be/Y7PoYlZUMgoDo You Need to SWITCH from Excel VBA Macros to Office Scripts? ► youtu.be/DOvHqukAGTY👕☕ 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 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: xelplus.com/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/courses⯆ 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🎬 LINKS to related videos:Cool Free Windows Utilities to Use EVERYDAY ► youtu.be/ZlyxesiiC6U5 Mind-Blowing FREE Windows Apps ► youtu.be/yridBTXFme8👕☕ 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!#freetools #windows
Create Pivot Tables Like NEVER Seen Before! Leila Gharani 2023-07-06 | Join 400,000+ professionals in our courses: xelplus.com/coursesExcel 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: xelplus.com/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. Availability: 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👕☕ 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
What Top Doctors Can Teach You About Excel Power Query #shorts Leila Gharani 2023-06-18 | 📢New Course: xelplus.com/course/power-query-recipesThis course is for you if you want to:☑️ Learn how to tackle real-world data problems with Power Query and other automation tools.☑️ Avoid Power Query pitfalls so your queries don't break in a few weeks time☑️ Discover new automation options your managers weren’t aware of so you can automate what comes before and after Power Query...The course page has all the details. Watch the video, read the content, check the curriculum and see for yourself if this course is right for you.I hope to see you inside the course and help you master Power Query and automation. 😊👉 XelPlus.com/courses🌍 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
You WONT BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯 Leila Gharani 2023-06-15 | 📢New Course: xelplus.com/course/power-query-recipesIn this video we'll unlock some hidden gems in your Excel Power Query Editor that you had this WHOLE time. They are simple but they will make your work life a lot easier. Some are also hidden tips when you work with Excel power query results - such as updating query refresh times, adding slicers to tables and also making it easier to change table names in Excel.00:00 Hidden features your Excel Power Query you had this whole time00:22 Power Query Editor Excel Shortcut01:14 Quick Access Toolbar in Power Query02:27 New Course: Automate with Power Query from Leila04:25 Properly Enter M-Functions in Power Query Editor05:32 Zoom-in and out Shortcut Keys in PQ Editor06:05 Automatically Sort Column Headers06:48 Import Entire File Content in Power Query08:01 Add Table Name to QAT-Bar in Excel09:10 Copy & Paste Power Queries to Different Excel Files10:01 Add Slicers to Tables11:09 Adjust Refresh Settings in Excel11:45 Wrap Up🌍 My Online Courses ► xelplus.com/coursesRead the blog post here: xelplus.com/power-query-10-hidden-features➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:How Power Query Will Change the Way You Use Excel: youtu.be/6lBqYInBldkHow To Import & Clean Messy Accounting Data in Excel: youtu.be/TjGbOoKvZ7MConvert Columns to Rows in Excel: youtu.be/JMrfbv2h7p8👕☕ 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
Find Which Exact Color Is In The Picture (Find color code) #shorts Leila Gharani 2023-06-11 | Join 300,000+ professionals in our courses: xelplus.com/coursesWhen working with visuals, you often need to make a graphic that perfectly match a particular color. To use that color, you'll need its exact color code. The best way to find out is to use the Color Picker in Microsoft's Power Toys. 🌍 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
The Secret to Note-taking for Busy People Leila Gharani 2023-06-08 | Join 400,000+ professionals in our courses: xelplus.com/coursesIn this video I'll share my tips for neat and efficient note taking. You'll learn an effective note-taking technique for any type of work: The quadrant method. Whether it's for your work meetings, for your consulting projects, taking notes for school or even for your own personal projects- this method works wonders. It's how I take perfect notes now for every meeting I attend. 🌍 My Online Courses ► xelplus.com/courses➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join00:00 Why You Need An Efficient Note Taking System02:30 How to Takes Notes For Work04:55 Take Notes By Hand06:35 Wrap Up🎬 LINKS to related videos:How to Use OneNote Effectively: youtu.be/Poepoh1b_3k👕☕ 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!#notetaking
🆕 How to Use WRAPROWS & WRAPCOLS Function in Excel #shorts Leila Gharani 2023-06-04 | Join 300,000+ professionals in our courses: xelplus.com/coursesMicrosoft introduced some very useful new functions in Excel. You can use them to rearrange your data in a dynamic way. With WRAPROWS you can take a row or column of values and make it into a table with rows and columns. You just need to tell it how many values you want in each row.The WRAPCOLS function is a tool in Excel that lets you change the shape of a row or column of data. It lets you change a list of values into a table of values. It does this by putting some values in different columns. Requires Microsoft 365. These functions 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 Split Text with Multiple Delimiters with Excel TEXTSPLIT #shorts Leila Gharani 2023-05-28 | Join 300,000+ professionals in our courses: xelplus.com/coursesThe new TEXTSPLIT function in Microsoft Excel allows you to split across columns or down by rows. In this video I'll show you how you can even use multiple delimiter to split text into multiple cells. 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
Announcing the LG supporter squad 😎 Leila Gharani 2023-05-26 | ➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
How to Use Excels New TAKE Function to Impress Your Boss and Colleagues Leila Gharani 2023-05-25 | Join 300,000+ professionals in our courses: xelplus.com/coursesThis tutorial is a step by step deep dive into understanding how to use the Excel TAKE function. With the new TAKE function in Microsoft Excel you can extract a specified number of rows or columns from the start or end of your dataset. This opens many opportunities for data extraction and calculations in combination with other Excel functions. For example, you can combine TAKE with the FILTER function. This way you can filter your dataset by certain criteria and then return the top/bottom rows. Or combine TAKE with SORTBY to sort your data by a certain column and then return the top/bottom N results. We'll also cover how you can combine TAKE with another new function: VSTACK. If you're wondering what the difference between TAKE and CHOOSECOLS or CHOOSEROWS functions are, I cover that in the tutorial. Requires Microsoft 365. The TAKE function will not be available in Excel 2021 and earlier versions. 🌍 My Online Courses ► xelplus.com/courses00:00 How to Use TAKE Function to Extract Data in Excel01:12 How Excel TAKE Function Works02:13 Difference between TAKE & CHOOSECOLS or CHOOSEROWS02:58 TAKE & Average of Last Rows04:12 Combine Excel FILTER and TAKE Function05:13 Combine SORTBY and TAKE Function07:32 Combine VSTACK and TAKE Function09:55 Wrap Up➡️ Join this channel to get access to perks:youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join🎬 LINKS to related videos:Excel VSTACK: Quickly Combine Data from Multiple Sheets: youtu.be/qNz35j5ZevQHow To Use Excel FILTER Function With Multiple Criteria: youtu.be/1mHAVptUKAk👕☕ 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 Properly Copy Formulas to Another Excel File WITHOUT File Reference #shorts Leila Gharani 2023-05-21 | Join 300,000+ professionals in our courses: xelplus.com/coursesLearn the trick to properly copy Excel formulas without file reference: When you copy formulas from an Excel workbook to another Excel file, it creates links referencing the old file. I'll show you how you can easily fix that so the new formulas reference the new Excel file.🌍 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
You Wont Believe These Crazy PIVOT TABLE Hacks! Leila Gharani 2023-05-18 | Join 300,000+ professionals in our courses: xelplus.com/coursesIn this video I'll share my Excel Pivot Table pro tips to make the best use of Pivot Tables in Microsoft Excel. You'll discover hidden productivity tips as well as pivot table hidden tricks for example using a hidden pivot table so you can use Slicers on formulas as well. There is a lot of Excel tips and tricks that many Excel experts don't know yet.00:00 10 Best Pro Tipps for Pivot Tables in Excel00:23 No 1: Fast PivotTable01:06 No 2: Adjust Field Settings01:59 No 3: Timeline slicer03:17 No 4: Pivot Table Without Using a PivotTable 🤔04:56 No 5: Top N Analysis06:36 No 6: Type Over Sorting07:12 No 7: Repeating VS Centering Labels08:15 No 8: Custom Sorting Pivot Table Fields08:54 No 9: Easy %-Change Calculations in Pivot Tables10:31 No 10: Disable Double-Click for Details🌍 My Online Courses ► xelplus.com/courses⬇️ Download the file I use in the video from here: xelplus.com/pivot-table-pro-tips🎬 LINKS to related videos:Excel Pivot Tables 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/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 #pivottable
Resize Multiple Images At Once #shorts Leila Gharani 2023-05-14 | Join 300,000+ professionals in our courses: xelplus.com/coursesDo you need to resize multiple images or photos all at once? In this video, I'll show you how you can use the free Power Toys Windows utility to do that. It's called Image Resizer. It allows you to bulk resize images by dragging and dropping your selected files with the right mouse button. This way, resized pictures can quickly be saved in a different folder.🌍 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
3 Ways to Use Forms in Your Business from Polls to Recruiting + AI Features Revealed! Leila Gharani 2023-05-11 | Join 300,000+ professionals in our courses: xelplus.com/coursesUse Microsoft Forms to as a data collection tool in your Business. Forms has gotten AI updates which will make it easier for you to prepare the forms and analyze the results. In this step-by-step tutorial I'll show you how you 3 ways you can use Microsoft Forms in your business. This applies to you whether you work at a corporate job or you're running your own business. You'll learn how to use surveys, quizzes and polls to gather insights about your customers, team and employees. Learn about the new AI features Forms has gotten recently. There is an AI form generator that prepopulates the forms with questions and answers based on the topic. There is AI generated themes based on the topic of the form. You can add music, share the form with anyone outside the organized, create timed quizzes and get insights from the results with the help of AI. The AI will also help you find patterns in the answers people provide. We'll also cover how to use new features like AI-generated insights, questions with images, timed quizzes, and much more. 00:00 Introduction to Microsoft Forms01:25 How to Create a Survey05:23 How to Share Your Survey05:56 Reviewing the Answers for Surveys06:42 How to Create a Quiz08:55 Reviewing the Answers for Quizzes10:10 How to Create a Poll11:22 Difference Polls vs Forms App in Teams11:59 Wrap Up🌍 My Online Courses ► xelplus.com/courses🎬 LINKS to related videos:How To Send Forms Responses to Outlook With Power Automate: youtu.be/8sg2yGg6Q1gProperly Create Surveys with Microsoft Forms & Export to Excel: youtu.be/nXeYv-W-Wt4👕☕ 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!#microsoftforms #datacollection
How to Use VSTACK HSTACK Function in Excel #shorts Leila Gharani 2023-05-07 | Join 300,000+ professionals in our courses: xelplus.com/coursesYou're going to love the new VSTACK & HSTACK functions in Microsoft Excel! With these power functions you can append your data together. VSTACK dynamically combines arrays into a single vertical array while HSTACK combines them horizontally. In this video I'll show you how it works.Requires Microsoft 365. The TAKE 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 PROPERLY Convert Excel to PDF Leila Gharani 2023-05-04 | Join 300,000+ professionals in our courses: xelplus.com/coursesIn this video I'll show you how to easily convert your Microsoft Excel file to a PDF file. You'll learn 3 different methods to get this done but also some important tips to avoid your text getting cut-off by adding page breaks in Excel, how to repeat header and titles on every page and how to print with landscape orientation. You'll learn how to add page numbers in your Excel sheets which is very important if you decide to print your Excel reports. You'll also learn how to center the content on the PDF page or you might choose not to center the content. Instead have the content start from the top of the PDF page. We cover it all in this video. 🌍 My Online Courses ► xelplus.com/courses00:00 Convert Excel File to PDF00:24 Method 1: Use Shortcut01:18 Method 2: Use Export01:30 Method 3: Use Save As01:47 Best Practice Tips02:36 Page Setup04:04 Add Page Numbers04:55 Landscape Orientation05:03 Repeat Headers on Printouts05:28 Add Page Breaks07:08 The Final Result in PDF07:35 Wrap Up 🎬 LINKS to related videos:How To EASILY Convert PDF to Word: youtu.be/apLkSKszEPkConvert Picture to Data in Excel: youtu.be/68yBb7a1uGU👕☕ 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📚 Excel RESOURCES I Recommend: xelplus.com/resources🎥 GEAR I use: xelplus.com/resources/#gearMore 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 #exceltips
Paste Text ONLY - NEW Shortcut in Word #shorts Leila Gharani 2023-04-30 | Join 300,000+ professionals in our courses: xelplus.com/coursesMicrosoft Word got a new shortcut - Paste text only. Wouldn’t it be great if you could just copy and paste a formatted text without having to manually remove the source formatting like font size, type, or background color?There is a shortcut called “keep text only” or “paste plain text” in other applications like Microsoft Teams. And now it's available in Word for Windows and Word Mac too! I'll show you how it works in this video.Requires Microsoft 365. The shortcut 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!#word #microsoftword
5 Cool Websites When You Are Bored (Watching Free Movies Included 🍿) Leila Gharani 2023-04-27 | Join 300,000+ professionals in our courses: xelplus.com/coursesThese are 5 cool and fun websites for you to enjoy. Whether you’re bored or just need a break from work - or you need a fun website for school. I will show you 5 fun websites that you can visit at any time to instantly cure your boredom. From free movie streaming where you can watch movies legally and for free - to free workout plans, free trivia & games and live radio stations. We've searched the web to bring you the best of the best. 00:00 Fun Websites That Will Cure Your Boredom00:27 Free Movies & Series01:52 Live Radio Stations03:12 Free Workout plans04:08 Learn How Everything Works05:00 Free trivia website05:54 Wrap Up🌍 My Online Courses ► xelplus.com/courses🔗 LINKS to WebsitesTubi TV: tubitv.comRadio Garden: http://radio.gardenMusclewiki: musclewiki.comHowStuffWorks: howstuffworks.comSporcle: sporcle.com🎬 LINKS to related videos:6 Useful Websites You NEED to Use! youtu.be/rvtuQo_8wTA👕☕ 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 use: 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 #fun
How to Use TAKE Function in Excel #shorts Leila Gharani 2023-04-23 | Join 300,000+ professionals in our courses: xelplus.com/coursesYou're going to love the new TAKE function in Microsoft Excel! It let's you dynamically take the parts of a data set (rows or columns) you need. Basically you can use a function to keep the rows you need and discard the rest. In this video I'll show you how it works.Requires Microsoft 365. The TAKE 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 Excel FILTER Function With Multiple Criteria & Return Only the Columns You Need Leila Gharani 2023-04-20 | Join 300,000+ professionals in our courses: xelplus.com/coursesHow can you use the Excel FILTER function with two criteria in different columns? I made a short video about this some time ago: youtube.com/shorts/O20bjXIXQKI - The video today gives you a more detailed explanation as well as more examples on how to use the FILTER function to tackle different data challenges. The FILTER function in Microsoft Excel allows you to filter a range of data based on criteria. This criteria applies to a single column. But what if you need to use the Excel Filter function and apply a condition that applies to multiple columns? You might need to include two or more columns. You might need to account for AND conditions - i.e. the criteria applies to each column, or you might need an OR condition: the criteria applies to either column. There is a trick you can use with the FILTER function that helps you account for multiple columns easily. Once you learn how Excel calculates the FILTER function in the background, you'll learn how to account for any condition, value or criteria you need. Learning this will make you an Advanced Filter functions specialist :).I'll also show you the new way of using the FILTER function and returning only the columns you need: Combine FILTER with the CHOOSECOLS function to return only the columns you need.🌍 My Online Courses ► xelplus.com/courses00:00 Using Multiple Criteria within the Excel FILTER Function00:41 Multiple Criteria With AND 04:58 Multiple Criteria With OR05:51 FILTER function to return specific columns with CHOOSECOLS07:09 FILTER Multiple Criteria In The Same Column09:19 Wrap Up⬇️ Download the file I used in the video from here: xelplus.com/excel-filter-function-with-multiple-criteria🎬 LINKS to related videos:Excel Lookup to Return Multiple Values with FILTER Function: youtu.be/Eehk6PC0oGs👕☕ 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📚 Excel RESOURCES I Recommend: xelplus.com/resources🎥 GEAR I use: xelplus.com/resources/#gearMore 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
New OneNote Feature You Should Try - Vertical Tabs #shorts Leila Gharani 2023-04-16 | Join 300,000+ professionals in our courses: xelplus.com/coursesWith the latest update, OneNote desktop finally lets you switch between vertical and horizontal tabs. This way you can have your notebooks, sections and pages neatly organized on the left side. This way you can have the same navigation experience like in OneNote on the web, iPad, Mac, and OneNote for Windows 10. 🌍 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!#onenote
Easiest Way to Edit Visuals in Power BI - Watch before using the new features (Includes hidden tips) Leila Gharani 2023-04-13 | Get the Complete Fast Track to Power BI course: xelplus.com/course/fast-track-to-power-biEditing visuals and charts in Power BI just became more Excel-like. So if you're familiar with formatting charts in Excel, you will love this Power BI update! Microsoft introduced a new way to build and format visuals directly ON the visual. It puts common actions for creating and formatting visuals on the visuals themselves, actions such as adding fields, changing visualization types, and formatting text. Just like you're used to in Excel charts. You can now easily format your bar, column and line charts directly on the canvas. There is an object edit mode. You don't have to keep going to the side panel to make your updates. Double click on your visual to get the blue border and edit the chart as you need. Check out the video and time stamps for more detail.After-all most people who open Microsoft Power BI for the first time are overwhelmed. They struggle to navigate around the many panes to perform even simple actions. This update will change that.Note: This feature for contextual on-object interaction with Power BI visuals is currently in preview. You need to turn it on manually in the Options - Preview features. 🌍 My Online Courses ► xelplus.com/courses00:00 New Power BI On Object User Interface 00:14 How to Turn On-Object Interaction On00:32 What's Changed in Power BI01:19 Contextual Options to Build Visuals02:49 New Formatting Options03:30 How to Add a Subtitle and Divider to Your Visual03:57 Pane Switcher and How to Bring Back Closed Panes04:27 How to Open Different Panes Side by Side04:52 Turning On the Format Mode for Visuals06:13 Canvas Settings06:28 Wrap Up🎬 LINKS to related videos:- How to Use Microsoft Power BI: youtu.be/c7LrqSxjJQQ- How To Create these Useful Power Bi Visuals that Excel Lacks: youtu.be/GpP0EbSMRpg👕☕ 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 use: 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!#powerbi
Useful Shortcuts in Windows File Explorer (Windows 11) #shorts Leila Gharani 2023-04-09 | Join 300,000+ professionals in our courses: xelplus.com/coursesHere are my favorite keyboard shortcuts for Windows 11 file explorer.🌍 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📚 Excel RESOURCES I Recommend: xelplus.com/resources🎥 GEAR I use: xelplus.com/resources/#gearMore 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 #fileexplorer
Automatically Move Completed Tasks to an Archive (with Excel Office Scripts & Power Automate) Leila Gharani 2023-04-06 | Join 300,000+ professionals in our courses: xelplus.com/coursesLearn how to use the "record actions" button in Excel Automate tab and record an Office Scripts. With Office Scripts we'll create a macro that works on both Excel desktop and Excel online. In this example, I'll show you how to create a script to automatically move rows from one sheet to another sheet every single day. Many of us have to maintain and update task or to-do lists in Excel. Wouldn't it be nice if tasks marked as "Complete" or "Done" are moved to an Archive automatically at the end of each day. So, next time you open the task tracker only open tasks are shown on your to-do list?For example, you've created an Excel table to collect all the tasks your team is working on. At the end of the day, you want to move all the "Complete" or "Done" tasks to another Excel table. Instead of doing it yourself every single day, you can fully automate it. I'll show you how to create an Office Script to move rows from one table and append it to the bottom of another table based on a logic. I'll also show you how to let the script run automatically at a scheduled time using Power Automate. We'll set up a flow that runs the script every day. This way you don't need to worry about running the script yourself. Power Automate will run automatically. With this tutorial you'll get to learn both Office Scripts and get an introduction to Power Automate and how to create a flow from Excel.🌍 My Online Courses ► xelplus.com/coursesYou can download the script and file here: github.com/LG-Experiment/Scripts00:00 Move All Rows with Status Finished Into Another Worksheet02:00 The task tracker03:40 Record Actions with Office Scripts05:23 Testing the Recorded Script06:20 Understanding Office Scripts Code07:14 Office Scripts to copy visible range in table08:28 Append rows to the bottom of a table with Office Scripts11:17 Loop through a table and delete table rows with Office Scripts15:12 Power Automate to run the script every day18:18 Optimize and Debug Code19:31 Wrap Up 🎬 LINKS to related videos:Introduction to Office Scripts: youtu.be/fny4zUycp_wHow to use Office Scripts and Power Automate to do Boring Excel Tasks for You: youtu.be/v-_joMcPpLI👕☕ 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📚 Excel RESOURCES I Recommend: xelplus.com/resources🎥 GEAR I use: xelplus.com/resources/#gearMore 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!#officescripts #powerautomate #excel
Write in one cell and quickly wrap (Justify) the text over multiple rows in Excel #shorts Leila Gharani 2023-04-02 | Join 300,000+ professionals in our courses: xelplus.com/coursesDid you ever have to split text over multiple rows in Microsoft Excel so it fits a page nicely? This can be quite a pain. In this video I'll show you a hidden feature that will do it for you! It's called Justify and it does just that.🌍 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📚 Excel RESOURCES I Recommend: xelplus.com/resources🎥 GEAR I use: xelplus.com/resources/#gearMore 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
AI Feature in Edge - A Productivity Booster to Try Now! Leila Gharani 2023-03-30 | Become a superhero with the new AI in Microsoft Edge. Learn how you can start using artificial intelligence directly in the Microsoft Edge web browser! Have Bing Discover compose text, write poems, suggest recipes, summarize web pages, and rephrase sentences so they flow better. Ask follow up questions, and even generate images. Bing Discover now has three features: Chat, Compose and Insights. With "Chat", you get to chat with a chatbot and find specific answers to your questions including resources and links to useful pages. This is all based on the new GPT-4 and it's FREE! With "Compose" you can get started on your writing. Write an email, a paragraph, a blog post or get some ideas. You can also rephrase text in different tones like "Funny", "Causal", "Professional", "Enthusiastic" and "Informational". You have the ability to immediately add the result into your page or copy and paste it in another application.With "Insights" you get to quickly summarize the web page you're on and also find some related content. These three features in the Edge Sidebar allow you to easily 10x your productivity like never before. It's a free AI feature that anyone can use right away. It looks like Bing has gotten better than Google search.🌍 Join 300,000+ professionals in my Online Courses ► xelplus.com/courses00:00 AI in Edge Web Browser is a GAME CHANGER00:29 Chat with AI in Edge02:49 Compose Text with AI08:11 Get AI Insights in Edge08:50 Wrap Up🎬 LINKS to related videos:Why I Prefer Edge to Chrome (and YOU WILL TOO!): youtu.be/v73TaVDWh4sTop Features of EDGE! (You've GOT to KNOW these!): youtu.be/ATIVwXhTXHg👕☕ 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📚 Excel RESOURCES I Recommend: xelplus.com/resources🎥 GEAR I use: xelplus.com/resources/#gearMore 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!#bing #microsoftedge #ai
Name Ranges Trick to Leave Funny Easter Eggs in Excel #shorts Leila Gharani 2023-03-26 | Join 300,000+ professionals in our courses: xelplus.com/coursesI'll show you how you can leave hidden messages and easter eggs in your Microsoft Excel file using Excel Name manager and named ranges.🌍 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📚 Excel RESOURCES I Recommend: xelplus.com/resources🎥 GEAR I use: xelplus.com/resources/#gearMore 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
6 Useful Websites You NEED to Use! Leila Gharani 2023-03-23 | 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. For example, there's a site that's gonna help you with your writing, especially when you can't seem to find the right words. Another one that's gonna save you from viruses and malware. Sit back and explore some seriously useful websites that are going to make your work-life easier, safer and more fun. Here are the links to the websites:virusscan.jotti.orgprintfriendly.comhttps://blush.design/mixkit.coimglarger.comquillbot.comxelplus.com🌍 My Online Courses ► xelplus.com/courses00:00 Best Websites to Improve Daily Workflow00:24 Jotti's Malware Scan02:13 Print Friendly03:16 Blush04:30 Mixkit06:09 AI Image Enlarger07:27 Quillbot09:09 XelPlus🎬 LINKS to related videos:- Cool Free Windows Utilities to Use EVERYDAY: youtu.be/ZlyxesiiC6U- 5 Mind-Blowing FREE Windows Apps: youtu.be/yridBTXFme8👕☕ 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📚 Excel RESOURCES I Recommend: xelplus.com/resources🎥 RESOURCES I use: 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 #productivity
Find Your Excel Tools Quickly - New Feature #shorts Leila Gharani 2023-03-19 | Join 300,000+ professionals in our courses: xelplus.com/coursesMicrosoft Excel will now create a personalized toolbar just for you. It's based on your most frequently used commands for quick and easy access. And no worries, you'll still be able to view the classic ribbon whenever you want. 🌍 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📚 Excel RESOURCES I Recommend: xelplus.com/resources🎥 GEAR I use: xelplus.com/resources/#gearMore 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 #productivity
How to quickly ruin your career. Leila Gharani 2023-03-16 | 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.I find these reverse videos more relatable. Shoutout to the Better Ideas YouTube channel which served as the inspiration for this video.🌍 My Online Courses ► xelplus.com/courses00:00 How to NOT Get Promoted00:09 Step 1: Stop Learning00:54 Step 2: Complain02:06 Step 3: Make Yourself Irreplaceable03:07 Step 4: Stay Invisible03:54 Step 5: Blame Others04:53 Wrap Up👕☕ 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📚 Excel RESOURCES I Recommend: xelplus.com/resources🎥 GEAR I use: xelplus.com/resources/#gearMore 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
How to Keep a Window ALWAYS On TOP #shorts Leila Gharani 2023-03-12 | Join 300,000+ professionals in our courses: xelplus.com/coursesIn this video, we’ll cover how to use Microsoft's Power Toys. I'll show you my favorite utility called Always On Top. Use it to pin a window like Sticky Notes to always stay on top of other windows. 🌍 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📚 Excel RESOURCES I Recommend: xelplus.com/resources🎥 GEAR I use: xelplus.com/resources/#gearMore 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
How to Find Duplicates in Excel & Highlight Duplicates If You Need To Leila Gharani 2023-03-09 | Join 300,000+ professionals in our courses: xelplus.com/coursesIn this video I'll show you 4 ways on how to find duplicates in your Microsoft Excel data. We'll find solutions regardless if your data is in the same column, in separate columns and even if you need to find duplicates for a combination of cells. You'll learn how to use conditional formatting to color duplicate values, how to look inside an entire row and compare one row with another and flag it is a duplicate. As a bonus you'll learn how to use a dynamic formula to flag duplicate entries with an icon or returns just the duplicate entries. 🌍 My Online Courses ► xelplus.com/courses00:00 Find and Remove Duplicates in Excel00:33 Find Duplicates in Columns01:43 Find Duplicate Rows03:09 Excel Formulas to Find Duplicates06:37 Use Formulas to Return Duplicate Values08:07 Wrap Up⬇️ Download the file I use in the video from here: xelplus.com/excel-find-and-highlight-duplicates🎬 LINKS to related videos:3 EASY Ways to Find and Remove Duplicates in Excel: youtu.be/ADArCWLz55Y👕☕ 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📚 Excel RESOURCES I Recommend: xelplus.com/resources🎥 GEAR I use: xelplus.com/resources/#gearMore 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 FILTER with Multiple Criteria in Excel #shorts Leila Gharani 2023-03-05 | Join 400,000+ professionals in our courses: xelplus.com/coursesIn this video, we’ll set up the FILTER function with two criteria in different columns. Both of these conditions have to be met (AND) for the result to be included. If you're searching for how to FILTER your data with multiple criteria, this video has the answer. If you need OR criteria, for example looking up two different values within the same column, you'll need to use the PLUS operator. 🌍 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📚 Excel RESOURCES I Recommend: xelplus.com/resources🎥 GEAR I use: xelplus.com/resources/#gearMore 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
OneNote Shortcuts You Wished You Knew Earlier 😳 Leila Gharani 2023-03-02 | Join 300,000+ professionals in our courses: xelplus.com/coursesOneNote is a great note taking app. You can improve your productivity and work faster in OneNote if you remember some of these useful OneNote shortcuts. In this video I'll show you the best keyboard shortcuts for Microsoft OneNote to improve productivity and streamline your workflow. You'll learn how to quickly add pages/sections, navigate faster in your notes, how to create To Dos and Flags, and how to efficiently use Search in OneNote. 00:00 Best OneNote Shortcuts to Boost Your Productivity00:16 Which OneNote Version Should You Use? 00:40 Create New Pages/Sections01:26 How to Navigate Faster04:41 How to Quickly Use Tables06:02 Add Tags and Outlook Flags07:54 Quickly Search in OneNote08:44 Full List of Shortcuts08:49 Wrap Up🌍 My Online Courses ► xelplus.com/courses🎬 LINKS to related videos:What happened to OneNote?: youtu.be/4IkUfh05TGE5 Tips to Unlock the Power of OneNote: youtu.be/ElsiptoaSm8👕☕ 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📚 Excel RESOURCES I Recommend: xelplus.com/resources🎥 GEAR I use: xelplus.com/resources/#gearMore 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!#onenote #notetaking
Use ChatGPT inside Excel #shorts Leila Gharani 2023-02-26 | Join 300,000+ professionals in our courses: xelplus.com/coursesOpenAI inside Excel? How can you use an API key to connect to an AI model from Excel? Wouldn't it be great to have a search box in Excel you can use to ask any question? This video shows you how. 🌍 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📚 Excel RESOURCES I Recommend: xelplus.com/resources🎥 GEAR I use: xelplus.com/resources/#gearMore 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 #chatgpt
Will Artificial Intelligence Make Learning DAX Obsolete? | Power BI Leila Gharani 2023-02-23 | 🎓 Join our popular FREE Power BI mini-course today: pages.xelplus.com/powerbi-free-tourMicrosoft introduced a new feature in Power BI that can suggest DAX formulas for you. You can ask for the DAX measure you need in natural language and artificial intelligence will write the DAX code for you. The AI used is OpenAI GPT-3. It's one of the first AI integrations of GPT-3 in the Microsoft applications. In this video we'll see how well this works. It's also important to test your DAX measures and also some scenarios you need to be aware of. So you'll have to currently "correct" the automatic DAX measures that are written for you. 🌍 My Online Courses ► xelplus.com/courses00:00 No More Learning DAX00:24 Important Settings for Quick Measure Suggestions01:43 Why Use AI in Power BI02:14 Simple Measures with AI03:49 More Complex Measures05:44 When AI in Power BI Fails09:03 What to Watch Out For13:02 My Conclusion about AI in Power BI🎬 LINKS to related videos:Should You Learn Power Bi? Everything You Need To Know: youtu.be/7ZMQZ0UUuTsHow To Create these useful Power Bi Visuals that Excel Lacks: youtu.be/GpP0EbSMRpg👕☕ 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📚 Excel RESOURCES I Recommend: xelplus.com/resources🎥 GEAR I use: xelplus.com/resources/#gearMore 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!#powerbi #ai #chatgpt
