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 Header & Footer (& Quickly Copy to other Sheets)

About this tutorial: Video duration: 8: Check the Excel Essentials Course: Quickly learn how to insert header and footer information to your Excel sheets. This is great if you’d like to optimize your print outs of your Excel sheets or PDF files. In this Excel Basics tutorial we cover different topics such as: 1. How […]

Data Validation in Excel – should you include these in your files?

About this tutorial: Video duration: 15:42 Check the Excel Essentials Course: Quickly learn how to make a drop down list in Excel or add other data validation checks. By the end of the this tutorial you will learn: 1. How to create dynamic drop-down lists that grow as new categories are added 2. How to […]

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 […]

Best Features of Office 2019 Excel | Can't miss these cool features!!

About this tutorial: Video duration: 5:49 Top 4 Features of Excel 2019 that you should know!!!!!!!!!!!!!!!!!

Make better Excel tables: BMW report to the test (Part 3)

About this tutorial: Video duration: 11:7 Check the Excel Essentials Course: In this case study we take a look at the 2015 Annual Report from BMW and look at ways we could improve on some of the tables and graphs used in the report. In this specific video we take a look at presenting data […]

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 […]

How to Make Attendance in Excel – Video Tutorial

About this tutorial: Video duration: 18:14 Attendance in MS Excel can be prepared in many different formats. In this tutorial you will learn how to make attendance sheet in Excel. This attendance will be full automated. You would just need to change 1st day date in attendance and it will change complete attendance by its […]

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 Dynamic Arrays (How they will change EVERYTHING!)

About this tutorial: Video duration: 7:1 Excel Dynamic Array formulas are new to Excel Office 365 (Insider for now). After this, everything will change! Complex tasks will be done with simple Excel formulas. Everything you wished Excel could do, can now be done! ★★ Link to complete Excel Dynamic Arrays Course: If you have Office […]

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 […]

Power query in Excel in Hindi ||excel for accountant| interview questions|| PIVOT TABLE DASHBOARD ||

About this tutorial: Video duration: 15:55 MOST ASKING QUESTION IN INTERVIEW. WATCH AND APPLY THIS AND BE A UNIQUE EXPLORE YOUR KNOWLEDGE

V lookup and H lookup in Hindi || 10 different ways

About this tutorial: Video duration: 51:22 #basitsolanki if anybody want this EXCEL file please give me their EMAIL ID IN COMMENT BOX .. (beginner to expert level v lookup example watch full video and become a expert in v lookup .. GET A JOB AFTER WATCHING THIS VIDEO . FOR SURE ….

ExcelHash: Greatest Threat – MAX, FREQUENCY, Form Controls, 3D Model

About this tutorial: Video duration: 9:20 ExcelHash is here!! 6 of us Excel MVPs came together to take on the challenge of making an integrated Excel solution by starting with 4 random Excel elements based on your suggestions. We have: – MAX function – FREQUENCY function – Form Controls – 3D Model See the other […]