Download Excel 2007 Getting Started: Navigation, Formatting, and Data Manipulation - Prof. Marilyn and more Study notes Accounting in PDF only on Docsity! Chapter 1: Getting Started with Excel 2007 ACIS 2504, Fall 2008 Skills Practice 1. Navigate Excel using the Excel Ribbon 2. Navigate Excel using the Quick Access Toolbar (located on upper left hand column) a. Add common commands to the Quick Access Toolbar b. Add other commands to the Q.A. Toolbar 3. Create, name and save a new Excel file using various “Save” options. a. Excel workbook (no support for macros, safer) b. Excel 97-2003 Workbook (previous version compatible) c. Macro-enabled Workbook d. Other Formats (we will practice with some of these later in the semester) i. Delimited text files (For importing/exporting (non-Excel) data.) ii. PDF capability by integrating with Adobe Acrobat (also .xps which is Microsoft’s version of portable document files) iii. Web page formats iv. XML formats v. and more 4. Format cell contents a. Distinguish between a cell’s content and its format b. “General” format type c. Formatting text data i. Text effects: bold, italic, small caps, etc. ii. Text color and background color iii. Align cell contents 1. Left (default), right, center 2. Indent cell contents 3. Merge and center text across multiple columns (or rows). d. Formatting numeric data i. Currency/Accounting ii. Percentage 1 iii. Dates (we will devote an entire class period to working with Dates in Excel) e. Wrap text inside a cell f. Correct formatting errors i. ######### ii. Number, Date/Time formats g. Apply conditional formatting (will postpone until later in this exercise) 5. Copying and Moving Cell Contents a. Copy multiple items to clipboard b. Paste a series of data c. Paste a pattern of data i. Paste custom patterns (a.k.a. “custom lists”): Office Button, Excel Options, Edit Custom Lists ii. Can also use custom lists for sorting options. Link to sort list by: Data, Sort, Order, Custom List (More about sorting in Chapter 5). d. Paste Special Options (most popular paste options) i. Values only (to remove the formula from a range of cells) ii. Formats iii. Transpose (reverse table layout) iv. Skip blanks: when pasting new data over old and don’t want to paste blank values over previous existing values. 6. Apply conditional formatting a. Format is determined by the value of the cell content b. Many, many options for formatting specific value ranges c. We will continue to apply conditional formatting in future class exercises as appropriate. 7. Insert new columns & rows 8. Resize columns & rows 9. Rename a worksheet 10. Set worksheets for printing: use Page Layout ribbon Vocabulary Spreadsheet- (also called worksheet)- is a two-dimensional table with a cell at the intersection of each column and row. (Excel) workbook- excel files are called workbooks. They represent the entire excel project and may contain one or more worksheets, charts or graphs. (Excel) worksheet- (Excel) formula a mathematical expression that uses other worksheet cells contents as inputs to the calculation or expression. cell format cell value conditional formatting custom lists- 2