Excel 2013 - Part 1

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

Lesson 1: Getting Started with Microsoft Office Excel 2013

» Navigate the Excel User Interface
» Use Excel Commands
» Create and Save a Basic Workbook
» Enter Cell Data
» Use Excel Help

Lesson 2: Performing Calculations

» Create Worksheet Formulas
» Insert Functions
» Reuse Formulas

Lesson 3: Modifying a Worksheet

» Insert, Delete, and Adjust Cells, Columns, and Rows
» Search for and Replace Data
» Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

» Modify Fonts
» Add Borders and Colors to Worksheets
» Apply Number Formats
» Align Cell Contents
» Apply Styles and Themes
» Apply Basic Conditional Formatting
» Create and Use Templates

Lesson 5: Printing Workbooks

» Preview and Print a Workbook
» Define the Page Layout

Lesson 6: Managing Workbooks

» Manage Worksheets
» Manage Workbook and Worksheet Views
» Manage Workbook Properties