Microsoft Excel Level 1

Hours: 6.00 | Estimated Cost: $179.00

Learn to use Microsoft® Excel® 2016 to create spreadsheets and workbooks that you can use to store, manipulate and share your data.

Additional Information

Learn About

• Creating a basic worksheet
• Performing calculations
• Modifying a worksheet
• Formatting a worksheet
• Printing workbooks
• Managing workbooks

Benefits & Outcomes

• Improve productivity by allowing mundane tasks to be completed more efficiently
• Learn valuable tips and tricks to improve efficiency and accuracy

Training Outline

**Getting Started with Microsoft Excel 2016**

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

**Performing Calculations**

• Create Worksheet Formulas
• Insert Functions
• Reuse Formulas and Functions

**Modifying a Worksheet**

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

**Formatting a Worksheet**

• Apply Text Formats
• Apply Number Formats
• Align Cell Contents
• Apply Styles and Themes
• Apply Basic Conditional Formatting
• Create and Use Templates

**Printing Workbooks**

• Preview and Print a Workbook
• Define the Page layout
• Configure Headers and Footers

**Managing Workbooks**

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