
Getting started with Numbers
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
You will be able to format tables and cells thanks to the property panels. You will appreciate the filters to group information with categories. Numbers proposes lots of powerful features to print and to layout the sheets. Finally, you will discover graphics, shapes, media objects and templates.
ABOUT THE AUTHOR
Rémy Lentzner has been an IT trainer since 1985. Specialized in mastering office automation tools, he supports companies in the professional training of their employees. Self-taught, he has several computer books to his credit.
More details
Content
- Intro
- Chapter 1Fundamentals
- 1.1 Startup
- 1.1.1 Managing rows and columns
- 1.1.2 Equalizing rows or columns size
- 1.1.3 Actions with rows or columns
- 1.1.4 Creating and manipulating sheets
- 1.2 Formatting Cells
- 1.2.1 The default display with styles
- 1.2.2 Formatting a range
- 1.2.3 The grid
- 1.2.4 Coloring the cells
- 1.3 The different formats
- 1.3.1 The number format
- 1.3.2 The date format
- 1.3.3 The Tickbox format
- 1.3.4 The star rating format
- 1.3.5 The Slider format
- 1.3.6 The Steeper format
- 1.3.7 The Pop-Up menu format
- 1.4 Shortcuts to select cells
- 1.5 Copying values, dates or formulas
- 1.5.1 Copying Values
- 1.5.2 Copying dates
- 1.5.3 Performing a simple formula
- 1.5.4 Formulas with the $
- 1.6 Moving cells and tables
- 1.7 Calculations between several tables
- 1.8 The functions
- 1.9 Saving your work
- 1.10 Comments
- 1.10.1 Author name and color
- 1.10.2 Managing comments
- 1.10.3 Printing comments
- Chapter 2Printing
- 2.1 The print preview
- 2.2 The header and the footer
- 2.2.1 Adding a header or a footer
- 2.2.2 Inserting a page number
- 2.2.3 Modifying the Footer/Header size
- 2.3 Printing several pages
- 2.4 Printing ranges of cells
- Chapter 3Filters, categories and highlighting
- 3.1 Filters
- 3.1.1 Filtering on texts by the panel
- 3.1.2 Deactivating or removing a filter
- 3.1.3 A quick filter
- 3.1.4 Multi-column filters
- 3.1.5 The different filter rules
- 3.2 Categories
- 3.2.1 Setting up groups
- 3.2.2 Inserting a subtotal in the category
- 3.2.3 Deleting a category
- 3.2.4 Counting elements in a category
- 3.2.5 A Category by date
- 3.2.6 Multiple Categories
- 3.3 Conditional highlighting
- Chapter 4Enhanced functions
- 4.1 The IF function
- 4.1.1 The operators with IF
- 4.1.2 An IF function with an AND operator
- 4.1.3 An IF with a date
- 4.2 The VLOOKUP function
- 4.2.1 VLOOKUP for a scale
- 4.2.2 VLOOKUP with several sheets
- 4.2.3 The IFERROR function
- 4.2.4 One IFERROR and two VLOOKUP
- 4.2.5 VLOOKUP with a wildcard character
- 4.3 The INDEX/MATCH binomial
- 4.4 The COUNTIF and COUNTIFS functions
- 4.4.1 Counting with one criterion
- 4.4.2 Counting with several criteria
- 4.5 The functions SUMIF and SUMIFS
- 4.5.1 SUMIF with a condition
- 4.5.2 SUMIFS with several conditions
- 4.5.3 SUMIF with dates
- 4.6 Date functions
- 4.6.1 Extracting parts of a date
- 4.6.2 Comparing two dates with DATEDIF
- 4.7 The text functions
- Chapter 5Charts
- 5.1 Creating a Chart
- 5.1.1 A column 2D chart
- 5.1.2 Adding a trendline
- 5.1.3 Adding value labels
- 5.1.4 Other 2D graphics
- 5.2 Some 3D charts
- 5.3 Interactive graphics
- 5.4 The chart icon
- Chapter 6Shapes, media and templates
- 6.1 Inserting shapes
- 6.1.1 Lines
- 6.1.2 Shapes
- 6.1.3 Inserting an image into a cell
- 6.2. Media files
- 6.2.1 Inserting an audio file
- 6.2.2 Inserting an existing video file
- 6.3 Templates
- 6.3.1 The Personal Budget template
- 6.3.2 The Invoice template
System requirements
File format: ePUB
Copy protection: Watermark-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Use a reading software that can process the file format ePUB: e.g., Adobe Digital Editions or FBReader – both free (see eBook Help).
- Tablet/Smartphone (Android; iOS): Before downloading, install the free app Adobe Digital Editions (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePUB works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Watermark-DRM, a „soft” copy protection. This means that there are no technical restrictions to prevent illegal distribution. However, there is a personalised watermark embedded in the eBook that can be used to identify the purchaser of the eBook in the event of misuse and to provide evidence for legal purposes.
For more information, see our eBook Help page.