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

×

Share Your Needs



Information Request (check all that apply - your information is private)
Areas of Interest (check all that apply)

(e.g., MS Excel on-site)

loading
×
Business & Industry Services (BIS)
5 N. Systems Drive
Appleton, WI 54914-1655

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