THIS COURSE IS CURRENTLY FULL
join Waiting List
Excel to the Max - February 22-23, 2010
 
 

Title: Excel to the Max

Date: February 22-23, 2010

Time: 8:30am - 4:30pm

Instructor: Darla 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 January 22, 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: Darla Cloud

    Darla Cloud with Cloud Training Services has been teaching computer classes for over 16 years. Darla trains on a variety of computer software products-both industry-specific and off-the-shelf. However, a major focus of her business has been on training Microsoft Office products such as Word, Excel, PowerPoint, Access, Outlook and Publisher. She has spent years learning tips, tricks and shortcuts that she will pass on during her class.

    Darla’s training experiences come from “real world experiences,” not just books. In addition to Darlas years of teaching, she also has over seven years of audit experience. Darla is a Certified Public Accountant and a Certified Technical Trainer. She has authored numerous technical manuals, software manuals and operations manuals. So, when it comes to teaching word processing techniques needed when writing large documents and/or reports she has first-hand experience. Her accounting experience has made her an excellent Excel and Access trainer.

    CPE: 16 hours

    Level:Intermediate to Advanced

    Type of Class: Computer

    TX Board of Public Accountancy Sponsor Number: 009317

    Cancellation Information: Cancellation Date: February 8, 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.

    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