Important Disclosure: Please Read Before Proceeding
Some of the links below are affiliate links, which means that if you choose to make a purchase, I will earn a commission. This commission comes at no additional cost to you. Please understand that I have experience with all of these companies and I recommend them because they are helpful and useful, not because of the small commission I make if you decide to buy something. Please do not spend any money on these products unless you feel you need them or that they will help you achieve your goals.
Featured Resource
Storytelling with Data by Cole Nussbaumer Knaflic
Storytelling with data changed my perspective on how to communicate visually with decision makers at work. If you’re looking for a step-by-step book for creating charts in Excel, this isn’t the book for you. Instead, Cole gives you a framework for how to clearly and concisely communicate through data visualization, using well researched physchological principles as the backdrop. She presents the first version of a data visual, explains why it could be confusing or even misleading, then applies her princples. Every iteration of the data visual becomes clearer and tells a more compelling story. Best of all, this book won’t put you to sleep as it’s written in a way that’s fun and engaging.
Browse our other resources by category:
Charts & Dashboards
SWD Book
Storytelling with data changed my perspective on how to communicate visually with others at work. This book provides a clear framework for how to present data visualizations, using well researched physchological principles. One of the best books I’ve read on this topic.
Other Levels Excel Dashboard Templates
Don’t have the time or design chops to put together a visually appealing dashboard in Excel? No problem! Other levels provides pre-made, visually stunning Excel templates that are sure to get people’s attention.
Dashboards & Power BI Course
If you are creating reports and dashboards in Excel and struggling to figure out an efficient way of updating and sharing your reports, then Power BI is the way to go. This course teaches you all you need to know as quickly as possible. Video modules are short and straight to the point, and it
VBA & Macros
The VBA Pro Course
This is one of the best VBA courses I’ve come across. Videos are short and sweet, the modules are engaging and you learn by practing the lessons, which includes robust exercises. VBA can get overwhelming, but the course gives you information in bite-sized chunks to ensure you don’t get lost.
VBA Programming Course on Skillshare
Alan Jarvis has over 30 years of experience and is known for delivering lessons in a clear and concise manner. Many of his students don’t have any prior VBA experience. Check the course out by following the link below and get a month of Skillshare for free.
Excel VBA For Dummies
If you prefer to read through lessons at your own pace (or would like some written material to reference back to while you’re working), this is the best book out there. It’s well written with step-by-step materials, and everything is easy to look up during those moments where you want to get a refresher.
Other Excel Tools & Resources
Pivot Table Course
Pivot Tables are an essential part of any Excel user’s arsenal, no matter the profession. Pivot tables allow you to analyze data quickly reveal meaningful insight in a matter of seconds. If you’re like me you learn by doing, and Chris Dutton’s course on Pivot Tables is one of the best out there (he also has another course for more advanced users). Check the course out by following the link below and get a month of Skillshare for free.
Excel Elevate
Excel Elevate is one of the most comprehensive online Excel programs out there, covering all topics such as Advanced Formulas, Navigation Shortcuts, Data Tables, Power Query, Pivot Tables, Macros, and everything else in between. The lessons are straight to the point and easy to follow, and the course includes detailed case studies, Q&A Forums, and even an email script you can send your employer to help with getting reimbursed for the program. It’s the fastest way to go from beginner to Excel guru.
Able Bits
There’s no sense in wasting time in Excel anymore, speed yourself up with Ablebits! These toolsets allow you to perform manual tasks in a blink of an eye. Merging and comparing sheets, performing calculations across multiple workbooks, splitting tables or cell values, deduplicating your data set, and more. I’ve used these tools personally and they have saved me so many hours of manual work, they’re truly a lifesaver!
Miscrosoft Office 365
You can’t learn Excel without having a copy installed on your computer, right? At least this way, you don’t have to use your work computer to practice 😉
Join Over 10,000 Readers
I’ll send you my best Excel tips, hacks, and exclusive content. My tutorials are straight forward and easy to follow.