Tag: Excel for analysts

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

Check the Excel Essentials Course: 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 Excel Index Match (the right way)How to use Excel Index Match (the right way)

Check the Excel Essentials Course: Quickly learn all you need to know about INDEX & MATCH to get a quick start. Complete Excel Dashboard course: ★ Get the Official XelPlus