Printer-friendly copy Email this topic to a friend
Lobby General Discussion topic #13250288

Subject: "I have to assess a set of financials to determine fiscal health" Previous topic | Next topic
dba_BAD
Charter member
14873 posts
Fri Apr-13-18 01:30 PM

Click to send email to this author Click to send private message to this authorClick to view this author's profileClick to add this author to your buddy list
12. "I have to assess a set of financials to determine fiscal health"
In response to In response to 11


          

and make strategic recommendations

(which is what I already know how to do)

and then make a dashboard for that theoretical organization to use to manage (forecast, allocate, etc) their finances moving forward (which I kinda know how to do, and have done many times in simplified formats, but I never tried to make anything hugely integrated and pretty)

Would love the opportunity to inbox with you or others in this post in more detail, if you're game to advise further. All input is hugely helpful and appreciated!

__

fairweather

  

Printer-friendly copy | Reply | Reply with quote


any of yall basically work in excel for a living? or any excel pros [View all] , dba_BAD, Fri Apr-13-18 09:07 AM
 
Subject Author Message Date ID
You definitely would want to create a macro in VBA
Apr 13th 2018
1
^
Apr 13th 2018
8
Pivot tables/charts definitely learn...asap
Apr 13th 2018
2
you'll definitely need conditional formatting for dashboards
Apr 13th 2018
3
^^^^ all of the above.... and if you have time which you won't: VBA
Apr 13th 2018
4
vlookups are essential, first thing they ask about at my gig
Apr 13th 2018
5
vlookup was a game changer for me
Apr 13th 2018
6
      ^ THIS ^ 1st priority!!! - I assumed this as already known
Apr 13th 2018
7
thanks for all the great suggestions above - Imma do my googles
Apr 13th 2018
9
https://www.youtube.com/channel/UCkndrGoNpUDV-uia6a9jwVg
Apr 13th 2018
10
RE: any of yall basically work in excel for a living? or any excel pros
Apr 13th 2018
11
      RE: I have to assess a set of financials to determine fiscal health
Apr 13th 2018
14
Yep, both of those. Youtube has good free tutorials.
Apr 13th 2018
13
you need to holla at THIS dude: ben collins
Apr 13th 2018
15
THANKS man I wish I was working in sheets
Apr 13th 2018
16

Lobby General Discussion topic #13250288 Previous topic | Next topic
Powered by DCForum+ Version 1.25
Copyright © DCScripts.com