Subtitles of the Movie

Hey, welcome to chapter three in our look at iWork 2008. This is the one, this is the start of the look at the brand-new application called Numbers and this is a spreadsheet application, of course built to crunch numbers and otherwise compete with Microsoft's Excel spreadsheet application, which has been around for ages and which is a trusted friend to many of you who are working with spreadsheets day to day and this should look pretty familiar. As we get started with numbers, you can click on it if it's the icon that's on your dock or in your applications folder and like in the other two applications in the iWork 2008 suite, you should get the template chooser here and I'll show you where that is, but as we get started and we look at the Numbers window, let's click on a template here called travel planner and just to start to get a feel for what Numbers can do and how it does it different as far as crunching numbers and also using it in ways that you may not have considered before. So let's choose this travel planner and let iWork or let Numbers generate this template for us and there we go. We have three sheets here; an activity list, a reservations sheet and a packing list and these are all on the upper left-hand side. As you can see, this is where we keep track of the sheets that you will see in Numbers. If you just select the activities sheets for example, you will start to get a feel for what Numbers is capable of and you're looking at and you're like, are you kidding me? Is that a spreadsheet with all those pretty pictures and that nice font? And down here, indeed, are some cells where we can add text and then numbers and you can see right below the sheet section you get a styles column as well where you can start to immediately improve the look and feel of the spreadsheets that you'll generate. Now, once again, just like with our cousins, the Pages program and the Keynote program, whether or not that template chooser comes up can be set from the Numbers file and by clicking on preferences and there we are right here. So as we get started with this program, just keep in mind that when you add a new numbers document, you will see the template chooser unless you choose maybe a different template so you could choose that as your default and then click on ok. Now, when I create a new document, a new spreadsheet in this case, it will immediately create a new Hawaiian vacation 2008 activity list. So you can see up here this is the second entitled spreadsheet that I've opened up here. So I'll give that on a close here in the upper left-hand corner. Other than that, everything else should look fairly familiar if you've dealt with, again, the previous applications. You should see the standard toolbar here, a set of menus up here at the very top and we'll deal with all these of course as we go through. Over on the right-hand side, as you can see, the resolution is keeping this window fairly big right now, but again, I'll adjust that. You can see the inspector, the media colors and fonts just like we did in Pages and in Keynote. So these are the items here. The only differences that you'll see possibly are the sort and filter buttons here, the formula button here and the standard toolbar also comes in very handy, especially, of course, as you deal with numbers, which is the main purpose of Numbers. And so we'll continue to look at these things throughout our time with Numbers and you'll get a great feel for how not only to adjust these items in here, but how to build your own similar spreadsheets that will quite simply blow people away.