Continuing Studies and Outreach
Search
09-CPT306 - Microsoft Excel 2007 Advanced Skills November 4, 2009 - December 2, 2009
**Class will not meet Wednesday, November 25**

**Approved for 12.0 Hours of CPE**

*This is the third course in the three part series preparing the student for the Microsoft Certified Application Specialist (MCAS) exam - Microsoft Excel 2007.

*Prerequisite: Microsoft Excel 2007 Essential Skills and Building Productivity classes or comfort level in skills covered in those courses.  

This class is intended to increase efficiency in using Excel by expanding on the skills covered in the first two courses.  
In this course you will learn and practice the following Excel 2007 techniques: using AutoFill to copy or fill data; finding and replacing specific types of data; consolidating and summarizing data; grouping and outlining data; converting text to columns; using AutoFill to set up a series of data; finding and replacing data in a worksheet; using paste special to create different types of data; creating groups and subtotals from the data in the worksheet; converting text to columnar formats; validating data and removing duplicate rows of data; using pick lists; working with existing templates; creating your own template; creating, modifying and removing a hyperlink; saving a worksheet or a range of cells in a HTML format; publishing a worksheet to the Internet; working with shared workbooks including adding protection or tracking changes; changing workbook properties and using the Document Inspector appropriately; setting up what-if scenarios with a worksheet; using the Goal Seeking and Solver tool; working with a single or two variable data table; and creating and modifying PivotTables and PivotCharts.

MEET THE INSTRUCTOR:
Diane Kutz

For the past twenty-two years, Diane Kutz has utilized her business and technical knowledge to effectively integrate business technology in the office environment.  She specializes in analyzing current business processes and procedures and applying office automation in order to improve the efficiency of the office.  Employed by companies such as Fotomat/Konica, Fiserv, United Insurance Companies, and Aegon Insurance, she has been the liaison between the IT department and the functional departments.  As such, she used her business experience to implement automated processes to improve upon manual business processes.  

At Fotomat, she supported all general business functions and conducted training sessions in office automation software as well as proprietary software.  Fiserv provided financial services to credit unions and Diane not only provided support for inside office automation but would also implement, train, and support member credit unions in the use of Fiserv automation.  In her position at United Insurance Company's, Student Insurance Division, a sales office, Diane directly assisted administrative personnel and sales executives in office procedures.

Currently Diane is using her knowledge to assist businesses throughout the area under her company, Kutz Training and Professional Services.  She also facilitates continuing education courses in Microsoft Word, Excel, Access, PowerPoint, Publisher, Project, Outlook, Windows XP, Internet Explorer and QuickBooks for The University of North Alabama.

Diane has a Bachelors Degree in Management Information Systems from The University of South Florida and an MBA in Computer Information Systems from The University of North Alabama.

DAILY SCHEDULE
DATE START TIME END TIME
11/4/2009, Wed 8:30AM 11:30AM
11/11/2009, Wed 8:30AM 11:30AM
11/18/2009, Wed 8:30AM 11:30AM
12/2/2009, Wed 8:30AM 11:30AM
Facility
      UNA EAST CAMPUS ROOM 106
      1640 Tune Ave
      FLORENCE, AL 35630
      Phone:   256-765-4862
      Fax:   256-765-4872

    Facility Description:   Please park in the east side parking lot and enter in the side door.  (You will need to go behind the building to reach the east side parking lot.)   Handicapped parking is located in the back of the building.  UNA East Campus is located at 1640 Tune Avenue, Florence, AL.

    Directions To UNA East Campus from Huntsville:
    Take U.S. Hwy 72 West through Madison, Athens, Rogersville and Killen to Florence; in Florence, 72 also becomes Florence Boulevard.   
    On (Florence Boulevard and US Hwy72), continue west across Cox Creek Parkway for 1.7 miles and take a right onto Darby Drive and take a left at the first traffic light (Decatur Ave).  After going through a 4-way stop take a left onto Tune Ave and another left into the parking lot.   

    Directions to UNA East Campus from downtown Florence:
    On (Florence Boulevard and US Hwy 72) take a left onto Darby Drive and take a left at the first traffic light (Decatur Ave).  After going through a 4-way stop take a left onto Tune Ave and another left into the parking lot.  

    For more information, please call 256-765-4862.

CE CREDITS
CREDIT TYPE SPONSOR CREDITS
COM UNA 1.2
CPE UNA 12

To register, please enter the following information. NOTE: You must pay by credit card or company PO to process this registration. Please enter any notes or comments below:
  


© Copyright 1999-2009 Peopleware. All Rights Reserved.