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
- Numbers Quick Start
- About Numbers
- Learn Terminology and the Interface
- Work with Sheets and Templates
- Learn Table Basics
- Master Cell Basics
- Use Table Formats and Styles
- Learn About Cell Formats
- Control Data Input
- Learn About Data Formats
- Use Special DataâInput Options
- Sort Data
- Filter Data
- Analyze Data with Categories
- Handle Formulas and Functions
- Master IF Statements and Logical Operators
- Work with Text Functions
- Create Charts
- Format Charts
- Add Comments
- Add Audio
- Work with Shapes and Images
- Tackle Text
- Manipulate Objects
- Import, Export, and Share Files
- Print Spreadsheets
- About This Book
- Title: Take Control of Numbers, 3rd Edition
- Release date: September 2021
- Publisher(s): Take Control Books
- ISBN: 9781947282209
You might also like
SQL Cookbook, 2nd Edition
You may know SQL basics, but are you taking advantage of its expressive power? This second …
Tiny Python Projects
The projects are tiny, but the rewards are big: each chapter in Tiny Python Projects challenges …
Essential Algorithms, 2nd Edition
A friendly introduction to the most useful algorithms written in simple, intuitive English The revised and …
40 Algorithms Every Programmer Should Know
Learn algorithms for solving classic computer science problems with this concise guide covering everything from fundamental …