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