Create Excel Scroll & Sort Table using Formulas & Conditional Formatting

In this video tutorial we are going to create a Scrolling and Sorting Table in Excel 2019, using Formulas , like INDEX, MATCH, CHOOSE and RANK. Also we are going to use Radio (Option) Buttons , Scroll Bar and Conditional Formatting. The Scroll & Sort Excel Tables are extremely useful when we make Excel Dashboards or Data Visualization Excel Charts & Graphs.

───────────────────────────────────
💎Check Out My Online Courses ►►►►►►►►►►►►►►►

Create Excel Dashboards, Interactive Excel Graphs and Pivot Charts with Microsoft Excel 2019 + Free Excel Templates

Become a proficient Excel Macro Programmer in a very short time + Excel VBA for beginners. Excel Templates included.

Learn Excel Power Query - Power Pivot - Power Map and Excel Power BI Tools. Build Excel Data Analyst Models with Microsoft Excel 2019

The Best 100 Excel Tips & Hacks with Microsoft Excel 2016 - Excel Templates Included

Learn from scratch professional Advanced Excel Charts with Microsoft Excel 2019 - Excel Templates included

A Python Practical Programming Course for Absolute Beginners - Learn how to Code in Python and Improve your Productivity

Boost your Productivity with 25+ Gmail Techniques like Gmail Filters , Security , IFTTT . Master Email Communication
─────────────────────────────────────────────────────