8 Tips To Maximize Trust In Your Excel Reports

  Рет қаралды 15,748

The Financial Controller

The Financial Controller

Күн бұрын

Пікірлер: 28
@mikehoffman1475
@mikehoffman1475 2 жыл бұрын
This really isn't taught in accounting classes, thank you for addressing what items ad hoc reports should include.
@TheFinancialController
@TheFinancialController 2 жыл бұрын
Thanks brother
@markissleepy
@markissleepy 2 жыл бұрын
The tip about adding a check sum at the bottom is a surprisingly big one. A part of my job for several years involved providing reports for our CFO and I noticed he always added those at the bottom, so I started doing it before I sent them to him and the number of questions I got back from him on the reports dropped considerably because he saw that (and some other similar things I noticed him doing to all my reports, that I then started added before delivering them) and had more trust in my numbers. Just that one little thing saved us both a lot of time spent on asking/answering questions.
@TheFinancialController
@TheFinancialController 2 жыл бұрын
Thanks for this story brother, it backs my advice so I appreciate it
@marcaerontionson3127
@marcaerontionson3127 2 жыл бұрын
we lucky to have you!, very hands-on on teaching us thanks a lot !
@Adidas9234
@Adidas9234 2 жыл бұрын
These are value adding videos not the interview sessions and tips..thank you Sir!!
@ldang918
@ldang918 2 жыл бұрын
A pivot table/power query would be most efficient for a summary tab. ☺️ thank u for the tips !
@amirfirdaus9419
@amirfirdaus9419 2 жыл бұрын
Could you do a video on which excel functions are useful for auditors?
@TheFinancialController
@TheFinancialController 2 жыл бұрын
Great suggestion!
@gunjankalra1256
@gunjankalra1256 2 жыл бұрын
I am from india and m a internal auditor here... thank you for sharing your knowledge
@p.r.7776
@p.r.7776 2 жыл бұрын
Great tips! Would you recommend an online excel tutorial that is good for a finance analyst or accountant?
@Soulenergy31
@Soulenergy31 2 жыл бұрын
Thanks, Bill!! great content as always!!!!! 0:57 Hard-coded numbers are not trustworthy by nature,......................................... formula-driven reports definitely are the way to go in the information age, gone are the days of hard-coded numbers in spreadsheets for all of us who became advanced Excel users :) 4:03 fat fingering and entering the wrong number
@TheFinancialController
@TheFinancialController 2 жыл бұрын
Thanks brother
@efnfamilyadventuretv3129
@efnfamilyadventuretv3129 2 жыл бұрын
Great Vlog im might share my tips
@JarlTryggve
@JarlTryggve 2 жыл бұрын
Great video. Thank you sir.
@Wale_mo
@Wale_mo 2 жыл бұрын
Bill, Good job you are doing. I will suggest you do tutorial on IAS, IFRS and international standards applicable to Accounting. Thanks
@TheFinancialController
@TheFinancialController 2 жыл бұрын
Ok wale
@张淑佳-g9u
@张淑佳-g9u 2 жыл бұрын
Ups and downs are inevitable in life. The more favourable the situation, the humbler we need to be. Keep bitterness to ourselves and leave happiness to others.
@roseballerine4395
@roseballerine4395 2 жыл бұрын
Hey Bill, will you do content on what is SAP fico vs SAP Hana, and other SAP module a finance professional should know
@karlanunez3847
@karlanunez3847 2 жыл бұрын
Thank you, Bill! As always, excellent content. Éxitos! ;)
@TheFinancialController
@TheFinancialController 2 жыл бұрын
Thank you Karla
@ianjosephmukabi26
@ianjosephmukabi26 2 жыл бұрын
Hello ,I'm a young man just done with high school. I'm really interested with Accounting
@Chironex_Fleckeri
@Chironex_Fleckeri 2 жыл бұрын
Why do people tend to start in B2 in excel? Leaving A column and Row 1 empty makes it easier to add columns and rows? Is it a "best practice"? Now, for sheets in a spreadsheet that are going to be referenced by functions like index+match or vlookup, or when working with csv (flat files I hear them called sometimes) you will likely be starting in A1. Just curious. I always seem to see this
@happygill85
@happygill85 2 жыл бұрын
Can you do an episode on how and where to get clients?
@TheFinancialController
@TheFinancialController 2 жыл бұрын
Sure
@priya-cl9ud
@priya-cl9ud 2 жыл бұрын
Sir I am a commerce graduateI got selected in mnc (accounts controllership process) what would be my job role as a fresher wt is my work
@roseballerine4395
@roseballerine4395 2 жыл бұрын
First!
@KainOfNosgoth
@KainOfNosgoth 2 жыл бұрын
Unconscious bias 😁
9 Mistakes you make with month 📆 end close
11:19
The Financial Controller
Рет қаралды 38 М.
How To Find Mistakes In The Income Statement
15:16
The Financial Controller
Рет қаралды 127 М.
Good teacher wows kids with practical examples #shorts
00:32
I migliori trucchetti di Fabiosa
Рет қаралды 7 МЛН
Every parent is like this ❤️💚💚💜💙
00:10
Like Asiya
Рет қаралды 20 МЛН
Top 10 Essential Excel Formulas for Analysts in 2024
13:39
Kenji Explains
Рет қаралды 861 М.
Top Tips to Manage Your Outlook Calendar 📅 (which are you using?)
11:19
7 Excel Time Hacks Everyone Should Know | Learn Excel the FAST Way!
22:31
Excel University
Рет қаралды 423 М.
THE SECRET TO BEING A GREAT PHOTOGRAPHER
11:22
The Art of Photography
Рет қаралды 239 М.
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
5 Accounting Adjustments From Easy to Insane 😵‍💫
14:42
The Financial Controller
Рет қаралды 11 М.
How To Close The Books For Dummies. Financial Close In 15 Steps
20:15
The Financial Controller
Рет қаралды 131 М.
7 SIMPLE photography TIPS I wish I knew EARLIER
18:33
Nigel Danson
Рет қаралды 2,4 МЛН