Getting started with Numbers E-Book

Rémy Lentzner

• Herausgeber: Remylent
• Kategorie: Wissenschaft und neue Technologien
• Sprache: Englisch
• Veröffentlichungsjahr: 2022

Seitenzahl: 59

Beschreibung

Welcome to Numbers, the spreadsheet application for Mac. This book is intended to anyone who wants to discover its possibilities and advantages. While learning how to perform simple calculations, you'll discover elaborate functions to work out complex results. 
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.

Leseprobe

REMY LENTZNER

Getting started with Numbers

French original title : Bien débuter avec Numbers

EDITIONS REMYLENT, Paris, 1ère édition, 2022

R.C.S. 399 397 892 Paris

25 rue de la Tour d’Auvergne - 75009 Paris

[email protected]

www.REMYLENT.FR

ISBN EPUB : 9782490275694

The Intellectual Property Code prohibits copies or reproductions intended for collective use. Any representation or reproduction in whole or in part by any means whatsoever, without the consent of the author or his successors in title or cause, is unlawful and constitutes an infringement, pursuant to articles L.335-2 and following of Intellectual Property Code.

This book is dedicated to Anna and Hélène.

I could not have written it without their support, advice, encouragements and proofreading.

Graphic illustration : Anna LENTZNER

In the same collection

Improve your PivotTables with Excel

Upgrading your skills with Excel

Improve your skills with Google Sheets

Programming macros with Google Sheets

Getting started with HTML

Getting started with JavaScript

Getting started with PHP & MySQL

Google Docs

Google Slides

Google Gmail

Macros & VBA with Excel

Getting started with WordPress

Getting started with Programming

Table of contents

Chapter 1 Fundamentals

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 2 Printing

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 3 Filters, 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 4 Enhanced 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 5 Charts

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 6 Shapes, 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

INTRODUCTION

Welcome to Numbers, the spreadsheet application for Mac. This book is entended to anyone who wants to discover its possibilities and advantages. While learning how to perform simple calculations, you'll discover elaborate functions to work out complex results.

You will be able to format tables and cells thanks to the properties panel. 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.

At the time of writing this book, the operating system is MacOs Big Sur.

This book is divided into 6 chapters.

Chapter 1 details the fundamentals of the spreadsheet: row and column management, cell formatting, layout of the work frame, keyboard shortcuts, calculations, formulas and comment management.

Chapter 2 covers printing and layout techniques when previewing data.

Chapter 3 describes filters and categories that enable you to group information.

Chapter 4 shows the elaborated functions: IF, VLOOKUP, IFERROR, INDEX/MATCH, COUNTIF, COUNTIFS, SUMIF, SUMIFS, some date functions including DATEDIF as well as the text functions.

Chapter 5 details the graphics you can insert.

Chapter 6 outlines shapes, media objects and pre-made table templates.

I hope this book will help you to work with Numbers better.

Please feel free to contact me at [email protected] if you have any comments or questions about this book.

I will be sure to answer you.

Enjoy your reading.

The author