1 - day course
Print this page
Course Code: S161en
Who should attend?
This course is intended for new Microsoft Excel 2016 users.
Prerequisites
Windows XP, Windows Vista, Windows 7, Windows 8, or Windows 10
Course Objectives
Upon completion of the course, participants will be able to accomplish the following:
  • Create, save, open, close and move around in an Excel workbook to learn navigation skills necessary for creating and using Excel worksheets.
  • Organize columns and rows to accommodate information and edit the contents of cells to organize the information in your worksheet.
  • Calculate values by entering formulas into cells and specify an exact address of a cell by creating an absolute cell reference, create formulas by typing functions or build more complex formulas using the Insert Function dialog box.
  • Format worksheets and use view features to more effectively review large worksheets.
  • Use views to determine the layout of a worksheet, change the page setup, and preview/print workbooks.
Course Content  
    Getting Started with Excel 2016
    Understanding Spreadsheet Concepts ; Getting Started ; Creating and Saving Workbooks ; Opening and Closing Workbooks ;
    Modifying Worksheets
    Working with Columns and Rows ; Working with Cell Contents ;
    Using Formulas and Functions
    Creating and Using Formulas ; Creating and Using Functions ; Using Absolute Cell References ; Inserting Functions ;
    Formatting and Viewing Worksheets
    Formatting Worksheets ; Viewing Worksheets ;
    Printing Workbooks
    Using Workbook Views ; Changing the Page Setup ; Previewing and Printing Workbooks ;