1 Day (6.5 instructional hours)
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.
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
Topic A: Create Formulas in a Worksheet
Topic B: Insert Functions in a Worksheet
Topic C: Reuse Formulas
Topic A: Edit Worksheet Data
Topic B: Find and Replace Data
Topic C: Manipulate Worksheet Elements
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
Topic A: Manage Worksheets
Topic B: View Worksheets and Workbooks
Topic A: Define the Page Layout
Topic B: Print a Workbook