O'Reilly logo

Raspberry Pi For Dummies by Mike Cook, Sean McManus

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

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 ...

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