"any of yall basically work in excel for a living? or any excel pros"
I'm in final consideration for a new gig that I really, really, really want - last step is a sample project that includes building a somewhat involved dashboard in excel.
I regularly work in excel, and zip around using obvious features like basic math functions, sorting data etc - but in this case I know they're particularly assessing my excel chops and I want to pull out all the stops.
If you were building something in excel with specifically showing off an advanced skillset in mind - what special functions would you make sure to include?
I don't know wth a pivot table or a macro is, but I know they're things lol
3. "you'll definitely need conditional formatting for dashboards" In response to Reply # 0 Fri Apr-13-18 09:30 AM by Cocobrotha2
You essentially enter logic such that if X is, say, >= Y, make the cell green. If X==Y, cell is yellow. If X<Y, cell is red.
I've also gotten alot of run out of knowing how to name a range of values and then using countif() to find the certain values in that range.
For instance, if I've got 10 values in column A of Sheet1 that I need to find amongst 5000 values in another tab in Sheet 2 of the spreadsheet, I'll name the large range of values "MyRange".
Then in column B of Sheet1, I'll put =countif(MyRange, A1)>0 . The ">0" at the end changes the countif into a True/False statement.
So if A1 is in the range of 5000 values in "MyRange", B1 will be "True". If not, it'll be false.
Autofill that function for all 10 entries and I've quickly determined whether any entry in column A is in "MyRange".
5. "vlookups are essential, first thing they ask about at my gig" In response to Reply # 0
as far as stepping into the next realm of data consumption. and they're easy once you get the hang of them
the level I am looking to get on is VBA where you are getting not only multiple worksheets in Excel, but multiple programs like Access / Outlook working together.
9. "thanks for all the great suggestions above - Imma do my googles" In response to Reply # 0
are there any particular online resources you're a fan of?
I'm a seasoned googler and am confident I can find the instructions and info I need - youtube etc, but if there's something dope out there you're already aware of let me know
Thanks all!
And keep any more great ideas coming! This has been super useful so far
12. "I have to assess a set of financials to determine fiscal health" In response to Reply # 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!
14. "RE: I have to assess a set of financials to determine fiscal health" In response to Reply # 12 Fri Apr-13-18 02:45 PM by GNT1986
Feel free to inbox me. I'm at work today and tomorrow reading up on how to design and implement a data governance framework, so if you know anything about that, sharing is caring.
I'm not sure how much help I can be, but yeah, happy to assist however I can.
Is the forecasting straight line linear regression?
The guy who taught me a majority of my excel trickery loved using slicers in dashboards:
if you go to the top level url, he mostly fux w/ google sheets now (which is what i mostly mess with), but he got some fire on excel, too, at the link i posted.
in particular, he's GREAT at explaining stuff -- one of the best tutorialists (? that a word?) on the 'net, and he always has sample files, etc.
========================================= I'm an advocate for working smarter, not harder. If you just focus on working hard you end up making someone else rich and not having much to show for it. (c) mad