MS Excel 2010/2013/2016: Level 1

Course Description

Microsoft Excel Level 1, is the first course in a series of Excel courses. This course will give you the basic skills to create, edit, format, and print basic worksheets and charts in Excel.

Course Objectives

Upon successful completion of this course, students will be able to:

• Create a basic worksheet by entering text and values.
• Work with cells and cell data by using a variety of moving and copying techniques.
• Perform calculations on data by using formulas, including functions.
• Change the appearance of worksheet data by using a variety of formatting techniques.
• Work with multiple worksheets by formatting, repositioning, copying and moving, and adding and
  deleting worksheets within a workbook.
• Create and modify charts.
• Set the page display and printing options.

Course Content

Lesson 1: Getting Started
Topic 1A: Identify What You Can Do with Excel
Topic 1B: Enter Data in a Worksheet
Topic 1C: Edit Data
Topic 1D: Change the Appearance of Data
Topic 1E: Save a Workbook
Topic 1F: Obtain Help

Lesson 2: Editing Your Worksheet
Topic 2A: Moving Data to Other Cells
Topic 2B: Copy Data to Other Cells
Topic 2C: Fill Cells with a Series of Data
Topic 2D: Insert and Delete Rows and Columns
Topic 2E: Undo and Redo an Entry
Topic 2F: Find and Replace Numbers
Topic 2G: Enter Data in a Range
Topic 2H: Verify Data in a Range

Lesson 3: Performing Calculations
Topic 3A: Sum a Range of Data
Topic 3B: Use a Built-in Function
Topic 3C: Copy a Formula
Topic 3D: Create an Absolute Reference

Lesson 4: Formatting
Topic 4A: Specify Number Formats
Topic 4B: Create a Custom Number Format
Topic 4C: Change Font Size and Type
Topic 4D: Apply Styles
Topic 4E: Add Borders and Color to Cells
Topic 4F: Find and Replace Formats
Topic 4G: Change Column Width and Row Height
Topic 4H: Align Cell Contents
Topic 4I: Merge and Center Cells
Topic 4J: Apply an AutoFormat

Lesson 5: Working with Multiple Worksheets
Topic 5A: Format Worksheet Tabs
Topic 5B: Reposition Worksheets in a Workbook
Topic 5C: Copy Worksheets
Topic 5D: Change the Number of Worksheets

Lesson 6: Creating and Modifying Charts
Topic 6A: Create a Chart
Topic 6B: Modify Chart Items
Topic 6C: Format a Chart
Topic 6D: Change the Chart Type

Lesson 7: Setting Page Display and Printing Options
Topic 7A: Freeze Rows and Columns
Topic 7B: Set Print Title
Topic 7C: Set Page Margins
Topic 7D: Create a Header and Footer
Topic 7E: Change Page Orientation
Topic 7F: Insert and Remove Page Breaks
Topic 7G: Print a Range

Appendix A: Common Problems Associated with Printing