{"product_id":"9781457191046","title":"Take Control of Numbers","description":"\u003cp\u003e\u003cb\u003eGet serious with Numbers, Apple's powerful spreadsheet for the Mac!\u003c\/b\u003e\u003c\/p\u003e\u003cp\u003eApple's Numbers has become a grown-up spreadsheet (and it's free on every Mac sold since October 2013!), but many of us still haven't learned even the basics, much less been able to take advantage of its surprisingly deep collection of features.\u003c\/p\u003e\u003cp\u003eWith the advice in this 330-page ebook, you'll \u003cb\u003elearn to input, calculate, sort, filter, format, and chart your data with ease\u003c\/b\u003e, as author Sharon Zardetto guides you through the basics all the way to power-user features like conditional highlighting, custom data formats, and star ratings. Richly illustrated with \u003cb\u003ehundreds of annotated screenshots\u003c\/b\u003e, the ebook also includes a \u003cb\u003ehands-on example spreadsheet\u003c\/b\u003e you can use to try what you're learning, plus \u003cb\u003ea special tutorial chapter that helps you put it all together\u003c\/b\u003e. Of course, you can also treat the book as a reference, using the Quick Start to focus on a topic of interest.\u003c\/p\u003e\u003cp\u003eThe book covers Numbers 3.5, which works on any Mac running OS X 10.10 Yosemite.\u003c\/p\u003e\u003cp\u003eYou'll learn how to...\u003c\/p\u003e\u003cp\u003eHandle the basics:\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eInput data into a table.\u003c\/li\u003e\n\u003cli\u003eChoose the best chart type for your data.\u003c\/li\u003e\n\u003cli\u003eAdd, modify, and position shapes, such as arrows, comments, and text boxes.\u003c\/li\u003e\n\u003cli\u003eImport\/export from Excel, text, CSV, and older versions of Numbers.\u003c\/li\u003e\n\u003cli\u003eSet up page numbers and other header\/footer information for printing.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eSee what you want to see:\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eKnow what to expect when you sort by column.\u003c\/li\u003e\n\u003cli\u003eHide and show columns.\u003c\/li\u003e\n\u003cli\u003eMerge and unmerge cells.\u003c\/li\u003e\n\u003cli\u003eCreate rules that filter data to display only specific rows.\u003c\/li\u003e\n\u003cli\u003eSet up and view interactive charts.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eMake formulas:\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eWork fluidly in the formula editor to create formulas.\u003c\/li\u003e\n\u003cli\u003eMake formulas from the tear-off tokens on the Quick Calc bar.\u003c\/li\u003e\n\u003cli\u003eNimbly use various types of cell references in formulas.\u003c\/li\u003e\n\u003cli\u003eUnderstand how to use IF, TRUE, and FALSE in formulas.\u003c\/li\u003e\n\u003cli\u003eTake charge of logical operators (AND, OR, NOT) in formulas.\u003c\/li\u003e\n\u003cli\u003eConcatenate and break apart text.\u003c\/li\u003e\n\u003cli\u003eStrip extra spaces out of data.\u003c\/li\u003e\n\u003cli\u003eFind medians, modes, ranks, percentiles, and more.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eCreate clever formulas that can:\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eCalculate a sales discount based on whether a total is over or under a certain amount.\u003c\/li\u003e\n\u003cli\u003eSort seemingly unsortable data, such as items described as Poor, Good, or Excellent.\u003c\/li\u003e\n\u003cli\u003eTake a column of cells, with each cell containing a full name, and move all the last names into a different column.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eApply formatting:\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eAdd and remove grid lines and cell borders.\u003c\/li\u003e\n\u003cli\u003eWork with a cell's background fill.\u003c\/li\u003e\n\u003cli\u003eFormat a chart so it looks fabulous.\u003c\/li\u003e\n\u003cli\u003eSet up conditional highlighting that appears only when data meets certain criteria.\u003c\/li\u003e\n\u003cli\u003eEnsure accurate data entry with cell formats like sliders, menus, and checkboxes.\u003c\/li\u003e\n\u003cli\u003eUse and create templates.\u003c\/li\u003e\n\u003cli\u003eFormat faster with character, paragraph, list, shape, and table styles. \u003c\/li\u003e\n\u003c\/ul\u003e","brand":"TidBITS","offers":[{"title":"Default Title","offer_id":47125604073712,"sku":"9781457191046","price":12.49,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781457191046_p0.jpg?v=1763863535","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781457191046","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}