Excel Picture Lookup: 5 easy steps for dynamic images
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
3
views
FIFA World Cup 2018 Excel Template for Predictions and Sweepstakes
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
3
views
3 REALLY Useful Excel Chart Tips You May Have Missed
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
10
views
Excel Custom Data Validation (Use formulas to check for text, numbers & length)
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
21
views
Excel VBA basics: Data types, DIM & SET (Learn to use them correctly)
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
5
views
Create SMART Drop Down Lists in Excel (with Data Validation)
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
5
views
Easiest Step Chart in Excel (this trick will surprise you!)
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
8
views
How to use the Message Box in Excel VBA (syntax you'll need for msgbox)
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
27
views
Build Impressive Charts: It's NOT your usual Bar Chart (Infographics in Excel)
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
37
views
Excel VBA: Loop through cells inside the used range (For Each Collection Loop)
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
4
views
Copy & Paste in Excel VBA (copy, pastespecial, resize & offset)
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
39
views
Excel VBA: Referring to Ranges & Writing to Cells (Range, Cells, Offset, Names)
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
45
views
Excel VBA tutorial for beginners: Object Properties & Methods
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
70
views
Excel VBA tutorial for beginners: The Visual Basic Editor (VBE)
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
30
views
Excel VBA: Copy Data from one Sheet to Another (Absolute Vs. Relative Macro Recording)
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
40
views
Excel: Find Multiple Matches & Dependent Drop Down List (Unsorted Tabular Data Set)
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
10
views
Advanced Excel Filter (And, Or, Between conditions for criteria range)
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
5
views
Excel Filter Basics (for quick data analysis)
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
4
views
Excel Hack: Copy Formula Without Changing Cell References (or Without File References)
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
16
views
Excel VBA: Adjust Fill Color of WordArt with a Macro
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
23
views
Dynamic WordArt in Excel with Bar in Bar Chart (Info-chart that shows % completion)
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
4
views
Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)
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
38
views
How to Create a DYNAMIC Map Chart With Drop-Down (works with ANY Excel version)
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
8
views
Excel Conditional Formatting the Lookup result in data table (Index Match)
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
9
views
How to create a Step Chart in Excel (that is fully dynamic & easy to read)
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
9
views