Microsoft Excel 2000 - 2003 Level 1 (S1N1)
Classroom Learning
Classroom Learning
Also available via
Who Needs to Attend
New users of Excel 2000/2002/2003
Prerequisites
There are no prerequisites for this course.
Follow-On Courses
If you are new to Microsoft Excel 2000, 2002, or 2003, this course will teach you the fundamentals about spreadsheets. You will explore worksheets and workbooks, learn to work in columns and rows, and to work with cell contents. You will create formulas and use function commands to manipulate data. Finally, you will learn how to change the page setup, and to print your documents.
What You'll Learn
- Learn navigation skills to create and use Excel spreadsheets
- Organize columns and rows to accommodate information
- Edit the contents of cells to organize the information on your worksheet
- Calculate values using formulas and specify an exact address of a cell by creating an absolute cell reference
- Create formulas by typing functions or building more complex formulas using the Insert Function dialog box
- Format cells and worksheet elements to make the worksheet consistent and readable
- Change the page setup and preview the workbook to define how the printed worksheet appears
Course Outline
1. Getting Started with Microsoft Excel
- Understanding Spreadsheet Concepts
- Creating New Workbooks
2. Modifying the Worksheet
- Working with Columns and Rows
- Working with Cell Contents
3. Using Formulas and Functions
- Creating and Using Formulas
- Creating and Using Functions
- Using Absolute Cell References
- The Insert Function Command
4. Formatting Worksheets
- Formatting Cells
- Formatting Worksheet Elements
5. Setting Print Options
- Changing the Page Setup
- Previewing the Workbook
Classroom Dates and Locations
Don’t see the location or date you need? No problem – just use our By Request service.
Course Code: 8760
Registration Information
$225 CAD
1 Day Course
Microsoft Course: S1N1
Practice Files
RSS