ExcelFrog Clear Excel Tutorials

home about

Clear & Free Tutorials on Microsoft Excel

You are using Microsoft Excel at your job, but you don't know all the tips and tricks of the software. Really understanding Excel is a great way to be more efficient, impress your boss, or even get a promotion!

ExcelFrog.com is full of high quality tutorials that are short and up-to-date. Enjoy :-)

Note: if you are looking for a freelancer to build a custom financial model for your business, I'm available. Learn more here.

Basics

• Learn the basics in just 11 gifs ← start here
• How to format your data in 60 seconds
• Awesome things you can do with the fill handle
• Three features to handle a spreadsheet full of data
• Seven tips to be more efficient

Important Knowledge

• The must-know Excel settings to customize | Part 1
• The must-know Excel settings to customize | Part 2
• Why you should start using the table feature
• Make your data visual with conditional formatting
• Compute the percentage change between 2 numbers
• Six common errors and how to fix them
• Everything you need to know about cell references (coming soon)

Functions

• Discover how to use functions
• Understand IF, nested IF, and IFS functions
• Master the power of the VLOOKUP function
• Use INDEX MATCH to perform advanced lookups new
• How and when to use the four COUNT functions
• Five important functions to handle texts (coming soon)

Data Analysis & Modelling

• The what if analysis with goal seek
• The what if analysis with data table
• How to do problem solving modelling the right way new
• Financial modelling for a real estate investment new

Resources

• The best forums to ask questions
• The best blogs to learn new things

New tutorials are added weekly!