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

 

   

 

 
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 or those who have completed the basic Excel 2013 course. This course emphasizes using traditional keyboard and mouse actions to perform tasks, with some relevant tips for working with a Windows 8 touch-screen device also provided.

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
  • Use the Watch Window to view cells
  • Display the active workbook in multiple windows
  • Split a single worksheet into multiple panes
  • Protect and unprotect cells and hide formulas

Designed For

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

Prerequisite

"Microsoft r Excel r 2013: Getting Started" (GSWE) or equivalent experience working with Excel 2013 in the Windows 8 (or earlier versions) operating system environment
Add to Cart