O'Reilly logo

Creating Spreadsheets and Charts in Microsoft Office Excel 2007 for Windows: Visual QuickProject Guide by Maria Langer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

3. build the budget worksheet

The primary element of our project is the monthly budget worksheet. This worksheet lists all of the income and expense categories with columns for budgeted amounts, actual amounts, dollar difference, and percent difference. It also includes subtotals and totals.

As you can see, an Excel worksheet window closely resembles an accountant’s paper worksheet. It includes columns and rows that intersect at cells. To build our budget worksheet, we’ll enter information into cells.

In this chapter, we’ll create the budget worksheet as shown here. (We’ll apply formatting to the worksheet so it looks more presentable later in this project.)

name the sheet

The sheet tabs at the bottom of the worksheet window enable you to identify ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required