|

This course teaches intermediate level Excel-based applications to help forestry and wildlife professionals use Excel more effectively for solving problems in the workplace. Upon completion of this course, you should be able to:
- Efficiently sort and filter data
- Use advanced formula functions such as SUMIF, IF, and VLOOKUP
- Reorganize and summarize data using graphs, Pivot Tables and Pivot Charts
- Set up, record, and run macros using Visual Basic
- Import and export data to and from Access

Forest resource professionals who have a working knowledge of Microsoft Excel and want to become more powerful users. Important: This is not a course for beginners. Participants must have some familiarity with Excel to benefit from this course.

This course follows a seminar format, with the introduction of Excel applications and tools followed by hands-on, forestry-related exercises to reinforce the tools. Students will also have opportunities to ask about Excel-related issues or challenges specific to their work outside of this course. Handouts and a CD will be provided that summarize the material covered and provide Excel-based examples and samples.

Dr. Brooks Mendell is principal of Forisk Consulting, a timber market research and education firm. Brooks has 15 years of operating, research, and consulting experience in forestry and the forest-products industry. His industry experience includes roles in harvest operations and procurement with Weyerhaeuser and in management consulting with Accenture. Brooks earned BS and MS degrees at MIT; an MBA at the University of California, Berkeley; and a PhD in forest finance at UGA.
Dr. Tim Sydor joined Forisk Consulting in 2005 as a forest economist. Tim's professional experience includes roles in forest operations research at the University of Arkansas at Monticello and in forest management for the Tsuman State Forest Enterprise in Ukraine. His research and consulting include the study of factors driving timber and timberland markets. Tim earned a BS in forestry at the National Agricultural University of Ukraine, an MS in forest economics at Purdue University, and a PhD in forest economics at UGA.
Tim and Brooks use Excel to help clients and students organize, understand, and present data and information.

The fee for this course is $445, which includes lunch, refreshment breaks, and instructional materials. There is a $50 discount for fees paid by check or credit card and postmarked by May 14, 2007. Preregistration must be accompanied by check, purchase order, or credit card number to guarantee a place in the course. Limited seating is available.

- 11 Continuing Forestry Education (CFE) hours Category 1
- 11 Continuing Logger Education (CLE) hours Business Management
- 7 Georgia Real Estate Appraisers Board credits approved; hours accepted by the Georgia Real Estate Commission
Full Attendance Is Mandatory to Receive Credit.
If you are not satisfied with this course, we will refund your registration fee.
Third Course Free!
Attend two forestry courses in 2007 as a paid participant and get the third course (with equal or lower course fee) for free. Contact Nette Penn, at 706-542-6658 or Nette.Penn@georgiacenter.uga.edu, before you register for the third course.
Fourth Person Free!
Register three people from your organization and the fourth person is free. All registrants must be with the same program (same address and same budget), and the registration fees must be paid in advance by check or credit card.
|

All sessions to be held in WSFNR Computer Lab 210.
Monday, June 4, 2007 |
8:00 am |
Registration |
8:30 am |
Introductions and the Big Picture: Keeping Excel in Perspective |
9:00 am |
Excel Review: Data, Formulas, and Absolute References |
10:00 am |
Break |
10:15 am |
Data: Filtering, Sorting, and Importing |
11:00 am |
Advanced Formulas: SUMIF, IF, and VLOOKUP |
Noon |
Review and Tips for Setting Up Spreadsheets |
12:15 pm |
Lunch |
1:00 pm |
Pivot Tables and Pivot Chart Reports: Creating and Modifying |
2:30 pm |
Break |
2:45 pm |
Excel Shortcut Challenge for Foresters |
3:00 pm |
Pivot Tables and Pivot Chart reports: Printing |
3:30 pm |
Charts, Drawings, and Tables: Creating and Formatting |
4:45 pm |
Review and Tips for Organizing Workbooks |
5:00 pm |
Adjourn |
5:15 pm |
Professional Ethics in Forestry (optional) |
Tuesday, June 5, 2007 |
8:00 am |
Review and Unanswered Questions from Day 1 |
8:30 am |
Macros: Running, Recording, and Visual Basic |
10:00 am |
Break |
10:15 am |
Excel with Other Applications: Access, PowerPoint, and Word |
Noon |
Adjourn |

This optional one-hour course focuses on case studies to illustrate the place of ethics in the practice of forestry. It meets the ethics requirement for registered foresters in Georgia.
Now Available Online! Forestry Ethics Online Course
Now you can complete the one-hour Forestry Ethics Online Course from the comfort of your home or office. Register today for this self-paced, self-study program and earn CFE credit! Go here for more details: www.georgiacenter.uga.edu/is/forestry

The Georgia Center for Continuing Education Conference Center & Hotel,
located on the beautiful, historic campus of the University of Georgia in Athens, Georgia, provides innovative lifelong learning opportunities that develop intellectual and human potential. A total living and learning environment, the Georgia Center includes a 200-room hotel, restaurants, banquet areas, conference rooms, auditoriums, a fitness center, and computer lab all under one roof. As a unit of UGA's Office of the Vice President for Public Service and Outreach, the Center brings the University's teaching, research, and service expertise to the people of Georgia and beyond! For more information, visit www.georgiacenter.uga.edu.
Special Needs:
If you require special services, facilities, or dietary considerations, contact your event coordinator, Nette Penn at 706-542-6658 or Nette.Penn@georgiacenter.uga.edu prior to May 28, 2007.
Lodging (Georgia Center Hotel):
A block of rooms is being held for your conference until 5:00 p.m. ET,
May 13, 2007. Policies: (1) Tax Exemption The State of Georgia only allows tax-exempt charges for a payment by a state-issued credit card or check or by a direct bill to a state agency (with a Georgia State Tax Exemption Certificate). (2) Lodging Cancellation Cancel your reservation by 4:00 p.m. ET the day prior to your scheduled arrival to avoid being charged one night's room and tax. (3) At check-in, you must present your credit card or a completed credit card authorization form (for a copy, call 800-884-1381, Mon.-Fri., 8:00 a.m. to 5:00 p.m. ET). Note: The Georgia Center is a smoke-free building; all lodging rooms are nonsmoking.
Travel Information:
Athens, Georgia, is located about 60 miles northeast of Atlanta. For directions, see www.georgiacenter.uga.edu/conferences/about/directions.phtml. A parking deck is located adjacent to the Center (hourly rates, maximum $8 each 24-hour period; vehicle height limit, 7 feet). Athens is served by two airports. Athens-Ben Epps Airport offers connecting flights to and from Charlotte, NC. Hartsfield-Jackson Atlanta International Airport is located about 90 minutes southwest of Athens, with scheduled ground shuttle service and rental car service available between the airport and the Georgia Center.
Program Cancellation Policies:
(1) Full refunds are available for cancellations made by 5:00 p.m. ET,
May 24, 2007. No refunds will be issued thereafter; substitutions will be allowed. (2) If a program is cancelled for any reason, the Georgia Center will not be responsible for any charges related to travel. (3) If for unforeseen and unavoidable circumstances an instructor is unable to attend, the Georgia Center reserves the right to substitute a comparable instructor.

You have several registration options:
1. Register for this event online and request a room at the Georgia Center.
Register for the event online without requesting a hotel room.
A major credit card is required for on-line registration.
2. Call either 1-800-884-1381 or (706) 542-2134 to register by telephone. Please mention you saw this web page.
3. Download a registration form and FAX it to the number on the form or mail it to the address below. You need a copy of the free Adobe Acrobat Reader to view and print this application form.
4. Mail the form to:
Excel Tools and Functions for Forestry Professionals (#62803)
Attn: Conference Registration, Room 129
Georgia Center for Continuing Education
Conference Center & Hotel
The University of Georgia
Athens, GA 30602-3603
Payment of Fees
The Georgia Center for Continuing Education accepts payments for registration by cash (on-site), check (payable to the University of Georgia), and credit card (Visa, Mastercard, American Express, and Discover).
|
Directions |
Upcoming Conferences |
Forestry |
Soil/Erosion |
Gwinnett |
Long-Range Calendar
|
Need assistance finding something?
All contents copyright © 2008
University of Georgia Center for Continuing Education Conference Center and Hotel.
All rights reserved.
URL: http://www.georgiacenter.uga.edu/conferences/2007/Jun/04/excel.phtml
|
|