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
Business & Industry Services (BIS)
5 N. Systems Drive
Appleton, WI 54914-1655

P: 888-458-0449
P: 920-735-2525
F: 920-735-4771