Leila Gharani

June 12, 2018 Excel Dashboards & Reports ‍Learn to quickly lookup different pictures based on the value of a cell. Some people call this VLOOKUP on images. You can use this technique for company logos, employee pictures, flags - basically anywhere where you need to show different images based on the value of a cell. You'll also learn a few other techniques here. For example: 1. How to work with Excel's picture tools (Crop images, align etc) 2. How to use Name Manager to assign names to cells and how to do it quickly with "Create from Selection" option 3. A little bit about the INDIRECT function (find out more with the below link) 4. How to link pictures to cells 🡻 Download the workbook here 🡻 The steps are explained in 5 simple steps in this blog post: http://www.xelplus.com/excel-lookup-on-pictures/ Scroll down to the bottom to get the Excel file. ★ Links to related videos: ★ World Cup 2018 Sweepstake (with free template link): https://rumble.com/v2u2v5u INDIRECT function: https://rumble.com/v2skmfm Data validation basics: https://rumble.com/v2u2rbm Custom Data validation: https://rumble.com/v2u2v2e ★ 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

June 7, 2018 #MsExcel ‍Get the complete overview of the FIFA World Cup 2018 dates, times (according to your time zone), & groups. Download the Excel template, input your predictions - play against your family members or colleagues and have fun! 🡻 Download the workbook here 🡻 https://eexcel.co.uk/downloads/ (Website by Jacek Cetnarski - for questions please contact Jacek) The Pro Version: http://bit.ly/eexcelpro (Note: This is not a paid review.) Blog post: http://www.xelplus.com/fifa-world-cup-2018-excel-template/ Lookup on Pictures video: https://rumble.com/v2u2v68 ★ 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

May 31, 2018 Excel Charts ‍Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials These are the 3 most common Excel chart questions I get. In this video you'll find the answers to these. Some of these can be quite frustrating and not easy to figure out. For example: 1. How to show your chart but hide your data - basically how do you keep your chart from disappearing if you hide or group your columns where the chart data is in. 2. How do you snap the chart into the gridlines? Is there a shortcut key for this? 3. Can you avoid grouping charts and objects together if you add in text boxes and other shapes to your chart? Link to Blog post & downloadable Workbook: https://www.xelplus.com/excel-chart-tips/ ★ Links to related videos: ★ Chart basics: https://rumble.com/v2tul8o ★ 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

May 24, 2018 Drop Down Lists in Excel (Dependent, Unique Lists and other data validation lists) Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials Excel's data validation feature allows you to build in validation checks in your spreadsheet templates. This reduces mistakes upon data entry. In this video, I show you how to use Excel's custom data validation feature to validate for complex combinations. You'll learn how to use formulas for creating your data validation. Here we write a formula in the custom data validation box that checks for a specific combination of text and numbers. In the first example we take a look at validating for 1 letter and 4 numbers. In the 2nd example we look for specific characters inside the text and the last example we take a look at how we can validate for a combination of 2 letters and 4 numbers. We also cover Excel's LEN, RIGHT, LEFT and MID functions. Full Article: https://www.xelplus.com/excel-custom-data-validation/ ★ Links to related videos: ★ Basics of Data Validation: https://rumble.com/v2u2rbm ★ 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

May 17, 2018 Excel VBA & Macros Tutorials ‍Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/ It’s best practice to declare your Excel VBA variables before you use them. Declaring variables means that you give VBA a heads up that it needs to free up some memory space for your variables which will in most cases be less than the default. That's why it's important to understand the concept of data types and how much memory space each of these types will take. The less memory you allocate to a variable, the faster your code will run. I show the range associated to each data type - such as numbers, text, date, currency etc in the video. By default VBA assigns the data type “variant” to each variable. Variant means it changes depending on the data type so is it text, number or date. It will allocate around 16 bytes of memory if it’s a number and 22 bytes + length of string. ★ Links to related videos: ★ Learn about Visual Basic Editor: https://youtu.be/NpvvwrdDcQk Properties & methods in VBA: https://youtu.be/uYHrzo2gzbo Blog Post: https://www.xelplus.com/excel-vba-data-types-dim-set/ ★ 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

May 10, 2018 Drop Down Lists in Excel (Dependent, Unique Lists and other data validation lists) ‍Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials Quickly learn how to make a drop down list in Excel or add other data validation checks. By the end of the this tutorial you will learn: 1. How to create dynamic drop-down lists that grow as new categories are added 2. How to restrict cell input to dates that fall between two values or dates that are greater than today's date 3. How to restrict cell input to values that have specific length (or are greater or less than set total characters) 4. How to restrict numbers input to fall between predefined values 5. How to copy and paste data validation to other cells. Full Article: https://www.xelplus.com/data-validation-in-excel/ ★★ Links to related videos: ★★ Indirect Function: https://youtu.be/GUClkvJ7Gag Dependent data validation lists: https://youtu.be/w7cHgsFirLk ➹ ➹ ➹ Online Excel Courses ➹ ➹ ➹ Excel VBA & Macros ► http://bit.ly/LeilaVBA Excel Dashboards ► http://bit.ly/LeilaDashboards Excel Charts ► http://bit.ly/LeilaCharts Advanced Excel ► http://bit.ly/LeilaAdvancedExcel Excel Waterfall Charts ► http://bit.ly/LeilaWaterfall 🕮 Recommend Excel Resources 🕮 https://www.xelplus.com/resources/ ✉ Subscribe to my Newsletter ✉ Stay informed and get discounts when new courses come out: http://www.xelplus.com/ 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

May 3, 2018 Excel Charts Use this trick to create a super quick dynamic Step chart in Excel (great graph to show price & inventory fluctuations). What is a Step Chart? A Step Chart is great for visualizing variables that change on an irregular basis. For example price and inventory changes. If you create a line chart directly on the data set you will realize it doesn't show the correct visualization. There are different ways to get the right visualization. This videos shows you the easiest version. It uses a little chart trick called error bars. ★★ Contributions ★★ Many thanks to Mehdi & to Bart for providing us with different methods of creating the Step Chart. 🡻 Download the workbook here 🡻 http://www.xelplus.com/how-to-create-step-chart-in-excel/ ★ Links to related videos: ★ Alternative version of Step Chart: https://youtu.be/ksR63M9nuYM ★ 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

May 1, 2018 Excel VBA & Macros Tutorials Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/ You'll quickly learn the right syntax you'll need to create a VBA message box (or a pop up dialogue box) in Excel. I first show you how to create a simple message, and then we expand on this to include "YES" & "NO" buttons. More details: In the video, I'll also show you how to add a line break to your message box using Vbnewline and also how to use a variable which you can use to assign the answer of the message box to. You'll need this if you have "YES", "NO" or "CANCEL" buttons, so you know which one the user has clicked on. ★ Download the VBA file: https://www.xelplus.com/vba-message-box/ ★★ Links to related videos: ★★ Copy/Paste in Excel VBA: https://rumble.com/v2u2oh6 Referencing Ranges with VBA: https://rumble.com/v2u2ofm Learn about Visual Basic Editor: https://rumble.com/v2tv4va Recording macros: https://rumble.com/v2tv4ui Properties & methods in VBA: https://rumble.com/v2tv4wg ★ 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

April 26, 2018 Excel Infographic Chart Templates Create better Excel reports by improving your existing charts with the smart use of Icons. In this video you learn how to create a bar chart that includes the male/female icon in a dynamic way (I will also show you how you can add shapes inside charts - this way, you can change your series to look like any shape of your choice) - you can of course replace these icons with any icon of your choice. You could for example use images of your products. ★ My Online Excel Courses ► https://www.xelplus.com/courses/ This is an example of how you can use some chart tricks that allow you to create infographics or infocharts in Excel. You don't need to stick to the default chart types, you can improve on these to fit your corporate reporting style. ★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ Timestamps: 00:00 Info Charts in Excel 00:43 Prepare Clustered Bar Chart 04:09 Created Rounded Edges for Bar Chart 05:50 Add Data Label to Bar Chart 06:54 Insert Icons to Bar Chart 08:06 Dynamic Placement of Icon 🡻 Download the workbook here 🡻 http://www.xelplus.com/infographics-in-excel-bar-chart-icons-symbols/ ★ Links to related videos: ★ Special Excel Charts: https://rumble.com/v2ski6c ✉ 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! #MsExcel

April 25, 2018 Excel VBA & Macros Tutorials Get the complete course here: https://www.xelplus.com/course/excel-vba-excel-macros/ In this video we do a mini project where we count the number of cells that contain formulas on our worksheet. We do this with Excel VBA with the help of the For Each Collection loop. This allows us to loop through each cell inside the used range of the worksheet and check with the help of the IF statement whether or not we come across a formula cell. Here we use the HasFormula property of the range object. We then use a variable to keep this number in memory. ★★ Links to related videos: ★★ Copy/Paste in Excel VBA: https://youtu.be/p4ViTxIl0E0 Referencing Ranges with VBA: https://youtu.be/acGJb9Oojho Learn about Visual Basic Editor: https://youtu.be/NpvvwrdDcQk Recording macros: https://youtu.be/8IreWUk1Al4 Properties & methods in VBA: https://youtu.be/uYHrzo2gzbo ★ 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

April 19, 2018 Excel VBA & Macros Tutorials Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/ This tutorial shows you how you can copy and paste with VBA. We use the copy method as well as the pastespecial method. The copy method in VBA, copies data, as well as formatting, formulas, comments etc - with the pastespecial method, you have more control over your paste options. For example, you can paste formatting only - or choose to paste values as well as number formatting. I also show you how to use the resize property, so you can change the size of the current region before you copy. This is good for cases where you want to copy the data but exclude the header. Here we add in OFFSET as well. ➹ ➹ Excel VBA Course ➹ ➹ This Excel VBA tutorial for beginners, is part of my "Unlock Excel VBA and Macros" course. Get it here: https://courses.xelplus.com/p/excel-vba-excel-macros 🡻 Download the workbook here 🡻 http://www.xelplus.com/vba-copy-paste/ ★★ Links to related videos: ★★ Referencing Ranges with VBA: https://rumble.com/v2u2ofm Learn about Visual Basic Editor: https://rumble.com/v2tv4va Recording macros: https://rumble.com/v2tv4ui Properties & methods in VBA: https://rumble.com/v2tv4wg ★ 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

April 12, 2018 Excel VBA & Macros Tutorials Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/ Referencing ranges is a common task in Excel VBA. It's important to be aware of the different ways you can write to Excel cells with VBA or macros. The macro recorder has its own preference when writing to ranges but it's not the only way. You'll be surprised at all the available options. Each method has its own advantages. They will become more obvious later on when you learn to loop inside a range in Excel. You'll learn how to use ranges, cells property, offset, named ranges, difference between activecell and selection, and how to reference entire rows or entire columns and also how to use autofit in Excel VBA. Practice along with me by opening up a blank Excel spreadsheet. Make sure you close other spreadsheets as we'll be writing to the active Workbook. Written Article: https://www.xelplus.com/vba-writing-to-ranges/ ➹ ➹ Excel VBA Course ➹ ➹ This Excel VBA tutorial for beginners, is part of my "Unlock Excel VBA and Macros" course. Get it here: https://courses.xelplus.com/p/excel-vba-excel-macros Check out the last 2 minutes (16:50) of this video to get an overview of the course topics. ★ Links to related videos: ★ Learn about Visual Basic Editor: https://youtu.be/NpvvwrdDcQk Recording macros: https://youtu.be/8IreWUk1Al4 Properties & methods in VBA: https://youtu.be/uYHrzo2gzbo ★ 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! #ExcelVBA

Apr 5, 2018 Excel VBA & Macros Tutorials Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/ Understanding Objects, Properties and Methods in VBA is really important if you'd like to write your own Excel VBA code from scratch or update the VBA code you find on forums. This Excel VBA tutorial for beginners, includes two lectures from my "Unlock Excel VBA and Macros" course which is coming out in April. I cover objects and the Object library in detail inside the course. This is also a key concept. We cover this in detail as well as how to find the right object reference and the right syntax to be able to write your code. Written Article: https://www.xelplus.com/vba-object-properties-methods/ ➹ ➹ Excel VBA Course ➹ ➹ This Excel VBA tutorial for beginners, is part of my "Unlock Excel VBA and Macros" course. Get it here: https://courses.xelplus.com/p/excel-vba-excel-macros Check out the last (10:50) 2 minutes of this video to get an overview of the course topics. ★★ Links to related videos: ★★ Learn about Visual Basic Editor: https://rumble.com/v2tv4va Recording macros: https://rumble.com/v2tv4ui ★ 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

Mar 29, 2018 Excel VBA & Macros Tutorials This tutorial is your introduction to Excel's Visual Basic Editor (VBE). This is the place macros from the macro recorder are recorded as well as the place you'll be writing any VBA code. ➹ ➹ Excel VBA Course ➹ ➹: https://courses.xelplus.com/p/excel-vba-excel-macros You learn about the different ways you can get to the VBA editor. I'll show you where the code window is and the different views and windows inside the editor - you'll find out how to activate the properties window, immediate window (which we'll be using a lot inside the course) as well as additional editing options which can come in really handy. 00:00 How to Use the Visual Basic Editor in Excel 00:26 Introduction to the Visual Basic Editor 09:36 Visual Basics and Color Guidelines 19:32 Unlock Excel VBA and Macros Course - From Beginners to Advanced 🡻 Sample Workbook used in Last Lecture🡻 http://www.xelplus.com/excel-vba-to-copy-data-from-one-sheet-to-another/ The Article : https://www.xelplus.com/the-visual-basic-editor-vbe/ ★★ Links to related videos: ★★ Excel dynamic macro to copy data from one sheet to another: https://youtu.be/8IreWUk1Al4 ★ 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 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 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! #ExcelVBA

March 23, 2018 Excel VBA & Macros Tutorials Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/ Learn how to use the Excel macro recorder to copy or transfer data from one worksheet to the bottom of an existing data set on another sheet. You also learn the difference between absolute and relative macro recording. ➹ ➹ Excel VBA Course ➹ ➹ This Excel VBA tutorial for beginners, is part of my "Unlock Excel VBA and Macros" course. Get it here: https://courses.xelplus.com/p/excel-vba-excel-macros Check out the last (10:00) 2 minutes of this video to get an overview of the course topics. 🡻 Download the workbook here 🡻 http://www.xelplus.com/excel-vba-to-copy-data-from-one-sheet-to-another/ ★ 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 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

March 15, 2018 Excel Dashboards & Reports This video covers a few topics: 1. How to find multiple matches - (basically an INDEX MATCH that finds all matches instead of the first one only) 2. How to fix table column referencing (absolute column referencing in tables) 3. How to use OFFSET to restrict the dependent drop-down list to non-empty members only (exclude empty cells) We're going to learn all this, while creating a dependent drop-down list based on a messy random tabular data set. 🡻 Download the workbook here 🡻 http://www.xelplus.com/find-multiple-matches-in-excel-dependent-drop-down-list/ ★★ Links to related videos: ★★ Part 1 - Get the Unique drop-down list: https://rumble.com/v2tuqys Index Match basics: https://rumble.com/v2skkko Offset: https://rumble.com/v2skd7u This video from Kevin Lehrbass summarizes all the different techniques you can use to get a unique drop down list (for Part 1 of the video): https://youtu.be/BFojgCsKNjw ★ 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

Mar 8, 2018 Excel Introduction - Learn Excel Basics Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials How does Advanced Filter work in Excel? In this quick tutorial I show you many examples that explain: 1. How to setup advanced filter 2. How to use the criteria range in advanced filter 3. How to use wildcards 4. How to setup your criteria to filter for OR / AND conditions 5. How to filter between two dates or two numbers with advanced filter 6. How to get a list of unique values 🡻 Download the workbook here 🡻 http://www.xelplus.com/excel-filter-basic-to-advanced/ ★★ Links to related videos: ★★ Excel Filter Trick: https://youtu.be/evrnIuDRtsQ Excel Filter Basics: https://youtu.be/wMlTDXPEjag ★ 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 #Excel #LeilaGharani

Mar 1, 2018 Excel Introduction - Learn Excel Basics Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials Find out how to filter your data in Excel. In this filter basics tutorial you'll learn the following: 1. The shortcut key to turn filter on and off in Excel 2. How to do approximate matches (filter for words that contain a specific word) 3. How to filter multiple columns 4. How to filter for "or" conditions 5. How to copy a filtered range to another sheet 6. How to use formulas (such as subtotal) to sum a filtered range 7. How to filter for values between 2 dates 8. How to filter based on color 9. How to turn your data set into an Excel table (shortcut key) 10. How to add totals to your Excel table 🡻 Download the workbook here 🡻 http://www.xelplus.com/excel-filter-basic-to-advanced/ ★★ Links to related videos: ★★ 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

Feb 22, 2018 Excel Hacks: Tips & Tricks Would you like to copy your Excel formulas from one place to another without the cell references changing? In this video I show you a simple trick that does that. Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials Excel default behavior is to adjust the cell references when you copy a cell and paste to another one. You can choose to fix the cell reference by using the dollar sign ($). A $ for the row number, fixes the row and a $ on the column number fixes the column. You might however need to copy a set of formulas that have relative references from one location to another or from one file to another and keep the existing cell references. This video shows a very simple trick you can use. ★ 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

Feb 15, 2018 Excel Charts Find out how you can use Excel Macros to control the fill color of Wordart in VBA. In this specific case we'd like to show percentage completion as WordArt and control the amount of the fill color based on the actual percentage. If we have 50%, only half of the 50% word will be highlighted. This video is more than using Excel VBA to control word art. I'll show you how you can find the right syntax, even when the macro recorder doesn't work and doesn't pick up the right code for you. I'll show you how to use the VBA object library to find the correct syntax and how to use Excel's event procedures to connect the macro to your cell value. ➹ ➹ Excel VBA Course ➹ ➹ If you'd like to learn more and become more comfortable with VBA, check out my complete course here: https://courses.xelplus.com/p/excel-vba-excel-macros 🡻 Download the workbook here 🡻 http://www.xelplus.com/excel-vba-wordart-fill-with-macros/ ★★ Links to related videos: ★★ Video #1 using bar-in-bar chart: https://youtu.be/6iZT74sKi50 ★ 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

Feb 8, 2018 Excel Charts This video covers two topics that lets you get creative with Excel: 1. How to have dynamic word art that is controlled with a formula 2. How to create bar in bar Excel charts As a bonus we put them together to create an info-chart that shows percentage completed of a specific task. 🡻 Download the workbook here 🡻 http://www.xelplus.com/dynamic-wordart-in-excel-with-bar-in-bar-chart/ Links to related videos: Info-charts in Excel: https://youtu.be/C9beIaL-cBA Professional data visualization playlist: http://bit.ly/2nTDrPx ★ 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

Feb 1, 2018 Excel Intermediate Functions & Features (For ALL Excel Versions) Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/ Learn how to use Excel's IF Function in your reports. 00:00 When to use the Excel IF function 00:35 When to use a Nested IF formula 00:55 Excel IF THEN formula 03:18 Excel IF formula with AND condition 05:05 Nested Excel IF formula 07:52 Excel IF formula with OR condition 09:17 Excel IF formula with threshold 11:22 Excel IF formula with symbols for result 14:29 Wrap-Up of different uses of Excel IF function ⯆ Download the workbook here: http://www.xelplus.com/excel-if-formula-simple-to-advanced/ We cover a few examples in this tutorial including: 1. Simple IF function (also with greater than or less than checks). 2. IF Formula together with AND logical test to decide outcome if more than one condition is met. 3. Nested IF formula (an IF inside another IF) to check for multiple criteria. 4. IF formula with OR function (to check if "either" condition is met and then decide the outcome). 5. We also take a look at using formulas (other calculations) inside the IF function and finally: 6. How to use symbols as the result of the IF formula Your IF formula isn't working? One of the main mistakes is the "else" argument. That's the last argument inside the IF function. Make sure you haven't forgotten to specify what should happen "if" the condition isn't met. In case you have more than one condition, here's the place to add the second "if" statement. An IF formula inside another IF formula is called a nested if function. Links to related videos: Conditional formatting symbols: https://youtu.be/875eK_x4nyQ Custom formatting symbols: https://youtu.be/tGY70sdpaLc If Function with Partial text match: https://youtu.be/b9WoDkPOTPs ★ 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! #MsExcel

Jan 25, 2018 Excel Infographic Chart Templates Create a simple but effective Excel Dynamic Map Chart with drop-down. Also Conditionally formats the largest values on the map for improved readability. ★ My Online Excel Courses ► https://www.xelplus.com/courses/ 00:00 How to Create Interactive Map Charts in Excel 03:03 Adding Map Picture 06:12 Data Preparation 07:40 Setting Up the Chart 09:29 Adding Interactivity to the Chart 12:08 Updating the Bubble Chart 15:03 Conditionally Format Data Points Learn how to create a simple but impressive dynamic map chart that enables you to visualize specific KPI's by geography. This method doesn't use the relatively new Bing map feature, so it is works on all Excel versions. ★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ The technique shown uses a scatter plot first to set up the respective points on the map and then turns it into a bubble chart to be able to visualize the actual KPI. I also show you how you can conditionally format specific data points to bring the attention to certain categories. In this case I conditionally format the largest data point in the chart in a different color than the rest. This technique is really simple but has a very powerful effect. It makes the difference between a "nice" Excel dashboard to a "great" Excel dashboard. All it takes is 3 minutes of your time. ⯆ Download the workbook here: https://www.xelplus.com/simple-excel-dynamic-map-chart-with-drop-down/ Links to related videos: SumIFS formula: https://youtu.be/AZuBNWMh7VM ✉ 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! #MsExcel

Jan 18, 2018 Excel Advanced Formulas & Features Find out how you can highlight values inside your data set based on a condition. In this example, we are going to conditionally format the result of our lookup formula (I use INDEX Match here) to conditionally format that same value that we find inside the original data set. The tricky part is to get the conditional formatting formula correct. Just remember, one reason why your conditional formatting formulas might not work can be due to the wrong usage of the dollar sign for fixing the cell references (i.e. absolute, versus relative referencing - and sometimes you need a mix of the two). Download the workbook here: http://www.xelplus.com/conditional-format-index-match-result/ Links to related videos: Index Match basics: https://youtu.be/F264FpBDX28 More on Conditional Formatting: https://youtu.be/875eK_x4nyQ ★ 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

Jan 11, 2018 Excel Charts Step by Step approach to creating a Step Chart in Excel from Scratch. You can also download the template from the link below. What is a Step Chart? A Step Chart is great for visualizing variables that change on an irregular basis. For example price and inventory changes. If you create a line chart directly on the data set you will realize it doesn't show the correct visualization. For the correct visualization you need a data preparation table that plots two points for each value. One point represents the value before the change and the second point the value after the change. Once you get past this step, you can further improve the readability of the Excel Step Chart by taking additional steps to bring the data labels inside the chart instead of relying on the axis. This improves the readability of the chart. The last part of the video shows you how to create a fully dynamic Step Chart so that when new dates are added, the chart updates automatically. We do this with Excel's OFFSET function and Name Manager to create dynamic chart ranges. ★★ Contributions ★★ Thanks to Bart Titulaer (Lecturer at Fontys International Business School in Venlo, Netherlands) for providing the Step Chart Template. 🡻 Download the workbook here: http://www.xelplus.com/how-to-create-step-chart-in-excel/ Other fun chart tricks: Info Charts (non standard graphs): https://youtu.be/C9beIaL-cBA Dynamic drop-down: https://youtu.be/22jcw5slQJk Changing chart ranges: https://youtu.be/sHfWRb2yUrM ★ 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