Home Page
Driving Directions
Class Listings
Computers & Technology Excel 2007 Formulas & Functions
Functions are built-in formulas and Excel has hundreds of them! This class will concentrate on some of the more popular functions, including statistical (average, max, min), financial (pmt), logical (if, and, or), lookup (vlookup) and more. Prerequisite: Excel 2007 Part 1.
01 742 W2 March 2
Wednesday MCEC Rm. 207 1 session
Susan Howard Excel 2007 Level 1
Gain a solid understanding of the basics of Excel, a powerful spreadsheet application. You will learn how to navigate around in Excel; use the Ribbon to issue commands; insert, delete, rearrange and rename worksheets. You’ll also learn to enter text, values and formulas, delete and replace cell entries; work with number and text formatting, and modify the appearance of a worksheet by inserting columns and rows and hiding columns and rows. Finally, learn how to save and close your workbook for easy retrieval. This course will help improve your work productivity!
01 742 W1 Monday 1 session
01 742 W5 Monday
Jan. 31
MCEC Rm. 207 Susan Howard
2 sessions Susan Howard
8:30 am-3 pm $119
Feb. 2 and Feb. 16 6-9 pm MCEC Rm. 207
$119
8:30-11:30 am $59
Excel 2007 Level 3
Are you ready for some advanced topics in Excel? Then you're ready to learn how to use the tools Excel offers in analyzing data: Tables and Pivot Tables. Tables provide a structure for organizing lists of information and formatting, sorting and filtering the data. Pivot Tables let you summarize data in various ways (e.g. sum, average, standard deviation) and instantly change the way it is presented. These tools offer tremendous speed and flexibility in analyzing and presenting all of your day-to-day data. Prerequisite: Excel 2007 Level 2.
01 742 W4 Monday 1 session
March 14
MCEC Rm. 207 Susan Howard
8:30-11:30 am $59
Facebook & Twitter - How to Get Started! Interested in the social networking phenomenon? Learn Facebook and Twitter basics such as how to create an account, update your status, send messages, search for people you know - with whom you would like to reconnect - or with whom you share similar interests. Students may set up accounts during class if they wish. Safety and privacy issues will also be discussed.
01 804 W3 Jan. 26
Wednesday MCEC Rm. 207 1 session
Andrea Lee
7-9 pm $39
Excel 2007 Level 2
Learn charting skills to chart worksheet data. Discover how to sort Excel data by a single column or multiple columns, freeze rows and columns and split screens. Become acquainted with techniques to link worksheets and name cell ranges. Work in the Page Layout view to ready worksheets for printing, create workbook templates and find out how to protect a workbook structure and worksheet data from unwanted changes. Prerequisite: Excel 2007 Level 1.
01 742 W3 Monday 1 session
Feb. 28
MCEC Rm. 207 Susan Howard
8:30 am-3 pm $119
"My instructor was extremely prepared, knowledgeable and patient. Excellent teacher!" - Computer Education Student
40
Susan has been a computer programmer and systems analyst for IBM, The U.S. Department of Defense, Rockwell Corporation and Control Data/Ceridian. Susan founded her own firm, Howard Computer Training, LLC which provides classroom training for corporate clients and community education sites. Her expertise is on a variety of computer applications, especially the Microsoft Office Suite. Susan holds a B.S. in Mathematics from Purdue University and a Master of Arts in Education from San Diego State University.
Susan Howard
www.minnetonkacommunityed.org
Page 1 |
Page 2 |
Page 3 |
Page 4 |
Page 5 |
Page 6 |
Page 7 |
Page 8 |
Page 9 |
Page 10 |
Page 11 |
Page 12 |
Page 13 |
Page 14 |
Page 15 |
Page 16 |
Page 17 |
Page 18 |
Page 19 |
Page 20 |
Page 21 |
Page 22 |
Page 23 |
Page 24 |
Page 25 |
Page 26 |
Page 27 |
Page 28 |
Page 29 |
Page 30 |
Page 31 |
Page 32 |
Page 33 |
Page 34 |
Page 35 |
Page 36 |
Page 37 |
Page 38 |
Page 39 |
Page 40 |
Page 41 |
Page 42 |
Page 43 |
Page 44 |
Page 45 |
Page 46 |
Page 47 |
Page 48 |
Page 49 |
Page 50 |
Page 51 |
Page 52 |
Page 53 |
Page 54 |
Page 55 |
Page 56 |
Page 57 |
Page 58 |
Page 59 |
Page 60 |
Page 61 |
Page 62 |
Page 63 |
Page 64 |
Page 65 |
Page 66 |
Page 67 |
Page 68