Sign in to follow this  
Schildog

Excel Help Offered

10 posts in this topic

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.

Share this post


Link to post
Share on other sites

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. 

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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

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

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  


  • AngelsWin.com Ad-free Membership Options