Step by Step Chapter 6

Chapter 6 Intro
   Excel allows you to visualize and present information using charts, graphics, and formatting.
   You can organize data into tables.
   Tables allow you to analyze and store data quickly and easily.
   You can enter a data series; repeat one or more values; and control how Excel formats the cells, columns, and rows.
   You can also check the spelling of worksheet text.
   You can use a Thesaurus and translate words to other languages.

Entering and Revising Data
   Easiest way to enter data is to click a cell and type a value.
   You can enter a sequence by putting in the first element of the series and then using AutoFill to fill in the rest of the series.
   Grab the fill handle at the bottom-right corner of the cell and drag it to where you want to fill your data.
   FillSeries allows you to enter 2 values in a series and then use the fill handle to extend the series.
   If you drag the handle up or to the left, Excel will use values before the value that you are using to fill. If you have January, the other values would be December, November, October, etc.
   You can hold the Control key while you drag the handle so that the series won't be continued but instead copied.
   Data entry techniques include: AutoComplete, AutoFill, FillSeries, Pick from Drop-down list, and the Control and Enter key combination.
   Auto Complete finishes a word if a similar value exists when you type in the first few letters of a word.
   Pick from Drop-down list gives you a shortcut menu that include recently used values that you could pick from.
   To use Control+Enter combination you select a range of cells that you want to contain the same data, then type the data into the active cell and press Control+Enter.
   The AutoFill Options appear next to data that you just added using AutoFill.
   You can choose Copy Cells, Fill Series, Fill Formatting Only, Fill Without Formatting, or Fill Days, Weekdays, etc. from the AutoFill Options.
   Copy Cells copies the contents of the selected cells and puts them into the area that was being filled.
   Fill Series continues the series with the next item in the sequence.
   Fill Formatting Only applies the formatting of the selected cells to the area that was being filled.
   Fill Without Formatting is exactly like the Fill Series option only without the formatting.
   Fill Days, Weekdays, etc. is the option that appears if you began the series with days, weekdays, or other.

Moving Data Withing a Workbook
   You can move cells and worksheets.
   When a cell is highlighted, it is called the active cell.
   When multiple cells are selected, they are called a cell range.
   You can cut, copy, delete, or change the format of selected cells.
   You can move columns and rows.
   You do that by clicking and dragging the column header or row header.
   The Paste Options button appears next to data that you just copied and pasted.
   Paste Options include: Use Destination Theme, Match Destination Formatting, Keep Source Formatting, Values Only, Values and Number Formatting, Values and Source Formatting, Keep Source Column Widths, and Formatting Only.
  
Finding and Replacing Data
   Use that Find & Select button to easily find data in large worksheets.
   You can go to the Options section to choose specific formatting to find.
   The Find what field contains the value that you want to find.
   The Find All button selects every cell that matches the value in the Find what field.
   The Find Next button finds the next occurence of the value in the Find what field.
   The Replace with field contains the value that you want to put in to replace the value in the Find what field.
   The Replace All button replaces all of the values that match the Find what field.
   The Replace button replace the next value that matches the Find what field.
   The Options button displays additional options on what to Find and Replace.
   The Format button displays the Find Format dialog box and allows you to find values based on formatting.
   Within list box allows you choose whether to search in the active worksheet or the entire workbook.
   The Search list box allows you to select whether to search by rows or columns.
   The Look in list box allows you to select whether to search cell formulas or values.
   The Match case check box makes sure that values have the same capitalization.
   The Match entire cell contents check box makes sure that the values are exactly the same.
Correcting and Expanding Upon Worksheet Data
   You should check and correct data that you enter.
   You can use the spelling checker to automatically check spelling for you.
   You can replace it with the proper word from the list of suggestions or ignore the mispelling.
   You can add new words to the Excel custom dictionary.
   You can use the Thesaurus to find synonyms and antonyms.
   You can translate text from one language to another.
Defining a Table
   You can format a range of cells as a table.
   You can add total rows and other types of rows in the Design tab.
   You need to make sure that there aren't any empty cell when creating a data table.
   You also need the header and data below the header.
   There also can't be any data next to the area that you want to change into a table.
   To add data to a table, select a cell either below a row or to the right of a column and type a value.
   You can turn of the AutoCorrect Options.
   You can add rows and columns to a table.
   You can delete rows and columns.
   You can choose what function you want to use in the total row.
   You use the down arrow that appears in the total row.
   You can change the name of your table.
   You can change your table back to regular text.