Excel 2013 - Level 1

Course details

In this course, students will use Microsoft Office Excel 2013 to create spreadsheets and workbooks that youcan use to store, manipulate, and share your data.

What will I learn?

Lesson 1: Getting Started with Excel 2013

• Identify the Elements of the Excel Interface
• Create a Basic Worksheet
• Use the Help System

Lesson 2: Performing Calculations

• Create Formulas in a Worksheet
• Insert Functions in a Worksheet
• Reuse Formulas

Lesson 3: Modifying a Worksheet

• Manipulate Data
• Insert, Manipulate, and Delete Cells, Columns, and Rows
• Search for and Replace Data
• Spell Check a Worksheet

Lesson 4: Formatting a Worksheet

• Modify Fonts
• Add Borders and Color to Cells
• Apply Number Formats
• Align Cell Contents
• Apply Cell Styles

Lesson 5: Printing Workbook Contents

• Define the Basic Page Layout for a Workbook
• Refine the Page Layout and Apply Print Options

Lesson 6: Managing Large Workbooks

• Format Worksheet Tabs
• Manage Worksheets
• Manage the View of Worksheets and Workbooks

Lesson 7: Customizing the Excel Environment

• Customize General and Language Options
• Customize Formula Options
• Customize Proofing and Save Options
• Customize the Ribbon and Quick Access Toolbar
• Customize the Functionality of Excel by Enabling Add-Ins
• Customize Advanced and Trust Center Options

Requirements

To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows 8 environment and be able to use Windows 8 to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the  computer; and manage files and folders