If you don't know who the spreadsheet wizard is at your company, become that person. This works in almost any company regardless of field. Once there are some more lessons here, I can see it being a great resource.
This looks like a good start, but you pretty much need to get either Google Sheets or Excel into the browser window for the exercises. The half-working thing currently there just isn't going to cut it. It was very hard to work with.
I don't know what plans you have for future tutorials, but I would suggest using specific business use cases as scenarios and exploring them from a basic approach along to more advanced solutions where appropriate.
Good suggestion on the business use cases. I want the exercises to be realistic documents that you build up over the course of the lesson, not just interactive quiz questions.
Agreed, the Spreadsheet needs a lot of work. It's currently just an MVP to gauge interest.
Excel has no competitors today for serious use. Google Spreadsheet lacks analysis features, LibreOffice is laughable (can't even deduplicate rows).
If you want to teach serious spreadsheet use, don't waste any time on trying to compete with Excel. Just use it. If you really need to, figure out how to make interactive lessons as VBA macros. But teach real Excel.
Also 50% of using the potential of excel is learning the shortcuts (like any good IDE). Worth making a list of the most common things you do, google the shortcut, and adding it to a cheat sheet underneath your screen.
In my experience if you are a real Excel wizard you are close to irreplaceable and yes you can demand a very good salary. A lot of the business world runs on spreadsheets and being able to do some magic will make you a very popular person with management.
Investment firms value Excel so highly (and are so good at it, see this[1] amazing video that I saw on a previous HN thread of Martin Shkreli using Excel extremely effectively) that I'm sure they have internal training that is better than anything you can get outside.
Accountants pay very good money for Excel training, at least in Israel (I tried to compete with those courses by teaching Excel automation with Python, so I did some market research and customer development.)
Could you link to a specific moment where his Excel skills show? I have seen this video pop up from time to time and by clicking through the timeline all I ever see is him copying numbers from pdf's into Excel. Surely the whole "wizardry" aspect cannot just be the fact that he uses alt-tab and arrow keys instead of a mouse?
Basically all corporate functions rely on some excel experience.
Corp Finance or FP&A typically require advanced skills. Excel is basically half the value, the other half is business acumen. You need both to be valuable.
Yeah the problem with excel based processes isn't really reliability (not the least because they are built and maintained by users who understand the domain rather than programmers writing code on specs), but lack of automation.
It's also very inefficient. Sort of a push approach where if you change an input you need to recompute every single combination of outputs instead of just the one output you want, as opposed to code which has a pull approach, where you call your output and it recalculates the steps it needs for just that output.
And as soon as you get into something you would express as a loop, or loop of loops, excel starts to be really painful to use if hardly usable.
Comments
If you don't know who the spreadsheet wizard is at your company, become that person. This works in almost any company regardless of field. Once there are some more lessons here, I can see it being a great resource.
This looks like a good start, but you pretty much need to get either Google Sheets or Excel into the browser window for the exercises. The half-working thing currently there just isn't going to cut it. It was very hard to work with.
I don't know what plans you have for future tutorials, but I would suggest using specific business use cases as scenarios and exploring them from a basic approach along to more advanced solutions where appropriate.
Also, I really like the name.
Good suggestion on the business use cases. I want the exercises to be realistic documents that you build up over the course of the lesson, not just interactive quiz questions.
Agreed, the Spreadsheet needs a lot of work. It's currently just an MVP to gauge interest.
(edit: typo)
Excel has no competitors today for serious use. Google Spreadsheet lacks analysis features, LibreOffice is laughable (can't even deduplicate rows).
If you want to teach serious spreadsheet use, don't waste any time on trying to compete with Excel. Just use it. If you really need to, figure out how to make interactive lessons as VBA macros. But teach real Excel.
Also 50% of using the potential of excel is learning the shortcuts (like any good IDE). Worth making a list of the most common things you do, google the shortcut, and adding it to a cheat sheet underneath your screen.
Is there any money to be made on mastering Excel? Like are businesses ready to pay for Excel related services?
In my experience if you are a real Excel wizard you are close to irreplaceable and yes you can demand a very good salary. A lot of the business world runs on spreadsheets and being able to do some magic will make you a very popular person with management.
Investment firms value Excel so highly (and are so good at it, see this[1] amazing video that I saw on a previous HN thread of Martin Shkreli using Excel extremely effectively) that I'm sure they have internal training that is better than anything you can get outside.
Accountants pay very good money for Excel training, at least in Israel (I tried to compete with those courses by teaching Excel automation with Python, so I did some market research and customer development.)
[1] https://www.reddit.com/r/videos/comments/4df5il/martin_shkre...
Could you link to a specific moment where his Excel skills show? I have seen this video pop up from time to time and by clicking through the timeline all I ever see is him copying numbers from pdf's into Excel. Surely the whole "wizardry" aspect cannot just be the fact that he uses alt-tab and arrow keys instead of a mouse?
Basically all corporate functions rely on some excel experience.
Corp Finance or FP&A typically require advanced skills. Excel is basically half the value, the other half is business acumen. You need both to be valuable.
Many investment firms heavily rely on Excel
CRM administration for example. Excel mastery is generally the entry point into those teams (from my experience)
If you find a way to audit spreadsheets to find fraud and error you'd make a fortune.
Speadsheets are scary.
http://www.eusprig.org/2006/spreadsheets-in-clinical-medicin...
This spreadsheet "shaming" is getting tiresome. The sheer amount of spreadsheets means that more than a few mistakes will come to light.
Let's not forget the fMRI software with bugs. Was it done in Excel?
Sure, Excel has some problems. No, they are not even close to what is implied in HN threads like this one.
Yeah the problem with excel based processes isn't really reliability (not the least because they are built and maintained by users who understand the domain rather than programmers writing code on specs), but lack of automation.
It's also very inefficient. Sort of a push approach where if you change an input you need to recompute every single combination of outputs instead of just the one output you want, as opposed to code which has a pull approach, where you call your output and it recalculates the steps it needs for just that output.
And as soon as you get into something you would express as a loop, or loop of loops, excel starts to be really painful to use if hardly usable.