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