Surgent's Microsoft Excel 2013: Working with Formulas and Functions Using

 

   

 

 
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