Hands-on workshop to learn to use Microsoft Excel 2007 to create professional spreadsheet by formating cell, column, row and table. Learn to use the toolbars, on-screen elements, online help, print function, copy/ paste text, format cell, row, column and worksheet, and set text style and size. This workshop will also help you prepare for IC3 Module B: Key Application Certification test. Prerequisite: Microsoft Windows Basic, Internet or equivalent.
- Getting Started with Programs
- Sharing Common Elements
- Starting Excel
- Exiting Excel
- Using the Quick Access Toolbar
- Using the Ribbon
- Getting Help
- Working with Files
- Printing Files
- Understanding Basic Excel Terminology
- Creating a New Blank Workbook
- Opening Workbooks
- Closing a Workbook
- Saving Workbooks
- Managing Your Files
- Entering Data in the Worksheet
- Moving Around the Worksheet
- Manipulating the Information
- Selecting Cells
- Making Changes to the Contents
- Using Undo, Redo, or Repeat
- Copying and Moving Data
- Using AutoFill
- Changing the Column Widths
- Adjusting the Row Height
- Inserting or Deleting Rows, Columns, or Cells
- Managing Worksheets
|
