Archive | Intermediate

Pivot Tables in 5 Minutes

Never used pivot tables before in Microsoft Excel and want to learn how? Look no further because in this short article, we are going to show you how to create your first pivot table in less than 5 minutes. Step 1: Assuming the data you want to pivot has column headers (this is a requirement), […]

Continue Reading 1

How to Make an Easy Budget Spreadsheet

In this tutorial, I will show you how to make a super easy budget spreadsheet in Excel. You just need to have basic to intermediate Excel skills to make this incredibly helpful personal finance tool. Use it every month to see where all your money’s going! When you’re done, you will have a beautiful, fully […]

Continue Reading 2

What Every Experienced Excel User Should Know

They say Excel users fall into two groups: Those who draw tables in Excel, and those who surprise their colleagues with amazing charts of data analysis functions. If you are the latter type, here are some tips that you absolutely must know. VLOOKUP Got data scattered across different workbooks and sheets? VLOOKUP will help you […]

Continue Reading 0