Lubbock Excel to the Max 12/18-19/2017 (2 Day Class)

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

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

This course is designed for intermediate to advanced user.  In the class you will learn the following:

Understand Absolute References
•    Work with relative and absolute references
•    Create and use Absolute References

Create and use Named Ranges
•    Navigate with named ranges
•    Use named ranges in formulas
•    Print using range names

Working with multiple pages in a workbook
•    Group sheets
•    Navigate multiple sheets
•    Link multiple sheets

Advanced formulas
•    The IF Function
•    The Vlookup Function
•    Text Functions
•    The Concatenate Function

Working with Dates
•    Understand date serial numbers
•    Create date formats
•    The Now Function
•    The Today Function

Charting
•    Creating a chart
•    Modifying charts
•    Create user defined charts

Database Functions
•    Sorting
•    Custom Sorts
•    Filtering
•    Create And/Or Conditions
•    Automatic Subtotaling
•    Pivot Tables

Customizing the Work Area
•    Add, Delete and Rearrange toolbar buttons 
•    Working with Styles
•    Creating and Using Templates
•    Learn shortcuts

Working with Macros
•    Running macros
•    Recording macros
•    The Basics of VBA
•    Viewing and Editing macro

Class must be canceled 5 days before start date

Class Information

Class date: 12/18/17
Class end date: 12/19/17
Seats Remaining: 9
Cut off date: 12/18/17
Individual Price: $279.00
Location: Lubbock County Training Center

Group Rate

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