Excel 2013 - Part 1

Course details

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

Lesson

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