Titlebook: Learn Excel 2016 for OS X; Guy Hart-Davis Book 2015Latest edition Guy Hart-Davis 2015

Pigeon

Configuring Excel to Suit the Way You WorkIn this chapter, we look at how to configure Excel for Mac to suit the way you work. You can change Excel’s appearance and behavior in many ways, and by setting it up as you prefer, you can save yourself plenty of time and effort.

走调

权宜之计

Loathe

Performing Custom Calculations with FormulasTo make your worksheets deliver the information you want, you’ll probably need to perform calculations with your data. To perform calculations, you enter formulas and functions in cells. You’ll learn to use formulas in this chapter and functions in ..

temperate

Creating Clear and Persuasive ChartsIn this chapter, you’ll learn how to create powerful charts that present your data clearly and persuasively.

GOUGE

Using Data Bars, Color Scales, Icon Sets, and SparklinesIn this chapter, we’ll look at how you can use four graphical elements to give your worksheets more visual appeal and oomph without using full-scale charts. These four elements are data bars, color scales, icon sets, and sparklines. Each is a graphical element that appears in a single cell.

Inflamed

TAIN

轻浮女

闷热

Solving Business Questions with What-If Analysis, Goal Seek, and Solverther times, you’ll need to ask questions of your data—for example, by how much do you need to raise prices to boost your revenue by a certain amount, or what will happen if you cut 10 percent off your manufacturing costs?