7 Excel Tricks You Don't Know About

Опубликовано: 23 Апрель 2026
на канале: MS Excel: professional secrets

3,182

110

In this video, I share 7 interesting Excel tricks you might not know about:

0:14 - Grouping sheets (automatically resizing a group of sheets)
01:17 - Automatically sum multiple sheets
01:59 - Dividing/multiplying a range of cells by a number
02:38 - Comments in formulas using the ROUND() function
03:31 - Rounding with the ROUND() function
04:33 - "Super-hidden" sheet in Excel
05:53 - Hiding errors with the IFERROR() function

==================================================
Do you like Excel? Download our PowerQuick add-in to speed up your work in Excel and other add-ins (including financial calculators): https://ексэл-висро.рф
Join our VK group:

The most interesting videos on our channel about Excel:
   • Как преобразовать таблицу из PDF в EXCEL   How to convert a table from PDF to Excel
   • Анализ чувствительности проекта в Excel   How to perform a project sensitivity analysis
   • Подбор параметра (поиск решения) Excel сра...   Advanced parameter selection in Excel
   • Гиперссылки на файлы и папки в Excel   How to quickly create hyperlinks to files or folders
   • Фамилия и инициалы в Excel   Converting last names and initials to Excel
   • Сборка таблиц из разных файлов Excel  : Assembling tables from different Excel files
   • Сбор данных со всех листов Excel  : Assembling data from all Excel sheets
   • Многоуровневые выпадающие списки Excel из ...  : How to create multi-level (cascading) drop-down lists in Excel