XelPlus

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

Excel Productivity for Lazy (but Smart) People

801913
11239
427
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

NEW! Excel LIVE Collaboration in Teams Meetings

48620
1523
104
00:05:19
22.09.2022

Join 300,000+ professionals in our courses: 🤍 Microsoft is bringing Excel directly into your Teams meetings. Until now, sharing spreadsheets within a Teams meeting has been a rather one-sided experience. With Excel Live your Teams meeting participants can now edit Excel spreadsheets together in real time. You share a file, and everyone in the meeting can now edit the Excel file directly from the meeting screen in Teams. Participants can follow the presenter, interact, and edit the workbook — without ever leaving the meeting screen. Everyone can look at the data in their own way - while working together. Excel Live supports custom Sheet Views and flexible zoom levels for each participant. 00:00 Transform Microsoft Teams meetings with Real-Time Collaboration 00:35 Participant View 01:34 Create your Own Sheet View 02:26 Presenter View 03:47 Requirements and Limitations 04:54 Wrap Up Availability: Currently in Beta in Public Preview in Teams 🌍 My Online Courses ► 🤍 🎬 LINKS to related videos: - We FINALLY get the Excel functions we've been Wanting: 🤍 - NEW Features in Microsoft Teams (Did you see these?): 🤍 👕☕ 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 #teams

5 Excel Functions YOU NEED in 2021 & 2022

796126
21164
891
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

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

150680
6837
462
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

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

2559427
47213
972
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

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

1226016
22801
529
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

Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)

2454050
38703
1152
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

👕 Introducing the New Merch! ☕

31644
861
121
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

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

1562603
60529
2530
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

How Power Query Will Change the Way You Use Excel

1318558
20170
938
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

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

712048
12785
526
00:23:03
16.12.2021

Make sure to sign up here: 🤍 if you'd like to receive the FREE Power BI course preview end of October. 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

Why Most People FAIL To Be Successful At Financial Analysis

96708
2797
234
00:09:01
28.04.2022

Get access to the complete course: 🤍 Upping your game when it comes to analyzing finances is a critical skill. When you not only understand how money is created, how it flows, and how it multiplies, but can also give recommendations… you give yourself one of the most valuable – and lucrative skills in the world. When you speak the language of finance, doors open. Here’s the thing: Anybody can learn to read and analyze financial statements. So then why do so many people struggle in this area? Because nobody taught them in simple terms how the numbers flow into the reports. Basic concepts like debits & credits, and how journal entries go from the general ledger to a trial balance, and to the financial statements. There's a certain grammar to this language of business that you need to be comfortable with. Most books and courses use the same terminology which can be too technical or too dry for many people. Come join my proven learning system - that half a million professionals have already completed successfully - and give yourself an unfair advantage in your career. 00:00 Why You're Failing in Accounting 02:56 What is Financial Analysis? 04:57 Why Context is Important 06:12 How to Learn Financial Analysis 🌍 My Online Excel Courses ► 🤍 🎬 LINKS to related videos: - Accounting Basics: 🤍 - Excel for Accounting: 🤍 🎒 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! #finance #accounting

Excel shortcut keys you SHOULD know!

1860187
48800
1526
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

Answering Your Questions: My Age, Nose, Marriage, Background (1 Million Subscriber Milestone)

518312
16473
1951
00:26:36
10.08.2021

This video is to celebrate 1 million subscribers on YouTube! I asked you recently what you wanted to know about me. I'll answer some of them in this video. ★★★ My Online Excel Courses ► 🤍 00:00 1 Million Subscribers Q&A 00:58 Where Are You From? 01:17 How Old Are You? 01:47 Where Did You Go to School? 02:15 What Did You Want to Become When You Were a Kid? 02:22 How Do You See Your Channel's Future? 02:48 Do You Have Free Time and If So, What Do You Like To Do? 04:20 Why Is Your Voice Coming Through Your Nose? 05:51 Were You a Good Student? What Did You Study? 06:23 Please Share Your Career Journey? 09:13 Do You Work For Microsoft? 10:05 Is There Anything You Don't Know About Excel? 10:35 Why Did You Create This Channel? Was It Hard at First? 12:25 Do You Only Do YouTube or Consulting As Well? 13:06 How Many People Work With You on the Channel? 13:34 How Much Prep Goes Into a Video? Do You Talk From a Script? 14:38 Were You Ever Tempted To Give Up On Your Channel? 15:45 How Do You Decide Which Topics to Cover? 16:59 How Do You Prepare Yourself for a Video / Course? 18:01 Are You Going to Create Courses for Power Automate, Power BI & Power Apps? 18:35 Do You Think Excel Is Still Worth Learning? 19:10 What Is The ONE Excel Feature You Use Daily? 19:28 How Do You Manage a Work-Life Balance With Constant Content Creation? 20:31 How Much Money Does Your YouTube Channel Generate? 21:11 If I Also Want to Be Successful Like You, What Do I Have To Do? 21:49 Will You Marry Me? 22:10 Do You Have Children? 22:47 How Did You Receive The Cut On Your Nose? 23:33 Are You a Cat or a Dog Person? 23:38 How Many Push-Ups Can You Do? 23:54 What Are Your Favorite Netflix Shows? 24:11 What Sport Do You Follow? 24:25 What Do You Eat and What Don't You Eat? 24:41 Do You Still Enjoy What You're Doing? 24:57 Recommendation to Aspiring Online Educational Content Creators? 26:06 Wrap Up ★ 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!

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

682882
17533
614
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

Excel Tutorial for Beginners | Excel Made Easy

1063811
21647
467
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

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

85539
3044
299
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

Excel SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria)

1463369
14567
1074
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

Master Excel's SUMPRODUCT Formula

576690
9533
692
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

Hidden Excel Productivity Tip: Copy Values From the Status Bar #shorts

160843
8087
130
00:00:53
03.04.2022

Excel has long provided quick facts about your data – like sum, average, and count – on the status bar when you highlight cells. But did you know that you can copy this information to the clipboard and then simply paste it wherever you need it? 🌍 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

VLOOKUP EXPLAINED - 2 Practical Excel Lookup Examples

643403
6465
390
00:12:16
13.09.2018

★ Check the Excel Essentials Course: 🤍 Quickly learn the ins and outs of Excel's VLOOKUP formula. I show 2 practical examples of the VLOOKUP formula. I also explain why your VLOOKUP formula might not be working correctly. 00:00 How VLOOKUP Works in Excel 02:30 How to Use VLOOKUP in Excel 10:00 How to Avoid #N/A in VLOOKUP ★ Get the Official XelPlus MERCH: 🤍 Summary: The Excel VLOOKUP formula looks up a value in an Excel table and returns a value from an adjacent column. "V" stands for vertical lookup. This is one of most common lookup functions in Excel. If your data table is not sorted, it's important to look for an exact match - this means you can't omit the last argument of vlookup. You need to set that argument to "false" or to 0. 🡻 Download the workbook here 🡻 🤍 ★ Links to related videos: ★ For reverse or 2-way lookup problems use INDEX & MATCH: 🤍 Relative & Absolute referencing: 🤍 ★ 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

How to use Excel Index Match (the right way)

2957732
33680
1865
00:11:32
04.03.2017

Join 300,000+ professionals in our courses: 🤍 Quickly learn all you need to know about INDEX & MATCH to get a quick start. Complete Excel Dashboard course: 🤍 ★ Get the Official XelPlus MERCH: 🤍 How to do Index Match in Excel: The basics. Watch this video tutorial to find out how you can use Index & Match for more complex lookup problems. This video shows you how Index Match works with simple and to the point explanation. It first shows you how Index works on it's own and then how Match works and then puts the two Excel functions together. ⯆ Download workbook here: 🤍 Timestamps: 00:00 Is INDEX & MATCH the same as VLOOKUP? 00:52 Excel INDEX function explained 05:07 Excel MATCH function explained 06:29 Using INDEX & MATCH together 08:08 Two way lookup with INDEX & MATCH (data validation) 10:30 How to REALLY learn Excel INDEX & MATCH Why Index Match is better than Vlookup & why use Index Match instead of Vlookup? Here are 3 reasons why Excel experts generally substitute VLOOKUP with INDEX and MATCH. 1. Unlike VLOOKUP, which searches only to the right, INDEX and MATCH can look in both directions – left and right. 2. INDEX & MATCH can perform two-way lookups by both looking along the rows and along the columns to find the intersection within a matrix. 3. INDEX & MATCH is less prone to errors. Assume you have a VLOOKUP where the final value you want returned is in column N. Your lookup value is in column A. You need to highlight the entire A to N range and then provide your index number to be 14. If you happen to delete any of the in-between columns, you would have to update that index number. You don’t need to worry about this when you use INDEX & MATCH. All in all, INDEX and MATCH is more flexible than VLOOKUP. Here are some of the reasons why Excel experts generally substitute VLOOKUP with INDEX and MATCH. Note: Index match is not case sensitive Index explained: The first argument of INDEX is to give it an array. This array (range) should include your answer. You then need to specify how many rows to go down and how many columns to move to find the correct value. You cannot move outside the INDEX range. The syntax of INDEX is: • The range where the return value resides. • Number of rows to move down (the row index) • Number of columns to move to the right (the column Index). This argument is optional. If you only have one column, you can leave the column argument empty, otherwise, you need to specify the number of columns to move over, in the range. The MATCH function’s syntax is as follows: • Like VLOOKUP, Match needs a lookup (target) value. The user can reference a cell or directly type the value into the formula. • Lookup_array: The “list” (range) where the return values are located. • Match_type: 0 for an “exact” match. Index MATCH used together: When INDEX and MATCH are used together, the MATCH function finds the look up value’s row / column index and then hands this value off to the INDEX function to get the lookup value. ★ 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

6 FREE Add-Ins for Excel to Start Using Now

784348
19902
558
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

Excel Waterfall Promo: Ultimate Excel Waterfall Chart Course on XelPlus

24610
122
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: 🤍 🤍 🤍 🤍 🤍

4 Excel Settings to Review Now to be more Productive ⏩

173810
7405
431
00:10:15
25.08.2022

Join 300,000+ professionals in our courses: 🤍 Microsoft Excel has lots of default settings that might work against your preferred work flow. In this video I'll show you my recommended settings you should review. Some of these will improve productivity and some are for convenience. Examples are Excel Custom Lists, AutoCorrect. If you find yourself typing the same text or lists often these settings will improve your life. Other settings to review is the ability to define a default layout for your Pivot Tables and change your Excel startup options. Another one I like is to stop the selected cell from moving down when I press enter. 🌍 My Online Courses ► 🤍 00:00 Change These Excel Settings Now! 00:18 What Happens on Enter 01:46 Long Phrases with AutoCorrect 03:05 Custom Lists 05:03 Pivot Table Settings 07:21 Startup Settings 08:17 Keep Leading Zeros 09:47 Wrap Up ⯆ Link to the blog post: 🤍 🎬 LINKS to related videos: 7 Things You're Doing WRONG 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 #exceltips #office365

3 Hidden Tips 🤫 in Power Pivot to Make Better Excel Pivot Tables

105152
2439
123
00:09:23
25.11.2021

Get Access to the Course: 🤍 In this video I share 3 hidden tips for Microsoft Excel Power Pivot that will make your data modeling life easier. We'll cover how you can easily copy your data model (together with queries, measures and relationships) from one Excel file to another. I'll also show you how you can setup a dedicated measures table that will be used by default. So every time you click to create a new measure, the separate measures table will be the default choice. Finally, you'll learn the benefits of using Excel cube functions. 🌍 My Online Excel Courses ► 🤍 00:00 3 Productivity Tips for Using Microsoft Excel Power Pivot 00:20 Easily Copy Your Data Model 02:49 Dedicated Measures Table 05:11 Use Cube Functions 08:31 Wrap Up Blog post: 🤍 🎬 LINKS to related videos: Excel Productivity for Lazy (but Smart) People: 🤍 🎒 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: How to Best Import External Data into Excel & Import data from the Web to Excel

441300
3589
158
00:11:16
07.09.2016

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. If you'd like to learn the newest version of this feature check out Power Query. Time Stamps 00:00 How To Properly Import Data to Excel 01:16 How To Use Text to Columns in Excel 03:27 How To Import Data from CSV / TXT files to Excel 09:52 How To Import Data from The Web to Excel Excel has various tools that can help you easily clean up your raw data for further analysis. Apart from using formulas and formatting, there are two useful Excel features that let you easily clean up. One method is text to columns feature and the other to import external data. The Get External Data tool can be used to import and analyse data from other systems. This tool is also useful for importing data to run your dashboards or do further analysis using pivot tables, etc. Usually you can get data extracts from any system (e.g. “.dat” or “.csv” from Oracle, “.xml” files from SAP, etc.). These can be imported into Excel. Importing External Data also gives you control over the decimals and thousand separator, especially if you’re dealing with international companies. In the US, the decimal is dot and the comma is a thousand separator and in most European countries it’s the other way round, where the comma is a decimal and the dot a thousand separator. It’s always safest to Import it properly with the Excel Data Import wizard! After importing press Ctrl + T to create a table out of it. You can create a pivot table off this one, and when you do, even if you add more data to it, the pivot reflects the new data. Importing Data from the Web / Internet into Excel – creating web queries that refresh automatically: In Excel you can also import data directly from the web. You basically create a web query which you set to refresh automatically based on your preference. ★ 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

5 Design Tips for Better Excel Reports & Dashboards

302089
3147
123
00:04:44
19.05.2017

I take you through 5 design tips that help create better Excel Reports and Dashboards. Link to Excel Dashboard course: 🤍 Full article is here: 🤍 5 tips to create the best Excel dashboard: 1. Create emphasis: Add a strong contrast to headings to show at a glance the KPIs on display in your Excel dashboard. 2. Connect different elements: Show relationships with alignment. 3. Draw parallels and create associations: Two things that should be repeated consistently in your dashboard are abbreviations and color usage. 4. Organise content and create focal points: Think about proximity. What will you choose to group or separate? 5. Balance large elements with smaller elements ★ 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

Smart Excel Pivot Table Trick - Choose Your KPI from Slicer (Excel Dashboard with DAX)

234470
6261
250
00:12:39
09.09.2021

With Pivot Charts in Microsoft Excel you can add slicers to add interactive functionality to your dashboards. But what about adding even more interactivity? You could give the user the ability to change the relevant KPI in the chart from the slicer. In this video I'll show you how you can use Power Pivot and DAX to create a fully flexible chart for your interactive dashboard. You can use this technique to create disconnected tables in your Dashboards that you can use as slicers. You can connect these to multiple pivot tables and pivot charts as well. ★★★ My Online Excel Courses ► 🤍 00:00 How to Create Interactive Dashboards with Power Pivot and DAX 00:50 Adding Data to the Data Model 01:26 How to Add a New Measure in Power Pivot 03:09 Creating Slicer Selections 04:33 Add Measures for Slicer Selection 09:18 Insert the Chart with Slicers 12:03 Wrap Up Learn DAX: 🤍 ⯆ DOWNLOAD the workbook here: 🤍 LINKS to more Excel Dashboard 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

5 FREE Cool Add-Ins for PowerPoint to Start Using NOW

95737
3953
126
00:10:15
18.08.2022

Join 300,000+ professionals in our courses: 🤍 In this video you'll learn the top 5 best add-ins for Microsoft PowerPoint any professional should have. Create word cloud images from text for free in PowerPoint, insert QR codes with a free addin. An icebreaker for any presentation is the Mentimeter addin for PowerPoint. I'll show you how to easily integrate Mentimenter with your PowerPoint presentation. You'll also learn how to add a count down timer or a break timer so everyone knows when to get back, and a hammer to memorize the size and position of any shape on a PowerPoint slide. This way you can use the same size and shape setting of one image on other slides as well. I also added a bonus tip to speed up the use of PowerPoint add-ins in your daily work. 00:00 6 Must Have Microsoft Office PowerPoint Add-ins 00:23 How to Install an Add-in in PowerPoint 00:35 Pro Word Cloud - Create Word Cloud Images from Text 02:24 Break Time - Countdown Timer 03:35 QR4Office - Create Your Own QR Codes 04:26 Mentimeter - Best Icebreaker for Presentations 06:58 Thor - The Hammer 09:09 Bonus: Productivity Tip 09:46 Wrap Up 🌍 My Online Courses ► 🤍 🎬 LINKS to related videos: - Transform Boring Presentations into Interactive Meetings: 🤍 - 3 Cool Effects You Did NOT Think are Possible in PowerPoint: 🤍 👕☕ 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! #powerpoint

Forecasting in Excel Made SIMPLE (include seasonality & make predictions)

311998
11147
304
00:05:42
11.11.2021

Get Access to My Course "Fundamentals of Financial Analysis" HERE: 🤍 In this video I'll show you how easy it is to create a forecast in Microsoft Excel. A forecast can help you predict things like future sales, inventory requirements, or consumer trends based on historical data. We'll use The Home Depot's quarterly sales data to make predictions for the upcoming quarters. You'll learn how to use Excel's Forecast Sheet. This feature turns historical data into accurate predictions with just a few clicks. This is especially helpful when you're working with seasonal data. This feature is available in Excel 2016 and higher. It automatically creates formulas with the FORECAST.ETS function with its exponential triple smoothing algorithm. 🌍 My Online Excel Courses ► 🤍 00:00 How to Do Forecasts in Excel 00:37 Analyzing Historical Data 01:24 How to Use the Forecast Sheet 04:54 Wrap Up Blog post and workbook: 🤍 🎬 LINKS to related videos: Percentile in Excel: 🤍 Excel for Accounting: 🤍 🎒 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

How to Create a Dynamic Numbered List in Excel #shorts

3780703
176819
1541
00:00:41
26.06.2022

Join 300,000+ professionals in our courses: 🤍 In this #shorts you'll learn a super easy way to create a dynamic numbered list in Excel with a single function. The function is the sequence function in Excel. You can make it dynamic so you only get a numbered list until where you need it. 🌍 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

Create INTERACTIVE Excel Dashboards With Option Buttons | How to use Radio Buttons

435866
13669
467
00:13:53
17.06.2021

Radio buttons or Option buttons in Microsoft Excel are a great way to add interactivity. In this video I'll show you how you can allow a user to choose the data they want to see on a chart. You'll learn to switch the chart view based on user selection. I'll show you how to add the developer tab to Excel, how to use form controls and how to group radio buttons together in case you have more than one set of option buttons. We'll also cover how to use the FILTER and the SWITCH functions in Excel for the data preparation. And finally I'll show you a trick to make your chart range dynamic to avoid gaps or missing data in the chart. This way your chart range and chart axis adjusts based on the size of your data. ★★★ My Online Excel Courses ► 🤍 00:00 How to Create an Interactive Chart with Radio / Option Buttons 00:14 How to Insert Option Buttons in Excel 04:07 Prepare the Raw Data for the Chart 06:38 Insert and Format The Chart 08:16 How to Make Chart Ranges Dynamic 12:14 How to Create Dynamic Chart Titles 13:27 Wrap Up ⯆ Download the Workbook from here: 🤍 ★ 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 #dashboard

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

183947
7292
279
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

Top Features of EDGE! (You've GOT to KNOW these!)

133443
7797
500
00:11:27
06.07.2021

I ditched Google Chrome in favor of Microsoft Edge. Find out what's so special about Edge. In this video I'll share my 10 best HIDDEN Features in Edge and also show you some tips and tricks when it comes to using EDGE. These tips and tricks will save you time and help you browse better. For example, you'll learn how to use collections to keep track of topics you'd like to go back to. How to you can take notes, use multiple profiles (this is the BEST!) and also how to use tab groups - and how you can group your tabs vertically. You'll also learn, how you can create apps from web pages and add them to your taskbar. AND also how to activate experimental features in EDGE. There are some similarities to Google Chrome, but there are some small details about EDGE that make it more user friendly. Timestamps 00:00 Best Hidden Features in Microsoft Edge 00:33 Collections - Organize Your Ideas 02:17 Read and Annotate PDF Files 03:56 Create Web Apps 04:57 QR Code Generator 05:27 Web Capture - Screenshot 06:13 Multiuser Functionality with Profiles 07:16 Math Solver 08:16 Edge Browser Task Manager 09:13 Tab Groups 10:33 Paste Friendly URL 10:57 Wrap Up ★★★ My Online Excel Courses ► 🤍 LINKS to related videos: ► Ditch Chrome for Edge: 🤍 ► Create Bookmarks for PDF files: 🤍 ► Windows 10 Tips & Tricks: 🤍 ► Mirror Phone on PC | Your Phone App: 🤍 ★ 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! #microsoftedge

How to Use Microsoft Teams Effectively | Your COMPLETE Guide

1101707
22703
747
00:24:06
12.01.2021

Join 300,000+ professionals in our courses: 🤍 This is the COMPLETE GUIDE to Microsoft Teams! It's a step-by-step guide to Microsoft Teams for beginners. You'll learn how to use teams to collaborate, manage chats, meetings and files in one place. If you've already used Teams for some time, you'll discover Microsoft Teams tips and tricks and how to use it effectively to get the most out of the Teams app. In this beginner Microsoft Teams tutorial I cover topics including: - Teams view and channel organization - How to add members to a Team / channel - How to translate messages in teams - Post view in Teams and how to format text / add announcements / post messages in multiple channels / add tables and tag people - How to pin messages in Teams and how to find pinned messages - Files view in Teams and how to upload and organize files (Files are automatically saved in the Teams SharePoint drive) - How to add applications to teams to customize your space. For example, add a Trello board, Planner, and even files as separate apps. - How to use Wiki in Teams (with example) - How to hold a teams meeting in a channel / sharing screen / changing your video background in Teams / Record a meeting - How to schedule a meeting in Teams - Calendar view in Teams - Files View - Chat in Teams - How to hide and mute chat / how to unhide and unmute chat - Commands in Teams / shortcuts - Bookmark or save messages so you find them easier - Notifications in Teams / getting notified when a team member becomes available - Changing your status in teams 00:00 How to Use Microsoft Teams - Complete Guide 00:46 How To Get and Install Microsoft Teams 01:52 What are Teams and Channels in Microsoft Teams 04:35 Posts View in Microsoft Teams 09:34 Channel Files in Microsoft Teams 10:55 Channel Wiki in Microsoft Teams 11:33 Customize Your Workspace in Microsoft Teams 13:27 How To Do a Video Meeting in Microsoft Teams 16:22 How To Chat in Microsoft Teams 19:49 How To Save / Bookmark Messages in Teams 20:53 How To Use Activity View in Teams 21:30 How To Use Search in Microsoft Teams 22:20 How To Make Calls in Teams ★ My Online Excel Courses ► 🤍 Complete Microsoft Teams article: 🤍 ✉ 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! #MicrosoftTeams

Breaking News! We FINALLY get the Excel functions we've been Wanting!

627792
19944
990
00:10:51
17.03.2022

Join 300,000+ professionals in our courses: 🤍 Microsoft Excel team just announced brand new Excel functions (Dynamic array functions) that save us from writing complex Excel formulas. These new Excel functions are for EVERYONE! Excel beginners to advanced to Pro. We get TEXTSPLIT to split text based on multiple delimiters (such as multiple spaces). We can grab the part of text before a delimiter with TEXTBEFORE and after a delimiter with TEXTAFTER. We have TOROW and TOCOLS to combine data from multiple ranges into a single row or a single columns. Together with the UNIQUE function you’ll be able to get a unique list of values from multiple columns. We also get CHOOSECOLS and CHOOSEROWS to select which columns and rows from a range you want returned. A great use-case is to combine CHOOSECOLS with the FILTER function to return columns from different places. WRAPCOLS and WRAPROWS allows you to take horizontal or vertical data and create multiple columns or multiple rows from it. TAKE & DROP functions allows you pick which part of a table you want returned. You can keep the first top rows or the last rows. You could combine this with the SORT function to get the top results of your dataset. Finally the EXPAND function allows you to expand a range to a certain number of columns or rows. This will come in handy to calculations that require multiple ranges to have the same size. 🌍 My Online Excel Courses ► 🤍 00:00 New Excel Functions in 2022 00:52 TOCOL Excel Function 01:24 TOROW 01:58 TEXTSPLIT Excel Function 02:40 TEXTBEFORE 03:19 TEXTAFTER 03:48 VSTACK Excel Function 04:32 HSTACK 04:56 WRAPROWS Excel Function 05:28 WRAPCOLS 05:44 TAKE Excel Function 06:56 DROP 07:19 CHOOSECOLS Excel Function 08:20 CHOOSEROWS 08:39 EXPAND 10:21 Wrap up Availability: Current partly in the BETA channel for those in the OFFICE INSIDER program. More info is here available in the Microsoft Excel announcement: 🤍 Download the File: 🤍 (scroll down the post and you'll find the file there) - if you have Office 365 beta, then you can open the file on your version of Excel to see the new function names in your language. 🎬 LINKS to more amazing Office 365 functions: 🤍 🎒 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

Get a Free Library as you Learn Excel Power Query Tricks (Custom data types, Hyperlink data type!)

93559
2711
200
00:11:07
03.06.2021

You can create your own free video library with Power Query Custom Data Types. You'll learn about Excel Power Query custom data types and how you can use this to optimize your Excel reports. Excel has a number of linked data types that you can use right away. But, you can also create your own data type from any supported data source by using Power Query. With this new feature, you can create custom data types and you can view the data in an Excel table, display it as an easy-to-read card, or use it in formulas. Power Query doesn't have a hyperlink data type, but you can create hyperlinks using data from Power Query by following the steps I show in the video. This way your Power Query results will be hyperlinked and clickable. We'll use Power Query custom data types to create a free library of all my YouTube tutorials in Excel. I'll also show you a great trick in Power Query to return clickable hyperlinks with friendly names to Excel. Timestamps 00:00 How to Use Power Query Custom Data Types 02:08 Create a Connection to a File From the Web 03:11 How to Fix Missing Hyperlinks in Power Query 05:34 Create Custom Data Types in Power Query 07:24 How to Expand Cards and Use in Excel Formula 08:35 Convert Links from Power Query to Hyperlinks 9:28 Updating Table after Website File is Updated 10:25 Wrap Up ★★★ Get the complete Power Query Course: 🤍 ► LINK to more Power Query tutorials: 🤍 ★ Get the Official XelPlus MERCH: 🤍 ★ 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

How To Delete Blank Rows In Google Sheets #shorts

51331
1204
24
00:00:30
28.11.2021

In this #shorts I'll show you how easy it is to remove blank rows or blank cells in Google Sheets. Data cleaning does not have to be boring, manual or difficult! 🌍 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! #googlesheets #shorts

Excel for Accounting - 10 Excel Functions You NEED to KNOW!

1448356
32987
756
00:19:05
25.02.2021

Get Access to My Course "Fundamentals of Financial Analysis" HERE: 🤍 If you work in accounting or you are a finance professional, make sure you learn these Excel formulas. They'll make your work life a LOT easier and they work in all Excel versions. Some of these are basic Microsoft Excel formulas and functions and some are more advanced Excel formulas. 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. If you have Office 365, make sure you check out this Excel tutorial. You'll find a list of easy and useful Excel functions such as FILTER, SORT, UNIQUE and SEQUENCE functions: 🤍 ★ My Online Excel Courses ► 🤍 00:00 Most Important Excel Functions for Accountants 00:15 AGGREGATE Function 03:16 Excel ROUND Function 04:40 EOMONTH Function 05:53 Excel EDATE Function 07:05 Excel WORKDAY Function 08:43 3D Formulas 10:17 SUMIFS / AVERAGEIFS / COUNTIFS 12:51 Excel IF Function 14:41 VLOOKUP Function 16:50 TRIM Function _ Detailed article for Excel functions for accounting: 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 LINKS to related videos: ► 3D Formulas: 🤍 ► SUMIFS / COUNTIFS: 🤍 ► IF Function: 🤍 ► VLOOKUP: 🤍 ► XLOOKUP: 🤍 ► TRIM Function: 🤍 More accounting & Finance videos: 🤍 For more Excel functions, check out this advanced Excel tutorials and functions playlist: 🤍 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

Назад
Что ищут прямо сейчас на
XelPlus вкусно паттайя gulab Raja never pause spongebob баблс hohenzollern daly* ФРОНТАЛЬНАЯ НАВЕСКА banyuwangi horor cned bbl ������������ ���������� ������ абстракт пение вместе high end dinamicas evangelicas عبدالفتاح السيسى С Рахманинов потеряла голову Feed and Grow: Fish bone rex акинатор