Excel 2013 - Part 1

Course details

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

Course Outline

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

2 - Performing Calculations

• Create Worksheet Formulas 
• Insert Functions 
• Reuse Formulas

3 - Modifying a Worksheet

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

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

5 - Printing Workbooks

• Preview and Print a Workbook
• Define the Page Layout

6 - Managing Workbooks

• Manage Worksheets 
• Manage Workbook and Worksheet Views
• Manage Workbook Properties

Target Audience: This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2013 that is necessary to create and work with electronic spreadsheets.