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

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

[MS Office Tips]1.Microsoft excel 2019:Headers & Footers Add

About this tutorial: Video duration: 3:6 MS Office Tips: Microsoft excel 2019-How to insert Headers & Footers image, page number, footnote text … *How to add header and footer in excel 2019?* Header and footer in excel – Video header and footer in excel 2019 Method 1: Page layout → Page Setup → Header / […]

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

IFS Formula in Excel – New Excel Formula 2019 – Every Excel User Should Know

About this tutorial: Video duration: 10:28 IFS Formula in Excel – New Excel Formula 2019 – Every Excel User Should Know – IFS Formula in Excel – Use the IFS function to check whether one or more conditions are met and returns a value that corresponds to the first TRUE condition #MYBIGGUIDE #MSExcel #Excel Facebook […]

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

How to auto Grade Calculation in Excel, Nested If and Conditional If function , Excel tutorial

About this tutorial: Video duration: 10:5 How to Auto Calculate Grade like Grade A, Grade B, Grade C, Fail etc in a Mark sheet in Excel 2007, 2010, 2013, 2016 ? Download the workbook here ? Complete Tally ERP9 With GST step by step Tutorial 2018 Subscribe us: Thanks for watching Don’t forget to – […]

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

Advanced Excel video Tutorial – Generating reports using MACROS

About this tutorial: Video duration: 23: Enroll for our online course : Excel Macro Tutorial 1 – Extreme Excel Solutions brings another online advanced excel lecture video to explain the concepts of VBA macros. In this online video you will learn how to generate reports from raw data. This video is for all people who […]

EXCEL training course | how to extract parts of a text string

About this tutorial: Video duration: 29 ☢ Note ► Limitless tutorials was selected among the top 40 cad blogs on the planet in 2017 by Feedspot ☢ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ▶ “Discover How You Can […]