Lubbock Excel to the Max 1/23-24/2018 (2 Day Class)

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

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

•    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: 01/23/18
Class end date: 01/24/18
Seats Remaining: 9
Cut off date: 01/23/18
Individual Price: $279.00
Location: Lubbock County Training Center

Group Rate

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