967
Index
Form button, 41–42
New button, 42
Customize Regional Options dialog box, 257
Customize Ribbon tab, Excel Options dialog box, 548
customizing
charts, 408–413
Quick Access toolbar
adding new commands, 543–545
overview, 17–19, 541–542
Ribbon feature, 5, 546–549
SmartArt feature, 527–528
Sparkline graphics
adjusting axis scaling, 509–510
changing colors and line width, 508
changing type, 508
faking reference lines, 510–512
hidden or missing data, 508
highlighting certain data points, 509
sizing cells, 507
user interface
Quick Access toolbar, 541–546
Ribbon feature, 546–549
Cut method, 891D
Daily Dose of Excel, Web site, 948
Dalgleish, Deborah, 948
damping factor, 786
Dark style category, tables, 103
data. See also entering and editing data
adding in outlines, 588
non-numeric, 715–717
for pivot tables, 698–701
preparing for outlines, 588
ranking with array formulas, 392–393
returned by Query
adjusting external data range properties, 688–689
changing, 690
deleting, 690
refreshing, 689–690
selecting from charts, 408–409
sharing with Office applications. See sharing data with
Office applications
specifying location for, 687–688
transforming with formulas, 240
types of
formulas, 30–31
numeric values, 30
overview, 29
text entries, 30creating user interface for add-in macros, 912–913
installing add-ins, 913
procedures in Module1, 909
protecting projects, 911–912
setting up workbooks, 908
testing workbook, 910–911
overview, 903–904
reasons for creating, 906
Custom category in the Number tab, Format Cells dialog
box, 399
Custom conditional formatting rule, 482
Custom error bar, Format Error Bars dialog box, 462–463
Custom format, Format Cells dialog box, 46–47, 554
Custom Format option, 484
Custom option, Data Validation dialog box, 572
custom templates
changing workbook defaults, 166–167
changing worksheet defaults, 167–168
editing, 168
ideas, 170
overview, 165–166
resetting default settings, 168
saving, 170
Custom Value option, Sparkline group, 509
Custom Views feature, 587–588
Custom Views of worksheet, printing, 190–191
custom workbook template, 166
custom worksheet functions
debugging, 833–834
example of
analyzing, 825–826
custom function, 824
using function in worksheet, 824–825
function procedure arguments
function with no argument, 829
function with one argument, 829–831
function with range argument, 832–833
function with two arguments, 831–832
overview, 828–829
function procedures
calling custom functions from, 827
overview, 826–827
using custom functions in worksheet formulas, 828
inserting, 834–836
VBA functions, 823
customer list, 630
customer satisfaction charts, 413
Customize button, Customize Regional Options dialog box, 257
Customize Quick Access Toolbar
Add button, 41
Choose Commands list, 4160_474877-bindex.indd 96760_474877-bindex.indd 967 3/29/10 11:48 PM3/29/10 11:48 PM