Print Page   |   Contact Us   |   Your Cart   |   Sign In   |   Join
Excel - Building Powerful Lookup & Reference Formulas CXOXLS123W2
View Registrations Tell a Friend About This EventTell a Friend
 

Excel has over 500 functions that are built-in and ready to use. You just have to figure out which one to use and when. Integrating functions into each and every one of your spreadsheets not only improves efficiency, it also makes your task easier to execute.

 Export to Your Calendar 11/22/2017
When: 11:00 AM to 1:00 PM
Where: Webinar/Webcast
United States
Presenter: Bryan L. Smith, CPA.CITP, CISA
Contact: April Deneault
801-466-9005
« Go to Upcoming Event List  

Office 365

Field of Study

Computer Software & Applications - Non-Technical

Credit:  2

Level:  Intermediate

Designed for:

All Excel users who want to become Excel Formula Experts

Objective

After completing this class you will have the ability to...

  • Create complex lookup formulas
  • Use the INDIRECT function to speed worksheet creation
  • Use ERROR checking functions in calculations

Description

The major topics that will be covered in this class include:

  • Performing advanced searching & data retrieval with LOOKUP, INDEX & MATCH functions
  • Speeding up worksheet creation with the INDIRECT function
  • Testing conditions with the LOGICAL functions (IF, AND, OR, NOT)
  • Using ERROR checking functions

 

Price:  $79.00

Link to register:  http://cpe.cpacrossings.com/CXOXLS123W2?partner=uacpa

Event Code:  8031

Keywords:

Excel Formula Expert Data Preparation Design Logical Function Indirect Error Checking Lookup

Membership Management Software Powered by YourMembership  ::  Legal