Excel for Busy PeopleAwesome Excel content for all skill levels.
Recent Excel Posts
Beginner Excel Tips to Advance Your Professional Career
Introducing a non-intimidating, beginner Microsoft Excel course. Learn to solve problems in this beginner Excel crash course. Now available on Udemy. Update: the course link has been removed from this post. I will be publishing this course to YouTube. If you've ever...
Excel 2016 Quick Reference Laminated Cards
I present to you, quick Excel 2016 spreadsheet knowledge in laminated guide goodness. Of course you can make these yourself but they are cheap enough pickup and keep near your workstation. Microsoft Excel 2016 Introduction Reference Card (instructions, tips, and...
Excel Curriculum by Difficulty
The beginner’s guide to Excel is available now! The curriculum the next intermediate version is done. Let me know if I should finish and release it.
I also have enough material to make the curriculum of the final advanced version. Also let me know if I should work on it more. This part is my favorite as this one has the potential to make you a boat load of money. It involves tricks taught by MBA programs and used in companies around the world.
Beginner tips to start using Excel strategically.
- Interface and ribbon walkthrough.
- Math and stat functions.
- Other important functions for beginners.
- Function libraries.
- References and range names.
- Calculations and subtotals.
- Auditing and error correction.
How to use and manage data effectively.
- Reformatting data and flash fill.
- Using lookups and indexes.
- Using charts, graphs, and pivot tables.
- Turning rows of data into maps.
- Personal finance project exercises – debt payoff calculator, rule of 72, etc.
- Extra tips for using Excel (get rid of empty rows).
Using Excel for modeling and other business purposes.
- Dashboarding – include debt info or risk analysis in a dashboard.
- Modeling and decision making.
- Risk equations and other statistical functions.
Excel Application Links by Store
The first three links will take you to the free Excel applications at their respective platform. The last link to Amazon is an affiliate link to buy the Office 365 platform (highly recommended).