XelPlus

XelPlus смотреть последние обновления за сегодня на .

Excel VSTACK 🍔 - Quickly Combine Data from Multiple Sheets (Excel Noob Vs Pro)

174221
7688
499
00:06:59
26.05.2022

Join 300,000+ professionals in our courses: 🤍 What to do when the regional director wants the data combined from 15 different Excel sheets? Combining or appending data from multiple sheets is a common task in Excel. In this video I'll show you how you can stack multiple data sets vertically with a single formula. We'll use Microsoft Excel's new VSTACK function. I'll also show you how you can combine VSTACK with the FILTER function to eliminate blanks/empty spaces. You'll also learn how to use the SORT function to dynamically sort your data - even with multiple levels. Example: Sort your data first by products (ascending) and then by sales (descending). 🌍 My Online Excel Courses ► 🤍 00:00 How to Use VSTACK to Combine/Append Data in Excel 01:28 Consolidate Data in Many tabs with 3D Referencing 02:26 How to Combine VSTACK with FILTER 03:16 How to SORT with Formula 03:57 Automatically Include Data From New Worksheet 05:12 Pro Tip! Dynamically Sort With Multiple Levels 06:33 Wrap Up VSTACK is currently available in Office 365 Insider Beta Channel. ⯆ DOWNLOAD the workbook here: 🤍 🎬 LINKS to related videos: - Return Multiple Values with FILTER Function: 🤍 - FILTER Function TRICK for Non Adjacent Columns: 🤍 - New Functions in Excel: 🤍 🎒 Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 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! #Excel #office365 #noobvspro

Excel Productivity for Lazy (but Smart) People

842095
11480
434
00:10:41
18.11.2021

Get Access to the Course: 🤍 Learning Power Pivot, data modelling and DAX is a skill you need to have if you’re responsible for analyzing data and creating reports. Even if you're great with Excel formulas, you will struggle to report on large and scattered data. And these days even small companies collect millions of data points. They need to get meaningful reports which can help them view their key figures from different angles. They need proper data models and someone who can quickly make sense of the data and create dashboards from these models. The great thing is that data modelling and DAX is a skill you need to master for Power BI as well. With my Master Excel Power Pivot & DAX course, you’ll be able to do it all! Improve your workflow, create impressive models and extraordinary dashboards! What's Inside the Course: - 14 hours of video content - 2 complete business dashboards - 60+ Practice Workbooks - Challenges & Quizzes - Course Notes - Helpful Articles & Job Aids - Your very own eBook with 300+ pages - Lifetime access 00:00 Take Advantage of Power Pivot & DAX 01:28 The OLD & SLOW Way of Using Excel 03:35 Using Excel Data Model & DAX 08:20 Master Excel Power Pivot & DAX 🌍 My Online Excel Courses ► 🤍 🎒 Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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

🎤 Quick announcement - Power BI course is finally available on XelPlus.com

30817
762
62
00:00:39
08.11.2022

🎓 Link to course: 🤍 Quick announcement to let you know that our much-anticipated Power BI online course is finally available! Hope to see you inside the course! #powerbi #powerbishorts #powerbitraining #learnpowerbi

👕 Introducing the New Merch! ☕

31858
862
118
00:02:19
18.05.2021

Merch website: 🤍 I'm so excited to be dropping the first XelPlus / Leila Gharani merch! Thank you so much for all of the support! If you love Excel, Power Query, XLOOKUP or data analysis, you'll find something here. From t-shirts, hoodies, phone cases and mugs you'll find funny quotes for Excel enthusiasts. Interested in Excel Courses instead? ► 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 EXCEL RESOURCES I Recommend: 🤍 Get Microsoft 365: 🤍 Microsoft Surface: 🤍 GEAR Screen recorder: 🤍 Main Camera: 🤍 Backup Camera: 🤍 Main Lens: 🤍 Zoom Lens: 🤍 Audio Recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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! #xelplus #merch

5 Excel Functions YOU NEED in 2021 & 2022

839692
22051
912
00:12:15
07.01.2021

Join 300,000+ professionals in our courses: 🤍 In this Excel functions tutorial you'll learn how to use the NEW Excel formulas and functions. These Excel functions are available in Excel for the Web (for free) and also Excel Desktop if you have a Microsoft 365 subscription. I've rounded up the most useful Excel functions you'll need as an Excel beginner, accountant or if you need the right Excel functions for data analysis. GET ACCESS TO THE COMPLETE COURSE to MASTER Excel Functions in Microsoft 365: 🤍 You’ll master the new Excel functions through multiple exercises and challenges so you can use the FILTER Function instead of a complex combination of INDEX & MATCH. Not only will these save you from headaches but also from wasting time doing things the long way. Time Stamps 00:00 The Most Important Excel Functions in 2021 00:32 SORT Function (SORTBY) 03:16 UNIQUE Function in Excel 05:41 XLOOKUP 07:43 FILTER Function 09:29 SEQUENCE Function in Excel DOWNLOAD the Excel Workbook from here: 🤍 LINKS to more Excel 365 tutorials: 🤍 ★ My Online Excel Courses ► 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 EXCEL RESOURCES I Recommend: 🤍 Get Microsoft 365: 🤍 Microsoft Surface: 🤍 GEAR Screen recorder: 🤍 Main Camera: 🤍 Backup Camera: 🤍 Main Lens: 🤍 Zoom Lens: 🤍 Audio Recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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

How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)

2800528
57348
1042
00:13:34
28.11.2019

Join 300,000+ professionals in our courses: 🤍 Excel XLOOKUP will soon become the ONLY Excel LOOKUP Function you’ll ever need to solve any lookup problem you come across. If you'd like to learn about the other brand new Excel functions like FILTER & UNIQUE check out the complete course: 🤍 In this video we cover 5 common Excel lookup problems: 1. Lookup returns an error (#NA) - This is a common problem with VLOOKUP. If the VLOOKUP function returns #NA it is likely because the item you're looking up does not exist on the lookup table. The solution so far has been to wrap the VLOOKUP function inside IFNA or IFERROR functions. With XLOOKUP however, you no longer need to do that. You just need to use the 4th argument of XLOOKUP [If_not_found] optional argument and specify the value you'd like to get back if the value does not exist on the lookup array. 2. Horizontal lookup - In legacy Excel when we needed to lookup a value in a table that was structured horizontally instead of vertically we would use the HLOOKUP function. The new XLOOkUP function can do horizontal lookups as well. You just have to select the horizontal array instead of the vertical array. 3. Look for a partial match instead of an exact match in Excel: There might be times you need to look for a partial match. In this case you can combine wildcards such as the asterisk or question mark characters and combine them together with the 5th argument of XLOOKUP which is the optional [match mode] argument. 4. Two way Excel lookup: To look up a value on the rows as well as columns we generally combined VLOOKUP with Excel Match function or used the famous INDEX & MATCH functions. We no longer need to use two separate functions to do a two way lookup. We can use XLOOKUP inside another XLOOKUP to get the job done. The advantage is we just need to know one function well, instead of combining different Excel lookup functions with one another. 5. Excel approximate match lookup: There are times you'd like to look for a value inside a data table and return the closest match. This is specially used for cases where you have thresholds for example for bonus schemes. If a number falls between a specific threshold you'd like to return a corresponding value. This is where you can use XLOOKUP's 5th argument [match mode] to look for "exact match or next smaller item" or "exact match or next larger item". 00:00 What is Excel's New XLOOKUP Function 01:15 Lookup Value Not Found with XLOOKUP 04:06 Horizontal Lookup with XLOOKUP in Excel 05:44 Look For Partial Match with XLOOKUP 07:51 Two-Way Lookup with XLOOKUP 10:29 Approximate Match with XLOOKUP * AVAILABILITY * The XLOOKUP function is available to Office 365 and 2021 users. ⯆ DOWNLOAD the workbook here: 🤍 LINKS to related videos - First XLOOKUP video: 🤍 Excel left lookup with XLOOKUP: 🤍 ★ My Online Excel Courses ► 🤍 ✉ Subscribe & get my TOP 10 Excel formulas e-book for free 🤍 EXCEL RESOURCES I Recommend: 🤍 Get Office 365: 🤍 Microsoft Surface: 🤍 GEAR Screen recorder: 🤍 Main Camera: 🤍 Backup Camera: 🤍 Main Lens: 🤍 Zoom Lens: 🤍 Audio Recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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 Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)

2777565
43517
1228
00:13:22
18.06.2020

Join 300,000+ professionals in our courses: 🤍 Discover hidden productivity tips when working with Excel Pivot Tables. At first Pivot Tables might seem like a complex tool but they are one of Excel's EASIEST features to work with. They help you summarize data really FAST. ★ My Online Excel Courses ► 🤍 In this video I'll show you in about 10 minutes, how simple it is to create a pivot table and get quick insights into your data. I'll also throw in some Excel Pivot Table tips and tricks not everyone is aware of. To top it off we'll also add Pivot Slicers to get a professional visual to apply filters to our Pivot Table. ★ Get the Official XelPlus MERCH: 🤍 ⯆ DOWNLOAD the workbook so you can practice with this Pivot Table example data (scroll down to the bottom of the post): 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 Timestamps 00:00 Why use Excel Pivot Tables? 01:35 Convert Data to Excel Tables 02:46 Create Pivot Table 04:08 Change aggregation in Pivot Table to average or count 04:40 Adjust number format in Pivot Table 05:10 Add filter to Pivot Table 05:28 Add column fields to Pivot Table 05:50 Removing Grand Totals and Sub Totals in Pivot Table 06:27 Update Pivot Table layout and design 07:14 How to bring back Pivot Table Fields dialog box 07:42 Update Pivot Table column header without errors (pivot table field name not valid) 08:33 Sort values in Pivot Table 08:41 Lock column width on Pivot Table refresh 09:00 Add Value as percentage of grand total in Pivot Table 10:22 Add Pivot Table Slicers to Filter Data 11:10 Connect Slicer to multiple Pivot Tables 11:50 Refresh Pivot Tables 12:40 Benefits of Pivot Tables EXCEL RESOURCES I Recommend: 🤍 GEAR I use: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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

How to Use Microsoft Power BI | Create Your First Dashboard Now (Practice Files included)

926125
16588
639
00:23:03
16.12.2021

*Get Access to the NEW Power BI course: 🤍 Learn how to use Microsoft Power BI and created impressive dashboards. Power BI is so easy to use, but it can seem quite complex and confusing to learn. The best way for you to get started with Power BI is to download the files from the description of this video and then follow along with me. I promise after this session you will love the Power BI environment. We'll add time intelligence like YOY % calculation and YTD calculations - All in just 20 minutes and without writing a single DAX function! Power BI can feel overwhelming because it has so many different components. That's why I'll take you step by step and you can follow along with me by downloading my practice files. By the end of the video, you'll have created your first interactive Power BI dashboard which we'll publish to the web. I'll also show you how you can share your Power BI reports with others and how you can add your report as a separate tab in Microsoft Teams. 00:00 How to use Microsoft Power BI - Tutorial for Beginners 00:30 Download and Install 00:55 Welcome Screen 01:26 Import Data to Your Report 02:24 Transform Data from Text/CSV Using Power Query Editor 05:11 Transform Data from Excel Workbook Using Power Query Editor 08:40 Join Tables with Relationships 10:34 Insert Chart with Slicer 14:03 Insert Tables with Quick Measures 17:24 Insert Map Chart 18:29 Insert Line Chart 18:57 Add KPI Chart to Dashboard 20:17 Save and Publish Report on Web 21:15 Share Report with Others 22:05 Wrap Up 🌍 My Online Excel Courses ► 🤍 ⯆ DOWNLOAD the Files from this post⯆ (either right below the video, or scroll all the way to the bottom of the post): 🤍 🎬 LINKS to related videos: - Excel Productivity for Lazy (but Smart) People: 🤍 - How Power Query Will Change the Way You Use Excel: 🤍 🎒 Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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! #powerbi

Excel shortcut keys you SHOULD know!

1940280
50533
1555
00:08:48
11.04.2019

The first 500 people to sign up via my link will get two FREE months of Skillshare Premium: 🤍 In this tutorial you learn the most useful Excel shortcuts to be able to work faster in Excel. There are many hidden features in Excel that are easily accessible with shortcut keys (you might learn some new features too - check out the bonus tip) ★ Get the Official XelPlus MERCH: 🤍 Timestamps 00:00 Intro 00:13 Add / remove Excel Filter 00:40 Create an Excel Table 01:10 Navigate in Large Data Sets 01:27 Select a Range of Cells 01:55 Format Cells in Excel 02:09 Auto Sum 02:40 Paste as Values 03:11 Add a New Line Inside a Cell 03:31 Select All Data in Current Region 03:41 Insert Default Chart 03:48 Excel Flash Fill 04:23 Select Entire Row/Column 04:33 Insert a New Row/Column 05:09 Delete a Row/Column 05:24 Move a Cell/Row 05:54 Hide Column/Row 06:04 Check for Hidden Cells 06:27 Insert Time Stamp 06:43 Find Cells Without Formulas (Constants) ⯆ DOWNLOAD the list of shortcuts here: 🤍 (It will take you to the blog post. Scroll all the way down to download) ★ My Online Excel Courses ► 🤍 ✉ Subscribe & get my TOP 10 Excel formulas e-book for free 🤍 EXCEL RESOURCES I Recommend: 🤍 GEAR I use: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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 SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria)

1587503
15756
1127
00:14:04
10.02.2017

Join 300,000+ professionals in our courses: 🤍 Quickly learn how SUMIFS & COUNTIFS formulas work - and why they are better than SUMIF & COUNTIF formulas. ★ Get the full course: 🤍 The inclusion of the "IFS" formulas since Excel 2007 was a major gain for Excel users. Why? Because they allow you to easily add exceptions to your sum, average and count calculations. Don’t make your life more difficult by trying to use excel filters to get your sum. Use the SUMIFS formula instead. You can SUM based on multiple criteria. You can also use SUMIFS to sum if numbers are greater than a certain value. ★ Get the Official XelPlus MERCH: 🤍 Timestamps: 00:00 Why use Excel SUMIFS instead of SUMIF 01:20 Excel SUMIF function 03:10 Excel SUMIFS function 06:06 SUMIFS with wildcards 06:47 SUMIFS with comparison operators 09:17 Excel AVERAGIFS function 09:43 Excel COUNTIF function 10:19 Excel COUNTIFS function 11:50 How to use Excel Tables for dynamic referencing 13:31 Wrap Up ⯆ Download the workbook here: 🤍 In this video I will show you a SUMIFS example and explanation. AVERAGEIFS works in the same way. COUNTIFS function is shorter than SUMIFS and AVERAGEIFS because it doesn’t need the additional sum range. It only needs the criteria range. It counts the number of times the criteria is met. Not sure if you should use SUMIF or SUMIFS? Stick to SUMIFS. This way you're on the safe side. In case you ever need to add more criteria, you can just expand on the arguments inside the formula. If you used SUMIF, you actually have to replace it with SUMIFS. ★ My Online Excel Courses ► 🤍 ✉ Subscribe & get my TOP 10 Excel formulas e-book for free 🤍 EXCEL RESOURCES I Recommend: 🤍 GEAR I use: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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

How to Find Cells Where the Formula Was Overwritten in Excel #shorts

171311
6594
115
00:00:45
05.12.2021

It happens all the time that someone accidentally has overwritten a formula with a hard-coded value. It can take a long time to spot errors like that. Fortunately, there is a great feature in Microsoft Excel and I'll show you a super easy way to find these cells in Excel. 🌍 My Online Excel Courses ► 🤍 🎬 LINK to more YouTube Shorts videos: 🤍 🎒 Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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

Do NOT Shut Down Your Computer! (here's why)

2678312
91424
3518
00:05:05
07.07.2022

Join 300,000+ professionals in our courses: 🤍 We've all seen the buttons for Shut down and Restart in Windows. But have you ever wondered what is the difference between a "shut down" and a "restart"? Or why a Windows PC boots up really fast from a shutdown but takes longer after a restart? I'll tell you why in this video. 00:00 Why Shut Down Doesn't Actually Shut Down Your Computer 02:46 How to Turn Off Fast Startup 🎬 LINKS to related videos: FREE Windows Apps You Should be Using: 🤍 Windows 11 Settings You Should Change NOW!: 🤍 🌍 My Online Courses ► 🤍 👕☕ Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 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! #windows #windows10 #windows11

Excel Tutorial for Beginners | Excel Made Easy

1274686
25911
552
00:15:54
04.02.2021

Join 300,000+ professionals in our courses: 🤍 Learn the basics of using Microsoft Excel. How a spreadsheet is setup, and how you can enter data in Excel. Learn useful Excel shortcuts. Understand how the menu bar (the Excel Ribbon) works and where to find different features. Learn formatting in Excel to display your data better. This basic tutorial is for all versions of Excel (Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Office 365). Looking for more Excel basics videos? Check out this playlist: 🤍 Time Stamps 00:00 Learn the Basics of Microsoft Excel 00:27 Anatomy of a spreadsheet in Microsoft Excel 01:20 What is a Cell in Microsoft Excel 03:50 What is a Range in Microsoft Excel 04:41 Excel Cursor and Mouse Pointer Shapes 05:48 How to Change Size of Rows and Columns in Excel 07:26 How to Use the Ribbon in Microsoft Excel 09:25 How to Enter Data in Microsoft Excel 11:47 How to Format Data in Microsoft Excel * Complete Excel Essentials course for beginners: 🤍 ⯆ The full article to Excel for beginners: 🤍 ★ My Online Excel Courses ► 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 EXCEL RESOURCES I Recommend: 🤍 Get Microsoft 365: 🤍 Microsoft Surface: 🤍 GEAR Screen recorder: 🤍 Main Camera: 🤍 Backup Camera: 🤍 Main Lens: 🤍 Zoom Lens: 🤍 Audio Recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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

How to Create & Use Excel Macros (Real world example)

1347689
24938
550
00:10:09
01.04.2021

Complete Course: 🤍 In this video you'll learn the basics of Macros and VBA in Excel. Plus you learn all of this in 10 minutes! Macros allow you to automate repetitive tasks in Excel. I'll show you how to to enable the Developer Tab, which allows you to record and run macros. We'll do an example on how to automatically create and format an Excel chart based on a dataset. This dataset has different ranges so we want to record the macro in such a way that its dynamic depending on the size of the data. You'll learn to avoid a common mistake when referencing ranges in Excel. Instead of hardcoding a certain data range with excel macros we'll use dynamic cell referencing. I'll show you what the macro recorder can record and which actions you have to add yourself to the visual basic editor. I'll add an example by using the IF statement in VBA and also referencing a range for the chart title. Learn how to save your spreadsheet so you can access your Excel macros again in the future. ★ My Online Excel Courses ► 🤍 00:00 Excel Macro Tutorial for Beginners 01:12 How to Record a Macro in Excel 06:36 How to Manually Adjust Code in Visual Basic Editor 07:33 Add IF Condition to Avoid Errors 09:10 How to Save Excel Workbook With Macro 09:34 Wrap Up ⯆ DOWNLOAD the sample workbook here: 🤍 LINKS to related videos: ► Relative Referencing - Copy Data from one Sheet to Another: 🤍 Check out the FULL VBA Playlist: 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 EXCEL RESOURCES I Recommend: 🤍 Get Microsoft 365: 🤍 Microsoft Surface: 🤍 GEAR Screen recorder: 🤍 Main Camera: 🤍 Backup Camera: 🤍 Main Lens: 🤍 Zoom Lens: 🤍 Audio Recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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

Return Multiple Match Results in Excel (2 methods)

1594406
20552
1119
00:14:13
30.08.2018

Join 300,000+ professionals in our courses: 🤍 Quickly learn how to lookup one value in Excel and return multiple matches. VLOOKUP and INDEX & MATCH formulas always return the first match they find inside a data table. What if you wanted to return multiple matches? I'll show you two different methods: ★ Get the Official XelPlus MERCH: 🤍 00:00 How to Find Multiple Match Results in Excel 01:10 How to Use INDEX & AGGREGATE to Find Multiple Matches in Excel 11:12 How to Use TEXTJOIN to Find Multiple Matches in Excel 13:36 Wrap Up - Method 1: Uses INDEX & AGGREGATE formulas. This doesn't require CSE (control shift enter) and it works on older Excel versions. - Method 2: Uses the relatively new TEXTJOIN formula (available in Excel Office 365, Excel 2019) and requires CSE. Pick the method you find easier to maintain. 🡻 Download the workbook here: 🤍 ★ Links to related videos: ★ VLOOKUP basics: 🤍 INDEX MATCH basics: 🤍 Get Unique List: 🤍 TEXTJOIN: 🤍 ★ My Online Excel Courses ► 🤍 ✉ Subscribe & get my Excel top 10 tips and formulas e-book for free 🤍 EXCEL RESOURCES I Recommend: 🤍 GEAR I use: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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

Master Excel's SUMPRODUCT Formula

616860
10084
705
00:14:56
13.04.2016

Quickly learn how Excel's SUMPRODUCT formulas works. Download the workbook: 🤍 Get the full course: 🤍 Advanced Excel: Master Excel's SUMPRODUCT Formula This video is part of a series that belongs to my Advanced Training course called "Advanced Excel: Top tips and formulas". The classical use of Excel's SUMPRODUCT function is to do a sum of multiplications. The good thing about SUMPRODUCT is that it can work on arrays of values and it doesn’t have to be entered as an array function so no need to do control + shift + enter (CSE). The great thing about SUMPRODUCT, is that it can help solve many more problems in non-obvious ways. It can act as a conditional SUMIFS function or work as a lookup function as INDEX and MATCH does. It can also act as a COUNTIF function. SUMPRODUCT is also a better SUMIFS, because it can check for OR conditions - which the SUMIFS can't. SUMIFS can only check for AND conditions. In this video you will see different examples of the SUMPRODUCT function and you will learn how it can save you from unnecessary "workarounds" in your Excel files. It will also show you the SUMPRODUCT formula in slow motion. ★ My Online Excel Courses ► 🤍 ✉ Subscribe & get my TOP 10 Excel formulas e-book for free 🤍 EXCEL RESOURCES I Recommend: 🤍 Get Office 365: 🤍 Microsoft Surface: 🤍 GEAR Camera: 🤍 Screen recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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

Fill Data AUTOMATICALLY With Your Own CUSTOM LIST #shorts

80773
3733
43
00:01:00
16.10.2022

Join 300,000+ professionals in our courses: 🤍 A little-known but super-helpful feature are custom lists. If you create a custom list in Microsoft Excel, you can easily auto-fill a series with your own list of departments, clients, cities, etc. This not only saves time but also reduces errors. 🌍 My Online Excel Courses ► 🤍 🎬 LINK to more YouTube Shorts videos: 🤍 👕☕ Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 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! #Excel

Excel Waterfall Promo: Ultimate Excel Waterfall Chart Course on XelPlus

25591
125
8
00:02:29
27.10.2016

For the complete course click here: 🤍 Excel Waterfall Chart Tutorials show you how to design any Waterfall Chart in Excel - In ANY version of Excel too. Ultimate Excel Waterfall Chart course summary: A waterfall or a bridge chart is a way of visualizing data that explains the movement from one balance to another balance. They are common in corporate reports – because they help to easily visualize the factors that are responsible for the change – for example how you got from gross sales to net income or how your profit developed from last year to this year. But they are also a good story teller for non-financial data. In this course you will learn to create different impressive variations of the waterfall from scratch. By the end of this course, you will be able to create your own customized variation of the waterfall chart which you can include in your corporate reports. You’re also going to learn a handful of useful tricks which you can use to create other amazing charts. Your colleagues and management will certainly be impressed. Here is an overview of the topics covered: - Shortcomings of Excel 2016 in-built Waterfall Chart - How to create the easiest Waterfall Chart EVER – (No stacked columns - works with negative values as well) - How to add sub-totals to the waterfall chart - Real business examples of Waterfall charts - How to overcome real-world issues such as - Long category labels on the horizontal axis - Adding dynamic connectors to improve readability - How to deal with very small delta values - Vertical Waterfall chart (bar version of the Waterfall) and creating them in impressive ways - Over 4 hours of Waterfall variations - Workbook included and Cheat sheets to be uploaded soon In this training I’m going to cover different alternatives for creating the waterfall chart. One alternative is obviously the new Excel 2016 standard waterfall, but as we dig deeper we will come across many limitations which will lead us to create it from scratch. That’s why you can take this course, no matter which Excel version you have. The target audience for this course is anyone who is interested in creating different variations of the waterfall in Excel. You might be a controller, financial analyst, someone responsible for creating corporate reports or you might just be interested to improve your Excel charting skills and want to learn advanced tricks to create impressive graphs. Other related videos: 🤍 🤍 🤍 Other Chart videos: 🤍 🤍 🤍 🤍 🤍

SUPER EASY Excel Data Entry Form (NO VBA)

1792634
50855
1824
00:06:22
06.06.2019

Join 300,000+ professionals in our courses: 🤍 Learn to quickly create an Excel data entry form to your tables. This is the easiest form to create in Excel! No VBA or macros are required. You will also learn how you can activate the data entry form on existing tables - how you can add data validation to your forms and also how you can search for criteria using the Excel forms. One great advantage of using forms on larger tables is the ability to search for records using wildcards. You have the ability to search for a category and view the entire line of data in one place. You can also easily navigate and update information with an Excel data form. ★ Get the Official XelPlus MERCH: 🤍 Timestamps: 00:00 How to Create Simple Data Entry Forms in Microsoft Excel 00:56 Turn Data into an Excel Table 01:25 Add Data Entry Form to Quick Access Toolbar 02:04 How to Use Data Entry Form 03:50 Add Data Validation to Data Entry Form 05:05 Use Data Entry Form to Search Records 05:50 Wrap Up ⯆ Link to detailed article: 🤍 LINKS to my Excel Basics Playlist: ★ My Online Excel Courses ► 🤍 ✉ Subscribe & get my TOP 10 Excel formulas e-book for free 🤍 EXCEL RESOURCES I Recommend: 🤍 GEAR I use: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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

How to Color Code Drop-Down Lists in Google Sheets #shorts

24876
1141
19
00:01:00
29.01.2023

Join 300,000+ professionals in our courses: 🤍 Learn how to create modern, colorful, chip-style looking drop down lists in Google Sheets. Drop-down lists are a great way to simplify data entry by using data validation. You can limit the input to predefined options with different colors. This not only makes it easier to input data but also eliminates spelling errors or the entry of non-existent options. 🌍 My Online Excel Courses ► 🤍 🎬 LINK to more YouTube Shorts videos: 🤍 👕☕ Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 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! #googlesheets

How To Use the new Excel TEXTBEFORE & TEXTAFTER Functions to Save Time on Your Next Project

117812
4706
238
00:07:38
20.10.2022

Join 300,000+ professionals in our courses: 🤍 Extracting certain parts of a text in a cell in Excel wasn't easy. Microsoft recently updated the new TEXTBEFORE and TEXTAFTER functions to make them even more useful. If you need to extract text that occurs before or after a given character or string - this is your solution! I also show you an Excel trick you can use to avoid needing to use nested functions to extract the last delimiter. These new functions also got an update and have more optional arguments you can use. I'll show you how to that in the video. 🌍 My Online Courses ► 🤍 00:00 Extract Text - Split Names in Excel 01:18 TEXTBEFORE 03:53 Bonus Trick 05:36 TEXTAFTER 07:03 Wrap Up ⯆ DOWNLOAD the workbook here (scroll to the bottom of the blog post): 🤍 🎬 LINKS to related videos: - New Excel TEXTSPLIT Function to Separate words with Ease: 🤍 - Breaking News! We FINALLY get the Excel functions we've been Wanting: 🤍 👕☕ Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 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! #Excel

Create a custom, seamless repeating pattern in Photoshop

10737
285
4
00:00:36
22.01.2023

Join 300,000+ professionals in our courses: 🤍 Learn to create a custom, seamless repeating pattern in Photoshop. 🌍 My Online Excel Courses ► 🤍 🎬 LINK to more YouTube Shorts videos: 🤍 👕☕ Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 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! #adobephotoshop

Excel DGET Function Solves 2 of Your VLOOKUP Problems

813920
14234
398
00:11:18
16.01.2020

Join 300,000+ professionals in our courses: 🤍 Excel DGET Function is one of Excel's "forgotten" database functions that can do a Left lookup (unlike VLOOKUP) and ALSO easily look for multiple criteria. ★ My Online Excel Courses ► 🤍 One limitation of DGET is that you can't apply it to multiple cells. Basically you can't pull down the formula to lookup different values. If that's something you need, then you'll need to use INDEX MATCH, VLOOKUP, Excel FILTER function or FILTER feature or XLOOKUP. Check out the links under Related Videos below to find these videos. ★ Get the Official XelPlus MERCH: 🤍 00:00 Excel DGET Function 01:44 Excel DGET Explained 06:03 DGET With Approximate Match 06:28 DGET With OR & AND Conditions 08:18 DGET With Multiple Criteria DGET can lookup values to the left and act like an automatic filter. Excel DGET disadvantages: 1. DGET formula can't be pulled down - you'll need to include the header for each lookup value 2. DGET returns an error (#Num error - 7:25) if there are duplicate lookup values in the range (as opposed to VLOOKUP or Index & Match which return the first match). ⯆ DOWNLOAD the workbook at the bottom of the blog post here: 🤍 Related Videos - Excel Index Match basics: 🤍 Excel VLOOKUP explained: 🤍 Excel XLOOKUP: 🤍 Excel FILTER function: 🤍 Check out the complete Excel Lookup Formula Playlist: 🤍 ★ My Online Excel Courses ► 🤍 ✉ Subscribe & get my TOP 10 Excel formulas e-book for free 🤍 EXCEL RESOURCES I Recommend: 🤍 GEAR I use: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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 Features You NEED to KNOW (If you work in Accounting)

372941
10816
344
00:16:36
11.03.2021

Get Access to My Course "Fundamentals of Financial Analysis" HERE: 🤍 In this video we'll cover the top Excel Features that you should know if you work in accounting. They'll make your work life a LOT easier and they work in most Excel versions. All are great for accountants, auditors, data analysts and anyone else who'd like to use Excel more efficiently. If you have a small business and you are busy with bookkeeping for your small business, this tutorial will help you. Some of these great features include Go To Special in Excel. With Go to Special you can quickly find cells of specific type. For example blank cells. Or cells with formulas or constants. You'll also learn how to automatically add subtotals by using the Group option in Excel to add groupings and levels to your data. I also include number formatting shortcuts in Excel, like shortcut for date format, currency and more. You'll learn how to remove duplicates in your data and use conditional formatting on your data. We'll create drop-down lists with data validation and you'll learn how to create and use Pivot Tables to analyze your data. Lots to cover. The timestamps are below. Timestamps: 00:00 Top Excel Features For Accountants 00:21 Quickly Identify Cells with Go To Special 01:56 Automatically Add Subtotals in Excel 03:45 Shortcuts for Number Formatting in Excel 04:53 Trace Precedents and Dependents in Excel Formulas 06:38 Use Conditional Formatting to Visualize Your Data in Excel 08:12 How to Remove Duplicates in Excel 09:01 Use Flash Fill to Automatically Fill in Values 10:08 Quickly Filter Your Data with AutoFilter in Excel 11:19 Create Drop Down Lists in Excel with Data Validation 13:15 Easily Analyze Your Accounting Data with Pivot Tables 15:59 Wrap Up Top 10 Excel Functions for Accountants: 🤍 Link to more accounting videos: 🤍 Complete article: 🤍 ★ My Online Excel Courses ► 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 EXCEL RESOURCES I Recommend: 🤍 Get Microsoft 365: 🤍 Microsoft Surface: 🤍 GEAR Screen recorder: 🤍 Main Camera: 🤍 Backup Camera: 🤍 Main Lens: 🤍 Zoom Lens: 🤍 Audio Recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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 #accounting

6 FREE Add-Ins for Excel to Start Using Now

817913
20641
559
00:15:52
27.08.2020

Check out AlchemyJ: 🤍 In this video we'll cover the Best 6 FREE Excel Add-Ins. They will improve your reporting, data analysis and make your life a LOT easier. QR4Office - Easily Create QR Codes in Excel Web Video Player - Embed YouTube videos directly in Excel (or PowerPoint) Visio Data Visualizer - Create Dynamic Flowcharts and OrgCharts without Shapes or SmartArt People Graph - Easily Create an Infographic out of your dataset Mini Calendar/Date Picker - Select Dates from a Calendar Bing Maps - Plot Locations and Visualize your Data ★ My Online Excel Courses ► 🤍 00:00 Best FREE Excel Add-Ins 00:55 How to Install Add-Ins in Excel 01:45 QR4Office 02:47 Web Video Player 03:41 Visio Data Visualizer 07:16 People Graph 09:14 Mini Calendar and Date Picker 10:49 Bing Maps 13:08 Sponsor AlchemyJ ⯆ DOWNLOAD the workbook here: 🤍 More Excel Tips and Tricks: 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 EXCEL RESOURCES I Recommend: 🤍 Get Microsoft 365: 🤍 Microsoft Surface: 🤍 GEAR Screen recorder: 🤍 Main Camera: 🤍 Backup Camera: 🤍 Main Lens: 🤍 Zoom Lens: 🤍 Audio Recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 Thanks to AlchemyJ for sponsoring this video! 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

Web Scraping Made EASY With Power Automate Desktop - For FREE & ZERO Coding

904307
22501
734
00:13:11
10.02.2022

Join 300,000+ professionals in our courses: 🤍 Power Automate Desktop is a Windows desktop tool that allows the designing, creation, and running of automated processes. Accessible for free to anybody. It has recording abilities like a macro recorder — you can just record your steps and run it. With Robotic Process Automation (RPA) you can build bots and automate repetitive tasks in a user-friendly drag and drop environment without coding knowledge. In this video I'll show you how you can use Power Automate Desktop to perform web scraping without any coding. 🌍 My Online Excel Courses ► 🤍 00:00 How to Use Power Automate Desktop 02:28 Create a Flow 04:22 Browser Automation 06:50 Use Recorder to Create Flow Actions 09:20 Store Extracted Data in Excel Spreadsheet 10:42 Run Flow for Web Scraping 12:28 Wrap Up 🎬 LINKS to more Power Automate videos: 🤍 🎒 Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 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! #powerautomate #powerautomatedesktop

How to Calculate Hours Worked in Excel #shorts

113480
4241
88
00:00:56
09.01.2022

In this video I'll show you how you can calculate work hours between dates and times. You'll learn how to format the result to represent total hours even if shifts are longer than 24 hours. 🌍 My Online Excel Courses ► 🤍 🎬 LINK to more YouTube Shorts videos: 🤍 🎒 Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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 What-If Analysis Data Table | Easy to Use Once you Learn This☝️

218891
7028
214
00:08:42
01.12.2022

Join 300,000+ professionals in our courses: 🤍 Use an Excel Data Table What-if Analysis to quickly create multiple results based on a formula you already have. The data table in Excel will allow you to change values in some cells and come up with different answers to the problem. This is what Microsoft Excel's What-if Analysis Data Table does best - it allows you to experiment with different input variables. A Data Table allows you to see how different input values would impact the result at one glance. It's quite a hidden Excel tip and trick. Data Tables can be confusing at first, but this tutorial explains it in simple English and in a way, you will never forget how to use this feature again. In this example we’ll create a retirement savings plan. You'll calculate how much money you will have after saving a specific amount of money per month over a number of years. Our inputs for the calculation are the monthly payments, the number of years we're paying into the retirement fund, and the interest rate earned. We’ll use a Data Table in Excel to explore what happens to the future value of the fund if the interest rate or years changes. Data tables recalculate every time you make changes in the workbook. There is a setting you can tweak to stop data tables from calculating. Go to Formulas / Calculation Options / Automatic Except Data Tables. You can toggle this option on or off depending on your needs. 00:00 What-If Analysis in Excel - Most Simple Explanation 00:16 Data Table - 1 Variable 04:47 Bonus Trick: Custom Formatting as icon 05:55 Data Table - 2 Variables 08:07 Wrap Up 🌍 My Online Courses ► 🤍 ⯆ DOWNLOAD the workbook here: 🤍 🎬 LINKS to related videos: - Excel Goal Seek Explained in Simple Steps: 🤍 - Excel Solver - Example and Step-By-Step Explanation: 🤍 👕☕ Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 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! #excel

5 Mind-Blowing FREE Windows Apps (you probably didn't know existed)

233962
9201
321
00:09:50
21.07.2022

Join 300,000+ professionals in our courses: 🤍 This video is not sponsored or endorsed by any of the apps I mention. These are 5 great Windows Apps & Software that are free of cost. Everything from an antispy tool to improve your privacy, an app to capture or record any area of your screen (much better than Windows snipping tool), a free VPN service, a video transcoder to easily compress video files, and a fun tool to listen to and record internet radio stations. 5 useful Windows apps every Windows user needs. 🌍 My Online Courses ► 🤍 00:00 FREE Windows Apps You Should be Using 00:11 Antispy Tool: O&O ShutUp10 02:07 Screenshot and Screencast: ShareX 04:00 VPN: PrivadoVPN 05:07 Video Transcoder: HandBrake 06:49 Record Internet Radio: streamWriter 09:08 Wrap Up ⯆ DOWNLOAD the free apps here: O&O ShutUp10: 🤍 ShareX: 🤍 PrivadoVPN: 🤍 HandBrake: 🤍 streamWriter: 🤍 👕☕ Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 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! #windows #windows10 #windows11

🖼️ NEW! Insert Images INSIDE Cells with Excel IMAGE Function #shorts

72514
3037
70
00:00:56
28.08.2022

Join 300,000+ professionals in our courses: 🤍 Finally we get the Excel IMAGE Function where we're able to insert images from the web in Excel cells! Your images can now be part of the worksheet, instead of floating on top. You can move and resize cells, sort and filter, and work with images within an Excel table. Availability: This feature is currently in Office 365 Insider Beta Channel 🌍 My Online Excel Courses ► 🤍 🎬 LINK to more YouTube Shorts videos: 🤍 👕☕ Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 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! #Excel #exceltips

How To Import & Clean Messy Accounting Data in Excel | Use Power Query to Import SAP Data

418914
10168
365
00:20:38
04.03.2021

Get Access to My Course "Fundamentals of Financial Analysis" HERE: 🤍 In this Excel for Accounting tutorial you'll learn how to use Power Query to import messy SAP data extracts into Excel. Importing data from ERP systems like SAP or Oracle into Excel can be a pain. The data is usually very messy. You need to clean and organize the data to be able to use it in Excel reports. In this tutorial I'll show you 2 practical examples on how you can use Excel Power Query or Get and Transform in Excel to do the work for you. We also create an Excel Pivot Table to analyze the imported data. The great thing with Power Query is that the import is automatic. It's like a macro. Every time we get a new SAP data extract, we just have to refresh our Excel table and all the steps to organize the data will be automatically applied. Time Stamps 00:00 Data Cleaning with Excel for Accountants 00:40 How to Import SAP Data in Excel with Power Query 15:43 How to Create a Pivot Table from Messy Excel Data 20:02 Wrap Up LINK to more Accounting tutorials: 🤍 ★ My Online Excel Courses ► 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 EXCEL RESOURCES I Recommend: 🤍 Get Microsoft 365: 🤍 Microsoft Surface: 🤍 GEAR Screen recorder: 🤍 Main Camera: 🤍 Backup Camera: 🤍 Main Lens: 🤍 Zoom Lens: 🤍 Audio Recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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 #accounting #sap

How Power Query Will Change the Way You Use Excel

1446982
21560
961
00:09:02
25.06.2020

Complete Excel Power Query course: 🤍 * Note: On XelPlus you will get additional bonuses that are not available on other platforms. Check the course landing page for more info. Power Query is like an Instant Miracle Cure to your difficult data analysis problems. ★ Get the Official XelPlus MERCH: 🤍 Here's the problem... Excel Power Query has been a part of Excel since Excel 2016! It's in the Data tab under Get and Transform. Unfortunately many people haven't explored what it has to offer! They continue doing things the old "manual" way, Or the "complex" way with difficult formulas. And something else you may not know ... Generally, when you learn something, the more effort you put in, the more you get out. But it's NOT the same with learning Power Query! If you just put in a little effort, you get SO much in return! This is the difference with learning Power Query to learning other skills like VBA. And that’s why I created this course! To give you the tools to really make a difference at your workplace. I’m going to take you from Power Query Beginner to Pro! Check out the full article: 🤍 ★ My Online Excel Courses ► 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 EXCEL RESOURCES I Recommend: 🤍 GEAR I use: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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 #powerquery

The BEST Windows Shortcut You're NOT Using #shorts

130473
6195
203
00:00:43
20.06.2021

In this #shorts video you'll learn how to Copy & Paste the RIGHT way. I'll show you how you can use the clipboard history in Windows. Forget Ctrl + V! Instead use Win + V. This way you can copy & paste multiple items with ease and you'll never lose any copied item anymore! LINK to more YouTube Shorts videos: 🤍 ★★★ My Online Excel Courses ► 🤍 ★ Get the Official XelPlus MERCH: 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 EXCEL RESOURCES I Recommend: 🤍 GEAR I use: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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 #windows10 #Office365 #shorts

Should YOU Learn Google Sheets?

53208
1499
186
00:06:25
13.10.2020

Join My Google Sheets Comprehensive Masterclass HERE: 🤍 * Additional Bonuses are ONLY available on XelPlus. Check the course landing page for more info. Why Learn Google Sheets? In 2020 online collaboration became a part of our daily work. Corporations want spreadsheet applications like Google Sheets to help them collaborate in real-time with ease. On the job market there is more demand for Google Sheets professionals. In the past it was only Excel. Knowing one spreadsheet application is not enough if we want to be successful in these changing times. And something else you may not know … You can apply MOST of the knowledge you learn in this Sheets course to Microsoft Excel as well! There are many helpful and time-saving Sheets formulas and features. We tend to forget what these are if we don't use them. This course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time. ★ My Online Excel Courses ► 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 EXCEL RESOURCES I Recommend: 🤍 Get Microsoft 365: 🤍 Microsoft Surface: 🤍 GEAR Screen recorder: 🤍 Main Camera: 🤍 Backup Camera: 🤍 Main Lens: 🤍 Zoom Lens: 🤍 Audio Recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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! #googlesheets

TOP Excel Shortcuts for MAC #shorts

36024
1030
23
00:00:59
03.07.2022

Check out my top Excel Shortcuts for Mac. These mac shortcuts will help you get things done faster in Microsoft Excel for Mac. You'll be able to significantly improve your productivity. 🌍 My Online Excel Courses ► 🤍 🎬 LINK to more YouTube Shorts videos: 🤍 👕☕ Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 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! #excel #shorts

Create QR Codes for FREE | Use Anywhere (Excel, Word & PowerPoint)

867732
13263
565
00:06:53
01.12.2020

Create Beautiful Charts in PowerPoint without the hassle with think-cell: 🤍 In this tutorial you'll learn how you can easily create custom QR codes for free. I'll show you how you can then use the QR codes in Microsoft Word, Excel and PowerPoint. Feel free to grab your copy of the free Google Sheet QR code generator (link is below). All you need to do is add your URL to the cell and get your QR code. You can then copy the QR code and paste it in any application you want, including any Microsoft 365 Office application. This way you can easily create a custom QR code for your website, video links, surveys etc. If you're interested to find out how the QR function works in Google Sheets continue watching the video. I'll explain how it's setup. This way you can create your bulk QR codes with different settings and resolutions whenever you want. Time Stamps 00:00 How to Create QR Codes for free 01:39 How to Open a New Google Sheet 02:12 Syntax for Google Sheets IMAGE Function to Create QR Codes 05:17 Create Bulk QR Codes in Google Sheets ⯆ Get your own copy of the Google Sheet QR code generator: 🤍 Google Developers QR code link: 🤍 Windows tips & tricks video: 🤍 Create QR code in Excel with a free add-in - watch the video: 🤍 Google Sheets Playlist: 🤍 Link to full article: 🤍 ★ My Online Excel Courses ► 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 EXCEL RESOURCES I Recommend: 🤍 Get Microsoft 365: 🤍 Microsoft Surface: 🤍 GEAR Screen recorder: 🤍 Main Camera: 🤍 Backup Camera: 🤍 Main Lens: 🤍 Zoom Lens: 🤍 Audio Recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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!

2 Simple Ways to Remove Duplicates | Create List of Unique Values in Excel #shorts

108917
6445
60
00:00:50
12.06.2022

Join 300,000+ professionals in our courses: 🤍 In this #shorts you'll learn 2 easy ways to remove duplicates or create a unique list of values in Microsoft Excel. 🎬 LINK to more YouTube Shorts videos: 🤍 🎒 Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 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! #Excel #shorts

How to Create a Dynamic REPEATED Numbered List in Excel #shorts

60147
1992
32
00:01:00
21.08.2022

Join 300,000+ professionals in our courses: 🤍 In this #shorts you'll learn a super easy way to create a dynamic repeated number list in Excel with a single function. This is not possible by just dragging down an example. The function to use is the sequence function in Excel. We'll use a single Excel function which will repeat the same number multiple times and then start over with then next number in the sequence. 🌍 My Online Excel Courses ► 🤍 🎬 LINK to more YouTube Shorts videos: 🤍 👕☕ Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 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! #Excel #shorts

Google Sheets BEATS Excel with THESE 10 Features!

475061
14009
1242
00:16:31
24.09.2020

Go to 🤍 and find out how you can get 3 months free. 🏫 My complete Google Sheets course: 🤍 Excel has been around for decades and has been largely considered the King of all spreadsheet applications. When Google Sheets first launched in 2006, it was nowhere near dethroning Excel. But since then it improved significantly and today the functionality between Excel and Google Sheets is very similar. In fact, it has useful features which Excel either completely lacks or hasn't implemented as neatly as Sheets. In this video we'll explore 10 features of Google Sheets where Excel doesn’t compete (yet). Time Stamps 00:00 The Superpowers of Google Sheets 01:22 Searchable Drop-Down Lists in Google Sheets 02:58 The SPLIT Function 04:08 Automatic Refresh for Pivot Tables 05:08 IMPORTXML and IMPORTHTML to Import Data from Websites 06:38 Lookup on Images in Sheets 07:42 Search and Replace with REGEX 08:51 Insert QR-Codes with IMAGE Function in Sheets 09:54 Translate with a Function (GOOGLETRANSLATE) 11:04 Chat Inside Your Spreadsheet 11:46 The All-Powerful QUERY Function 13:36 The GOOGLEFINANCE and SPARKLINE Function in Sheets If you want to find out how Excel fights back check out this video: 🤍 ⯆ Check out the complete blog post about Google sheets vs. Excel: 🤍 ★ My Online Excel Courses ► 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 EXCEL RESOURCES I Recommend: 🤍 Get Microsoft 365: 🤍 Microsoft Surface: 🤍 GEAR Screen recorder: 🤍 Main Camera: 🤍 Backup Camera: 🤍 Main Lens: 🤍 Zoom Lens: 🤍 Audio Recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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! This video was sponsored by ExpressVPN. #googlesheets #MsExcel

VLOOKUP or SUM Not Working? Convert Text to Date? (Excel Text to Columns)

91383
3171
300
00:04:55
31.01.2019

Check the Excel Essentials Course: 🤍 This tutorial uses Excel's Text to Columns feature to address two common Excel problems. Problem 1: VLOOKUP formula doesn't work One common reason for your VLOOKUP formulas or SUMIFS formulas not working is that Excel doesn't recognize the numbers as numbers. It sees them as text. Even if you change the cell custom formatting from General to a Number, your formulas still don't work. This is a common issue when you import data to Excel from SAP or Oracle systems. Problem 2: Dates are not recognized as dates in Excel. - sometimes imported dates from other systems to Excel are seen as text or number but not as a date. Excel's text to column feature can convert these super fast into dates. ⯆ DOWNLOAD the workbook & read the article: 🤍 LINKS to related videos: VLOOKUP - 🤍 ★ My Online Excel Courses ► 🤍 ✉ Subscribe & get my TOP 10 Excel formulas e-book for free 🤍 EXCEL RESOURCES I Recommend: 🤍 Get Office 365: 🤍 Microsoft Surface: 🤍 GEAR Camera: 🤍 Screen recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 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

Назад
Что ищут прямо сейчас на
XelPlus mbak meida hubyfan msc Japanese koi breeding half guard berdua ff engraçado realme cấu hình render giá rẻ ador player His Babuflex arms min min 本地圈 gorou guia disney world красота serem курс premiere pro копия часов эпл