NEAT Computer Basics - Class 4

Career Building

• Resume information: Education, Work Experience, Volunteer Experience, Self Taught Skills, Certificates/Awards, People Skills, Organizational Skills, Interests, Goals, What You Can Bring to an Employer
• http://www.resumetemplates.org/
• http://jobsearch.about.com/od/sampleresumes/a/sampleresume2.htm
• http://office.microsoft.com/en-us/templates/CT101043371033.aspx
• http://jobstar.org/tools/resume/index.php

Creating a Cover Letter

• FILE > NEW > NEW DOCUMENT >TEMPLATES
• On my computer vs. Online
• http://office.microsoft.com/en-us/templates/CT101467921033.aspx
  
• Enter your data
• Save, Save, Save...

Creating Resumes

• FILE > NEW > NEW DOCUMENT >TEMPLATES
• On my computer vs. Online
• http://office.microsoft.com/en-us/templates/CT101043371033.aspx
• Basic vs. Job Specific vs. Situation Specific
• Create new resumes for each job you apply for
• Create 2 resumes

Microsoft Excel

Excel Basics

• workbook 1
  
• sheets (tabbed)
• column headings
• row headings
• Name Box - 256 columns, 65,536 rows, 16,777,216 cells
• Active Cell - black outline

Creating a Basic Spreadsheet

• title your columns: days of the week (don't use column "A")
  
• 8th column should be "Daily Averages"
• title your rows: read, watch tv, walk, sleep, etc.
• bottom row should be "Daily Totals"
  
• ENTER - goes down
• TAB - goes across
• enter the number of hours you spend doing each activity (you can use decimal points)

AutoSum

• sum the total hours for each day (going down)
• average the hours per day (going across)
  
• note the options: Max, Min, Count Number
• works horizontally and vertically

Tips

• CTRL + ; enters the current date
• CTRL + SHIFT + ; enters the current time
• To enter fractions, leave a space between the whole number and the fraction. For example, 1 1/8.
• To enter a fraction only, enter a zero first. For example, 0 1/4. If you enter 1/4 without the zero, Excel will interpret the number as a date, January 4.
• If you type (100) to indicate a negative number by parentheses, Excel will display the number as -100.
• ######### means your data is too long to be displayed - you will need to spread out the column

Budgets

• http://office.microsoft.com/en-us/templates/CT101172321033.aspx

Expense Reports

• http://office.microsoft.com/en-us/templates/CT101423481033.aspx

Inventories

• http://office.microsoft.com/en-us/templates/CT101172541033.aspx
  

Invoice

• http://office.microsoft.com/en-us/templates/CT101172551033.aspx

Receipts

• http://office.microsoft.com/en-us/templates/CT101423521033.aspx

Time Sheets

• http://office.microsoft.com/en-us/templates/CT101172771033.aspx
  

More Categories

• http://office.microsoft.com/en-us/templates/CT101485751033.aspx?av=ZXL
  

NEAT Computer Basics - Class 3

Using Google

• maps
• images
• shopping
• blogs
• groups
• "quotes"
• preferences
  

Microsoft Word

Inserting Photographs/Images

• Where are those photos?
• Camera to computer
  
• Grabbing stuff from the internet

Printing

• Setting up printers
• Printing documents
• Buying printers

NEAT Computer Basics - Class 2

Web Browsers

• Firefox
• Internet Explorer
• URL
• http://
• https://
• www
• bookmarks
• homepage
  

Microsoft Word

Creating a new Word document

• New Blank Document
• Fonts - type and size
• Template for future documents
  

Woops!

• Undo/Redo
• Spell checking

Selecting Text

• Single clicking
• Double clicking
• Triple clicking
• Selecting by dragging

B/I/U

• creating Bold/Italics/Underline highlights in text
  

Saving

• Save vs. Save As
• Where's my stuff?
• Extensions

Cut/Copy/Paste

• Keyboard shortcuts
• button bar
• right-clicking
  

Preparing for Next Class

• Resume information: Education, Work Experience, Volunteer Experience, Self Taught Skills, Certificates/Awards, People Skills, Organizational Skills, Interests, Goals, What You Can Bring to an Employer
• http://www.resumetemplates.org/
• http://jobsearch.about.com/od/sampleresumes/a/sampleresume2.htm
• http://office.microsoft.com/en-us/templates/CT101043371033.aspx
• http://jobstar.org/tools/resume/index.php

NEAT Computer Basics - Class 1

Microsoft Office

• Word/Excel/PowerPoint/Access...
• 2003/2004 vs. 2007/2008
• Versions and Pricing: http://office.microsoft.com/en-us/products/FX101635841033.aspx
• Online Microsoft support: http://office.microsoft.com/en-us/help/FX100485361033.aspx?pid=CL100605171033

Open Office

Google Docs

Microsoft Word

• Maximize/Minimize
• Button Bar
• Menu Bar
• Ruler Bar