MS Excel Level I, CMP957
Explore the new and improved MS Excel 2007 environment to create, modify, and format electronic work sheets. Learn how to create and use built-in statistical formulas to manipulate data. Master techniques to copy and move work sheet data, change the width and height of columns and rows, insert and delete data, and check for spelling errors.
Prerequisites: Computer Basics and Working with Windows XP or Working with Vista or equivalent experience with PC File Management.
Textbook: Purchase at the Rockville or Takoma Park/Silver Spring Campus Bookstore and bring to first class along with a USB Flash Drive/memory stick (at least 512 MB).
Classroom Hours: 10-
Course Objectives:
- Explore the Microsoft Office Excel 2007 environment and create a basic worksheet
- Perform calculations
- Modify a worksheet
- Format a worksheet
- Print workbook contents
- Manage large workbooks
Course Content
Lesson 1: Creating a Basic Worksheet
- Explore the User Interface and the Ribbon
- Navigate and Select in Excel
- Obtain Help
- Enter Data and Save a Workbook
- Customize the Quick Access Toolbar
Lesson 2: Performing Calculations
- Create Basic Formulas
- Calculate with Functions
- Copy Formulas and Functions
Lesson 3: Modifying a Worksheet
- Manipulate Data
- Insert and Delete Cells, Columns, and Rows
- Search for Data in a Worksheet
- Spell Check a Worksheet
Lesson 4: Formatting a Worksheet
- Modify Fonts
- Add Borders and Color to Cells
- Change Column Width and Row Height
- Apply Number Formats
- Position Cell Contents
- Apply Cell Styles
Lesson 5: Printing Workbook Contents
- Print Workbook Contents Using Default Print Options
- Set Print Options
- Set Page Breaks
Lesson 6: Managing Large Workbooks
- Format Worksheet Tabs
- Manage Worksheets in a Workbook
- Manage the View of Large Worksheets