Learning advanced Excel functions and macros helped advance my career...

You’ve probably found your way to this blog from a Google search, or maybe a friend passed it along to you. Either way, I’m happy you’re here. I wrote this guide because when I was in a time of desperate need, not too long ago, becomming super profficient with Excel helped advance my professional career.

I was working as a new mechanical engineer at a struggling company where everyone else at my company was much more experienced than I was. I realized that made me expendable. When the economy took a turn for the worse, and coworkers began getting laid off, I feared for my job and my family’s future. I needed a way to set myself apart to prove my value to the team. Learning how to write VBA macros in Excel gave me a huge advantage over my coworkers. Additionally, once I was able to create Excel macros I was able to apply that knowledge to other software, such as CAD systems, which helped to quickly earn my colleague’s respect, leading not only to me keeping the job but also to quicker promotions, along with more job freedom and flexibility. Not only did it help me bounce back from a low point but it opened my eyes to the world of automation and the opportunities that it can create for anyone's career. And if I can do it then you can too!

Excel Spreadsheets Help is my way of giving back for all of the fortunate things that have happened to me ever since. This Excel blog is a guide, and the purpose of this guide is to do just that – guide you. If I can help just one person learn one thing that will help them in their career and/or life, all the time and effort I have put into writing these Excel tips will have been totally worth it! If at any point while you’re reading any of my articles and you have any questions, please don’t hesitate to contact me. Even if you don’t have any questions, I’d love for you to come by and say hello!

Why Use Excel?

With its wide variety of extreme uses, Microsoft Excel is the Swiss Army Knife of software tools. From a hand-made quilt designer to a 3D graphics engine, Excel is one of the most versatile and user friendly programs around. It doesn't matter what your skill level is - anyone can learn to use Excel! See a wide variety of uses for Excel on my Downloads page where you can download my Excel spreadsheet templates.

One Way to Use this Blog

A reader recently told me my Excel tips are great but when you don’t need to use them for a long period of time they are easily forgotten. My response to her was I don’t remember specific formulas either. I like to use what’s called Just In Time (JIT) learning. It’s one of the reasons I created this blog as well. I may not remember a specific function or formula but I do remember I wrote a blog post about it so now I just have to find that blog post. If you see an Excel tip you think is cool, useful, and will save you time in the future but may not necessarily need right now then bookmark the post and come back to it later.

Pinterest is a great tool for doing this. Create a board called Excel and pin each of my tips you think you might need in the future. Be sure to add a good description when you pin it so you can search for the post when needed. Or simply follow my Excel board here where I pin each and every one of my own posts as well as others I find useful.

If you're just getting started check out this post, 20 Excel shortcuts you need to know (number 15 is my favorite).

Get Updates in Your Inbox

Please feel free to subscribe to my email newsletter below to get notifications when I add something new as well as to get exclusive Excel formula and macro tips that you cannot find here on the site. As a thank you for signing-up I'll give you free access to my master project management template.

Subscriber Counter

If you can't get enough Excel info, check out my Resources page for other related Excel tools I use on a daily basis. Thank you for taking the time to read this, and I hope to see you on the blog sometime soon!