Excel Tips

  • How to Use the Goal Tracking Meter

    This post provides detailed instructions on how to use the Goal Tracking Meter.

  • How to Use the Basic Weekly Planner

    Read below for instructions on using the Basic Weekly Planner.

  • 10 Free Weekly Schedule Templates for Excel

    Want a weekly schedule for Excel but don’t know where to begin? Lucky for you I’ve combed through the internet to find the best free weekly schedules and planners out there. These are the best in my opinion for various reasons, which I’ve described below. Each of these are also very user-friendly, and pretty looking. […]

  • How to Use the Easy Budget Spreadsheet

    So you’ve followed my tutorial on making an easy budget spreadsheet. Fantastic! Now you just need to understand what you’ve just made . For some of you, especially if you’ve used the Super Starter Budget before, this template will be very intuitive and you might not need these instructions at all. For others, here […]

  • 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 […]

  • Simple Tips for Creating Outstanding Column Charts in Excel

    Excel is known for its chart making skills; however, users still have difficulty creating amazing column charts using Excel. Here are some tips for making your task easier. Note that the rules given here can be applied to bar charts as well. Start at Zero That sounds simple enough. When you start a column chart […]

  • Exciting Charting Features of Excel 2013

    Excel 2013 boasts of several new charting features that will enhance your productivity. The best thing about Excel 2013 charts is that you can make them with a few clicks. This is a major improvement over previous versions because making charts using Excel used to take lots of time and specialized knowledge. Also, Excel 2013 […]

  • 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 […]

  • Summing Based on Multiple Criteria

    In the last post I showed you how to use SUMIF, which let’s you subtotal based on a specific single criterion. You can also subtotal based on multiple criteria with a very similar, but much more powerful function called SUMIFS. SUMIFS SUMIFS is structurally similar to SUMIF, but you put your sum range in the […]

  • Summing Based on a Specific Criterion

    If you read my last two posts on COUNTIF and COUNTIFS, you might wonder if, instead of just counting, you could add something based on specific criteria. Well, you can, with SUMIF! SUMIF With SUMIF, you can quickly create subtotals based on a single criterion. For instance, say you have bunch of spending data for […]

  • Counting Based on Multiple Criteria

    Last week we talked about the COUNTIF formula and how you could use it to count rows based on a single criterion. But what if you wanted to count rows based on multiple criteria? If you haven’t guessed already, the answer is with COUNTIFS! COUNTIFS COUNTIFS is a function that counts data based on multiple […]

  • Counting Based on a Specific Criterion

    Do you know there is a really fast and easy way to count rows that meet specific criteria? For instance, if you have over a hundred rows of spending data, like the hypothetical data below, how can you quickly find out how many times you bought something in the month of October? The answer is, […]