ASU Continuing Education and Community Outreach
106 N. Caraway Road
Jonesboro, AR 72401
Driving Directions
Parking
Approaching Arkansas State University from Stadium, turn right or left onto Johnson Avenue, turn left at the second light onto Caraway Road. Turn right into the parking garage, where visitor parking is available. Visitor parking marked with a "V".
Parking Garage Map
Sue Melton
Sue is a 2003 graduate of Arkansas State University with a degree in Management Information Systems. Sue currently works for ASU CECO as a Computer Technology Instructor with responsibilities in various areas of maintaining computers for the CECO Department and acting as the help desk person for CECO and Degree Centers. Sue lives in Jonesboro, AR and is married to Yvonne Melton. Sue enjoys being active in her church. She loves camping, swimming, fishing, and doing almost any activity with her children and grandchildren.
After an introduction to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and learn how to manage large workbooks.Course manual comes with CertBlaster exam prep software (download). This course will help students prepare for the Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882) and the Microsoft Office Specialist Expert exam for Excel 2010 (exam 77-888). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Excel 2010. Table Of Contents: Unit 1: Getting started Topic A: Spreadsheet terminology Topic B: The Excel environment Topic C: Getting help Topic D: Navigating a worksheet Unit 2: Entering and editing data Topic A: Entering and editing text and values Topic B: Entering and editing formulas Topic C: Working with pictures Topic D: Saving and updating workbooks Unit 3: Modifying a worksheet Topic A: Moving and copying data Topic B: Moving and copying formulas Topic C: Absolute and relative references Topic D: Inserting and deleting ranges, rows, and columns Unit 4: Using functions Topic A: Entering functions Topic B: AutoSum Topic C: Other common functions Unit 5: Formatting Topic A: Text formatting Topic B: Row and column formatting Topic C: Number formatting Topic D: Conditional formatting Topic E: Additional formatting options Unit 6: Printing Topic A: Preparing to print Topic B: Page Setup options Topic C: Printing worksheets Unit 7: Charts Topic A: Chart basics Topic B: Formatting charts Unit 8: Managing large workbooks Topic A: Viewing large worksheets Topic B: Printing large worksheets Topic C: Working with multiple worksheets Unit 9: Graphics and screenshots Topic A: Conditional formatting with graphics Topic B: SmartArt graphics Topic C: Screenshots | ||
You must be registered by Wednesday before the week classes start.
Check out our schedule for Evening Computer Classes now offered at ASU Jonesboro and ASU Paragould.
If you are interested in a class that is not listed, please let us know. Our schedule changes so please call to inquire if one has been recently added to the schedule or will be offered later in the year. We look forward to hearing from you.
Phone: (870) 972-3052
Contact:
Jessica Scott Sue Melton
jkscott@astate.edu kmelton@astate.edu
Cost: $109 per class.
Payment Options:
Mail:
ASU Treasurer's Office
P.O. Box 2640
State University, AR 72467
Phone:
Credit/Debit Card
(870) 972-3847 (Monday - Friday 8:00 a.m. - 5:00 p.m.)
In Person:
ASU Treasurer's Office Cashier's Window
Student Union Building, 2nd Floor
North Hall adjoining the Parking Deck, ASU Jonesboro
(Monday - Friday 8:00 a.m. - 4:30 p.m
***Checks should be made out to: ASU CECO/Computer Classes. The name of the class, student's name, and Account # 133101-212910-511416-0000 should be included on checks.
Note: If registering for multiple classes, a registration form is required for each class.
Classes may be added upon request, providing there are enough participants to make a class.
Computer Lab Location
Arkansas State University
Continuing Education and Community Outreach
Eugene W. Smith Hall, Suite 410
106 N. Caraway Road
Jonesboro, AR 72401
Phone: (870) 972-3052
Fax: (870) 972-3849