|
Course Name |
Excel 2007 Level 1 |
Contact Hours: 24 |
|
Course Description |
This course introduces students to Microsoft Office Excel 2007. It covers basic spreadsheet features and acquaints students with Excel's tools. Students will learn to manage workbooks, work with cells and cell data, format and print worksheets, create and revise formulas, work with basic functions, use fills to save data entry time, and create and modify charts from worksheet data. They will also be introduced to the main interface changes of Microsoft Office 2007, such as the Ribbon, Quick Access toolbar, and the Mini toolbar. Finally, students will also learn how to access and use the Excel Help feature. |
|
Outcome |
This course will teach students how to: - use basic spreadsheet features and acquaints students with Excel's tools
- learn to manage workbooks
- format and print worksheets
- work with cells and cell data
- create and revise formulas
- work with basic functions
- use fills to save data entry time
- create and modify charts from worksheet data
|
|
Assessment |
Student performance is assessed by cumulative training time, number of lessons completed and, where tests are available, the percent correct. Many courses also have a pre- and post-test where the pre-test will automatically assign only the lessons needed to achieve course mastery.
|
|
Outline |
This course contains 63 lessons - Look At Microsoft Office Excel 2007
- Open Microsoft Office Excel
- Examine The Excel Window
- Understand The Quick Access Toolbar
- Open Workbooks
- View Worksheets
- Go To Specific Cells
- Examine Saving Options
- Close Workbooks
- Create New Workbooks
- Enter Cell Content
- Edit Cell Content
- Check Spelling
- Insert And Delete Cells
- Merge And Split Cells
- Insert And Delete Columns And Rows
- Modify Column Width And Row Height
- Look At The Office Clipboard Task Pane
- Examine Cut, Copy, And Paste
- Cut And Paste Data
- Copy And Paste Data
- Use Paste Special
- Move Cells And Ranges
- Understand Fills
- Fill A Series
- Fill By Example
- Understand Formulas
- Understand Cell References
- Use Cell References In Formulas
- Enter A Formula In The Formula Bar
- Copy And Edit Formulas
- Understand Functions
- Build Functions
- Use A Button To Find Sums And Averages
- Calculate Sums Using The Insert Function Dialog Box
- Calculate Averages Using Functions
- Create Minimum Functions
- Create Maximum Functions
- Understand The Mini Toolbar
- Understand Date And Number Formatting
- Format Numbers
- Change Text Alignment
- Wrap Text Within Cells
- Modify Text Appearance
- Apply Fill Colors To Cells
- Use The Format Painter
- Add Borders
- Examine Charts
- Create Charts
- Change Chart Types
- Apply Different Chart Styles
- Resize and Move Charts
- Modify Chart Titles, Legends, And Data Labels
- Understand Printing
- Preview Worksheets
- Change Page Orientation And Scaling
- Set Page Margins And Alignment
- Create Headers And Footers
- Select Print Options
- Set, Print, And Clear Print Areas
- Print Selections
- Print Worksheets And Workbooks
- Getting Help In Microsoft Office Excel
|
|
|
|