Managing Your Budget in LibreOffice Calc
LibreOffice Calc is a spreadsheet application, similar to Microsoft Excel. A good way to try it out is to open one of your Excel spreadsheets using it. Your formulae should work fine and the cell formats should carry over. The interface is similar to LibreOffice Word, with icons you can roll the mouse pointer over to find out what they do. Figure 6-3 shows Sean’s holiday budget in LibreOffice Calc. We’ve used the slider at the bottom of the screen to magnify the content so it’s easy for you to read.
We don’t have room to provide an in-depth guide to spreadsheets here, but we can show you how to work out a simple holiday budget.
A spreadsheet is basically a grid of information, but it’s powerful because you can use it to perform calculations using that information. The boxes on the spreadsheet are called cells. To enter information into a cell, you just click it and then type what you want to enter. Alternatively, you can click a cell and then type into (or edit the contents of) the formula bar at the top of the screen, which is indicated in Figure 6-3.
Each cell has a grid reference, taken from the letter at the top of its column and the number on the left of its row. The top-left cell is A1, and the next cell to the right is B1, and the one below that is B2, as you can see in Figure 6-3.
To start with, enter a list of the different expenses you’ll incur, working your way down the screen in column A. Beside each item, in column B, enter ...