iWork - Numbers

Bookboon, 2012. — 62 p. — ISBN: 978-87-403-0073-4 We all need to use productivity software for word processing, to reconcile budgets, or to make presentations. Apple users have the option to use iWork software, from Apple, to perform these tasks. This is one of three guides that explore the essential features and functions of one of the three applications that make up the iWork Suite. This guide investigates Numbers for Apple’s OSX. Numbers is a spreadsheet application, and this guide illustrates organising data, managing lists, creating tables and charts, working with data tables and calculations, and how to import, modify and export Microsoft Excel spreadsheets. Opening Numbers Overview of the Numbers Interface Adjusting Images Working With Sheets Working With Tables Cell Formats Importing Data Calculations Design Formatting Charts Sharing Work Conclusion Content 1. Opening Numbers 1.1. Choosing The Right Template For The Job 1.2. Exploring the Personal Finance Templates 2. Overview of the Numbers Interface 2.1. The Number’s Interface 2.2. The Tool Bar 2.3. Customising the Tool Bar 2.4. The Format Bar 2.5. The Sheets Pane 2.6. Styles Pane 2.7. The Inspector 2.8. Text and Graphics 2.9. The Media Browser Adjusting Images Framing Images Working With Sheets Renaming And Adding Sheets Organising the Sheet Pane Working With Tables The Anatomy Of A Table Formatting A Table Cell Formats Manually Formatting Cell Navigating from Cell to Cell Series Customised Series Data Sorting Data In A Table Organising Data With Categories Using Checkboxes, Steppers, and Sliders Freezing Header Rows And Columns Importing Data Importing Excel Spreadsheets Using Address Book Cards Calculations Formula Editor Operators Functions Performing Calculations With Variables Referencing Multiple Sheets And Tables Referencing Data; Relative and Absolute References Design Formatting Using Table Styles Modifying and Saving Table Styles Print Setup Charts Column And Stacked Column Charts Bar And Stacked Bar Charts Pie Charts Line Charts Area And Stacked Area Charts Scatter Charts Sharing Work Printing from Numbers Exporting spreadsheets from Numbers Publishing with iWeb Conclusion Sisältö Opening Numbers Choosing The Right Template For The Job Exploring the Personal Finance Templates Overview of the Numbers Interface The Number’s Interface The Tool Bar Customising the Tool Bar The Format Bar The Sheets Pane Styles Pane The Inspector Text and Graphics The Media Browser Adjusting Images Framing Images Working With Sheets Renaming And Adding Sheets Organising the Sheet Pane Working With Tables The Anatomy Of A Table Formatting A Table Cell Formats Manually Formatting Cell Navigating from Cell to Cell Series Customised Series Data Sorting Data In A Table Organising Data With Categories Using Checkboxes, Steppers, and Sliders Freezing Header Rows And Columns Importing Data Importing Excel Spreadsheets Using Address Book Cards Calculations Formula Editor Operators Functions Performing Calculations With Variables Referencing Multiple Sheets And Tables Referencing Data; Relative and Absolute References Design Formatting Using Table Styles Modifying and Saving Table Styles Print Setup Charts Column And Stacked Column Charts Bar And Stacked Bar Charts Pie Charts Line Charts Area And Stacked Area Charts Scatter Charts Sharing Work Printing from Numbers Exporting spreadsheets from Numbers Publishing with iWeb Conclusion Innhold Opening Numbers Choosing The Right Template For The Job Exploring the Personal Finance Templates Overview of the Numbers Interface The Number’s Interface The Tool Bar Customising the Tool Bar The Format Bar The Sheets Pane Styles Pane The Inspector Text and Graphics The Media Browser Adjusting Images Framing Images Working With Sheets Renaming And Adding Sheets Organising the Sheet Pane Working With Tables The Anatomy Of A Table Formatting A Table Cell Formats Manually Formatting Cell Navigating from Cell to Cell Series Customised Series Data Sorting Data In A Table Organising Data With Categories Using Checkboxes, Steppers, and Sliders Freezing Header Rows And Columns Importing Data Importing Excel Spreadsheets Using Address Book Cards Calculations Formula Editor Operators Functions Performing Calculations With Variables Referencing Multiple Sheets And Tables Referencing Data; Relative and Absolute References Design Formatting Using Table Styles Modifying and Saving Table Styles Print Setup Charts Column And Stacked Column Charts Bar And Stacked Bar Charts Pie Charts Line Charts Area And Stacked Area Charts Scatter Charts Sharing Work Printing from Numbers Exporting spreadsheets from Numbers Publishing with iWeb Conclusion We all need to use productivity software for word processing, to reconcile budgets, or to make presentations. Apple users have the option to use iWork software, from Apple, to perform these tasks. This is one of three guides that explore the essential features and functions of one of the three applications that make up the iWork Suite. This guide investigates Numbers for Apple’s OSX. You can download the book via the link below. Numbers is a spreadsheet application, and this guide illustrates organising data, managing lists, creating tables and charts, working with data tables and calculations, and how to import, modify and export Microsoft Excel spreadsheets. You can download the book for free via the link below. This is one of three guides that explore the essential features and functions of one of the three applications that make up the iWork Suite. This guide investigates Numbers for Apple’s OSX. You can download the book for free via the link below.