Resources in Microsoft Excel
10 min
A Beginner's Guide to Power Query, Power Pivot and Power BI
We demystify the differences between Power Query, Power Pivot, and Power BI and show you how they all work together.
15 min
How to Master Excel in 12 Steps
It's no secret that Excel is an essential skill. If you are ready to level up your skills, check out our guide on the steps needed to become a pro!
11 min
How to Make a Column Chart in Excel: A Guide to Doing it Right
Ready to wow your colleagues with some impressive graphs and charts? Then learn the in's and out's of Excel column charts with this handy guide!
17 min
How (and When) to Use ANOVA in Excel: The Ultimate Guide
Looking to improve your processes by running an analysis of variance? Learn how to run one and two-way ANOVA in Excel with this step-by-step guide!
11 min
9 Best Excel Skills for Accountants
Like most people, you're probably using Excel for accounting. If you want to maximize your efficiency then check out these top Excel skills for acc...
11 min
11 Best Excel Presentation Tips
Make not just professional but stunning spreadsheets with these 11 Excel presentation tips!
11 min
The Best Free Gantt Chart Template for Excel
Make your life a lot easier with this free Excel Gantt chart template! Download it now!
11 min
How to Create a Power BI Pie Chart
Want to make a Power BI Pie chart? Follow along with our step-by-step guide!
15 min
How to use PowerPivot in Excel: The Ultimate Guide
Learn how to use PowerPivot and take your data processing skills to the next level! We cover why and how to use PowerPivot with real business use c...
13 min
Power Query Tips: 10 Most Useful Commands
Check out these Power Query tips that will help you transform your data like a pro!
14 min
11 Best Excel Tips for Beginners
Getting started in the world of spreadsheets? Check out these essential Excel tips for beginners to level up your skills.
10 min
6 Advanced Pivot Table Techniques You Should Know
Up your Excel game with these advanced pivot table techniques.
10 min
Why You Should Be Using INDEX MATCH instead of VLOOKUP
Where the VLOOKUP is lacking, INDEX MATCH picks up the slack. Learn how INDEX MATCH can make your life that much easier.
12 min
Incredibly Useful Examples Of Excel User Defined Functions in VBA
Excel UDF give you more control of your spreadsheets. Check out our guide to create your own, including some handy Excel user defined function exam...
11 min
Advanced Excel Charts: What to Know to Take Your Charts Up a Notch
Interested in taking your spreadsheet skills to the next level? Check out our advanced Excel chart tutorial to find out how.
9 min
The Beginner’s Guide to Excel Charts
Follow our pain-free Excel chart tutorial to easily shape your data into a beautiful graph.
7 min
How to Create a Pivot Table in 5 Easy Steps
Need to sift through a lot of data fast? Our Excel Pivot Table tutorial shows you how to do it quickly and painlessly in 5 easy steps!
12 min
How to Create an Excel Dashboard in 7 Steps
In this step by step tutorial, we’re breaking down exactly how to create an Excel dashboard (with no stress or headaches required).
11 min
30+ Excel Business Templates for Workplace Productivity
To make your life easier, here are some of our favorite Excel templates for business to help boost productivity in the workplace. See all you can d...
9 min
The Beginner’s Guide to Excel Macros
Excel Macros might seem complicated. But learning to use them to your advantage is actually surprisingly simple. Learn how to use macros from scratch.