Excel to the Max - September 20-21, 2010
 
To register for this course, please enter the registrant's unique ID and click "Register Now". The unique ID is composed of the last name of the registrant (without any punctuation) and the last 4 digits of the registrant's social security number.
 
UniqueID:     
 

Title: Excel to the Max

Date: September 20-21, 2010

Time: 8:30am - 4:30pm

Instructor: Gary Cloud

Location: The course is being held in the City of Austin's Small Business Development Program computer lab located at 505 Barton Springs Road in the One Texas Center building in Austin, Texas. You can get a map to this building by accessing: City of Austin's SBDP Computer Lab

Price: $425
Early Bird Discount: $399 if you register by August 20, 2010.

Software Version: This class is taught on Microsoft 2003 Excel software. Our instructor is able to provide some in-class instruction for Microsoft 2007 users.

Course Description:

Designed for the intermediate to advanced Excel user, this interactive two-day class will move you to the next level of knowledge of Excel. Packed full of shortcuts, this popular class will help you discover new ways to use Excel to help you in your daily work.

Course Outline

DAY 1:

Absolute References

  • Work with Relative & Absolute Addresses
  • Create and Use Absolute Addresses

    Named Ranges

  • Navigate with Named Ranges
  • Use Named Ranges in Formulas
  • Print Using Range Names

    Multiple Sheet Workbooks

  • Navigate Multiple Sheets
  • Name and Copy Sheets
  • Work with Grouped Sheets
  • Link Sheets

    Advanced Formulas

  • Work with the Insert Function Dialog Box
  • Work with Auto Calculate
  • Create IF and Lookup Functions
  • Understand the ISERROR Function
  • Use the ROUND Function
  • Learn TEXT Functions
  • Work with DATE Functions

    DAY 2:

    Charting

  • Create charts
  • Modify charts
  • Annotate charts
  • Create User Defined Charts

    Database Functions

  • Learn Sorting & Custom Sorts
  • Work with Custom Lists
  • Use Filters & Advanced Filters
  • Create And/Or Conditions
  • Work with Automatic Subtotaling
  • Understand Pivot Tables

    Shortcuts and Features

  • Learn Shortcuts
  • Work with Text to Speech

    Introduction to Macros

  • Learn VBA Basics
  • Understand Absolute vs. Relative Recording
  • Run macros
  • View and Edit Macros

    Instructor Bio: Gary Cloud

    Gary Cloud with Cloud Training Services has been teaching computer classes since 1996. He trains on a variety of computer software products-both industry-specific and off-the-shelf. However, a major focus of his training has been on training Microsoft Office products such as Word, Excel, PowerPoint, Access and Outlook. During his years of training he has worked with a variety of industries, including banking. utility, medical, local and state government and higher education.

    Gary holds a B.A. from Texas Wesleyan University and a M.A.M. from Wayland Baptist University.

    CPE: 16 hours

    Level:Intermediate to Advanced

    Type of Class: Computer

    TX Board of Public Accountancy Sponsor Number: 009317

    Cancellation Information: Cancellation Date: September 3, 2010
    To cancel your registration from this course, please call or email the course contact listed below.

    Cancellation Policy for Computer Classes: If a cancellation is received after the cancellation date, the registrant may send a replacement, or be charged in full. A set of course materials will be sent to the registrant.

    If you are making travel plans to come to the training, please make "refundable" air and hotel reservations or wait until 14 days before the class to actually book your reservations. Courses are occasionally canceled or rescheduled due to low enrollment. We determine whether a course has enough participants approximately 16 days prior to the course date. If we cancel or reschedule, we will email the participant no later than 14 days before the original class date. Solutions Training will not pay for cancellation/change fees associated with travel and hotel arrangement changes.

    Class participants will be billed after the class. Payment should be made to SOLUTIONS TRAINING GROUP, Federal Tax ID: 20-2732184 and mailed to 2701 Maria Anna Rd, Austin, TX 78703. If you have any questions, please contact Shannon Bieberdorf at (512) 914-5557 shannon@solutionstraininggroup.com.

    For additional information about this class, please contact Laurie Garrant at laurie@solutionstraininggroup.com, (512) 914-5567.

  •      Your schedule, your location.

    To train your group, Solutions Training Group On-site training is the right choice.
    • We have courses to fit your training needs from business writing to technical training.

    • We offer professional trainers with real-world experience and high-energy presentation styles.

    • We can customize the classes to address your unique needs.
    100% satisfaction guarantee

    Let us help you make the training day a celebration for your office.

    Call 512-914-5557



       
    ©2008. Solutions Training Group. All rights reserved. Courses             Contacts