Is GROUPBY better than PivotTables? How to calculate Period, YTD and Full Year Projection
Автор: Excel Off The Grid
Загружено: 2025-03-27
Просмотров: 17263
Sign up for our free Insiders program and get the example file:
Click here: https://exceloffthegrid.com/insiders-...
File Reference for this video: 0256 Period, YTD & Projection with GROUPBY.zip
★ Want to become an Excel ninja? Check out our training academy ★
https://exceloffthegrid.com/
★ About this video ★
In this video, we explore how to use the GROUPBY function in a scenario where PivotTables aren't up to the job. It shows how ot calculate Period, Year-To-Date, and full year projections using Budget and Actual values in a single output.
The video goes step-by-step through array and boolean techniques to calculate the required output. Even if this isn't your scenario, you can use this method to calculate almost any layout.
0:00 Introduction
0:36 Workbook setup
2:12 Boolean logic
5:12 Using GROUPBY
6:30 Differences and Projections
8:58 Result
9:21 Wrap up
★ 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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
