Most of us have heard about or used Microsoft Excel, now let us introduce you to Apple's impressive alternative: Numbers ’09. In this course we will show you how you can import and export your Excel documents, how to organize your project into flexible sheets and tables from templates, how to work with formulas, and even how to add charts and graphs. Numbers ’09 is a great way to add a some power and creativity to your spreadsheets
Intermediate
With the basics of the interface under our belt, lets dive in and learn how to format text, graphics, numbers, and cells. We'll show you how you can use conditional formatting to bring attention to specific cells with shadings, fills and borders, and we'll learn how to add photos and movies to our spread sheet. In this course you’ll also explore multi tasking capabilities and how to manage multiple tables on one sheet, and even sort and filter data to give you a variety of options about how to display your projects.
Advanced
Now that you’ve gotten comfortable with Numbers ’09, we’ll delve into some of the special features that Microsoft Excel lacks. With Numbers ’09 we can include check boxes, steppers, sliders, and pop-up menus. In this course we'll show you how it all works behind the scenes. You’ll create and manage custom formulas that reference other sheets, and learn how to create and utilize your own style sheets to create quick and custom templates. We’ll also show you how to manipulate your graphs for optimal impact, and how to add comments to a project for later review and editing, and even how to share online with iWork.com
Numbers Overview
Introducing Numbers ’09, the spreadsheet program you’ve been waiting for. Innovative, powerful, and intuitive, Numbers ’09 lets you do everything from setting up your family budget to completing a lab report, and creating detailed financial documents.
New and intelligent tables with categories allow you to easily create multiple resizable and functional spreadsheets on a flexible canvas. Move advanced and stunning 2D and 3D charts and graphs wherever you’d like to support and enhance your data.
Easy formula lists with drag and drop functionality for over 250 functions help you analyze and sort your data with ease like never before.
Import and export your data to Excel and PDF formats, and with interactive print views, you can scale and arrange your spreadsheets and projects exactly as you like.
Customizable Templates are auto formatted with formulas and designed with presentation in mind.