Leila Gharani

Dec 20, 2018 #MsExcel ‍ ‍Last (Excel) video of 2018! Thank you to all my subscribers for helping this channel to grow so much in 2018! In this video we take a look at the some of the highlights of 2018. Also let me know what you'd like to see on this channel in 2019. Excel advanced? Dynamic arrays? more basic videos? Excel VBA? PowerPoint? Project management topics? Freelancing? Creating online videos? LINK to get the workbook that includes all videos (updated): https://www.xelplus.com/free-excel-tutorials/ LINK to Survey for topic ideas: https://goo.gl/forms/I0kZQ9Y9Sj9ks59U2 ★ My Online Excel Courses (including Excel VBA course) ► https://courses.xelplus.com ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U Note: 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! #MsExcel

‍‍‍‍December 13, 2018 Excel Hacks: Tips & Tricks ‍ ‍Learn how to reset a dependent drop-down list in Excel with a little bit of VBA. The problem we get with dependent data validation lists is that when you change the value of the first data validation, the value for the dependent data validation stays there until you activate the drop-down. This can be misleading. In this video, you will learn how to automatically reset the value of the dependent list to say "please select" the moment the value in the first drop-down list changes. We do this with Excel VBA, using the change event procedure. The default worksheet procedure is Selection Change event. This triggers every time you change the active cell. It's more optimal in this case to use the worksheet change procedure and make sure that it only run if the value of a specific cell is changed. We don't want to trigger the change procedure every time any cell value is changed. The simple Excel macro show you how you can set it up from scratch. Once you're done, make sure you save the workbook as a macro-enabled workbook. ⯆ DOWNLOAD the workbook here: https://www.xelplus.com/reset-dependent-drop-down/ LINKS to related videos: Dependent data validation in Excel: https://youtu.be/w7cHgsFirLk Dependent Combo Box: https://youtu.be/aSPtWo3IiOM VBA IF THEN Statement: https://youtu.be/dUSQ7wZHM7A VBA Message Box: https://youtu.be/EwbTFvXBfns Full VBA playlist on YouTube: https://www.youtube.com/playlist?list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se ★ My Online Excel Courses (including VBA) ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U Note: 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! #MsExcel #ExcelVBA

‍‍‍‍December 6, 2018 Drop Down Lists in Excel (Dependent, Unique Lists and other data validation lists) ‍ ‍In this video you'll learn a lot about combo box drop-down lists in Excel: 1. How to create a combo box drop-down list 2. How to create a dependent combobox drop-down. 3. How to restrict the combo box drop-down to exclude blank cells and the best part; 4. How to overcome the problem we face with dependent data validation lists where the dependent list doesn't reset once the value for the first list is changed - you'll learn an alternative method to overcome the failure to auto-reset (we're going to automatically refresh the dependent list once the value for the first list changes) ⯆ DOWNLOAD the workbook here: https://www.xelplus.com/dependent-combo-box/ LINKS to related videos: Dependent drop-down list playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKywYhC1Q9eZqR7D-_cdiwl6y Index Match basics: https://youtu.be/F264FpBDX28 ★ My Online Excel Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U Note: 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! #MsExcel

‍‍‍‍November 29, 2018 Excel Advanced Formulas & Features ‍ ‍Learn how to SUM values in Excel based on a partial text match. This is great for cases when you need to sum a column based on "criteria contains" a specific value or text. For these cases you can use Excel's SUMIF or SUMIFS function together with wildcards. Examples of wildcards are the asterisk "*" sign or the Question mark "?". The asterisk is a placeholder for zero or more characters. The ? mark is a fixed placeholder in terms of the numbers of characters. If you use the question mark once, this means only one character can be variable. If you use it two times, then two characters can be "anything". You can combine the question mark together with the asterisk sign as well. I show different examples on how you can do that in this video. I also show you how you can sum based on two or more conditions. Here the SUMIFS formula comes in really handy. ⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-sum-partial-text-match/ LINKS to related videos: Absolute Relative referencing: https://youtu.be/FRu48zy-Djk Excel SUMIFS Basics: https://youtu.be/AZuBNWMh7VM SUMIFS between Dates: https://youtu.be/XIhbL20jTHc ★ My Online Excel Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U Note: 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! #MsExcel

‍‍‍‍November 22, 2018 Excel VBA & Macros Tutorials ‍ ‍Use the DIR function in Excel VBA to check if a file or a folder exist. You can then decide what to do if they exist. For example you can open the Workbook to copy values from and then close the workbook. I will also show you how you can handle cases where the file does not exist or the file name is not typed correctly. In that case VBA generates an error but you can easily avoid with the IF statement. [5:10] I also show you how you can check with VBA if a folder exists. and if it doesn't exist, how you can create the folder. We use the message box function to ask the user for permission if we should create the folder or not. 🡻 Download the workbook here: https://www.xelplus.com/excel-vba-check-if-file-folder-exists-dir/ ★ Links to related videos: ★ Learn about declaring variables in VBA: https://youtu.be/zfc9TYH3UvY Complete Excel VBA free course (playlist): https://www.youtube.com/playlist?list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se ★★ My Online Excel Courses ★★ Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ ★ Excel Resources I Recommend https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U Note: 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! #ExcelVBA

‍‍‍‍November 15, 2018 Excel Infographic Chart Templates ‍ ‍Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials Quickly learn how to create a sales funnel chart in Excel. Excel 2016 has a built-in sales funnel graph, but what it doesn't have is a funnel chart that looks like a funnel. In this tutorial I show you how you can tweak the existing funnel chart to make it look more like a funnel. I do this with the help of Smart-art in Excel. I use the Pyramid Smartart, adjust it to fit the number of categories needed for the funnel and then convert the Smartart to a shape. Watch the video to see how you can copy these shapes into the chart and adjust the look of the funnel. 🡻 Download the workbook here: https://www.xelplus.com/funnel-chart/ ★ Links to related videos: ★ Excel charts and graphs playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyEj7oQkCf7TL9yQQWXbGOQ Excel Info-graphics: https://www.youtube.com/playlist?list=PLmHVyfmcRKyw08u-MZm4ROnB3J0gRlsop ★★ My Online Excel Courses ★★ Courses ► https://courses.xelplus.com/ 🕮 Excel Resources I Recommend 🕮 https://www.xelplus.com/resources/ ✉ Subscribe & get my Excel top 10 tips and formulas e-book for free https://www.xelplus.com/free-ebook/

‍‍‍‍Nov 8, 2018 Excel Hacks: Tips & Tricks ‍ ‍Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials Check out 3 ways to Transpose your data in Excel. These are useful when you want to switch the orientation of your data from columns to rows or vice versa. I show you how to: 00:00 Switch Data from Rows to Columns in Excel - or Vice Versa 00:25 Static approach - copy and paste as transpose 00:54 Use the Transpose Function to Rotate Data 02:54 Use a Simple Formula Trick to Transpose Note: Once you get dynamic arrays, writing the Transpose function becomes super simple. You no longer need to highlight the result area first, nor press control + shift + enter. DOWNLOAD the workbook: https://www.xelplus.com/transpose-excel-data/ ★ Links to related videos: Transpose Excel Hack for horizontal to vertical data: https://youtu.be/dF0cVRyC8c4 Dynamic Arrays video: https://youtu.be/2USJsIyIzvo ★ My Online Excel Courses ★ Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ ★ Excel Resources I Recommend https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Main Camera: https://amzn.to/3a5ldBs Backup Camera: https://amzn.to/2FLiFho Main Lens: https://amzn.to/39apgeD Zoom Lens: https://amzn.to/3bd5pN7 Audio Recorder: https://amzn.to/2Uo5rLm Microphone: https://amzn.to/2xYy9em Lights: http://amzn.to/2eJKg1U More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Note: 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! #MsExcel

‍‍‍‍Oct 25, 2018 Excel Dashboards & Reports‍ ‍ ‍Quickly learn how to change the number format of a cell based on the value of another cell. In this example, I show you how you can format a cell so its number format switches between currency and no currency. We can also switch the formatting of a cell to Bold and Regular depending on a condition. All you need is a little conditional formatting. ★ Links to related videos: ★ IF Formula: https://youtu.be/KkTaQ5OjAGc Excel Basics Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0 ★★ My Online Excel Courses ★★ Courses ► https://courses.xelplus.com/ 🕮 Excel Resources I Recommend 🕮 https://www.xelplus.com/resources/ ✉ Subscribe & get my Excel top 10 tips and formulas e-book for free https://www.xelplus.com/free-ebook/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Main Camera: https://amzn.to/3a5ldBs Backup Camera: https://amzn.to/2FLiFho Main Lens: https://amzn.to/39apgeD Zoom Lens: https://amzn.to/3bd5pN7 Audio Recorder: https://amzn.to/2Uo5rLm Microphone: https://amzn.to/2xYy9em Lights: http://amzn.to/2eJKg1U More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Let’s connect on social: Instagram: https://www.instagram.com/lgharani Twitter: https://twitter.com/leilagharani LinkedIn: https://at.linkedin.com/in/leilagharani Note: 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! #MsExcel #LeilaGharani

October 18, 2018 Drop Down Lists in Excel (Dependent, Unique Lists and other data validation lists) ‍‍‍‍ ‍Excel Dynamic Array formulas are new to Excel Office 365. Don't miss out on their full potential. ★★ Link to complete Excel Dynamic Arrays Course: https://courses.xelplus.com/p/excel-dynamic-array-formulas Complex tasks will be done with simple Excel formulas. Everything you wished Excel could do, can now be done! In this video, I take two of my popular videos which use traditional Excel complex formulas and use Dynamic array formulas instead. I also use a timer to test the time needed for the new formulas and compare it to the other videos. Here's what happens: We create a dynamic dependent drop-down list based on a messy data set. The first list includes unique values from cells and the second dependent data validation list filters the values to the ones that belong to the category selected from the first list. I also make sure the list is dynamic so if we add more data to the table, the drop-down list will automatically update (here we use the new dynamic array spill range reference #) I also use the sort function to get sorted names in the drop-down list. We use 3 Excel dynamic array functions: Unique, Sort & filter. LINKS to related videos: Extract unique items for dynamic data validation drop down list - https://rumble.com/v2tuqys Excel Find Multiple Matches & Dependent Drop Down List (Unsorted Tabular Data Set): https://rumble.com/v2tv4sy Digital Ticking Clock from DrLex1: https://youtu.be/Lsq0FiXjGHg ★ My Online Excel Courses ► https://www.xelplus.com/courses/ ✉ Take this Quiz to choose the right Excel course: https://www.xelplus.com/course-quiz/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Main Camera: https://amzn.to/3a5ldBs Backup Camera: https://amzn.to/2FLiFho Main Lens: https://amzn.to/39apgeD Zoom Lens: https://amzn.to/3bd5pN7 Audio Recorder: https://amzn.to/2Uo5rLm Microphone: https://amzn.to/2xYy9em Lights: http://amzn.to/2eJKg1U More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Let’s connect on social: Instagram: https://www.instagram.com/lgharani Twitter: https://twitter.com/leilagharani LinkedIn: https://at.linkedin.com/in/leilagharani Note: 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! #MsExcel #LeilaGharani

October 11, 2018 Excel Introduction - Learn Excel Basics Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials Sorting is super easy in Excel! You'll learn how to sort by values (ascending, descending), how to sort alphabetically & much more: 1. Sort multiple columns in Excel 2. Sort based on custom lists (including user defined sort order) 3. Exclude ranges from the sorted list 4. Sort by cell color 5. Sort by cell icon (conditional formatting result) 6. How to UN-Sort your data to get back to the original sort order Section timings: Sort basics: 0:45 Sorting by custom lists: 3:38 Multiple-Level sorting: 4:44 Sorting by color: 5:52 Sorting by icon: 7:42 Un-sort data: 9:12 🡻 Download the workbook here 🡻 https://www.xelplus.com/excel-sort-by-value-color-icon-own-list-how-to-unsort/ ★ Links to related videos: ★ Check out the Excel Basics playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0 How to use Excel Filter: https://rumble.com/v2tv4oo ★★ My Online Excel Courses ★★ Courses ► https://courses.xelplus.com/ 🕮 Excel Resources I Recommend 🕮 https://www.xelplus.com/resources/ ✉ Subscribe & get my Excel top 10 tips and formulas e-book for free https://www.xelplus.com/free-ebook/

Oct 4, 2018 Excel VBA & Macros Tutorials ‍‍‍‍ You'll learn how to link the page header to a specific cell with Excel VBA. The Excel macro is very simple. Best part is it runs automatically every time you print the page or save your Excel workbook or worksheet as PDF. ★★ Links to related videos: ★★ Excel Header Footer tutorial: https://youtu.be/Q6b315vRNrg For each loop in VBA: https://youtu.be/5bq3N99mNPE VBA Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se ★★ My Online Excel Courses including VBA ★★ Courses ► https://courses.xelplus.com/ 🕮 Excel Resources I Recommend 🕮 https://www.xelplus.com/resources/ ✉ Subscribe & get my Excel top 10 tips and formulas e-book for free https://www.xelplus.com/free-ebook/

September 27, 2018 Excel Introduction - Learn Excel Basics ‍‍‍‍ Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials Quickly learn how to insert header and footer information to your Excel sheets. This is great if you'd like to optimize your print outs of your Excel sheets or PDF files. In this Excel Basics tutorial we cover different topics such as: 1. How to insert a header & a footer in your documents. We take a look at two options. One option uses "Page Layout". 2. How to insert pictures in the header - such as your logo and how to adjust it so it fits better on the printed page. 3. How to add page numbers to the footer of your Excel sheets. Also how to add existing page number from the number of printed pages 4. How to copy an existing header or footer to other tabs 5. How to remove headers and footers in your Excel files. ★ Links to related videos: ★ If you're interested in Excel basics, check out my playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0 ★★ My Online Excel Courses ★★ Courses ► https://courses.xelplus.com/ 🕮 Excel Resources I Recommend 🕮 https://www.xelplus.com/resources/ ✉ Subscribe & get my Excel top 10 formulas e-book for free https://www.xelplus.com/free-ebook/ #MsExcel

September 20, 2018 Excel VBA & Macros Tutorials ‍‍‍‍ Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/ You'll learn how to create a handy navigation combo-box for your Excel workbooks. The ActiveX combobox is automatically filled with the sheet names of your open workbook. If you add sheets, these are automatically added to the drop-down box. Deleted sheets are automatically removed from the combo-box. You can get the complete Excel VBA and macros course here: https://courses.xelplus.com/p/excel-vba-excel-macros What you learn in this video: You learn how to work with ActiveX controls in Excel - what "design view" is and how to adjust the properties to ActiveX controls. You also learn how to fill the values of the the drop-down on the fly so the macro is executed without the need to press a button to run it. You learn about Active X events - how to debug your VBA code and also how to tweak it so it performs better. 🡻 Download the workbook here 🡻 https://www.xelplus.com/excel-activex-combo-box-with-vba/ ★ Links to related videos: ★ Check out my VBA playlist here: https://www.youtube.com/playlist?list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se ★ My Online Excel Courses ► https://www.xelplus.com/courses/ ✉ Subscribe & get my Excel top 10 tips and formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ GEAR I use: https://www.xelplus.com/resources/#gear More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Let’s connect on social: Instagram: https://www.instagram.com/lgharani Twitter: https://twitter.com/leilagharani LinkedIn: https://at.linkedin.com/in/leilagharani Note: 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! #MsExcel #LeilaGharani

Sep 13, 2018 Excel Lookup Formulas ‍‍‍‍ ★ Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials Quickly learn the ins and outs of Excel's VLOOKUP formula. I show 2 practical examples of the VLOOKUP formula. I also explain why your VLOOKUP formula might not be working correctly. 00:00 How VLOOKUP Works in Excel 02:30 How to Use VLOOKUP in Excel 10:00 How to Avoid #N/A in VLOOKUP ★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ Summary: The Excel VLOOKUP formula looks up a value in an Excel table and returns a value from an adjacent column. "V" stands for vertical lookup. This is one of most common lookup functions in Excel. If your data table is not sorted, it's important to look for an exact match - this means you can't omit the last argument of vlookup. You need to set that argument to "false" or to 0. 🡻 Download the workbook here 🡻 https://www.xelplus.com/basics-vlookup-hlookup/ ★ Links to related videos: ★ For reverse or 2-way lookup problems use INDEX & MATCH: https://youtu.be/F264FpBDX28 Relative & Absolute referencing: https://youtu.be/FRu48zy-Djk ★ My Online Excel Courses ► https://www.xelplus.com/courses/ ✉ Subscribe & get my Excel top 10 tips and formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ GEAR I use: https://www.xelplus.com/resources/#gear More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Let’s connect on social: Instagram: https://www.instagram.com/lgharani Twitter: https://twitter.com/leilagharani LinkedIn: https://at.linkedin.com/in/leilagharani Note: 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! #MsExcel #LeilaGharani

Sep 4, 2018 Excel Dashboards & Reports ‍‍‍‍ How can you combine unrelated Excel features to create a visualization your boss will be proud of? That's what I try to do using Excel's FREQUENCY function, Form Controls, MAX formula & 3D models. My solution is an Excel dynamic bar chart with icons. It's not your standard bar chart. It's an Excel chart that's conditionally formatted: The highest value is conditionally formatted with an icon. The icons are automatically hidden for the remaining bars. We use a trick to get it conditionally formatted. There are a lot of Excel chart tricks used here if you pay close attention. I'll also show you how you can use 3Dmodels in PowerPoint at the end of the video. This is solution entry to Oz du Soleil's #ExcelHash competition. VOTE for your favorite here: https://tinyurl.com/y9hmvelp (voting is closed) The entire Playlist is here: https://www.youtube.com/playlist?list=PLHrPHBbDHgT0UnY1qb36YZrBwpWNJX8Lx Other ExcelMVPs in the Excel Hash challenge are: Mike Girvin - Excel Is Fun Bill Jellen - MrExcel Mynda Treacy - MyOnlineTrainingHub Jon Acampor - Excel Campus Oz du Soleil - Excel on Fire ★ Links to related videos: ★ Learn Index Match: https://youtu.be/F264FpBDX28 Charts basics: https://youtu.be/DAU0qqh_I-A ★★ My Online Excel Courses ★★ Courses ► https://courses.xelplus.com/ 🕮 Excel Resources I Recommend 🕮 https://www.xelplus.com/resources/ ✉ Subscribe & get my Excel top 10 tips and formulas e-book for free https://www.xelplus.com/free-ebook/ Music: Italian Afternoon by Twin Musicom is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Artist: http://www.twinmusicom.org/ #ExcelHash #MsExcel #LeilaGharani

Aug 30, 2018 Excel Advanced Formulas & Features ‍‍‍‍ Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/ Quickly learn how to lookup one value in Excel and return multiple matches. VLOOKUP and INDEX & MATCH formulas always return the first match they find inside a data table. What if you wanted to return multiple matches? I'll show you two different methods: ★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 00:00 How to Find Multiple Match Results in Excel 01:10 How to Use INDEX & AGGREGATE to Find Multiple Matches in Excel 11:12 How to Use TEXTJOIN to Find Multiple Matches in Excel 13:36 Wrap Up - Method 1: Uses INDEX & AGGREGATE formulas. This doesn't require CSE (control shift enter) and it works on older Excel versions. - Method 2: Uses the relatively new TEXTJOIN formula (available in Excel Office 365, Excel 2019) and requires CSE. Pick the method you find easier to maintain. 🡻 Download the workbook here: https://www.xelplus.com/return-multiple-match-values-in-excel/ ★ Links to related videos: ★ VLOOKUP basics: https://youtu.be/E7gQ-PgYkMc INDEX MATCH basics: https://youtu.be/F264FpBDX28 Get Unique List: https://youtu.be/7fYlWeMQ6L8 TEXTJOIN: https://youtu.be/TMZEUlFGp1U ★ My Online Excel Courses ► https://www.xelplus.com/courses/ ✉ Subscribe & get my Excel top 10 tips and formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ GEAR I use: https://www.xelplus.com/resources/#gear More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Let’s connect on social: Instagram: https://www.instagram.com/lgharani Twitter: https://twitter.com/leilagharani LinkedIn: https://at.linkedin.com/in/leilagharani Note: 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! #MsExcel #LeilaGharani

Aug 23, 2018 Excel VBA & Macros Tutorials ‍‍‍‍ Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/ Quickly learn how to work with Excel VBA IF, THEN, ELSE, ELSEIF, AND statements. This way you can write Excel macros that are dependent on multiple conditions. We take a look at looping through a set range of cells in an Excel table, checking their value and then changing the cell color based on that value. In addition to learning the IF THEN statement and how to loop through cells, you also learn how to quickly get the color code of a specific cell so you can refer to it in your Excel macro. I'll show you a trick with the immediate window and how you can test, and query code in there. 🡻 Download the workbook here 🡻 https://www.xelplus.com/excel-vba-if-then-elseif-statement/ ★ Links to related videos: ★ FOR EACH VBA: https://youtu.be/5bq3N99mNPE IF THEN in Excel Formulas: https://youtu.be/KkTaQ5OjAGc VBA Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se ★★ My Online Excel Courses including VBA ★★ Courses ► https://courses.xelplus.com/ 🕮 Excel Resources I Recommend 🕮 https://www.xelplus.com/resources/ ✉ Subscribe & get my Excel top 10 tips and formulas e-book for free https://www.xelplus.com/free-ebook/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Main Camera: https://amzn.to/3a5ldBs Backup Camera: https://amzn.to/2FLiFho Main Lens: https://amzn.to/39apgeD Zoom Lens: https://amzn.to/3bd5pN7 Audio Recorder: https://amzn.to/2Uo5rLm Microphone: https://amzn.to/2xYy9em Lights: http://amzn.to/2eJKg1U More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Note: 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! #MsExcel #ExcelVBA #LeilaGharani

August 9, 2018 #MsExcel ‍‍This is a special Excel summer video - I'll show you how I come up with Excel video topics for my YouTube channel and I also show you how to search 116 Excel tutorials in one place. I also have accompanying articles as well as downloadable workbooks for most of the videos you'll watch. You'll find out how to get to them in the video. You can learn Excel basics, Excel formulas, tips & tricks, charts, visualization & dashboard techniques as well as Excel VBA & macros on this channel. Make sure you check out the palylists on the channel as well. Wish you a nice summer! 🡻 Download the workbook here: https://www.xelplus.com/free-excel-tutorials/ Links to related videos: If you'd like to start from the basics, check out my Excel basics playlist here: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0 ★ My Online Excel Courses ★ Courses ► https://courses.xelplus.com/ ► ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ ★ Excel Resources I Recommend https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U Note: 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! #MsExcel #LeilaGharani

August 2, 2018 Excel Dashboards & Reports ‍Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials You'll learn an Excel custom formatting hack which enables you to to show icons for deviations. For example the up & down arrows or icons with different colors based on a threshold. Great thing is, you can have up to 4 different thresholds. You can even define them in excel cells so they're dynamic. If you change the value in the cell, the custom formatting applied to the cells will be updated accordingly. We'll be using the IF function to assist us with this. 🡻 Download the Workbook 🡻 https://www.xelplus.com/smart-uses-of-custom-formatting-part-2/#c6 ★ Links to related videos: Part 1: https://rumble.com/v2tnek0 Part 2: https://rumble.com/v2tnemq IF Formula: https://rumble.com/v2tuwvk Microsoft link for color codes: https://bit.ly/2OEmUvd ★ My Online Excel Courses ★ Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U Note: 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! #MsExcel #LeilaGharani

July 26, 2018 Excel Advanced Formulas & Features ‍Use the Excel SUMIFS formula to sum values between two dates. Here you'll need to use the greater than & less than operators inside the SUMIFS formula. You'll also learn how to sum values within a month. For example, your data set contains dates and you'd like to create a monthly report where you show the total value for the month, you can use the SUMIFS function together with the EOMONTH (end of the month Excel formula) Last, you'll learn how to add more criteria to your sum range. For example, you'd like to sum values between two dates and also account for one or more additional criteria. Happy learning! 🡻 Download the workbook here 🡻 https://www.xelplus.com/excel-sum-between-dates/ ★★ Links to related videos: ★★ SUMIFS, COUNTIFS & AVERAGEIFS Basic introduction: https://rumble.com/v2skgke Formulas playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxvxehq3fiGjKDsEyy6d4Tz ★ My Online Excel Courses ★ Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Main Camera: https://amzn.to/3a5ldBs Backup Camera: https://amzn.to/2FLiFho Main Lens: https://amzn.to/39apgeD Zoom Lens: https://amzn.to/3bd5pN7 Audio Recorder: https://amzn.to/2Uo5rLm Microphone: https://amzn.to/2xYy9em Lights: http://amzn.to/2eJKg1U More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Note: 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! #MsExcel #LeilaGharani

July 19, 2018 Drop Down Lists in Excel (Dependent, Unique Lists and other data validation lists) ‍Create drop-down lists in Excel that are dynamic - #1 They expand as new data is added to the list, #2, they are dependent on another list and #3, they exclude blank/empty cells on the bottom of each list. Basically, they are only restricted to the cells that have values in them. In this video you'll learn how to use the OFFSET function to get fully dynamic dependent drop down lists. You'll then see another version which uses INDEX & MATCH as well as Excel Tables. We plug in the formula we create inside Name Manager and then use the new name inside our custom data validation formula box. 🡻 Download the workbook here 🡻 https://www.xelplus.com/excel-dynamic-dependent-drop-down-lists-exclude-blanks/ ★ Links to related videos: ★ Data Validation drop down Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKywYhC1Q9eZqR7D-_cdiwl6y Learn OFFSET: https://rumble.com/v2skd7u Learn INDEX & Match: https://rumble.com/v2skkko ★ My Online Excel Courses ► https://www.xelplus.com/courses/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Main Camera: https://amzn.to/3a5ldBs Backup Camera: https://amzn.to/2FLiFho Main Lens: https://amzn.to/39apgeD Zoom Lens: https://amzn.to/3bd5pN7 Audio Recorder: https://amzn.to/2Uo5rLm Microphone: https://amzn.to/2xYy9em Lights: http://amzn.to/2eJKg1U More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Let’s connect on social: Instagram: https://www.instagram.com/lgharani Twitter: https://twitter.com/leilagharani LinkedIn: https://at.linkedin.com/in/leilagharani Note: 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! #MsExcel #LeilaGharani

July 12, 2018 Excel VBA & Macros Tutorials ‍Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/ Quickly learn how to use the VBA FIND Function. What parameters are required. How to look for partial matches or for complete matches (whole word). Also if VBA should search in the cells, formulas or comments. I also show you how to handle cases if VBA FIND doesn't find a value. So in cases where your text or value is not found. You'll want to account for this, because in case your text or value is not found, you'll get a VBA error. In order to avoid the error, you can use the VBA IF statement. This ensures that if a value is not found, you will not end up with an error, instead you can decide what you'd like to do (in the video I'll show you how to create a custom message box, informing the user that the value was not found). ★ Links to related videos: ★ Check out the full playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se ★ My Online Excel Courses ★ Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U Note: 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! #MsExcel #ExcelVBA #LeilaGharani

July 5, 2018 Excel Infographic Chart Templates ‍Here's an alternative to the usual Excel column chart. Download the infographic template in Excel, then adjust the numbers and the icons to your own needs. 🡻 Download the workbook here 🡻 https://www.xelplus.com/creative-infographics-excel-male-female/ ★ Links to related videos: ★ Bar chart with icons: https://rumble.com/v2u2oko 3 handy chart tips: https://rumble.com/v2u2v36 ★ My Online Excel Courses ★ Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U Note: 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! #MsExcel #LeilaGharani

June 28, 2018 Excel Introduction - Learn Excel Basics ‍Sign Up to the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials Reference cells correctly when writing Excel formulas. If your formulas are not working correctly when you copy them to other cells, you've probably made a mistake with your cell referencing. Some cell references might need to be fully fixed, some partially fixed. This is called absolute versus relative cell referencing in Excel. Understanding this concept really simplifies your Excel work. ★ Links to related videos: ★ Check out the full Excel Basics playlist here: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0 ★ My Online Excel Courses ★ Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U Note: 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! #MsExcel #Excel #LeilaGharani

June 21, 2018 Excel VBA & Macros Tutorials ‍Interested to learn how to apply Excel VBA Arrays to real world examples? Learn how to declare two dimensional arrays in VBA, how to fill up the array with values from cells and how to re-use the array to create a new workbook with new sheets which have identical names as values defined in your array (i.e. as the text written in cells). ★★ To learn VBA in a structured way, from the ground up - check out my complete Excel VBA course here: https://courses.xelplus.com/p/excel-vba-excel-macros ★ Links to related videos: ★ Learn how to DIM variables in VBA: https://rumble.com/v2u2rce VBA Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se ★ My Online Excel Courses ★ Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U Note: 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! #MsExcel #ExcelVBA #LeilaGharani