Amazing 3D Formulas in Excel & How to Use Them

About this tutorial: Video duration: 11:57 Excel File: Excel Forum: How to use 3D formulas, which are an amazing thing in Excel that allows you to use functions across multiple worksheets at the same time – there are, however, a few limitations with these formulas and I’ll also show you how to get around these […]

Sort on Multiple Columns at Once in Excel – Excel Quickie 27

About this tutorial: Video duration: 2:59 Excel Quickie 26: Advanced sorting methods in Excel that allow you to sort by multiple columns at the same time. This is a great little trick that allows you to quickly and simply organize large lists of data in order to more easily view what you need for your […]

Countdown Timer in Excel

About this tutorial: Video duration: 15:19 Excel File: Excel Forum: Simple Excel countdown timer that includes a Start, Stop and Reset button. I’ll walk you through every step of creating this countdown timer and show you how to adapt it to your needs. This is a nice little trick, that, though it involves VBA/Macros, is […]

#Excel Exclude Cells that are Filtered, Hidden or Grouped from Formulas

About this tutorial: Video duration: 15:25 Excel File: Excel Forum: 2 different Powerful data analysis formulas for Excel that allow you to exclude hidden, grouped, or filtered data from calculations and that will also allow you to avoid issues caused by errors in the data set. Normally, functions in Excel will include data that is […]

5 Awesome Tips to Save Time Working with Huge Worksheets in Excel

About this tutorial: Video duration: 25:17 Excel File: Excel Forum: Save hours when working with huge worksheets in Excel – these tips will turn a headache of a worksheet into something that is manageable and easy to analyze. I use these tips on a daily basis and they will allow you to: – evaluate complex […]

How to Use INDEX MATCH Lookups in Excel – Step by Step Guide

About this tutorial: Video duration: 15:11 Excel File: Excel Forum: Step-by-Step guide to using INDEX/MATCH to create the most versatile and robust lookup formula in Excel. After this tutorial, you will never want to use a Vlookup again! I cover every step of creating the Index/Match lookup formula so that you have the skills and […]

The Best View for Working with Large Spreadsheets in Excel – Excel Quickie 4

About this tutorial: Video duration: 3:2 Excel Quickie 3: Excel Quickie 5: This is a tip I use every day and it saves me from having to go back and forth between worksheets. Change the view on large spreadsheets so you can work in multiple different sections of the workbook at once – this method […]

MS Excel Shortcut Key In Hindi Part – 2

About this tutorial: Video duration: 12:25 MS Excel Hindi Me

Tabulatoren – Microsoft Word 2016

About this tutorial: Video duration: 12:12 Dieses Video zeigt Ihnen, wie Sie mithilfe von Tabulatoren Texte in Dokumenten exakt platzieren k├Ânnen.