Juggling Your Finances: Basic Excel Primer: Juggling Your Finances

Also by M.L. Humphrey

Budgeting for Beginners

Budgeting for Beginners

Excel for Budgeting

Excel Essentials

Excel for Beginners

Intermediate Excel

50 Useful Excel Functions

Easy Excel Essentials

Pivot Tables

Conditional Formatting

Charts

The IF Functions

Formatting

Printing

Word Essentials

Word for Beginners

Intermediate Word

PowerPoint Essentials

PowerPoint for Beginners

Writing Essentials

Writing for Beginners

Excel for Writers

Achieve Writing Success

Self-Publishing Essentials

Excel for Self-Publishers

AMS Ads for Authors

CreateSpace for Beginners

ACX for Beginners

Juggling Your Finances: Basic Excel Primer

M.L. Humphrey

Contents

Introduction

Understanding Some Excel Basics

Addition Overview

Addition Examples

Subtraction Overview

Subtraction Examples

Multiplication Overview

Multiplication Examples

Division Overview

Division Examples

Excel Formatting and Navigation Tips and Tricks

Conclusion

About the Author

Copyright

Introduction

The purpose of this pamphlet is to discuss how to use Excel for basic budgeting calculations. If you're a little rusty on basic math (addition, subtraction, multiplication, and division) then read Juggling Your Finances: Basic Math Primer first.

This pamphlet will walk through the same calculations as that primer, but talk about how to use Excel to make the calculations as opposed to a calculator.

If you're familiar with Excel or don't plan on using it for budgeting, then you don't need to read this primer.

The primer will walk through how to do the following calculations in Excel.

Addition:

Total income.

Total expenses.

Total balance in your accounts if you have multiple accounts.

Total amount you owe if you have more than one credit card, loan, etc.

Subtraction:

How much money will be left over after you pay your bills.

Your net worth or liquid net worth. (In other words, how much you'd be worth if you sold everything you own and paid off everything you owe. The first one, net worth, is how much you're worth in theory, the second one, liquid net worth, is how much you're worth in reality.)

How much of a shortfall you might have if you're spending more than you earn.

Multiplication:

How much you'll earn when you know the rate you'll be paid per hour or task.

Your net earnings (how much you actually take home) from your gross earnings (how much you earn before taxes are taken out).

Your annual earnings or expenses based upon one month's earnings or expenses.

Division:

How much you earn or spend on average.

How many hours you need to work to earn a certain gross amount.

How much you need to gross in order to take home a certain net amount.

How many months of expenses you can cover with the current amount of cash you have in the bank.

In order to make it as easy as possible to learn the basics of using Excel for addition, subtraction, multiplication, and division, the main chapters focus only on how to do those mathematical computations. However, if you work in Excel to any great extent you will quickly find that you need to perform a number of other tasks such as widening columns, bolding text, and formatting text.

The Tips and Tricks chapter at the end covers these other functions in Excel. You'll likely refer to it often as you work through this pamphlet and when I use a trick that's covered in that section I'll let you know.

This will probably seem pretty daunting at first, but just keep working with it and practicing and you'll quickly be able to perform any computation you want in Excel with ease.

As I mentioned in the Basic Math Primer, it's a really, really good idea to be comfortable enough with math that you can at least judge whether an answer makes any sense or not. A spreadsheet is only as good as the person creating and using it. If you put in the wrong information or set up a formula wrong, you will get a wrong answer.

Excel is just a tool and you need to know enough to understand when the tool isn't working properly.

Okay, enough of that.

Ready?

Let's get started.

Understanding Some Excel Basics

Before we start, I want to make sure we're using the same terms.

This is what Excel looks like when I first open it.

I'm working in Excel 2007, which is VERY different from earlier versions of Excel in terms of how it looks. Your basic math functions are pretty much the same, but the menus up top are completely different. If you're working in an earlier version and just now trying to learn Excel, I'd recommend that you upgrade your version of Excel. They're different enough that you really don't want to have to learn the newer version later.

But I'll