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

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

Location:

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

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 macro
• The Basics of VBA
• Viewing and Editing macro

Class must be canceled 5 days before start date

Class Information

Class date: 01/29/19
Class end date: 01/30/19
Seats Remaining: 6
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: