Lubbock Excel to the Max 1/29-30/2019 (2 Day Class)

Length

14 hours (2 days)

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 the intermediate to advanced Excel user who wants to expand their knowledge of Excel. The focus of this class are topics such as Formulas, PivotTables, Charts, working with Multiple sheets and files and much more. Also we focus on learning shortcuts, keystrokes and the most efficient way to accomplish a task. In the class, you will learn:

FORMULA BASICS, ABSOLUTE REFERENCES AND NAMED RANGES

Review Basic Formulas

Work with Relative and Absolute References

Use Formula Auditing Tools

Create and use Named Ranges

Understand Guidelines and Scope of Named Ranges

Work with Shortcuts and Common Keystrokes

ADVANCED FORMULAS

Understand the Parts of a Function

Use Auto-Calculate

Create Subtotals and Grand Totals

Work with Order of Calculation

Learn the IF and VLOOKUP Function

Work with text functions like CONCATENATE, LEFT, RIGHT, LEN

More text Functions such as UPPER, LOWER AND PROPER

Use the Text-to-Columns feature

Look at the new Flash Fill feature

Use Paste Special

Protect your formulas and files

Work with Date Functions like TODAY and NOW

Perform Date Calculations

WORKING WITH MULTIPLE SHEETS AND LINKS

Learn Excel’s sheet options

Learn to quickly navigate sheets

Learn to Copy and Insert sheets

Rename and Color sheet tabs

Group sheets and work with all sheets simultaneously

Ungroup sheets

Move and Copy sheets within the workbook and to new workbooks

Create three-dimensional formulas

View multiple sheets at the same time

Link workbooks and manage the links

Use Comments

Freeze Rows and Columns

Learn to Split Views

CHARTING

Create a Chart

Change the Chart Layout and Style

Use the new Recommended Charts and Chart Types

Change the Chart Type

Modifying Charts and Work with Chart Elements

Expand the Chart Data

Create and use Chart Templates

Look at the new Sparkline feature

EXCEL’S DATABASE FEATURES

Setup your spreadsheet correctly for Data features

Learn to Sort alphabetically, numerically, chronologically, colors, by icons and by custom list

Use Data Subtotals

Learn various ways to Filter data

Create Tables and Understand their benefits

Create and Modify PivotTables

Work with PivotTable Slicers and Timelines

Work with Recommended PivotTables

QUICK LOOK AT OTHER EXCEL FEATURES

Modify the Quick Access Toolbar

Customize the Status bar

Learn the benefit of using Styles

Work with Conditional Formatting

Modify the Ribbon and use Text to Speech

Work with Custom Views

Who Should Attend

Intermediate or Advanced Excel users who would like to expand their knowledge of Excel

Prerequisites

Students must have a beginner level knowledge of Microsoft Excel.

Class must be canceled 5 days before start date

Class Information

Class date: 01/29/19
Class end date: 01/30/19
Seats Remaining: 0
Cut off date: 01/29/19
Individual Price: $279.00
Location: Lubbock Classroom

Group Rate

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