Take Control of Numbers

✍ Scribed by Sharon Zardetto

• Publisher: alt concepts inc.
• Year: 2021
• Tongue: English
• Leaves: 282
• Edition: 3
• Category: Library

✦ Synopsis

Work quickly, confidently, and effectively in Apple’s Numbers app!
Version 3.0, published September 23, 2021

Work quickly, confidently, and effectively in Numbers 11 with Sharon Zardetto’s detailed instructions. Input, calculate, sort, filter, format, and chart your data with ease as you learn not just the basics but also special tricks and power-user features.

There are many benefits to using Apple’s Numbers app, which is free for all Mac users. If you’ve ever wanted to add to your knowledge of Numbers—whether you’re new to spreadsheet programs in general, new to Numbers, or simply new to this latest version of Numbers—this book gives you detailed information about how to get the most out of this powerful app.

Following the advice of author Sharon Zardetto, you’ll learn how to input, calculate, sort, filter, format, and chart your data with ease. Taking you from the basics, all the way through complex formulas, charting, and other power-user features, this book will expand your understanding of what Numbers can do.

This book will show you how to:

• Get started with Numbers: Learn about Numbers’ terminology and interface, sheets and templates, table basics, and cell basics. For those new to spreadsheets, learn about the anatomy of a table and data entry basics. For those new to Numbers, but comfortable with spreadsheets, learn about working with sheets and tabs, the template chooser, and pop-up and contextual table menus.
• Work more efficiently: Customize your environment, utilize built-in and custom templates, speed up your work with autocomplete, autofill, and text substitution, make custom templates, use table styles, paragraph styles, and define a default text box.
• Use formulas and functions: Find out about formula-building basics, cell references, and functions and arguments. Explore the formula editor and the Function Browser, and use quick calculation tokens.
• Polish your formatting: Explore your formatting options, standardize the look of components in tables and sheets with styles, use rulers and ruler guides, add graphical elements (shapes and text boxes), and use color controls for everything from text to cell borders to shapes.
• Visualize data with charts: Learn the basics of chart parts and terminology, how to choose the right chart, how to create a chart, and how to work with 3D charts and interactive charts.
• Work with other people: Share, collaborate, and add comments to your work with other Numbers users. Find out how to import, export, and share files when others are not using Numbers.

✦ Table of Contents

Read Me First
ÿþW
Introduction
Numbers Quick Start
About Numbers
Learn Terminology and the Interface
Tables and Sheets
The Sidebar and Inspectors
Customize Your Environment
Global Features
Work with Sheets and Templates
Colorize a Sheet
Manage Sheets and Sheet Tabs
Use Built-In and Custom Templates
Learn Table Basics
Learn Table Anatomy
Recognize Table States
Create and Control Tables
Use Pop-Up and Contextual Table Menus
Title and Caption Tables
Manipulate Rows and Columns
Master Cell Basics
Cell Referencing
Select Cells
Move Between Cells
Move Within a Block of Cells
Move a Cell or Its Data
Merge and Unmerge Cells
Use Table Formats and Styles
Apply Table Formats
Use Table Styles
Reorganize Styles
Learn About Cell Formats
Apply Basic Cell Formats
Use Conditional Highlighting
Control Data Input
Learn Data Entry Basics
Understand Automatic Data Formats
Control Text Wrap in Cells
Speed Data Entry with Autocomplete
Speed Data Entry with Autofill
Explore Copy and Paste Options
Learn About Data Formats
Review Standard Data Formats
Create a Custom Data Format
ÿþU
Create Checkboxes
Define Sliders and Steppers
Build Pop-Up Menus
Sort Data
Learn About Sorting Order
Sort with Column Menus
Sort with the Organize Inspector
Master Unsorting
Deal with Special Sorting Issues
Filter Data
Use Quick Filters
Filter with the Inspector
Analyze Data with Categories
See the Categories Advantage
Create a Sample Category Table
Define and View Categories
Add a Summary Function
More About Categories
Handle Formulas and Functions
Save Time with Quick Calculations
Learn Formula-Building Basics
Work in the Formula Editor
Understand Functions and Arguments
Explore the Functions Browser
Master IF Statements and Logical Operators
What Is Truth?
Review Comparison Operators
Construct IF Statements
Learn About Logical Operators
Put It All Together
Construct Nested IF Statements
Work with Text Functions
Know Your Text Terminology
Learn Basic String Manipulations
Master Other Common Text Tasks
Create Charts
Chart Choices
Learn Chart Parts and Terminology
Create a Chart
Edit Chart Data
Design 3D Charts
Make Interactive Charts
Format Charts
Select Chart Elements
The Chart Tab
The Axis Tab
The Series Tab
The Style Tab
Tweak Text Elements
Add Comments
Set Comment Options
Solo vs. Swapped vs. Shared
Comments, Comments, Everywhere
Handle Comments and Replies
Add Audio
Create a Voice Recording
Work in the Audio Tab
Work with Shapes and Images
Add Shapes to a Sheet
Edit Shapes
Create a Custom Shape
Use Shape Styles
All About Arrows
Use Image Galleries
Tackle Text
ÿþW
Put Text in Text Boxes and Shapes
Tour the Text Tab
Create Bullet and Ordered Lists
Use Paragraph and Character Styles
Create a New Style
Search for Text
Search for and Replace Fonts
Manipulate Objects
Set Ruler and Guide Preferences
Select, Move, and Duplicate Objects
Work on the Sheet
Work on the Arrange Tab
Import, Export, and Share Files
Exchange Files with Excel
Import and Export Delimited Files
Export as a CSV or TSV File
Share a Numbers Document
Print Spreadsheets
The Print Process
Hone Headers and Footers
About This Book
Ebook Extras
About the Author
Acknowledgments
About the Publisher
Credits
Copyright and Fine Print