Resources
7 min
VLOOKUP Exact Match & Approximate Match
Learn one of Excel's most useful functions: VLOOKUP exact match and approximate match.
12 min
VBA Variable Types in Excel
Learn what a variable is, why they are important, and understand how to use the different VBA variable types in Excel.
8 min
7 Best Google Docs Add Ons
Check out these fun and handy Google Docs add ons to increase your productivity. These useful, time-saving, and fun add ons can transform your simp...
9 min
How to Remove Blank Rows in Excel
Avoid data errors by learning how to remove blank rows in Excel the right way.
6 min
Mixed References in Excel - a Beginner's Guide
Learn all about the mixed reference Excel feature in this beginner's guide.
10 min
Project Quality Management: The Ultimate Guide
Learn about project quality management to help enable the highest quality in the delivery of your projects.
6 min
Relative References in Excel - A Beginner's Guide
Learn all about the relative reference Excel feature in this beginner's guide.
2 min
Excel Challenge 2: Clean and Transform Data with Power Query
Ready for some fun with Power Query in Excel? Try your hand at solving this Excel challenge from Excel MVP Alan Murray (aka. Computergaga) now!
24 min
Excel VBA Code Library - Useful Macros for Beginners
Automate your Excel tasks with ready-made code from our VBA code library.
22 min
16 Best IDE for Web Development
Learn about the best IDE for web development, their pros, their cons, and their top features.
6 min
Absolute References in Excel - A Beginner's Guide
Learn all about the absolute reference Excel feature in this beginner's guide.
9 min
The RACI Matrix (Free Template Included)
Find out what the RACI matrix is, learn how to create one, and get your free template.
13 min
17 Best Microsoft Teams Integrations
Discover some of the best Microsoft Teams integrations to help you supercharge communication in your team.
10 min
12 Best Practices in Dashboard Design
Learn what a dashboard is, the different types, and the best practices in dashboard design.
10 min
How to Send an Awesome Follow Up Email After a Job Application
Want to land that dream role? Find out when and how you should send a follow up email after job application.
7 min
How to Use Wildcard Characters in Excel
Learn how to use wildcard characters in Excel to save time when working with formulas.
12 min
XLOOKUP vs VLOOKUP in Excel - What's the Difference?
XLOOKUP vs VLOOKUP! What is the difference between VLOOKUP and XLOOKUP? And which one is better? You be the judge. Includes a video and practice file.
40 min
7 Python Code Examples for Everyday Use
Get familiar with some useful Python code examples to polish your development skills.
2 min
Excel Challenge 1: Use Raw Data to Create Dynamic Reports
Think you’re pretty good at Microsoft Excel? Prove it by solving this Excel challenge from Excel MVP Alan Murray!
8 min
HLOOKUP vs VLOOKUP: A Beginner's Guide
It's the battle of the lookups - this time it's HLOOKUP vs VLOOKUP. Which will win?