Русские видео

Сейчас в тренде

Иностранные видео


Скачать с ютуб Don’t Use the PERCENTOF Function in Excel Until You Watch This! в хорошем качестве

Don’t Use the PERCENTOF Function in Excel Until You Watch This! 4 дня назад


Если кнопки скачивания не загрузились НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием, пожалуйста напишите в поддержку по адресу внизу страницы.
Спасибо за использование сервиса savevideohd.ru



Don’t Use the PERCENTOF Function in Excel Until You Watch This!

Sign up for our free Insiders program and get the example file: Click here: https://exceloffthegrid.com/insiders/ File Reference for this video: 0270 PERCENT of in GROUPBY ★ Want to become an Excel ninja? Check out our training academy ★ https://exceloffthegrid.com/ ★ About this video ★ In this video, we tackle the frustrating issue of Excel’s PERCENTOF function returning incorrect values when used inside a GROUPBY. You’ll see what the issues are, and how to resolve them. By the end, you’ll understand why the default formula falls short and how to build a robust solution. 00:00 Introduction 00:27 Basic GROUPBY 02:59 How not to fix it 04:11 How PERCENTOF really works 06:47 Solution 1 08:22 Solution 2 11:01 Next steps 11:41 Wrap up ★ Links to resources ★ Follow Dave Bruns from Excel Jet: https://exceljet.net ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter:   / exceloffthegrid   #MsExcel

Comments