Notice: Undefined index: order_next_posts in /nas/content/live/gadgetmag/wp-content/plugins/smart-scroll-posts/smart-scroll-posts.php on line 194

Notice: Undefined index: post_link_target in /nas/content/live/gadgetmag/wp-content/plugins/smart-scroll-posts/smart-scroll-posts.php on line 195

Notice: Undefined index: posts_featured_size in /nas/content/live/gadgetmag/wp-content/plugins/smart-scroll-posts/smart-scroll-posts.php on line 196
News

Tutorial: Budget your holiday spending using Numbers on Mac

Use simple tables in Numbers to budget how much money you have to spend on holiday

Main Image

Information Panel
Main ImageWith summer already  just a few months away again, many of us will already have our holidays planned out for next year. Whether you travel abroad or holiday at home, the majority of us will also be spending sleepless nights worrying about the accumulative cost of taking a break, from the cost of food and transport to the cost of day trips, activities and the temptation of local markets. Numbers is the perfect application to keep track of things that you need to budget for and for items that may already have been included, such as airport transfers or day trips. We’ve used simple tables and a pie chart to make a holiday hassle free.

Header Bar

Step 1

1: Travel Planner
Open Numbers and double-click on a template from the template chooser. We’ve selected the very topical Travel Planner.

Step 2

2: Naming
Rename the document and save it. You can replace the images to make it more personal by dragging photos from the Media Browser.

Step 3

3: Delete
Select the existing information by clicking on the bottom-left corner of the table; hold down the Shift key and select the top corner, then hit Delete.

Step 4

4: Input
Click on each field and type to input your data. We have divided our rows into a day-by-day expenditure, and columns by activity and costs (paid and due).

5: Format
To format your data as currency, select the relevant column and hit the pound icon at the top of the interface. Change the currency using the Cells Inspector.

6: Totals
With the column selected, head down to the bottom- left side panel to see the total sum, average, minimum and maximum spend.

7: Sums
Head up to the Tables menu and select Sums. We’re creating a table to divide our budget up by item. We’ve used three columns: food, activities and shopping.

8: Adding up
Add each expenditure for food to see the total bill at the bottom. Click on the bottom corner and drag down or across to add more rows and columns.

9: Create a chart
When you’ve filled in the table, select it and go to the Chart menu at the top of the interface. Choose a chart you like and your data will automatically be included.

Click Image to Enlarge


×