Brownwood - Excel for the Business Professional 5/28/2020 (Level 2)

NON-MEMBER PRICE: $169.00

CHAMBER Member Price - $149.00 (Use the coupon code save20)

Length

6.5 hours (1 day)

Class Time

8:30 a.m. – 4:00 p.m.
One-hour break for lunch and a 15-minute morning and afternoon break.

Location:

Brownwood Chamber of Commerce – Board Room
600 E Depot St
Brownwood, TX 76801

Learning Objectives:

This class is designed for the intermediate Excel user. The focus of this class is more intermediate Excel formulas. We will learn decision-making formulas such as IF statements and VLOOKUPS. We will also look at text functions like CONCATENATE, LEFT and RIGHT. This class will introduce new Microsoft Office features like Flash Fill. The afternoon will focus on Excel’s database (list) features like sorting, filtering, Table and PivotTables. We have been teaching computer classes for over 30 years and this class focuses on everyday skills that most Excel users need.

FORMULA BASICS, ABSOLUTE REFERENCES AND NAMED RANGES

  • Work with Relative and Absolute references
  • Use Formula Auditing Tools
  • Create and use Named Ranges
  • Work with Shortcuts and Common Keystrokes

ADVANCED FORMULAS

  • Understand the Parts of a Function
  • Use Auto-Calculate
  • Create Subtotals and Grand Totals
  • Learn the IF and VLOOKUP Function
  • Work with text functions like CONCATENATE, LEFT, RIGHT, LEN
  • Look at the new Flash Fill feature
  • Use Paste Special
  • Protect your formulas and files

EXCEL’S DATABASE FEATURES

  • Setup your spreadsheet
  • Learn to Sort alphabetically, numerically, chronologically, colors, by icons and by a custom list
  • Use Data Subtotals
  • Learn various ways to Filter data
  • Create Tables
  • Create and Modify PivotTables
  • Work with PivotTable Slicers and Timelines
  • Work with Recommended PivotTables

WHO SHOULD ATTEND?

Anyone who wants to learn Excel.

PREREQUISITES

Excel Level 1 or equivalent knowledge.

Class must be canceled 5 days before start date

Event Properties

Event Date 05-28-2020 8:30 am
Event End Date 05-28-2020 4:30 am
Capacity 14
Registered 7
Available place 7
Cut off date 05-28-2020
Individual Price $169.00
Location Brownwood Chamber of Commerce – Board Room
We are no longer accepting registration for this event

Location Map