Self-Study

Surgent's Microsoft Excel 2013: Getting Started Using a Touch Screen (GSET)

  • Monday, May 1 – Sunday, December 31, 2017

  • 6
    CREDITS
    Specialized Knowledge

This course introduces you to the Excel 2013 software and then guides you through basic Excel features using step-by-step hands-on activities. This course emphasizes using finger gestures and the keyboard to perform tasks in the Windows 8 operating system environment - mouse actions are not included.

Objectives

  • Explain how the Excel software is used
  • Start Excel
  • Identify the components of the Excel window
  • Describe a workbook and a worksheet
  • Navigate and select in a worksheet
  • Modify user options or preferences
  • Create and save a workbook
  • Enter, edit, and format text and numbers
  • Create basic formulas and use functions
  • Work in different worksheet views
  • Preview and print a worksheet
  • Work in Backstage view
  • Use the Quick Access Toolbar, the Ribbon, shortcut menus, and keyboard shortcuts to perform basic tasks

Highlights

  • Describe the Excel application and explain how it is used
  • Start Excel, describe the Start screen, and create a new workbook
  • Describe Excel window elements
  • Open an existing workbook
  • Navigate in a worksheet
  • Select in a worksheet
  • Change Excel options
  • Access Excel help and use Key Tips
  • Close a workbook and close Excel
  • Save a workbook
  • Insert, reposition, select, delete and rename worksheets
  • Enter, edit and format cell contents
  • Create formulas
  • Use functions
  • Apply Accounting and Percent Style formatting
  • Use Flash Fill for data entry
  • Show and hide worksheet elements
  • Undo and redo an action
  • Work in Normal view, Page Layout view and Page Break Preview
  • Set page setup options, preview, and print a worksheet

Additional Information

Designed For

New Excel users or experienced Excel users switching from earlier versions

Vendor

Surgent

Advanced Preparation

None

Prerequisite

None

Field of Study

Specialized Knowledge

Course Number

17GSET-DN

Level of Knowledge

Basic

Add to Cart

View All Courses