How to Excel

This channel is dedicated to helping you learn and succeed with Microsoft Excel and other Office 365 tools.

Check out my full courses and ebooks here:
👉 https://www.howtoexcel.org/courses/

DOWNLOAD any example workbooks here:
📖 https://howtoexcel.com/downloads

SUBSCRIBE & get my 3 FREE eBooks.
📧 https://howtoexcel.com/signup

CONNECT with me on social:
Facebook: https://www.facebook.com/howtoexcelblog
Twitter: https://twitter.com/howtoexcelblog
LinkedIn: https://www.linkedin.com/in/john-macdougall/

Thanks for all your support!

Преобразование таблицы Excel в объект JSON с помощью Python

Преобразование таблицы Excel в объект JSON с помощью Python
Параметры Excel Power Query: легко меняйте источник данных!

Параметры Excel Power Query: легко меняйте источник данных!
❌ Хватит копировать и вставлять! ✅ Перемещайте данные Excel с помощью скриптов Office

❌ Хватит копировать и вставлять! ✅ Перемещайте данные Excel с помощью скриптов Office
Выделение минимума и максимума на диаграмме Excel

Выделение минимума и максимума на диаграмме Excel
Как сгруппировать данные в Excel [5 методов]

Как сгруппировать данные в Excel [5 методов]
Your boss will LOVE this Excel dashboard!

Your boss will LOVE this Excel dashboard!
3 cases when VLOOKUP is BETTER than XLOOKUP

3 cases when VLOOKUP is BETTER than XLOOKUP
Build a Fancy Headcount KPI Data Card [Step by Step]

Build a Fancy Headcount KPI Data Card [Step by Step]
How to use the new COPILOT function in Excel [11 Examples]

How to use the new COPILOT function in Excel [11 Examples]
These functions are ESSENTIAL with GROUPBY

These functions are ESSENTIAL with GROUPBY
No refresh button needed! Refresh pivot tables automatically!

No refresh button needed! Refresh pivot tables automatically!
Use animated GIFs with the IMAGE function in Excel

Use animated GIFs with the IMAGE function in Excel
3 Ways to Unpivot Data in Excel

3 Ways to Unpivot Data in Excel
5 secrets to return ALL match results [#5 is PRO Level]

5 secrets to return ALL match results [#5 is PRO Level]
3 powerful techniques to get ALL combinations in Excel

3 powerful techniques to get ALL combinations in Excel
3 Ways to Easily Fill Down Values in Excel Like a Pro 🏆

3 Ways to Easily Fill Down Values in Excel Like a Pro 🏆
Flexible FILTER formulas with THESE three functions

Flexible FILTER formulas with THESE three functions
Easily COMBINE mulitple cells into a single cell [Excel Hacks]

Easily COMBINE mulitple cells into a single cell [Excel Hacks]
2 SIMPLE formulas for generating random samples in Excel

2 SIMPLE formulas for generating random samples in Excel
3 surprising ways to get GOLD prices in Excel!

3 surprising ways to get GOLD prices in Excel!
Compare two lists with XLOOKUP [Matches & Differences]

Compare two lists with XLOOKUP [Matches & Differences]
5 genius tricks to delete blank rows in Excel FAST!

5 genius tricks to delete blank rows in Excel FAST!
EASY search bar with this Excel formula

EASY search bar with this Excel formula
Secret trick to use slicers with GROUPBY or PIVOTBY

Secret trick to use slicers with GROUPBY or PIVOTBY
11 formulas to fix messy data in Excel

11 formulas to fix messy data in Excel
11 mind blowing Excel functions you won’t believe! 🤯

11 mind blowing Excel functions you won’t believe! 🤯
9 Essential Formulas for HR Professionals in Excel

9 Essential Formulas for HR Professionals in Excel
NEW Dark Mode in Excel

NEW Dark Mode in Excel
Get ALL images from SharePoint folder in Excel

Get ALL images from SharePoint folder in Excel
9 Essential REGEX Formulas in Excel

9 Essential REGEX Formulas in Excel