1 - day course
Print this page
Course Code: S151en
Who should attend?
This course is intended for new Microsoft Excel 2013 users.
Prerequisites
Windows XP, Windows Vista, Windows 7, or Windows 8
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 2013
    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 ;