Cover: Getting started with Numbers - Remylent

Getting started with Numbers

Remy Lentzner(Author)

Remylent (Publisher)

Published on 21. February 2022

107 pages

E-Book

ePUB with digital watermarking

System requirements

978-2-490275-69-4 (ISBN)

€12.99incl. 7% vat

System requirements

for ePUB with digital watermarking

E-Book Single Licence

Available for download

Description

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

Save as PDF Copy link into clipboard