Leila Gharani

13 Jun 2019 Excel for Office 365 & Dynamic Arrays ‍ Take advantage of the new Excel dynamic array functions to create interactive Excel dashboards really fast. To maximize the potential of the new Excel functions, check out the complete course: https://courses.xelplus.com/p/excel-dynamic-array-formulas UPDATE 2020: Dynamic arrays are now available in Excel for Office 365. Tutorial Summary: This video shows a practical example of using Excel's new Dynamic array functions to create a report that shows all records that fall between two dates. You learn: 1. How to use Dynamic array (# hash referencing) in data validation 2. How to create an Excel dependent drop down list 3. Create a FROM and TO Date drop down list where the TO date occurs AFTER the from date 4. Use the new Dynamic array SORT and UNIQUE functions 5. Use the new Excel Dynamic array Filter function (new Excel lookup formula) to return multiple match results 6. How to do an AND logical test with the Filter formula to return all values between two dates. This is a knowledge packed tutorial covering the different aspects of dynamic arrays and Excel's new calculation engine. ⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-dynamic-arrays-filter-function-all-records-between-dates/ LINK to Advanced Filter Feature: https://youtu.be/VqQACB_69SQ LINK to dynamic array playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP ★ My Online Excel Courses ► https://courses.xelplus.com ✉ 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 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 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 #Excel #LeilaGharani

6 Jun 2019 #excel ‍ Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/ Learn to quickly create an Excel data entry form to your tables. This is the easiest form to create in Excel! No VBA or macros are required. You will also learn how you can activate the data entry form on existing tables - how you can add data validation to your forms and also how you can search for criteria using the Excel forms. One great advantage of using forms on larger tables is the ability to search for records using wildcards. You have the ability to search for a category and view the entire line of data in one place. You can also easily navigate and update information with an Excel data form. ★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ Timestamps: 00:00 How to Create Simple Data Entry Forms in Microsoft Excel 00:56 Turn Data into an Excel Table 01:25 Add Data Entry Form to Quick Access Toolbar 02:04 How to Use Data Entry Form 03:50 Add Data Validation to Data Entry Form 05:05 Use Data Entry Form to Search Records 05:50 Wrap Up ⯆ Link to detailed article: https://www.xelplus.com/excel-data-entry-form/ LINKS to my Excel Basics Playlist: ★ 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/ RESOURCES I Recommend: https://www.xelplus.com/resources/ More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Let’s connect on social: Instagram: https://www.instagram.com/lgharani 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 #Excel #LeilaGharani

30 May 2019 Excel Advanced Formulas & Features ‍Learn how to combine Excel's IF function with wildcards for a partial text match. For example, you'd like to check IF a cell contains a specific word. If yes, then you'd like a specific result, otherwise you'd like another result. We also take a look at checking the data against multiple partial match strings. If you're familiar with the IF function, you know the logical test argument looks for an exact match. In case you'd like to look for a partial match in the IF formula (Excel IF function with text containing another word), you can't use an asterisk sign just like you would in the SUMIFS or COUNTIFS formulas. Instead you need to either use the SEARCH or the FIND functions. These will act as your wildcards. You can apply the same approach to the SUMPRODUCT function. ⯆ DOWNLOAD the workbook here: https://www.xelplus.com/if-function-with-wildcard-partial-text-match/ LINKS to related videos: Partial match in SUMIFS function: https://youtu.be/2h90wU9jicI Learn how IF function works: https://youtu.be/KkTaQ5OjAGc ★ 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 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 #Excel #LeilaGharani

23 May 2019 Excel Intermediate Functions & Features (For ALL Excel Versions) ‍ Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials Learn the basics of Excel's custom number formatting and how you can use it for best impact in your reports in this Excel tutorial: 1. The custom formatting rule 2. Practical uses of Excel's custom number formatting 3. How to hide zero values in Excel 4. Custom formatting tricks 5. The proper way to add text to numbers so that values can still be used in formulas If you have a choice between custom formatting or conditional formatting - always go with custom formatting. Processing times are faster with custom formatting. Conditional formatting is volatile. ⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-custom-number-formatting_1/ Many thanks to Michael for writing the detailed blog post and creating the Workbook so we can understand custom formatting better! LINKS to related videos: Smart uses of custom formatting: https://youtu.be/tGY70sdpaLc More tricks with custom formatting: https://www.xelplus.com/smart-uses-of-custom-formatting/ ★ 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 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 #Excel #LeilaGharani

16 May 2019 Excel Advanced Formulas & Features ‍ ONE Excel formula that converts numbers to words AND it does it, WITHOUT VBA and macros - without helper cells and without Excel array formulas. Download the free workbook provided below and use the formula in your own files. The formula 1:17 Changing currency 2:20 Applying formula to many cells 2:51 How the formula works 4:44 Excel Left function 5:07 Excel Mid function 5:27 Excel Text function 5:59 Excel Choose function 7:10 Many thanks to Peter Menhennet for sharing his solution with us. I'm really grateful to have subscribers who are willing to share their knowledge and solutions with others. THANK YOU! ⯆ DOWNLOAD the workbook here: https://www.xelplus.com/Excel-Formula-Convert-Numbers-to-Words For the VBA version check out this post from Microsoft: http://bit.ly/MSSupportNumbersWords ★ 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 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 #Excel #LeilaGharani

May 9, 2019 Excel Advanced Formulas & Features How can you reconfigure a horizontal row to a vertical column? You can use a simple Excel hack to get this done. In my previous video (https://youtu.be/yYVokk0NdiI) I talk about 2 other methods you can use. One method is to copy the data and paste special and select transpose. This way however the data is static. Another option is to use the Excel TRANSPOSE function. One thing I don't like about the Transpose formula is that it's an array function and you need to remember to press Control shift enter (at least until you get dynamic array functionality). You also need to highlight the answer area first before inputting the Transpose formula. This Excel hack is really simple. It's also dynamic and you can also account for additional cells. I came across this from Bob Umlas (his Excel books are great by the way). All you need to do is briefly switch to Excel's R1C1 referencing style. Find out more in the video. ⯆ Blog post and Workbook: https://www.xelplus.com/excel-horizontal-data-to-vertical/ LINKS to related videos: 3 ways to Transpose (including Transpose function): https://youtu.be/yYVokk0NdiI Unstack Excel data: https://youtu.be/rscXNUlRsH0 ★ 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 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

May 2, 2019 Excel VBA & Macros Tutorials In this Excel VBA & macros tutorial, learn how to automatically display all worksheets in an Excel ActiveX List Box and print multiple sheets as one print job. You can also use the same code to print preview multiple worksheets in one Excel print preview window. ★ Complete Excel VBA and macros course: https://courses.xelplus.com/p/excel-vba-excel-macros This VBA tutorial builds on the a previous video where we displayed all worksheets in an Excel ActiveX Combo Box - selecting a sheet name from the combo box, sent the user to the respective sheet. This time we will be using an ActiveX ListBox to allow the user to print the selected sheets in one go. We will use the Excel Worksheet Activate event to automatically populate the list of sheet names in the List Box. We will then use the VBA For Next Loop to create a string array of the sheet names that were selected. To do this, we will use the VBA redim preserve command. Finally we assign a command button (and later an icon) to run the macro once the user clicks it. Aside from this, you will also learn how to debug your macros by stepping into the VBA code and using the locals window. You also learn about VBA's object library and how you can search for specific objects to learn which methods, properties and events are associated with them. ⯆ DOWNLOAD the workbook here: https://www.xelplus.com/list-box-to-print-multiple-sheets-excel-vba/ LINKS to related videos - Excel ActiveX Combo Box to Select Sheets with VBA: https://rumble.com/v2u8htm ★ 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 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

April 25, 2019 PowerPoint & Presentation Tips The first 500 people to sign up via my link will get two FREE months of Skillshare Premium: https://skl.sh/xelplus2 These 3 PowerPoint tips will save you so much time when creating your next PowerPoint presentation. 00:00 Intro 00:18 Alternative to Boring Bullet Points in PowerPoint 02:30 Morph Transition in PowerPoint 06:05 Enhanced Morph Transition in PowerPoint Here is an overview of topics we cover: 1. No more bullet points - Super Fast trick to turn simple text into text you can present. This comes in really handy when you need to create a PowerPoint agenda or list of topics. 2. Effortless PowerPoint animation with Morph Transition: You can now easily create modern morph animated slides. The morph slide transition is one of the easiest and fastest ways you can create impressive animations in PowerPoint. And yes, this PowerPoint transition / animation is in fact professional. You can use it for your corporate presentations. You'll be surprised how simple this is to apply to your slides. 3. Enhanced Morph: The existing morph transition has been improved on in the latest version of Office 365. Now you can morph between different shapes! And it's so simple! You just need to name the two different objects the same - but start with 2 exclamation marks (!!). That's it. All you have to do is present. LINKS to related videos - PowerPoint Presentation tips: https://youtu.be/XA1o5rvy8r4 ★ 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/ 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! Many thanks to Skillshare for sponsoring this video! #PowerPoint

April 18, 2019 Excel Charts Find out how you can visualize survey results in Excel. This is specially good if you have conducted an employee satisfaction survey and you'd like to present the results. Of course the chart can also be applied to any survey data that uses a Likert scale (which is based on people's attitudes or emotions to a topic). This can range from strongly disagree, disagree, neutral, agree and strongly agree. I show how you can create a stacked bar chart, as well as a diverging stacked bar chart as shown on Jon Peltier's website here (https://peltiertech.com/charting-survey-results/). Peltier Tech Chart Utility for Excel: https://peltiertech.com/Utility20/PeltierTechUtility.html Link to Custom Formatting Blog Post: https://www.xelplus.com/excel-custom-number-formatting_1/ ⯆ DOWNLOAD the workbook here: https://www.xelplus.com/charting-survey-results-excel/ ★ 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 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

April 11, 2019 #MsExcel The first 500 people to sign up via my link will get two FREE months of Skillshare Premium: https://skl.sh/xelplus In this tutorial you learn the most useful Excel shortcuts to be able to work faster in Excel. There are many hidden features in Excel that are easily accessible with shortcut keys (you might learn some new features too - check out the bonus tip) ★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ Timestamps 00:00 Intro 00:13 Add / remove Excel Filter 00:40 Create an Excel Table 01:10 Navigate in Large Data Sets 01:27 Select a Range of Cells 01:55 Format Cells in Excel 02:09 Auto Sum 02:40 Paste as Values 03:11 Add a New Line Inside a Cell 03:31 Select All Data in Current Region 03:41 Insert Default Chart 03:48 Excel Flash Fill 04:23 Select Entire Row/Column 04:33 Insert a New Row/Column 05:09 Delete a Row/Column 05:24 Move a Cell/Row 05:54 Hide Column/Row 06:04 Check for Hidden Cells 06:27 Insert Time Stamp 06:43 Find Cells Without Formulas (Constants) ⯆ DOWNLOAD the list of shortcuts here: https://www.xelplus.com/excel-shortcut-keys/ (It will take you to the blog post. Scroll all the way down to download) ★ 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/ 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! Many thanks to Skillshare for sponsoring this video! #MsExcel

April 4, 2019 Excel Introduction - Learn Excel Basics Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials Learn 3 methods to change the case of text in Excel. This way you can quickly switch text to upper case (i.e. all caps), to lower case and to proper case (first letter of every word is in capital letter and the rest are lower case letters). Here is an overview of the three methods: 1. Excel's Text Formulas - We use the UPPER, LOWER and PROPER functions - as well as the TRIM function to get rid of any additional spaces in between words - also space before or after words. 2. Excel Flash Fill - The advantage of flash fill is that you don't need formulas, the disadvantage is that it's not dynamic. If your source data change, you have to apply flash fill again. 3. Use an ALL CAPS font. There are fonts that don't have lower case version. They are purely all caps fonts. Office has a few available by default, but you can download and install other fonts from websites like dafont.com ⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-change-case-of-text/ Excel Basics Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0 ★ 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 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

March 28, 2019 PowerPoint & Presentation Tips Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/ How can you make a great PowerPoint presentation? Make sure you follow these 3 tips to inform, impress and captivate your audience. How much should you fit on a slide? What if you have a lot of information and you can't fit it on one slide? Do I need the logo on every single slide? ★ My Online Excel Courses ► https://www.xelplus.com/courses/ Make sure you don't make the same mistakes I've made in the past when creating PowerPoint presentations. These 3 tips help you design professional, impressive slides. You can apply these concepts to all versions of PowerPoint, such as PowerPoint 2010, 2013 and PowerPoint 2016. ★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 00:00 How to Make a Great PowerPoint Presentation 00:34 Your Slides Shouldn't Make Sense Without You 02:41 Be Careful With Acronyms 03:58 Do You Need Branding On Every Slide? 05:02 Wrap Up Link to blog post: https://www.xelplus.com/powerpoint-presentation-tips/ Top 3 PowerPoint Hacks Video: https://youtu.be/s7jbBLJZ6a0 ✉ 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/ GEAR I Use: https://www.xelplus.com/resources/#gear 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! #PowerPoint

March 21, 2019 Excel Charts Learn how to insert a line chart in Excel and how to conditionally format the data points of the line chart to emphasize the maximum and minimum points of the line. We apply the conditional formatting in a dynamic way so that whenever the source data changes, the position of the highlighted markers changes on the chart. With this method you can conditionally format the series of any chart you'd like. For example, to highlight the months that had the highest values or to highlight the data points in red if they are below target and green if above target - or to add conditional data labels to the chart series. This chart is a good addition to corporate reports and Excel dashboards. ⯆ DOWNLOAD the workbook here: https://www.xelplus.com/highlight-max-min-values-in-an-excel-line-chart/ LINKS to related videos: Chart Basics - https://youtu.be/DAU0qqh_I-A Complete Chart Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyEj7oQkCf7TL9yQQWXbGOQ ★ 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 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

March 14, 2019 Excel Advanced Formulas & Features Learn how to rank duplicate values in Excel without skipping numbers in the sequence. I also show you how the RANK function works and the difference between Rank.EQ and Rank.AVG functions. We also take a look at understanding how complex Excel array formulas such as SUMPRODUCT with criteria works by breaking down the formula. 0:00 How to use the Excel RANK function 0:51 RANK Function & RANK.EQ 3:30 RANK duplicates but don't skip numbers in between 6:51 Top 3 Report 8:51 SUMPRODUCT & COUNTIF Excel Array formula explained You might need to create a top 10 or top 3 report in Excel. For example you'd like to get the top 3 values but there are two categories that have the exact same value and both are considered number 2. How can you show both categories as number 2 and not just the first one? VLOOKUP will not help here, because it will return the first match. You'd like ALL matches returned. The solution uses the SUMPRODUCT function together with the Excel COUNTIF function to get the ranking. We then use the TEXTJOIN and IF functions together as an array to get the category names ranked in ascending order. ⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-rank-without-skipping-numbers/ LINKS to related videos: Excel TextJoin Function - https://youtu.be/TMZEUlFGp1U Excel Lookup Formulas Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxpMnh_KKfAgp5DF9ydawmi ★ 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 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

March 7, 2019 Excel VBA & Macros Tutorials Good news! If you have Office 365 you can now unhide multiple sheets at once! YAY! Free Excel Download Utility to unhide selected worksheets. You can add this tool to your Quick access toolbar or to your Excel ribbon by saving it in your personal macro workbook. In this video I show you the steps to do that. Many Thanks to Daniel Lamarche from Combo Projects for sharing this tool for free with our community members here. ⯆ DOWNLOAD the Excel Unhide Utility from Daniel: http://www.comboprojects.com.au/unhide-worksheets-excel/ 3 Methods to Unhide all sheets video: https://youtu.be/hJsF8dK745Y ★ 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 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

March 3, 2019 #MsExcel Thank you for 100k! This is different to the usual. More on Amsterdam Excel Summit in May: https://excelsummit.amsterdam/ ✉ Sign-up to my newsletter & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ LINK to full Excel video list: https://www.xelplus.com/free-excel-tutorials/ (download the workbook at the bottom of the post) ★ My Online Excel Courses ► https://courses.xelplus.com 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 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

February 28, 2019 Excel Hacks: Tips & Tricks Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials A quick Excel presentation tip for better Excel seminars. Find out how to increase the font size of the formula bar and the name bar in Excel. Increasing the zoom level, increase the size to the cells but not of the formulas in the formula bar. For this to increase you need to update the default font size in Excel. LINKS to related videos - Excel basics playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0 ★ 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 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

February 21, 2019 Excel Introduction - Learn Excel Basics Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials How to calculate percentages in Excel. Learn how to show data effectively for reports for example when calculating percentage change (percent increase or decrease) from Actual to Budget or this year to previous year. Also learn how to calculate the final amount after a percent increase or percent decrease. For example if you have a 10% price increase - what is your final value? You also need to be careful when inputting percentages in Excel. I show you different methods on how to do this properly. This math percentage tutorial applies to calculating percentage change in all versions of Excel and also outside of Excel. ⯆ DOWNLOAD the workbook here: https://www.xelplus.com/calculate-percentage-change/ Excel Basics Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0 ★ 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 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

January 17, 2019 Excel Hacks: Tips & Tricks ‍ ‍Check the Excel Essentials Course: https://www.xelplus.com/course/learn-excel-essentials/ Good news! If you have Office 365 you can now unhide multiple sheets at once! YAY! How can you un-hide all Excel sheets at once? Hiding many worksheets at once is easy in Excel. Click on a sheet, hold down the control or the shift key, click on the other sheets you'd like to hide, right-mouse click and select hide. Now what if you wanted to unhide all the sheets in one go? If you right-mouse click on any sheet name and select unhide - a new window opens with a list of hidden sheets. Unfortunately you can't use the control key or the shift key to select multiple sheets to unhide. You have to unhide tabs one by one. Find out 3 methods you can use to un-hide: 1. Use Custom views to quickly unhide all sheets - no Excel VBA is needed here 2. Use the Immediate Window in VBA - type in or copy and paste a very simple macro 3. Save the macro in your Excel personal macro Workbook. You can add a button for the macro to your Quick Access Toolbar so it is available for ALL your Excel workbooks - also the ones that are not macro-enabled (just xlsx). ⯆ Blog Post: https://www.xelplus.com/3-methods-to-unhide-all-sheets-in-excel/ LINKS to related videos: Excel VBA FOR EACH Loop: https://youtu.be/5bq3N99mNPE Excel VBA full playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se ★ 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 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

‍‍‍‍January 10, 2019 Excel Hacks: Tips & Tricks ‍ ‍Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials This trick is the easiest (or laziest) method to unstack data from one column to multiple columns. You might come across a case where you need to move data (or transpose data) from one column to multiple columns. If you Google this, you'll find different ways of doing this such as: 1. Using Excel array functions or the INDEX function 2. Power Query to unstack data 3. Excel macros for unstacking data 4. Excel add-ins that can unstack. ★ My Online Excel Courses ► https://courses.xelplus.com In this Excel tutorial, we'll take a look at the easiest method of unstacking data. The good thing with this method is that it's dynamic so if your source data change, the stacked version also updates automatically. 00:00 How To Unstack Column Data in Excel 00:41 Unstack Data from ONE Column to MULTIPLE Columns 03:18 Hide Zeros Out of View in Excel Using Custom Number Formatting ⯆ DOWNLOAD the workbook here: https://www.xelplus.com/unstack-data-to-multiple-columns/ You'll find a similar trick used in these videos: Transpose data: https://youtu.be/yYVokk0NdiI Hack formula copy: https://youtu.be/zWhGVZ-R-6g ✉ 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

‍‍‍‍January 3, 2019 Excel Advanced Formulas & Features ‍ ‍Find out how you can quickly count the number of Fridays between two dates in Excel. You can use this technique to also count the number of weekends, Mondays, Tuesdays or any day of the week between two dates. The Excel formula is simple: It uses networkdays.intl function to get the answer. The difference between NetWorkDays function and the Networkdays.Intl function is that you can choose which days you'd like excluded. Excel Networkdays automatically excludes Saturdays and Sundays. ⯆ DOWNLOAD the workbook here: https://www.xelplus.com/count-how-many-fridays/ LINKS to related videos: More about Excel NetWorkDays: https://youtu.be/uJKFObU0Dug ★ 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