Microsoft Excel Fundamentals

Learning outcomes

Getting Started with Microsoft Excel

• Navigate the Excel User Interface

• Use Excel Commands

• Creating and Save a Basic Workbook

• Enter Cell Data

• Use Excel Help

Performing Calculations

• Creating Formulas in a Worksheet

• Insert Functions in a Worksheet

• Reuse Formula

Modifying a Worksheet

• Manipulate Data

• Insert, Manipulate, and Delete Cells, Columns, and Rows

• Search for and Replace Data

• Use Proofing and Research Tools

   

Formatting a Worksheet

• Modify Fonts

• Add Borders and Color to Cells

• Apply Number Formats

• Align Cell Contents

• Apply Cell Styles and Themes

• Apply Basic conditional formatting

• Create and Use Templates

   

Printing Workbook Contents

• Preview and Print a Workbook

• Define the Page Layout

   

Managing Large Workbooks

• Manage Worksheets

• Manage the View of Worksheets and Workbooks

• Manage Workbook Properties