Lubbock - Focus on Excel Formulas 4/29/2019

Length

7 hours (1 day)

Class Time

8:30 a.m. – 4:30 p.m.

One-hour break for lunch and a 15-minute morning and afternoon break

Location:

Lubbock Classroom
Melonie Park Meeting Space
3502 74th Street
Lubbock, TX 79423

Course Description

This class is designed for users who 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. In this class, you will learn:

FORMULA BASICS AND UNDERSTANDING FUNCTIONS

Quickly Review Simple Formulas

Understanding the Structure of Functions

Looking at the Common Basics Functions such as SUM, AVERAGE, COUNT, MAX, MIN, COUNTIF AND SUMIF

ABSOLUTE ADDRESSES AND RANGE NAMES

How and When to use Absolute and Mixed References

How to use the Formula Auditing Features

Learn how to Create` Range Names and their advantages

INTERMEDIATE AND ADVANCED FUNCTIONS

How to write and IF statement and nest IF statements

Using VLOOKUP and HLOOKUP functions

Working with MATCH and INDEX functions

Learn the ROUND functions

Using IFERROR

Using Date Functions such as TODAY, NOW, WEEKDAY and WORKDAY

Working with text functions such as CONCATENATE, LEFT and RIGHT, LEN, UPPER, LOWER and PROPER

New Functions like REPT

Work with Text-to-Columns and Flash Fill

Learn how to user TRIM to remove spaces

Work with Paste Special

Learn Three Dimensional Functions

Who Should Attend

Any users who would like to expand their knowledge of Excel.

Prerequisites

This class works with basic to advanced formulas Any level of student may attend this class. However, it is recommended that students have a basic understanding of Excel and know how to create basic formulas such a add, subtract, multiply, divide and use basic functions such as =Sum().

Class must be canceled 5 days before start date

Class Information

Class date: 04/29/19
Class end date: 04/29/19
Seats Remaining: 5
Cut off date: 04/29/19
Individual Price: $169.00
Location: Lubbock Classroom

Group Rate

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