Excel 2010: The Missing Manual
|
Index
[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]
data editing entering exchanging with other programs [See exchanging data with other programs] grouping [See grouping data] moving around [See spreadsheet modification] outlining [See outlining data] time-saving features AutoComplete AutoCorrect AutoFill AutoFit Redo Undo Data Analysis command Data Form dialog box data forms advanced seraching logical operators editing with searching with versus worksheets data labels adding individual bubble size labels category name percentage labels series name value labels data lists 2nd charting compared to pivot tables creating data forms [See data forms] editing adding new record adding or removing columns deleting records records Excel 2002 and filtering 2nd custom filters disappearing cells multiple sort keys restricting rows overview performing calculations with database functions dynamic calculations SUBTOTAL( ) function Total Row command sorting mulitple criteria simple sort order versus grouping data Data menu Consolidate command Filter command Form command Group and Outline submenu Import External data submenu List submenu PivotTable and PivotChart Report command Refresh Data command Sort command Subtotals command Table command Text to Columns command Validation command XML submenu data points formatting data series adding labels changing order of formatting data series (chart) data source definition data source, querying data table data types controlling dates and times how Excel determines if data is using dates trouble-free numbers how Excel determines if data is ordinary text how Excel determines if data is seeing how Excel is interpreting true or false data validation conditional validation rules Custom data type and with formulas and cell references with lists Data Validation dialog box 2nd Error Alert tab Input Message tab List option Setting tab database functions databases defining data source difference between worksheets and querying data source retrieving data from types of Date format date format strings date formats, types of DATE( ) function DATEDIF( ) function dates calculating difference between converting into serial numbers finding number of days between two formatting codes having time and date in same cell how Excel determines if data is intentional bug manipulating math with regional subtraction using dates trouble-free DATEVALUE( ) function DAVERAGE( ) function DAY( ) function DAYS360( ) function DB( ) function DCOUNT( ) function DCOUNTA( ) function DDB( ) function decimals, fixed decimal places declining balance depreciation Define Name dialog box named ranges naming formulas and constants DEGREES( ) function Delete command Delete Row command Delete Sheet command delimited text depreciation declining balance double declining balance straight-line sum-of- years -digits Detect and Repair command DGET( ) function Diagram command digit placeholders disaster recovery DISC( ) function discount rate discussion server Distributed (cell appearance formatting) Distributed (Indent) (cell appearance formatting) division DMAX( ) function DMIN( ) function Do Not Distribute command Document Updates task 2nd DOLLAR( ) function donut charts double declining balance depreciation double lookups DPRODUCT( ) function drag-and-drop drawing shapes 2nd adding text to shapes AutoShapes button basic shape categories basic shapes block arrows callouts connectors Fill Color button flowcharts in charts layers Line Color button lines more autoshapes selecting shapes stars and banners Drawing toolbar Drop Page Fields Here region DSTDEV( ) function DSUM( ) function DURATION( ) function DVAR( ) function DVARP( ) function dynamic calculations dynamic invoicing example dynamic spreadsheets
|