Microsoft® Excel® 2010: Level 1
< Back to Course Catalog
Duration:
1 Day (6.5 instructional hours)
Excel 2010
Course Number: 084676S3
Course Objective:
Upon successful completion of this course, you will be able to create and edit basic Microsoft Office Excel 2010 worksheets and workbooks.
Target Student:
This course is intended for students who wish to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets.
Prerequisites:
To ensure success, students will need to be familiar with using personal computers and should have experience with Windows XP Professional: Level 1; Windows XP: Introductions.
Course Outline
Lesson 1: Getting Started with Excel
Topic A: Identify the Elements of the Excel Interface
Topic B: Navigate and Select Cells in Worksheets
Topic C: Customize the Excel Interface
Topic D: Create a Basic Worksheet
Lesson 2: Performing Calculations in an Excel Worksheet
Topic A: Create Formulas in a Worksheet
Topic B: Insert Functions in a Worksheet
Topic C: Reuse Formulas
Lesson 3: Modifying an Excel Worksheet
Topic A: Edit Worksheet Data
Topic B: Find and Replace Data
Topic C: Manipulate Worksheet Elements
Lesson 4: Modifying the Appearance of a Worksheet
Topic A: Apply Font Properties
Topic B: Add Borders and Colors to Cells
Topic C: Align Content in a Cell Topic D: Apply Number Formatting Topic E: Apply Cell Styles
Lesson 5: Managing an Excel Workbook
Topic A: Manage Worksheets
Topic B: View Worksheets and Workbooks
Lesson 6: Printing Excel Workbooks
Topic A: Define the Page Layout
Topic B: Print a Workbook