Excel 2010 Bible

xxiii Contents Part III: Creating Charts and Graphics 401 Chapter 18: Getting Started Making Charts  . . . . . . . . . . . . . . ...

xxiv Contents User Interface Choices for Modifying Chart Elements .......................................................441 Usi ...

xxv Contents Using color scales ................................................................................................ ...

xxvi Contents Using SmartArt ................................................................................................... ...

xxvii Contents Displaying a negative sign on the right ....................................................................565 F ...

xxviii Contents Changing the link source ....................................................................................... ...

xxix Contents Controlling the advanced sharing settings ...............................................................632 Track ...

xxx Contents Floating point number errors ..................................................................................659 ...

xxxi Contents Adding and editing records in external database tables ............................................693 Formatting ...

xxxii Contents Chapter 36: Performing Spreadsheet What-If Analysis . . . . . . . . . . . . . . 745 A What-If Example ........... ...

xxxiii Contents Rank and Percentile............................................................................................. ...

xxxiv Contents Chapter 40: Creating Custom Worksheet Functions . . . . . . . . . . . . . . . . 823 Overview of VBA Functions ... ...

xxxv Contents Chapter 42: Using UserForm Controls in a Worksheet . . . . . . . . . . . . . . 859 Why Use Controls on a Worksheet ...

xxxvi Contents Selecting a row or column ....................................................................................... ...

xxxvii Contents What’s on the CD ............................................................................................... ...

xxxviii Contents Appendix C: Additional Excel Resources  . . . . . . . . . . . . . . . . . . . . . . . . 943 The Excel Help Syst ...

xxxix T hanks to everyone who bought the previous editions of this book. Your suggestions have helped make this edition the best ...

xl T hanks for purchasing Excel 2010 Bible. If you’re just starting with Excel, you’ll be glad to know that Excel 2010 is the ea ...

xli Introduction Excel commands Excel 2010 (like Excel 2007) features a “menu-less” user interface. In place of a menu system, E ...

xlii Introduction Mouse conventions You’ll come across some of the following mouse-related terms, all standard fare: l Mouse poi ...