≡ Menu

Microsoft Excel

Excel is the most pervasive analysis tool in the business world today. Many use it, few have mastered it.

Click on the articles belowto learn everything you need to know about Excel to become an awesome analyst.

VLOOKUP

The Ultimate Guide to Excel VLOOKUP Mastery

PIVOT TABLES

The Comprehensive Guide to Excel Pivot Tables

SUMIF and COUNTIF

Everything analysts need to know about sumif and countif

EXCEL ERRORS AND HOW TO SOLVE THEM

How to fix the #NA error in your vlookups
How to fix the #VALUE error in your Excel formulas
How to fix the #DIV/0 error in your Excel formulas

EXCEL KEYBOARD SHORTCUTS

Part 1: Excel Keyboard Shortcuts: CTRL key
Part 2: Excel Keyboard Shortcuts: ALT key
Part 3: Excel Keyboard Shortcuts: fast formulas

OTHER FUN EXCEL TUTORIALS

Print margins, why you should set them and how to do it
Case Study: building a line chart
The 80/20 rule of Microsoft Excel