Sign in to follow this  
Schildog

Excel Help Offered

10 posts in this topic

Schildog    1,669

I'm looking to moonlight with excel to see if this is something I can kickoff maybe into something bigger. I know there are a few small business owners here. If you need any help with spreadsheets, creating dashboards or analysis with excel, let me know.

  • Like 1

Share this post


Link to post
Share on other sites
Blarg    14,177

My son got fed up with the volatility of the television world and picked up a job as a junior analyst (yeah, he's a closet math nerd) at a well established company that provides parts for the aircraft industry. 

They would hand him a series of cost analysis tasks and tell him this will take him a day or two to compile. He sits in his cubicle, looks over all the data, builds some macros in excel to move data from one spreadsheet to another and in about an hour has everything done. 

He hands it on to one VP that looks it over and says, amazing, I don't know what you did but this saves us money, time and makes it easier to track. Tell me more. 

The other VP says, I don't know what you did, do it the other way. 

He is back working in the television industry after that five month detour. 

  • Like 1

Share this post


Link to post
Share on other sites
nate    6,558
On 2/27/2017 at 11:47 AM, Blarg said:

My son got fed up with the volatility of the television world and picked up a job as a junior analyst (yeah, he's a closet math nerd) at a well established company that provides parts for the aircraft industry. 

They would hand him a series of cost analysis tasks and tell him this will take him a day or two to compile. He sits in his cubicle, looks over all the data, builds some macros in excel to move data from one spreadsheet to another and in about an hour has everything done. 

He hands it on to one VP that looks it over and says, amazing, I don't know what you did but this saves us money, time and makes it easier to track. Tell me more. 

The other VP says, I don't know what you did, do it the other way. 

He is back working in the television industry after that five month detour. 

I experience something along these lines basically every day

  • Like 1

Share this post


Link to post
Share on other sites
mrwicked    2,339
On 2/27/2017 at 9:47 AM, Blarg said:

My son got fed up with the volatility of the television world and picked up a job as a junior analyst (yeah, he's a closet math nerd) at a well established company that provides parts for the aircraft industry. 

They would hand him a series of cost analysis tasks and tell him this will take him a day or two to compile. He sits in his cubicle, looks over all the data, builds some macros in excel to move data from one spreadsheet to another and in about an hour has everything done. 

He hands it on to one VP that looks it over and says, amazing, I don't know what you did but this saves us money, time and makes it easier to track. Tell me more. 

The other VP says, I don't know what you did, do it the other way. 

He is back working in the television industry after that five month detour. 

He should move to software industry - we are all about more being more efficient. 

Share this post


Link to post
Share on other sites
Geoff    5,981

I spent all day doing pivots and vlookups ... finally had to close my work computer to get spreadsheets out of my head.   Come to AW to escape and see this thread.

Damn you, @Schildog!!!!

 

 

 

 

 

  • Like 1

Share this post


Link to post
Share on other sites
Brandon    4,894

I might take this up. I've never been tech savvy and want to build two simple excel spreadsheets to monitor fundings....maybe a ytd and mtd for pay periods. I used to have one and it was so basic that I may be able to just lookup a Youtube video or some guy at work has one that maybe I can tinker with. 

Share this post


Link to post
Share on other sites
nate    6,558

Somewhat related but I have been using SAS for analytics lately.  It is great for automating reporting and it can connect to just about every type of db there is so you can query multiple dbs pull whatever data you need and build reports or data extracts.  Then setup a cron job or windows task scheduler to automate it, including emails to the target audience with stats and links to the location of the saved report.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this