Do you want to manage your staff’s allocations, shift schedules and view the results in a 4 week grid fashion (like below)? Then you are
Let’s say you have two dates in the cells D4 & D5 as above. You want to find out the duration in years, months & days between both. We can use the good-old DATEDIF formula for this.
Analyst’s life is busy. We have to gather data, clean it up, analyze it, dig the stories buried in it, present them, convince our bosses about the truth, gather more evidence, run tests, simulations or scenarios, share more insights, grab a cup of coffee and start all over again with a different problem.
So today let me share with you 35 shortcuts, productivity hacks and tricks to help you be even more awesome.
Here is a fabulous New Year gift to you. A free Calendar & Activity planner made entirely in Excel. A fully customizable and flexible calendar for all your planning needs.
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
Bill Jelen is one of my most favorite people on earth. That is why I wanted to have him as my first guest when I restarted the podcast. Even though I recorded this few weeks ago, only now I got around to publishing it. Please enjoy the conversation with Bill.
How about a fun Excel challenge? I have data in below format in the table named trips I want to know which employees visited both
I recently interviewed people for Power BI analyst roles and here are my top 10 favorite questions to assess the skills (with answer cues).
