Debits and Credits MADE EASY with ADEx LER
26 November 2019 Unleash your inner Financial Pro
Get Access to My Course "Fundamentals of Financial Analysis" HERE: https://www.xelplus.com/course/learn-financial-analysis/
Finally understand Debits and Credits and remember it easily with our secret weapon: ADEx LER (6:23)
There is a simple rule to understanding debits and credits. By the end of this tutorial you will understand the difference between debits and credits in accounting. You will have your cheat sheet to refer to when it comes to understanding whether a transaction needs to be debited or credited.
You will also understand debit and credit in banking and why banks use the terminology that seems confusing: debit card and credit card. You'll understand how that fits with our debit and credit examples.
Overview:
Debits and Credits are a fundamental part in accounting. Debits and Credits affect accounts differently depending on the type of account. To memorize the rules easily just remember: Accountants Don't Expect Low Earning Rates.
Debits and Credits always go together. Every transaction will have Debits and Credits and at least two accounts will be affected. If one account is debited then another one must be credited. Just think of it like a bank transfer. When you send someone money it comes out of your bank account and goes into their account.
The process of recording transactions with debits and credits is referred to as double-entry accounting, because there are ALWAYS at least two accounts involved. There can be more than 2 accounts involved in one transaction but never less than 2. We call this a flow of economic benefit from a source to a destination.
Assets, Dividends, and Expenses are Debits. The balance of these accounts increases with debits and decrease with credits.
Liabilities, Equity, and Revenues are Credits. The balance of these accounts increases with credits and decrease with debits.
Chapters:
T-Account Basics - 00:53
Rule #1 in Accounting - 1:08
Rule #2 in Accounting - 1:25
Balance of a T-Account - 2:04
Rule #3 in Accounting - 4:10
Which accounts are Debit and which credits - 4:34
ADEX LER (secret accounting method to remember) - 6:23
Accounting Debit / Credit example: 6:41
Debit and Credit in Banking (Debit Card) - 8:00
★ 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!
#Accounting #MsExcel #Excel #LeilaGharani
50
views
Left Lookup in Excel with XLOOKUP (Made Easy)
21 November 2019 Excel for Office 365 & Dynamic Arrays
A common Excel Lookup question is: How to return a value left of the lookup range in Excel? It's not easy if you use VLOOKUP. You either need to use a workaround or INDEX and MATCH.
With the Excel's XLOOKUP function we can use one single formula to do a left lookup in Excel. It's super easy because XLOOKUP takes the best of VLOOKUP and INDEX & MATCH formulas. We have a separate independent lookup range and a separate return range.
*** Availability of XLOOKUP: XLOOKUP is available in Excel for Office 365. It will not be available for Excel 2016 or Excel 2019. If you'd like to learn more about the new dynamic array functions like FILTER, UNIQUE & SORT check out the complete course: https://courses.xelplus.com/p/excel-dynamic-array-formulas
⯆ Article & Workbook use is here: https://www.xelplus.com/excel-lookup-to-the-left-with-xlookup/
Original XLOOKUP video: https://rumble.com/v2uqp14
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Take this Quiz to choose the right Excel course: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
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!
#MsExcel #Excel #LeilaGharani
16
views
How the Balance Sheet Works | with a FUN Demo
19 November 2019 Unleash your inner Financial Pro
Get Access to My Course "Fundamentals of Financial Analysis" HERE: https://www.xelplus.com/course/learn-financial-analysis/
Find out how a balance sheet works with this special demo!
The balance sheet is one of the three main financial statements and it provides information about a company’s financial position at a certain point in time. If you want to understand the financial health of a business that’s the place to start. However, please note that’s it’s just a snapshot a certain point in time: It does NOT show the flows into and out of the accounts during the period.
The balance sheet provides information on the company’s Assets, Liabilities and Equity. Assets are the resources the company owns and uses, and Liabilities is what it owes to others. Equity is the difference between total assets and total liabilities. This leftover money belongs to the owners of the company. Therefore, the more assets a company has and the smaller its debt, the bigger equity will be.
It all comes back to the main accounting equation: Assets equal Liabilities plus Equity or if we rearrange: Equity equals Assets minus Liabilities. A higher value for assets, a lower value for liabilities equals higher equity.
Link to Accounting Basics video: https://rumble.com/v2us1q8
Link to Controller Institute that gave me the Demo idea (Christian Kreuzer): https://www.controller-institut.at/
★ 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!
#Accounting #MsExcel #Excel #LeilaGharani
13
views
SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)
14 November 2019 Excel Hacks: Tips & Tricks
Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/
With Excel's Advanced Filter feature you can filter for multiple criteria and copy the filtered results to another sheet. But did you know of the trick shown in the video? I didn't :)
★ My Online Excel Courses ► https://www.xelplus.com/courses/
In this Excel tutorial we cover a few important topics rather quickly:
00:00 How to use Advanced Filter in Excel
00:50 How to Filter For MULTIPLE Conditions Using Advanced Excel Filter
02:05 Approximate Match - How to Use Wildcards in Advanced Filter
02:48 How to Copy the Advanced Filter Results to Another Sheet
04:20 Advanced FILTER TRICK
★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-advanced-filter-trick
To find out more about Excel Advanced Filter check out this video: https://rumble.com/v2tv4re
For Excel Filter Basics check out this video: https://rumble.com/v2tv4oo
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
RESOURCES I Recommend: https://www.xelplus.com/resources/
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
12
views
Accounting Basics Explained Through a Story
12 November 2019 Unleash your inner Financial Pro
Get Access to My Course "Fundamentals of Financial Analysis" HERE: https://www.xelplus.com/course/learn-financial-analysis/
New to Accounting? In this video I will introduce you to the world of accounting by telling you a story. This quick tutorial gives you an introduction to accounting and explains the concepts of income statement (Profit & Loss), balance sheet and the accounting equation (Assets = Liabilities + Equity).
You will also learn through examples what assets, liabilities and equity are. I will also introduce you to the concept of the T account. This is something that we will look into more detail in the Debits & Credits video.
You will follow a day of an Italian beach business and see how this is reflected in two financial reports - although this is a simple example, it can be applied to more complex situations:
00:00 Financial Statements Explained
00:53 Claudio's Beach Business
02:13 Income Statement (which is Revenue - Expenses)
03:31 Balance Sheet
06:21 Claudio's Balance Sheets at different points in time
In the next video of our accounting basics series, we'll take a look at Debits & Credits and in the video after that will take a closer look at the balance sheet.
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
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!
#Accounting #MsExcel #Excel #LeilaGharani
73
views
Excel Flash Fill For MAJOR Time Saving (7 Examples)
7 November 2019 Excel Intermediate Functions & Features (For ALL Excel Versions)
Learn how to use Excel Flash Fill correctly with these 7 Examples.
The Complete Excel Essentials course: https://courses.xelplus.com/p/learn-excel-essentials
Flash Fill in Excel is similar to Autofill except it will fill the values down based on a certain logic. That logic is derived automatically once Excel sees a pattern in the data.
There are different ways you can use flash fill:
1. Use the Excel shortcut key for Flashfill: Control + E
2. Pull down the values with the fill handle and then select Flash Fill
3. Go to Home / Fill / Flash Fill
4. Start typing the 2nd value and once Excel recognizes the pattern, you will see the results shown in the cells in light grey. Just Press Enter.
Excel Flash Fill not working? Check out 2:02.
You can only apply Flash Fill close and adjacent to your data set. You can also apply Flash Fill one column at a time. For example to split first name and last name, you can do the first name first and then do the last name separately. For Flash Fill to work it also needs to recognize a pattern. For really messy data, it might not find a consistent pattern.
If for some reason Excel doesn't show you the Flash Fill preview, it might be turned off in your Excel Options. To make sure Flash Fill is turned on go to File - Options - Advanced Editing Options - put a check mark in the "Automatically Flash Fill" box.
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-flash-fill
LINKS to Excel Basics Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0
Change Case of Text in Excel: https://rumble.com/v2uaza0
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
18
views
Fully Dynamic Emails from Excel with a SINGLE FORMULA!
31 October 2019 Excel Advanced Formulas & Features
Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/
Did you know you can create an Outlook email from Excel? You can even create it with an Excel formula using cell references for mailto, subject and cc? The Excel Hyperlink formula gives you the ability to create dynamic emails.
★ My Online Excel Courses ► https://www.xelplus.com/courses/
In this video you will learn how to use the Excel Hyperlink feature to create a manual email hyperlink. As we're doing this step, we learn some key components of the Hyperlink feature that will enable us to make the process dynamic by using Excel's Hyperlink Function.
This Excel tutorial will also show you how you can get creative with the Hyperlink function. We will use the Excel IF Function to create two different types of emails depending on whether goals were reached or not. We will also use some of Excel's text functions like TRIM and LEFT function to grab the part of the text we need for our email.
★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
Timestamps
00:00 How to Create Emails from Excel with a Formula
03:20 How to Use the HYPERLINK Function in Excel
05:29 Add a Subject Line
06:23 Add a CC Recipient
06:57 Add Body Text to the Email
07:22 Add a Line Break to the Body Text
08:27 Wrap Up
What to do if you need:
Excel email with Multiple Mail-to: If you'd like to have multiple recipients for the mailto address, just add the email addresses in the same cell and separate them with a semicolon.
Add a Line break to email body: To add a link break in the email body, you can us the carriage return character (%0A).
Beware of Excel's formula 255 character limit - you can't use the Hyperlink formula for extra long emails. Keep the [friendly name] as short as you can to allow for more characters in the rest of the email.
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/send-email-from-excel-with-hyperlink-formula
Excel IF Function Tutorial: https://rumble.com/v2tuwvk
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
RESOURCES I Recommend: https://www.xelplus.com/resources/
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
25
views
Get ALL External Links with This SIMPLE Excel TRICK (as NEVER seen before!)
24 October 2019 Excel VBA & Macros Tutorials
Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/
With this Excel trick you can use a formula to show all the external links in your Excel workbook in one place. This way you can keep an eye on where the data is coming from and if any link is pointing to the wrong workbook.
With this Excel hack you can also write a formula to get the list of files from a specific directory and bring it to your Excel sheet. So if you're waiting for your colleague to add a file to a directory, you'll be able to see it in your Excel formula results once you refresh the list.
The fun part about this Excel trick is it combines 4.0 Excel Macros with Excel dynamic arrays. You can use the Excel Transpose function to get a vertical list of external links for file names.
⯆ Blog post is here: https://www.xelplus.com/excel-external-links-trick-dynamic-arrays
Bob's Excel Magic book on Amazon: https://amzn.to/2oVFRln
All about Excel's NEW Dynamic arrays - check out the complete playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Take this Quiz to choose the right Excel course: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
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!
#MsExcel #Excel #LeilaGharani
21
views
Do's & Don'ts of Excel Spreadsheet Design (with Examples)
17 October 2019 Excel Dashboards & Reports
Check out the complete Excel Essentials course: https://courses.xelplus.com/p/learn-excel-essentials.
In this Excel tutorial I cover the Do's and Don’ts when it comes to creating your next Excel Dashboard or Report. There are two main aspects when you design an Excel spreadsheet:
1. Excel Workbook Structure
2. Visual Design of Each Excel Worksheet
The tutorial includes examples of professional and beautiful Excel reports that follow these design principles.
If you don't have time to watch the whole video make sure you watch Tip#8 at 3:28. This is the one we tend to forget about because we're too busy analyzing and getting the work done. But a little formatting goes a long way. The good news is "less is more" so it really doesn't take much effort to get this right. If you have the proper structure in place as shown at the beginning of the video, the rest will be easily done. Remember: "Organize before you serve".
Putting into practice and making a habit of as many of the Excel spreadsheet design principles outlined in this video will elevate your spreadsheets far above those around you. Who knows; it could be the reason for your next promotion!
⯆ Full Blog Post is here: https://www.xelplus.com/excel-spreadsheet-design
More tips on designing Excel Dashboards: https://rumble.com/v2st67u
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
20
views
5 Excel INTERVIEW Questions You NEED to Get RIGHT
10 October 2019 Excel Intermediate Functions & Features (For ALL Excel Versions)
Want to ROCK your Next Interview? Check out the complete Excel Essentials course: https://courses.xelplus.com/p/learn-excel-essentials
You’ll learn dozens of quick hidden tips and tricks to showcase your knowledge.
Once you get the job, you’ll have the course to rely on! Good luck : )
For now make sure you check out these 5 Excel interview questions before you go to your next job interview.
Over the last 30 years, Microsoft Excel has become the professional standard in offices across the globe. Many companies rely on Excel to carry out their day to day business.
Basic Excel skills is a mandatory requirement for most office-based professionals today. Advanced Excel skills can get you a promotion. Some jobs require advanced Excel skills to begin with. In this video I cover some of the most common interview questions asked at a job interview.
Explain Excel VLOOKUP function and limitations
How does absolute reference in Excel differ from relative cell reference?
What is a PivotTable and why should you use it?
What is conditional formatting?
When would you use the IF Function or a Nested IF in Excel?
Picture of Satya Nadella by By Brian Smale and Microsoft - Satya Nadella Microsoft leadership profile page, CC BY-SA 4.0, https://commons.wikimedia.org/w/index.php?curid=68400841
⯆ Blog post link: https://www.xelplus.com/top-5-excel-interview-questions
LINK to XLOOKUP video: https://rumble.com/v2uqp14
★ 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
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
23
views
5 Eye-Tracking Discoveries for OPTIMAL Chart Design - Do you use these?
3 October 2019 Excel Charts
Here are 5 design tips for creating optimal column charts. The tips are based on a study conducted which uses eye-tracking technology to get insights on how we read and understand charts (see link below).
This is how eye-tacking tests are done: The participant is presented with a question which they need to answer by looking at the visualization on the screen while the camera is tracking their eye movements. Two parameters are measured. One is effectiveness – which means was the answer correct and number two is efficiency, which means how fast were they able to respond.
Download the full research paper from: https://top-reports.com/reporting-design/fachbeitraege/
Sources used in this video ______________________________
Eye-tracking video: https://top-reports.com/eye-tracking/funktionsweise-eye-tracking/
Case study shown from University of Applied Sciences Upper Austria: https://www.fh-ooe.at/en/steyr-campus/
Attribution: Picture of Edward Tufte By Keegan Peterzell - Own work, CC BY-SA 4.0, https://commons.wikimedia.org/w/index.php?curid=40367115
________________________________________________________
★ 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
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
10
views
VBA to BROWSE & COPY Data from SELECTED File in Excel
26 September 2019 Excel VBA & Macros Tutorials
Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/
Use this simple Excel VBA macro to allow the user to browse for the file they need to import or copy the data from. They will get Excel's open File Dialog Box and they can browse and select the workbook to copy the data from. We use VBA GetOpenFilename method to Open the workbook selected in the background, copy the data and then close the workbook. The user will not even realize the other workbook was opened in the background.
I will also show you how to avoid getting the message "method getopenfilename of '_application' failed". This is a common error when using the application.getopenfilename method and it can easily be avoided by declaring the correct variable type.
You can expand on this Excel macro to copy data from multiple ranges or multiple sheets or create dynamic ranges.
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-vba-getopenfilename
Check out the FULL VBA Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se
★ 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
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 #Excel #LeilaGharani
16
views
1
comment
Convert Columns to Rows in Excel (NO Transpose, NO Formulas - SIMPLY UNPIVOT in Power Query)
19 September 2019 Excel Power Query (Get & Transform)
Check Out the Complete Excel Power Query course: https://www.xelplus.com/course/excel-power-query/
It sounds simple to just switch columns to rows - basically transpose horizontal data to vertical. BUT you can't always use a simple transpose (neither the transpose feature nor the Transpose function) if you only need to transpose parts of your data set. Some columns, instead of all columns.
For example if you have a report in Excel with a list of months in the columns, it would be easier to analyze the data and create formulas or pivot tables on the data, If your data is in a tabular format. For each value field in the original report, we will get a new row. Since this involves unpivoting or transposing parts of the data, it can be difficult to achieve with Excel formulas.
This is where you can use Excel's "Get & Transform" feature - (also called Power Query). Get & Transform is available since Excel 2016. All you need to do is create a table or a named range from your source data and then unpivot the columns in the Power Query editor.
If some of the value cells in your report happen to be empty - the entire row will be removed in the final table. To keep empty cells, you need to replace the null value in Power Query with 0.
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-powerquery-transpose-unpivot/
LINKS to related videos:
3 ways to transpose: https://rumble.com/v2ua37m
R1C1 trick to transpose: https://rumble.com/v2ub0do-
Unstack data: https://rumble.com/v2ua4uc
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
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
17
views
Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)
12 September 2019 Excel Lookup Formulas
Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/
No more VLOOKUP?! The NEW Excel XLOOKUP Function is here to stay!
Discover how XLOOKUP can solve your Excel lookup problems. Remember all those times your VLOOKUP wasn't working? You will have a better chance of getting your lookup formula correct on the first try.
★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
AVAILABILITY: XLOOKUP is available to Excel for Office 365 and Office 2021 users. If you'd like to learn about the other brand new Excel functions like FILTER, UNIQUE & SORT check out the complete course: https://courses.xelplus.com/p/excel-dynamic-array-formulas
Timestamps:
00:00 What is Excel XLOOKUP
00:55 XLOOKUP Basic Function
02:50 Get Last Match with XLOOKUP Search Mode
03:54 Get Next Smaller Match with XLOOKUP Match Mode
05:51 Why Excel XLOOKUP is Better than VLOOKUP
What is XLOOKUP?
If you need to lookup a value on another Excel sheet or table, you can use the XLOOKUP function. Here are some of its features:
- XLOOKUP can lookup values to the left OR right-hand side of the lookup range.
- XLOOKUP looks for an exact match by default (you can change it if you like)
- Use XLOOKUP to look for the next smallest value or the next largest value (approximate or close match)
- XLOOKUP can do vertical AND horizontal lookups
- XLOOKUP can find the first match or the last match (reverse lookup)
And guess what? XLOOKUP can also be combined with another XLOOKUP to lookup values inside a matrix - which means XLOOKUP can replace INDEX & MATCH formulas too!
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-xlookup-explained
► VLOOKUP tutorial: https://rumble.com/v2u8hqw
Playlist for Excel LOOKUP formulas: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxpMnh_KKfAgp5DF9ydawmi
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
RESOURCES I Recommend: https://www.xelplus.com/resources/
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #XLOOKUP #Excel #LeilaGharani
18
views
Progress Circle Chart in Excel as NEVER seen before!
5 September 2019 Excel Infographic Chart Templates
This Progress circle chart infographic is different to what you've seen before.
Just like the other progress circle charts it uses the doughnut chart as the basis. A text box is placed in the middle of the progress chart (I will show you an Excel chart trick to embed the text box inside the chart object). The value of the text box is connected to the percentage completed value which is input in a cell.
00:00 How to Create a Professional Doughnut Chart in Excel
00:42 Progress Circle Chart Version Leila
04:57 Progress Circle Chart Version Sam
10:00 Wrap Up
What makes this chart different to the rest?
It's a small design tweak that makes THIS progress circle chart look more professional. This chart comes with ROUNDED EDGES. This seems like a small tweak, but there isn't a simple option in Excel to get the inside shape have rounded edges. In this video you'll find two versions to create this Excel progress chart infographic with rounded edges (or the doughnut chart with rounded edges):
Version #1 (by me) - It requires a simple tweak to the border of the chart. This brings us halfway there but it doesn't give the professional look we're going after.
Version #2 (by Sam Dekoven): This version has perfectly rounded edges for the doughnut chart and it uses a smart technique which combines a scatter plot series with the doughnut chart (together with the SIN COS and PI Excel Functions). Many thanks to Sam for sharing his version with all of us!
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-progress-circle-chart
LINKS to Excel infographic chart playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyw08u-MZm4ROnB3J0gRlsop
Advanced Chart Techniques: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyEj7oQkCf7TL9yQQWXbGOQ
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
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
37
views
The QUICKEST & EASIEST Way to Work with TEXT in Excel
29 August 2019 Excel Hacks: Tips & Tricks
Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials
Justify text (or Fill Justify) is a useful and hidden Excel feature when it comes to managing text, rearranging or aligning text in Excel. Let's say you're writing a set of instructions. By default the text entered overflows to the next cells. Now let's say you'd like to cap the overflow so the text doesn't go over too may columns.
You can do that with Excel's Fill Justify feature. With ONE click you can properly align and arrange your text in a readable format. Justify automatically cuts the overflowing text and pastes it in the cells below. It also works the other way round. You can bring text from multiple rows in one single cell!
** Watch Out for Excel's 255 character limit: If your first cell has text with more than 255 characters and you Fill Justify down - then the remainder of the text is deleted.
You DON'T run into a problem if you Justify text from multiple columns to one cell - Excel puts the remainder on the row below.
⯆ Blog Post: https://www.xelplus.com/microsoft-excel-justify-text
LINK to Excel TIPS & HACKS playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxVeel8DFjewBSlZYdfd38A
LINK to Excel basics playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
9
views
Excel MAX or MIN with CONDITIONS (MAXIFS & AGGREGATE Method)
22 August 2019 Excel Advanced Formulas & Features
Is there an Excel Max IF or MIN IF function? If you have Excel for Office 365 or Excel 2019, you can use MAXIFS and MINIFS functions which allow us to find the maximum or minimum value in a data set based on multiple conditions. For example if you wanted to find the MIN value but exclude zero values, you can use the MINIFS function to do that.
If you have an older version of Excel, you can use an alternate method. The common solution is {=Max(If (array) )} but you need to press Control Shift Enter (CSE).
Another method to get the maximum or minimum value based on criteria is to use the AGGREGATE function. The advantage of AGGREGATE is you don't need to press control shift enter. Just enter. You need a little trick to get to work. We cover that in this video.
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-maxifs-minifs-with-conditions
More IFS functions - like SUMIFS: https://rumble.com/v2skgke
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
13
views
ALL YOU Need to Know About Excel HYPERLINKS (Function & Feature)
15 August 2019 Excel Intermediate Functions & Features (For ALL Excel Versions)
Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials
Find out all the different ways you can add hyperlinks to your Excel files. This improves workbook navigation and makes your Excel reports more user friendly. We cover:
- How to Add an Excel hyperlink to a web page, another sheet, another folder or another cell
- How to create and email with hyperlink
- How to add a friendly hyperlink name and add a screentip
- Add a hyperlink to a shape or an icon (create a button for your hyperlink)
- How to remove a hyperlink
- How to add multiple hyperlinks to different worksheets in one go
- How to change the color of the hyperlink or visited links
- Create dynamic hyperlinks with the HYPERLINK Function
- Use VLOOKUP to return a hyperlink (get a clickable link as a result of a lookup formula)
⯆ Blog Post & Workbook are here: https://www.xelplus.com/excel-hyperlink/
LINK to VLOOKUP video: https://rumble.com/v2u8hqw
Excel Basics Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0
★ My Online Excel Courses ► https://courses.xelplus.com
Direct link to Excel VBA Course: https://courses.xelplus.com/p/excel-vba-excel-macros
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
29
views
GUESS what's HIDDEN in Excel? (Cool Trick)
1 Aug 2019 Excel Hacks: Tips & Tricks
Do you want to bring some fun to your team meetings or Excel training sessions? Here's one way. Hide a picture behind this Excel puzzle chart (or Mosaic chart) and get everyone guessing. It's super easy to set up.
While we're having some Excel fun, you also learn:
- How to use Excel's RandBetween function to generate random numbers
- How to add a spin button form control and connect the value to the cell
- How to apply conditional formatting by checking the cell value against another number
- How to use Excel custom number formatting to hide numbers from view
MANY THANKS TO ROBERT PALECHEK FOR SHARING THIS IDEA!
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-fun-mosaic-trick/
LINK to other fun chart videos: https://www.youtube.com/playlist?list=PLmHVyfmcRKyw08u-MZm4ROnB3J0gRlsop
Note: The film clip is from 1978 Concentration Game
★ 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
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
11
views
Project Plan in Excel with Gantt Chart (Plan, Actual & Progress in ONE VIEW)
25 Jul 2019 Excel Charts
Excel Gantt Charts are great for project planning. They help you schedule your project tasks and keep track of your progress. In this Excel tutorial you learn to create a complete Gantt chart that includes Project Plan & Actual in one view. We also add the project progress bar for each task so we can keep track of percentage completed. You can also download the Gantt Chart template from the bottom of the blog post below and update according to your project plan.
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-gantt-chart-actual-plan
LINKS to related videos - Quick Gantt Chart: https://rumble.com/v2tmuf2
Fully featured Gantt Chart: https://rumble.com/v2tmuh0
Corporate report makeover playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKywqPsTWKKcRKCVAaf5B9N8M
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
24
views
How to SUM Cells by Color in Excel (Get it to update automatically)
18 Jul 2019 Excel VBA & Macros Tutorials
Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/
Learn how to write an Excel formula to sum values based on the cell background color.
We achieve this with a simple Excel VBA function. The VBA function has two arguments. One is for color and the other the range that needs to be summed. You can use a similar technique to count cells based on color.
We also improve on the VBA code to have the formula results update automatically when a cell color in the range changes. This is done by using the worksheet selection change event for a specific range. We achieve this with the Application.Intersect method.
⯆ Blog post & DOWNLOAD the workbook: https://www.xelplus.com/excel-sum-cells-by-color-vba/
LINK to Excel VBA Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #ExcelVBA #Excel #LeilaGharani
13
views
Use PowerPoint SLIDE ZOOM the RIGHT WAY
11 Jul 2019 PowerPoint & Presentation Tips
Get two free months of unlimited learning on Skillshare: https://skl.sh/xelplus4
It's an easy way to make your presentation more exciting and dynamic.
You can use slide zoom similar to the way you'd use a landing page on a website. You can click on the different icons and zoom into different parts of your presentation. It's a way of adding hyperlinks to your slides in PowerPoint but in a more professional way and with very little effort.
★ My Online Excel Courses ► https://www.xelplus.com/courses/
PowerPoint Slide Zoom is available in Microsoft 365 and PowerPoint 2019.
★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
00:00 Create PowerPoint Zoom Like Prezi
01:22 Basics of Slide Zoom
02:34 Important Zoom Feature (return to zoom)
04:11 Practical PowerPoint Zoom Example
06:10 Hide Zoom Slide and Show an Icon or Image Instead
08:02 Create Sections in PowerPoint
08:50 How to use Section Zoom to Zoom into More than 1 Slide
⯆ Article and Presentation will be here: https://www.xelplus.com/use-powerpoint-slide-zoom-the-right-way/
LINKS to related videos - check out the PowerPoint playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKywJTPy2_OBZEaKeGGdFXlX3
★ 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/
RESOURCES I Recommend: https://www.xelplus.com/resources/
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!
Many thanks to Skillshare for sponsoring this video!
#PowerPoint #MsExcel #Excel #LeilaGharani
16
views
Lock Cells & Protect Excel Worksheet - EVEN by Cell Color!
4 Jul 2019 Excel Introduction - Learn Excel Basics
Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials
Protect your Excel formula cells to make sure they're not changed. Only allow users to edit specific cells in Excel.
You'll learn a few Excel tips here such as:
00:00 How to Lock Or Unlock Cells in Excel
00:36 How to Protect and Unprotect Cells in Excel
01:04 How to Unlock Individual Cells so Users Can Edit as Needed
02:36 How to Lock or Unlock Cells Based on Their COLOR
⯆ Full Article Here (& download workbook): https://www.xelplus.com/excel-unlock-lock-cells-also-by-color
LINKS to related videos - Excel's FIND & REPLACE feature: https://youtu.be/3naynygx_dU
Excel Basics Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
11
views
Are YOU Ready for the NEW Excel? (New Calc. Engine & Dynamic Arrays)
27 Jun 2019 Excel for Office 365 & Dynamic Arrays
Complete course on the NEW Excel features: https://courses.xelplus.com/p/excel-dynamic-array-formulas
LINK to my first Excel Dynamic Array video: https://youtu.be/2USJsIyIzvo
UPDATE 2020 - These new functions are now available in Excel for Office 365 users.
How to become a Microsoft Office Insider: https://insider.office.com (Note: Currently dynamic arrays are only available in Microsoft Office Insider FAST edition)
If you have Office 365 Pro Plus check out this link: https://insider.office.com/en-us/handbook/for-work-or-school
This videos gives you a quick overview of all you can achieve with Excel's new calculation engine and the new Excel dynamic array formulas. It will show you how you can check if your Excel version has the new dynamic array formulas and it introduces you to my new Excel course called: Excel Dynamic Arrays - Beginner to Expert (Office 365 Insider)
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Take this Quiz to choose the right Excel course: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
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
18
views
Animate Charts Properly in PowerPoint
20 Jun 2019 PowerPoint & Presentation Tips
Get two free months of unlimited learning on Skillshare: https://skl.sh/xelplus3
This tutorial shows how you can make professional chart animations in PowerPoint. With this simple tool you can deliver a confident and professional presentation.
You will also learn how to best copy a chart from Excel to PowerPoint. This ensures the graph data is linked. If the data changes in Excel, it will be automatically reflected in PowerPoint.
When it comes to chart animations in PowerPoint, you have a few options. The default is to animate by the entire chart object. However you should change this to either by Series or by Category depending on which fits better with your narration. You can use the appear or the wipe animation for this.
You'll also learn more advanced PowerPoint animation by opening up the animation pane and controlling the animation of each element separately.
00:00 Comparison of Different Slide Styles
01:50 Creating Excel Chart #1
04:20 Excel Chart #2
06:20 PowerPoint Animation
⯆ Link to the article: https://www.xelplus.com/powerpoint-excel-chart-animation
Check out the PowerPoint series: https://www.youtube.com/playlist?list=PLmHVyfmcRKywJTPy2_OBZEaKeGGdFXlX3
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
Many thanks to Skillshare for sponsoring this video!
#MsExcel #Excel #PowerPoint #LeilaGharani
13
views