New Search

Overview

4.0 Credits

This course guides you through creating, copying and pasting, reviewing, and correcting basic and complex formulas in Excel 2013 using step-by-step hands-on activities. It is ideal for users familiar with Excel 2013 using a touch-screen or those who have completed the basic course on Excel 2013 using a touch-screen. 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

  • Describe formula and function syntax and create basic formulas
  • Copy/paste and fill formulas
  • Enter formulas on grouped worksheets
  • Use multiple methods to build formulas
  • Apply conditional formatting to formulas' results
  • Find and correct formula errors using a variety of tools, such as the Error Checking feature and Trace Error icon, the Formula Auditing tools, and the Watch Window

Major Topics

  • Describe formula and function syntax
  • Create basic formulas
  • Paste and fill formulas with relative references
  • Create quick calculations with status bar options and Sum (AutoSum)
  • Paste and fill formulas with mixed or absolute references
  • Paste formulas' results as values
  • Enter formulas on grouped worksheets
  • Use Formula AutoComplete and create formulas with 3-D references
  • Use the Insert Function button and the Function Library
  • Use defined names as function arguments
  • Apply conditional formatting to the formulas' results
  • Use the Error Checking feature and the Trace Error icon to identify and correct common errors
  • Use the Formula Auditing tools to trace a formula's precedent and dependent cells
  • Create and resolve a circular reference in a formula
  • Use color-coded cell borders to correct a cell reference error in a formula
  • Step through a nested formula

Designed For

Users experienced with using Excel 2013 in the Windows 8 operating system environment using a touch-screen, or experienced Excel users switching from earlier versions of Excel.

Prerequisite

"Microsoft r Excel r 2013: Getting Started Using a Touch-Screen" (GSET) or equivalent experience working with Excel 2013 in the Windows 8 (or earlier versions) operating system environment using a touch-screen
Add to Cart