Customer Service: 800-778-7436     

    Log In to Your Surgent Account

    Forgot?
    Forgot?

    Register for an Account

Sign In to Your Surgent Account

Forgot Username or Password | Register for an Account

Choose CPE Format:

Live WebinarSELECT

There are currently no upcoming dates scheduled for this webinar. Please fill out this short form to be notified when this webinar is next available. 

FIRST NAME
LAST NAME
EMAIL ADDRESS
COMMENTS (OPTIONAL)
Self-StudySELECT STARTING AT $65

Downloadable PDF

Credits: 4

Qualifies For:

$65

Textbook

Credits: 4

Qualifies For:

$80
Get this course FREE with an Unlimited Package! Learn More
  • It was an awesome course. I have recommended it to a couple of CPA friends.

    - A Surgent Customer

Interested in bringing this course into your firm?

PRIVATE WEBINARS AND LIVE ON-SITE COURSES ARE AVAILABLE. LEARN MORE.

Microsoft Excel 2013: Working with Formulas and Functions Using a Touch Screen (WFFT)

  • Customer Rating
  • Field of Study
    Spec. Knowledge
  • Level
    Intermediate
  • Credits
    4
  • Qualifies for

    CPE

Overview

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.

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

Learning 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
  •  

 

Who should take this course:

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 ® Excel ® 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

Advanced Preparation:

None

Loading...

Loading...

Thank You!

YOU HAVE ADDED THE FOLLOWING TO YOUR CART:


Loading...

Thank You!

Thank You! Your request has been submitted.



Get More with a Surgent CPE package

Self-Study Library Package

  • Unlimited 24/7 access to 200+ downloadable self-study courses

  • Courses range from 2-20 credits

  • Provides online grading & CPE certificates by email

$499

Learn More

Unlimited Webinar Package

  • Unlimited access to all non-premium live CPE webinars

  • Includes 1-, 2-, 3-, 4-, and 8-hour webinars, including Saturday and evening options

  • Access through 12/31/16

$649

Learn More

Unlimited Plus Package

  • Unlimited access to ALL live CPE webinars

  • Includes all premium courses and virtual conferences

  • Unlimited 24/7 access to all self-study courses

  • Includes all on-demand webcasts Access for a year from purchase date

  • Unlimited 24/7 access to all self-study courses

$849

Learn More
  • CPE Continuing Professional Education for CPAs

  • IRS Continuing Education for EAs and the AFSP program

  • CFP Accepted by the CFP® Board

  • YB YellowBook Continuing Education

Explore Additional Courses by Topic

SURGENT IS APPROVED AS A PROVIDER OF CONTINUING EDUCATION BY:

Thank You!

Thank You! Your subscription has been submitted.