|
Nexient Learning ~ Word Training, Excel Training, PowerPoint Training, Canada Wi Cancellation Policy
Description: Who Should Attend
This course is intended for new Microsoft Office Excel 2007 users
Performance Objectives
Upon completion of the course, participants will be able to accomplish the following:
- Understand the concepts of word processing, and how to create, save, and open documents for easy document management
- Organize columns and rows to accommodate information and edit the contents of cells to organize the information in your worksheet
- Calculate values by entering formulas into cells and specify an exact address of a cell by creating an absolute cell reference, create formulas by typing functions or build more complex formulas using the Insert Function dialog box
- Format worksheets and use view features to more effectively review large worksheets
- Use views to determine the layout of a worksheet, change the page setup, and preview/print workbooks
Course Outline
Getting Started with Excel 2007
- Understanding Spreadsheet Concepts
- Getting Started
- Creating and Saving Workbooks
- Opening and Closing Workbooks
Modifying Worksheets
- Working with Columns and Rows
- Working with Cell Contents
Using Formulas and Functions
- Creating and Using Formulas
- Creating and Using Functions
- Using Absolute Cell References
- Inserting Functions
Modifying and Enhancing Text Appearance
- Formatting Worksheets
- Viewing Worksheets
Printing Workbooks
- Using Workbook Views
- Changing the Page Setup Setting Indents
- Previewing and Printing Workbooks
Pre-Requisites: Windows 2000, Windows XP, or Windows Vista
Certificates offered: Certificate of Completion
Duration Details: 1 Day
8:30am - 4:30pm
Facility Location: Nexient Edmonton
10050 - 112 Street Suite 400 Edmonton Alberta Canada T5K 2J1
|