Lubbock - Excel Focus on Formulas 2/6/2018 (Level 1)

Class time: 8:30am - 4:30pm

Location:
Lubbock County Training Center
916 Main Street 10th Floor
Lubbock, TX 79401

Prerequisites: Basic Excel Knowledge

This class is designed for users that would like to focus on learning Excel formulas. We will begin by reviewing formula basics and the day will evolve through the most commonly used Excel formulas.

Below is a general outline of topics covered in this class:

  • Review of basic calculations such as how to add, subtract, multiple and divide
  • Understanding the structure of Functions
  • Looking at the basics Functions such as SUM, AVERAGE, COUNT, MAX and MIN
  • How to use the Formula Auditing Features
  • How to use Absolute References
  • Learn how to use Range Names and their advantages
  • How to write and IF statement
  • How to nest and IF statement
  • Using VLOOKUP and HLOOKUP functions
  • Working with MATCH and INDEX functions
  • Using IFERROR
  • Using the ROUND function
  • Working with CEILINGMATH and FLOORMATH
  • Working with Dates and Date Functions
  • Working with text functions such as CONCATENATE, LEFT and RIGHT
  • Work with Text-to-Columns and Flash Fill

These topics and many more will be covered in this exciting new class. You will not want to miss it.

For class fees paid directly to Cloud Training Services a person must cancel by the class deadline to receive a full refund. The cancellation deadline varies based upon location but it usually 5 to 10 days prior to the class. The cancellation deadline is stated at the top of this page.

If you are unable to attend and do not cancel prior to the class, you may send a substitute. Cloud Training Services will consider emergency situations such as a death in the family, illness and weather, and will make every attempt to work with the person in the event of an emergency.

Note: Cloud Training Services partners with other traning vendors such as Odessa College and New Mexico Junior College and has no control over payment and registration process. When the registration fees are paid to another agency or vendor, the cancellation and refund policy will be those of that agency or vendor.

Class Information

Class date: 02/06/18
Class end date: 02/06/18
Seats Remaining: 10
Cut off date: 02/06/18
Individual Price: $169.00
Location: Lubbock County Training Center

Group Rate

No Number registrants Rate/Person($)
1 3 149.00
Share this class: