5 Excel INTERVIEW Questions You NEED to Get RIGHT

About this tutorial: Video duration: 8:43 Want to ROCK your Next Interview? Check out the complete Excel Essentials course: To get the 40% OFF launch discount (until October 24th) use coupon code: YT_EXCEL You’ll learn dozens of quick hidden tips and tricks to showcase your knowledge. Once you get the job, you’ll have the course […]

Excel VBA: Check If File or Folder Exists (DIR) – Open File or Create Folder

About this tutorial: Video duration: 9:32 Use the DIR function in Excel VBA to check if a file or a folder exist. You can then decide what to do if they exist. For example you can open the Workbook to copy values from and then close the workbook. I will also show you how you […]

ARE YOU READY for the NEW Excel? (New Calc. Engine & Dynamic Arrays)

About this tutorial: Video duration: 4:28 Complete course: LINK to my first Excel Dynamic Array video: How to become a Microsoft Office Insider: (Note: Currently dynamic arrays are only available in Microsoft Office Insider FAST edition) If you have Office 365 Pro Plus check out this link: This videos gives you a quick overview of […]

Quick Excel Trick to Unstack Data from one Column to Multiple Columns

About this tutorial: Video duration: 5:4 This trick is the easiest (or laziest) method to unstack data from one column to multiple columns. You might come across a case where you need to move data (or transpose data) from one column to multiple columns. If you Google this, you’ll find different ways of doing this […]

Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays)

About this tutorial: Video duration: 11: ★ Link to complete Excel Dynamic Arrays Course: This technique uses data validation and (simple) Excel formulas to create a searchable data validation drop-down list. If you have Office 365, you will get these functions soon. Don’t miss out on their potential. We use the Excel SEARCH function, ISNUMBER […]

Excel Sum(ifs) between dates, sum month & sum with multiple criteria

About this tutorial: Video duration: 8:44 Use the Excel SUMIFS formula to sum values between two dates. Here you’ll need to use the greater than & less than operators inside the SUMIFS formula. You’ll also learn how to sum values within a month. For example, your data set contains dates and you’d like to create […]

LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results)

About this tutorial: Video duration: 9:13 Find out how you can take advantage of the new Excel dynamic array functions to create interactive Excel dashboards really fast. ★ Link to complete Excel Dynamic Arrays Course: If you have Office 365, you will get these functions soon. Don’t miss out on their potential. Tutorial Summary: This […]

Advanced Excel Filter (And, Or, Between conditions for criteria range)

About this tutorial: Video duration: 7:24 How does Advanced Filter work in Excel? In this quick tutorial I show you many examples that explain: 1. How to setup advanced filter 2. How to use the criteria range in advanced filter 3. How to use wildcards 4. How to setup your criteria to filter for OR […]

Excel Picture Lookup: 5 easy steps for dynamic images

About this tutorial: Video duration: 9:43 Learn to quickly lookup different pictures based on the value of a cell. Some people call this VLOOKUP on images. You can use this technique for company logos, employee pictures, flags – basically anywhere where you need to show different images based on the value of a cell. You’ll […]

Excel HACK: Change HORIZONTAL Data to VERTICAL (NO Transpose Function needed)

About this tutorial: Video duration: 5:33 How can you reconfigure a horizontal row to a vertical column? You can use a simple Excel hack to get this done. In my previous video ( I talk about 2 other methods you can use. One method is to copy the data and paste special and select transpose. […]

Simple Explanation of Excel SUMIFS, COUNTIFS & AVERAGEIFS (Multiple Criteria)

About this tutorial: Video duration: 14:4 Quickly learn how SUMIFS & COUNTIFS formulas work – and why they are better than SUMIF & COUNTIF formulas. Download the workbook here: 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 […]

Advanced Excel: Top 10 Tips & Formulas to Work Smarter

About this tutorial: Video duration: 2:3 Get the full course: Interested to master Excel? visit: www.xelplus.com – Stay informed. Subscribe to my newsletter. Build a strong foundation in Excel to solve complex problems fast. – Use my top 10 tips to save time – Learn the top 10 formulas for quick and dynamic analysis The […]

Excel Goal Seek Explained in Simple Steps

About this tutorial: Video duration: 5:55 Curious what goal seek does? Find out now, because it can save you time. Read the article: Excel’s Goal Seek tool is in the Data Tools Tab as a part of What-If Analysis in the Excel Ribbon. Goal seek can be described as follows: • It is the opposite […]

Alternative to Doughnut Charts: BMW report study (Part 2)

About this tutorial: Video duration: 15:37 In the 2nd part of our corporate report makeover in Excel, I show you a better alternative to Doughnut (Donut) charts in Excel. Doughnut graphs are very similar to Pie Charts except they use less ink. A better alternative to the Doughnut chart is a sorted bar chart. In […]

(Promo) Unlock Excel VBA and Excel Macros Course – Now available

About this tutorial: Video duration: 4:58 Link to complete course ► This is the promo video for my online Excel VBA & Macros course which will take you from beginner, all the way to VBA Expert. This course will take you from Beginner to VBA Expert and teach you everything you need to know to […]

Excel VBA tutorial for beginners: Object Properties & Methods

About this tutorial: Video duration: 13:9 Understanding Objects, Properties and Methods in VBA is really important if you’d like to write your own Excel VBA code from scratch or update the VBA code you find on forums. This Excel VBA tutorial for beginners, includes two lectures from my “Unlock Excel VBA and Macros” course which […]

Excel 2016 Auto Generated Named Ranges For More Robust Models

About this tutorial: Video duration: 4:42 Full 2.5hr Course with downloadable files Learn to automatically generate named ranges in Excel 2016. Setting up an input sheet for all of your model drivers is a best practice for model development in Excel. These principles extend into many other areas as well and make your Excel models […]

Excel Reset Week Number Every Month – (WeekDay & WeekNum Functions Explained)

About this tutorial: Video duration: 17:26 In this video I show you two ways to reset the week number to start from 1 at the beginning of every month. 1st case: We use Excel’s WEEKNUM function to start from 1 every time we reach the 1st of the next month. 2nd case: We reset the […]

Excel Dynamic Chart with Drop down List (column graph with average line)

About this tutorial: Video duration: 8:9 Learn how to create an interactive chart in Excel that switches views depending on the selection from the drop-down list. In addition to creating dynamic chart ranges, I also show you how to create combo or combination charts in Excel. In this specific example, I show you how to […]