Microsoft Excel Level 1

Hours: 6.00 | Estimated Cost: $179.00

Gain the foundational understanding of Microsoft Office Excel 2019 that is necessary to create and work with electronic spreadsheets. Prerequisites: Be comfortable in the Windows 10 environment, and be able to use Windows 10 to manage information on their computers.

Additional Information

• Learn About

  * Getting started with Microsoft Office Excel 2019
  * 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**
  * 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