Related Posts
Hi, I joined pwc AC early last year as a fresher in tech consulting Fortunately I have landed in a good project, did the best i could Got a tier 1 rating in last cycle This year snapshots have been great too Feedback from engagement team has been good🤞 Can I pursue for asking a promotion this midyear Current role : Associate 2 PwC PwC India Pwc AC
Due to the weather here in Texas tomorrow is…
What are the top designer brands for women?
Anyone there ?
What experiences do you have with flip grid?
Currently drunk, happy Friday y’all!
Feelings in general on Reminger and comp?
Additional Posts in Consulting
How would you explain the first two lines?
What’s your most important skill and why?
New to Fishbowl?
unlock all discussions on Fishbowl.
I'll google. This is worth my time
Do what ever you are doing in Microsoft access
DGet is one of the excel database functions. My questions is really... IndexMatch vs. Database functions
YouTube tutorials, Microsoft's website, internal web training (assuming D has an agreement with MS), just open it up and give it a try. If you have questions along the way you can post to Microsoft's forum or give stack exchange a try. It's a lot easier to learn when you actually have a problem you want to solve with it.
What's dget???
Option 1: if you're returning a number you could use a sum product and specify criteria using "--"
Option 2: you could make a new column next to both the data you are using to "lookup" and the data you are returning, and in that column you would put in all the criteria and return it as a true false. Then depending on what you want to do, you could do a lookup on first the t/f and then decide whether to return the the value, or you could try concatenating the true false in both the lookup and return areas and then doing some type of left/right function to determine if it met the criteria or not
Agree with access. If you're doing something that is this memory and processor extensive in excel, it should be done in access.
Any tips for learning access?
Also, I can already tell things should be structured different in access, than they are in excel. Tips on that?
QlikView. Much better and more intuitive than Excel and Access. Compression ratio also beats Excel and Access. Personal edition is free. I'm never using Office for complex analysis ever again.
Access for dummies is how I learned.