Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Excel is a spreadsheet application used to create and work with a variety of financial and logical functions. The strength of Excel is its ability to perform calculations. Use Excel to create simple worksheets and charts or elaborate financial statements. The major reason Excel is so popular is the ability to ask, “What if” questions. | Microsoft Excel 2010 Unit 1 Training Manual College of Lake County Professional Development Center Microsoft Excel 2010 Unit 1 Table of Contents Microsoft Excel 2010 Getting Started.3 Open Microsoft Excel 2010.3 Workbook Window.3 Look at the Areas of the Worksheet.4 Entering Information in Cells.7 Types of Data.7 Rows and Columns.7 Entering Text in a Workbook.8 Using the Keyboard to Move through the Worksheet.9 Navigating the Worksheet.9 Saving Closing and Opening Workbooks.10 Saving a Workbook for the First Time.10 Closing an Excel Workbook.10 Opening a Recently Used Excel Workbook.11 Working with Numbers and Formulas.12 Creating Formulas.12 Auto Calculating with Excel.12 Creating Formulas.13 Using AutoSum.14 Selecting and Formatting Cells.16 Format Text.16 Merge and Center Text.17 Selecting and Formatting Numbers.17 Using the Save As Command.18 Adjusting Column Widths and Row Heights.19 Excel Unit 1 PG 5-31-2011 Professional Development Center Page 1 of 31 AutoFit a Single Column Width.19 Change Columns to a Narrow Width.19 AutoFit Multiple Column Widths.19 Single Row Height Adjustment.20 Multiple Row Height Adjustment.20 Wrap Text in a Column.20 AutoFit Multiple Rows.20 Remove Wrap Text in a Column.21 Enter a Line Break to Wrap Text Easier.21 Using AutoComplete and AutoCorrect.21 Editing Cells.22 Edit Data in the Formula Bar.22 Edit Data Directly in the Cell.22 Overwrite Existing Data in Cells.22 Inserting Columns and Rows.23 Inserting a Column.23 Inserting a Row.24 Deleting a Column.25 Deleting a Row.25 The Cut Command.26 Move the Tax Rate.26 Delete the Tax and Total Rows.26 Move a Column.27 The Copy Command.28 Copy the Tax Rate.28 Creating a Total with Tax Formula.28 Spell Check a Workbook.29 Worksheet Wrap-Up.30 Preview and Print a Workbook.30 Excel Unit 1 PG 5-31-2011 Professional Development Center Page 2 of .
