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