Build a STUNNING Budget vs Actuals Dashboard

  Рет қаралды 11,867

Josh Aharonoff (Your CFO Guy)

Josh Aharonoff (Your CFO Guy)

Күн бұрын

Пікірлер: 24
@anatulymaimany
@anatulymaimany 8 ай бұрын
Thank you for sharing this with us!
@yourcfoguy
@yourcfoguy 8 ай бұрын
You’re welcome, thanks for watching!
@darpanshukla
@darpanshukla 8 ай бұрын
This is fantastic. The presentation style is awesome but i would suggest a faster delivery as i watched at 1.5x and understood everything easily.
@yourcfoguy
@yourcfoguy 8 ай бұрын
Very helpful feedback! If you have any other suggestions please do feel free to share as I have a lot to learn
@jsusv5387
@jsusv5387 8 ай бұрын
Great content
@yourcfoguy
@yourcfoguy 8 ай бұрын
Thanks for watching and sharing your feedback!
@racheallola8058
@racheallola8058 3 ай бұрын
Thanks for sharing josh
@yourcfoguy
@yourcfoguy 3 ай бұрын
Thanks for continuing to watch Racheal!
@navyasri9761
@navyasri9761 8 ай бұрын
I have a request! Could you please come up with the videos on: Balance Sheet, Profit & Loss Statement and Cash Flow Statement and the relationship between them. I'd be grateful to you always.
@yourcfoguy
@yourcfoguy 8 ай бұрын
Coming right up!
@navyasri9761
@navyasri9761 8 ай бұрын
@@yourcfoguy Thankyou❤️
@darpanshukla
@darpanshukla 8 ай бұрын
Ditto requested.
@yourcfoguy
@yourcfoguy 8 ай бұрын
Feel free to share any other topics you’d like to see! In the meanwhile, here’s a video on the p&l kzbin.info/www/bejne/qXLblWZrfc2ErtU
@tibibara
@tibibara 5 ай бұрын
My personal experience isn't the same, so I just cannot recommend to use Donut chart in case of Cash Flow/Ending Cash/Net Income as a chart type - the reason is so simple in theory it looks very good that all the variances are below 100% but in the practice this isn't the case and it can occur quite often values like 200% ,300% ..etc. which make the presentation of our KPI quite difficult according to the tutorial's approach... Perhaps at a consolidated level, it can be used in the case of a profit rate in these cases a bullet chart can more easily display the extreme values...
@yourcfoguy
@yourcfoguy 5 ай бұрын
You raise some good points - donut charts are difficult if the amounts are greater than 100% or less than 0%. What exactly is a bullet chart?
@tibibara
@tibibara 5 ай бұрын
@@yourcfoguy ... I prefer card-like KPI-s -> Rev, Profit, CF, ROE, CCC - value, delta indicator, %dif as single or cumulated KPI + quarterly/monthly bullet -> act vs fc or act vs budget or act vs fc vs budget, bullet its a classic column/bar chart using series overlap + no fill features with only borders... so don't get me wrong the progressive circle versions are so cool or a line chart with trendline etc... just in practice I've always had unusual %rates, especially between divisions or profit/cost centers because of company-specific reasons 😅 and when I planned the design, I had always fancy dreams and than the reality just destroyed them 🤣 or our CEO/CFO-s special demands 🤣
@yourcfoguy
@yourcfoguy 5 ай бұрын
lol I hear that - thanks for sharing your experience with us!
@marcthomas9806
@marcthomas9806 7 ай бұрын
Great hope ypr channel get big quickly
@yourcfoguy
@yourcfoguy 7 ай бұрын
I hope so too :)
@martacasillasvega7151
@martacasillasvega7151 4 ай бұрын
Buen tema versus
@eugeniahampton1670
@eugeniahampton1670 6 ай бұрын
*promo sm*
@yourcfoguy
@yourcfoguy 6 ай бұрын
Can you elaborate on that?
Build a Dynamic Budget vs Actuals Dashboard on Excel (Variance Analysis)
16:08
Build a DYNAMIC budget with POWER QUERY
24:42
Josh Aharonoff (Your CFO Guy)
Рет қаралды 8 М.
Quando A Diferença De Altura É Muito Grande 😲😂
00:12
Mari Maria
Рет қаралды 19 МЛН
Take Control of Your Finances in 2024 with Excel!
15:35
Kenji Explains
Рет қаралды 107 М.
How the 3 Financial Statements Connect Together
10:05
Josh Aharonoff (Your CFO Guy)
Рет қаралды 8 М.
How to build EVERY Excel Chart in 83 minutes
1:23:10
Josh Aharonoff (Your CFO Guy)
Рет қаралды 4,8 М.
Make Impressive McKinsey Visuals in Excel!
16:47
Kenji Explains
Рет қаралды 337 М.
Telling a Story with Data | Dashboard Build Demo
13:41
Maven Analytics
Рет қаралды 145 М.
5 Excel Tools Most Users Never Think to Use (Files Included)
12:34
MyOnlineTrainingHub
Рет қаралды 259 М.
STOP using VLOOKUP (and use this instead)
7:20
Josh Aharonoff (Your CFO Guy)
Рет қаралды 4,1 М.
Build a BEAUTIFUL KPI dashboard
14:20
Josh Aharonoff (Your CFO Guy)
Рет қаралды 11 М.
Build an ADVANCED Budget vs. Actuals Dashboard
20:27
Kenji Explains
Рет қаралды 182 М.