[OPLINLIST] Excel Basics Class Near Central OH
Terry Mullins
mullinte@oplin.org
Fri, 29 Apr 2005 10:47:49 -0400
This is a multi-part message in MIME format.
------=_NextPart_000_0028_01C54CA8.E5EF7760
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
The SOLO Regional Library System is offering
Microsoft Excel Basics
in a central Ohio location
LAST CHANCE TO REGISTER: MONDAY, MAY 2
When: Thursday May 05, 2005
From: 9:30 a.m. to 4:00 p.m.
Trainer: John Paul, Winsoft
Where: Newark Public Library, 101 W. Main St., Newark, OH 43055-5054
Description: Whether you need to create statistical reports, computerize
your budget, or track expenses, Excel is the ideal tool when working with
numbers on your computer. Attendees will learn to format spreadsheets,
create/edit worksheets, work with formulas, and generate charts and graphs
to enhance your documents. There will be a strong emphasis on editing and
formatting techniques, as well as a full discussion on printing. This
program is also suitable for Excel 2000 users. The full agenda is below.
Member Rate: $0 Nonmember Rate: $75
To register, visit: <http://cemall.solorls.org/events.cfm?ID=690>
http://cemall.solorls.org/events.cfm?ID=690
AGENDA:
I Getting Started
A) Screen Elements
B) Obtaining Help
II Creating Spreadsheets
A) Spreadsheet Elements
B) Navigation
1) Mouse Techniques
2) Keyboard Techniques
C) Understanding Cell Contents
D) Basic Formulas
E) Math: Order of Operations
III Functions
A) Constructing Functions
B) Function Types
1) Sum
2) Average
3) Min\Max
4) Count/CountA
C) Function Utilities
IV Managing Files
A) Opening, Closing, & Saving
1) Places Bar
2) Recently Used File List
B) Managing Multiple Files
1) Toggling Between Open Files
2) Displaying Multiple Files
C) Workbooks Vs. Worksheets
1) Managing Multiple Worksheets
2) Selection Techniques
3) Renaming Worksheets
4) Transferring Data Between Files
V Document Appearance
A) Selection Techniques
1) Mouse Techniques
2) Keyboard Techniques
B) Working With Columns & Rows
1) Column Sizing
2) Row Sizing
3) Best Fit Options
4) Inserting Columns & Rows
C) Formatting
1) Number Formats
2) Alignment Formats
3) Font Formats
VI Editing Text
H) Moving and Copying Text
1) Cut & Paste Options
2) Using Drag & Drop
I) Fill Series: AutoFill
J) Relative Cell Referencing
K) Undoing/Redoing Operations
VII Document Output
H) Page Setup
1) Basic Settings
2) Headers & Footers
3) Margins
I) Print Preview
J) Print Dialog Box
If you have any questions, please contact:
Terry Mullins
Executive Director
SOLO Regional Library System
40774 Marietta Road
Caldwell, OH 43274
phone: 740-783-SOLO
fax: 740-783-0403
cell: 740-336-0059
e-mail: mullinte@oplin.org
------=_NextPart_000_0028_01C54CA8.E5EF7760
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2627" name=3DGENERATOR></HEAD>
<BODY>
<DIV dir=3Dltr align=3Dleft><FONT size=3D4><SPAN =
class=3D820003516-25042005><FONT=20
color=3D#0000ff><FONT color=3D#000000><SPAN =
class=3D994114514-29042005><FONT=20
face=3DArial color=3D#0000ff size=3D3><FONT face=3D"Times New Roman" =
color=3D#000000=20
size=3D4>T</FONT></FONT></SPAN>he SOLO Regional Library System is=20
offering<STRONG> </STRONG><SPAN class=3D994114514-29042005><FONT =
face=3DArial=20
color=3D#0000ff =
size=3D3> </FONT></SPAN></FONT></FONT></SPAN></FONT></DIV>
<DIV dir=3Dltr align=3Dleft><FONT size=3D4><SPAN =
class=3D820003516-25042005><FONT=20
color=3D#0000ff><FONT color=3D#000000><SPAN=20
class=3D994114514-29042005> </SPAN><FONT =
size=3D5><STRONG>Microsoft</STRONG>=20
</FONT></FONT><FONT size=3D5> </FONT></FONT></SPAN><STRONG><FONT =
size=3D5>Excel=20
Basics</FONT></STRONG><SPAN class=3D820003516-25042005><FONT =
face=3DArial=20
color=3D#0000ff size=3D3> </FONT></SPAN></FONT></DIV>
<DIV dir=3Dltr align=3Dleft><FONT size=3D4><SPAN =
class=3D820003516-25042005><SPAN=20
class=3D994114514-29042005><FONT face=3DArial color=3D#0000ff=20
size=3D3> </FONT></SPAN>in=
a=20
central Ohio location </SPAN><BR></FONT><SPAN=20
class=3D994114514-29042005><FONT face=3DArial=20
color=3D#0000ff> </FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D994114514-29042005><FONT =
face=3DArial=20
color=3D#0000ff>LAST CHANCE TO REGISTER: MONDAY, MAY=20
2</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN=20
class=3D994114514-29042005> </SPAN><BR><STRONG>When:</STRONG> =
Thursday=20
May 05, 2005<BR><STRONG>From:</STRONG> 9:30 a.m. =
to 4:00=20
p.m.<BR><SPAN class=3D820003516-25042005><FONT face=3DArial=20
color=3D#0000ff><STRONG><FONT face=3D"Times New Roman"=20
color=3D#000000>Trainer</FONT></STRONG></FONT></SPAN><STRONG>:</STRONG> =
John Paul,=20
Winsoft</DIV>
<P><STRONG>Where:</STRONG> Newark Public Library, 101 W. Main St., =
Newark, OH=20
43055-5054<BR><BR><STRONG>Description:</STRONG> Whether you need =
to create=20
statistical reports, computerize your budget, or track expenses, Excel =
is the=20
ideal tool when working with numbers on your computer. Attendees will =
learn to=20
format spreadsheets, create/edit worksheets, work with formulas, and =
generate=20
charts and graphs to enhance your documents. There will be a strong =
emphasis on editing and formatting techniques, as well as a full =
discussion on=20
printing. This program is also suitable for Excel 2000 =
users. =20
The full agenda is below.<SPAN class=3D820003516-25042005><FONT =
face=3DArial=20
color=3D#0000ff> </FONT></SPAN></P>
<P><SPAN class=3D820003516-25042005> </SPAN><SPAN=20
class=3D820003516-25042005><STRONG>Member Rate:</STRONG> =20
$0 <STRONG> Nonmember=20
Rate:</STRONG> $75 </SPAN></P>
<P><STRONG>To register, visit: </STRONG><A=20
href=3D"http://cemall.solorls.org/events.cfm?ID=3D690"><STRONG>http://cem=
all.solorls.org/events.cfm?ID=3D690</STRONG></A><BR><BR><STRONG>AGENDA:<B=
R></STRONG><BR>I =20
Getting Started<BR>A) Screen=20
Elements<BR>B) Obtaining=20
Help<BR><BR>II Creating=20
Spreadsheets<BR>A) Spreadsheet=20
Elements<BR>B) =20
Navigation<BR>1) Mouse=20
Techniques<BR>2) Keyboard=20
Techniques<BR>C) Understanding Cell=20
Contents<BR>D) Basic=20
Formulas<BR>E) Math: Order of=20
Operations<BR><BR>III =20
Functions<BR>A) Constructing=20
Functions<BR>B) Function=20
Types<BR>1) =20
Sum<BR>2) =20
Average<BR>3) =20
Min\Max<BR>4) =20
Count/CountA<BR>C) Function=20
Utilities<BR><BR>IV Managing=20
Files<BR>A) Opening, Closing, &=20
Saving<BR>1) Places=20
Bar<BR>2) Recently Used File=20
List<BR>B) Managing Multiple=20
Files<BR>1) Toggling Between Open=20
Files<BR>2) Displaying Multiple=20
Files<BR>C) Workbooks Vs.=20
Worksheets<BR>1) Managing Multiple=20
Worksheets<BR>2) Selection=20
Techniques<BR>3) Renaming=20
Worksheets<BR>4) Transferring Data Between =
Files<BR><BR>V Document=20
Appearance<BR>A) Selection=20
Techniques<BR>1) Mouse=20
Techniques<BR>2) Keyboard=20
Techniques<BR>B) Working With Columns =
&=20
Rows<BR>1) Column=20
Sizing<BR>2) Row=20
Sizing<BR>3) Best Fit=20
Options<BR>4) Inserting Columns &=20
Rows<BR>C) =20
Formatting<BR>1) Number=20
Formats<BR>2) Alignment=20
Formats<BR>3) Font=20
Formats<BR><BR>VI Editing=20
Text<BR>H) Moving and Copying=20
Text<BR>1) Cut & Paste=20
Options<BR>2) Using Drag &=20
Drop<BR>I) Fill Series:=20
AutoFill<BR>J) Relative Cell=20
Referencing<BR>K) Undoing/Redoing=20
Operations<BR><BR>VII Document=20
Output<BR>H) Page=20
Setup<BR>1) Basic=20
Settings<BR>2) Headers &=20
Footers<BR>3) =20
Margins<BR>I) Print=20
Preview<BR>J) Print Dialog =
Box<BR><BR><BR>If you=20
have any questions, please contact:<BR><BR>Terry Mullins<BR>Executive=20
Director<BR>SOLO Regional Library System<BR>40774 Marietta =
Road<BR>Caldwell, OH=20
43274<BR>phone: 740-783-SOLO<BR>fax: =20
740-783-0403<BR>cell: 740-336-0059<BR>e-mail: =20
mullinte@oplin.org </P></BODY></HTML>
------=_NextPart_000_0028_01C54CA8.E5EF7760--