MenuClose
 Log Out
Cart 0 items
Site Search
Course Search

Surgent's Microsoftr Excelr 2019: Working with Formulas and Functions

 Currently available
 
4.0
26 / S-60515
Registration is Open
Member Price
$79.00 Regular Registration
Your Price
$83.00 Regular Registration
Designed For:

Users experienced with using Excel 2019 in the Windows 10 operating system environment or experienced Excel users switching from earlier versions of Excel.

Prerequisite:

Experience working with Excel 2019 in the Windows operating system environment

This course guides you through creating, copying and pasting, reviewing, and correcting basic and complex formulas in Excel 2019 using step-by-step, hands-on activities.

Delivery Method: Download
CPE Credit: Computer software & applications
Program Level: Intermediate

This course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.

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

Advanced Preparation

None

Vendor

The Virginia Society of CPAs (VSCPA) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: NASBARegistry.org.

For more information regarding refund, complaint, program cancellation or other policies, visit our Registration Policies page or call (800) 733-8272.