Microsoft Excel 2013 (BASIC)

This one-day instructor-led course provides students with an overview of the features and functions of Microsoft Office Excel 2007.This course is intended for novice information workers who want to learn beginning-level Excel 2013 skills.Before attending this course, students must have basic computer knowledge, such as keyboard and mouse skills, basic file-management skills. The student should know how to navigate to folders and files on a computer.

After completing this course, students will be able to:

• Become familiar with the new user interface.
• Create workbooks.
• Modify workbooks.
• Customize the Excel 2007 program window.
• Enter and revise data.
• Modify worksheets.
• Move data within a workbook.
• Find and replace data.
• Correct and expand upon worksheet data.
• Format cells.
• Define styles.
• Apply workbook themes and table styles.
• Make numbers easier to read.
• Create charts.
• Define a table.
• Name groups of data.
• Create formulas to calculate values.
• Add headers and footers to printed pages.

Learning Level: Intermediate

Duration: 3 day(s)-

• Becoming Familiar with the New User Interface
• Creating Workbooks
• Modifying Workbooks
• Customizing the Excel 2007 Program Window

• Entering and Revising Data
• Modifying Worksheets
• Moving Data Within a Workbook
• Finding and Replacing Data
• Correcting and Expanding Upon Worksheet Data

• Format cells by adding borders and shading.
• Store and apply sets of formatting as a style.
• Copy formatting by using the Format Painter.
• Format entire worksheets with themes, and format data lists with table styles.
• Assign formats to numbers to make them easier to read.

• Creating Charts
• Defining a Table
• Create a data table, add data, summarize the data, and rename the table.

• Create and use named ranges.
• Perform calculations that use formulas and reference cells in various ways.

• Adding Headers and Footers to Printed Pages
• Preparing Worksheets for Printing