Inserting a range D-1: Inserting rows D-2: Unit 4 : Using functions Deleting a range D-3: 0 Entering functions Topic A: Entering a SUM function A-1: Using the mouse to enter a function argument A-2: Inserting a SUM function 0 AutoSum A-3: Topic B: Using the AutoSum button 0 Other useful B-1: Topic C: functions Using AVERAGE C-1: Using MIN C-2: Using MAX C-3: Using COUNT and COUNTA Unit 5 : Formatting C-4: worksheets 0 Formatting text Topic A: Using the Font group to format text A-1: Formatting non-contiguous ranges A-2: Using the Format Cells dialog box to format text 0 A-3: Topic B: Formatting rows and columns Changing column width and row height B-1: Applying color to a row B-2: Setting alignment B-3: Applying borders to ranges B-4: Using the border-drawing pencil B-5: Using the Paste Special option B-6: Removing a border 0 Formatting numbers B-7: Topic C: Using the Number group to format numbers C-1: Exploring the Number tab 0 Conditional C-2: Topic D: formatting Creating a conditional format D-1: Editing and deleting a conditional format 0 D-2: Topic E: Copying formats and applying table formats Copying formats E-1: Using AutoFill to copy a format E-2: Applying cell and table styles E-3: Unit 6 : Using Find and Replace to change cell formats E-4: Printing 0 Preparing to print Topic A: Checking spelling in a worksheet A-1: Using the Research task pane A-2: Finding and replacing text A-3: Previewing a worksheet 0 Page Setup options A-4: Topic B:
D-1: Inserting a range D-2: Inserting rows D-3: Deleting a range Unit 4 : Using functions Topic A: 0 Entering functions A-1: Entering a SUM function A-2: Using the mouse to enter a function argument A-3: Inserting a SUM function Topic B: 0 AutoSum B-1: Using the AutoSum button Topic C: 0 Other useful functions C-1: Using AVERAGE C-2: Using MIN C-3: Using MAX C-4: Using COUNT and COUNTA Unit 5 : Formatting worksheets Topic A: 0 Formatting text A-1: Using the Font group to format text A-2: Formatting non-contiguous ranges A-3: Using the Format Cells dialog box to format text Topic B: 0 Formatting rows and columns B-1: Changing column width and row height B-2: Applying color to a row B-3: Setting alignment B-4: Applying borders to ranges B-5: Using the border-drawing pencil B-6: Using the Paste Special option B-7: Removing a border Topic C: 0 Formatting numbers C-1: Using the Number group to format numbers C-2: Exploring the Number tab Topic D: 0 Conditional formatting D-1: Creating a conditional format D-2: Editing and deleting a conditional format Topic E: 0 Copying formats and applying table formats E-1: Copying formats E-2: Using AutoFill to copy a format E-3: Applying cell and table styles E-4: Using Find and Replace to change cell formats Unit 6 : Printing Topic A: 0 Preparing to print A-1: Checking spelling in a worksheet A-2: Using the Research task pane A-3: Finding and replacing text A-4: Previewing a worksheet Topic B: 0 Page Setup options
Excel%202007-%20Basic.docx