Tuesday, May 15, 2012

MICROSOFT OFFICE EXCEL

http://www.csus.edu/training/handouts/workshops/Excel07pivot&macro.pdf

http://office.microsoft.com/en-us/training/CR006183114.aspx
http://office.microsoft.com/en-us/excel-help/examples-of-commonly-used-formulas-HP005200127.aspx
http://office.microsoft.com/en-us/training/the-new-office-made-for-you-RZ010148252.aspx?section=2
http://office.microsoft.com/en-us/excel-help/get-to-work-in-excel-2010-RZ101809963.aspx?section=2
http://office.microsoft.com/en-us/excel-help/excel-help-and-how-to-FX101814052.aspx?CTT=97
http://www.bgsu.edu/downloads/cio/file15626.pdf

Beginning Microsoft Excel 2010By Abbott Katz
http://books.google.ca/books?id=gXFnFNtqxf8C&lpg=PP1&dq=excel%202010&pg=PA22#v=onepage&q=excel%202010&f=false

http://www.housing.wisc.edu/docs/tlc_quicktip_excel.pdf

http://www.ecu.edu/cs-acad/techmath/upload/Excel2007Tutorial-2.pdf

http://depts.hre.wvu.edu/tltc/excel_tutorial.pdf

http://ewubd.edu/~asif/cse101/PowerPoint2007.pdf


Microsoft Office Excel 2007: Illustrated Complete
 By Elizabeth Eisner Reding, Lynn Wermers
http://books.google.ca/books?id=SKluv-LKjhYC&lpg=PP1&dq=excel%202007&pg=PA19-IA17#v=onepage&q=excel%202007&f=false


New Perspectives on Microsoft Office Excel 2007, Introductory
 By Dan Oja, June Jamrich Parsons, Roy Ageloff, Patrick Carey

http://books.google.ca/books?id=gQj4_J8V4wIC&lpg=PP1&dq=excel%202007&pg=PA15#v=onepage&q=excel%202007&f=false


http://books.google.ca/books?id=UD5jITytWHcC&lpg=PP1&dq=excel%202007&pg=PA42#v=onepage&q=excel%202007&f=false

Excel 2007: Beyond the Manual
 By Helen Dixon

http://books.google.ca/books?id=is25kOkwvRAC&lpg=PP1&dq=excel%202007&pg=PA43#v=onepage&q=excel%202007&f=false

Excel 2007: The Missing Manual
 By Matthew MacDonald

http://books.google.ca/books?id=m50jN0CRuosC&lpg=PP1&dq=excel%202007&pg=PA8#v=onepage&q=excel%202007&f=false

Excel 2007: Pocket Guide
 By Curtis Frye

http://books.google.ca/books?id=ZVsh12iG0FsC&lpg=PP1&dq=excel%202007&pg=PP1#v=onepage&q=excel%202007&f=false

Excel 2010

http://books.google.ca/books?id=GSpSfJoQ168C&lpg=PP1&dq=excel%202010&pg=PT26#v=onepage&q=excel%202010&f=false


http://books.google.ca/books?id=KJblYtDJAnEC&lpg=PP1&dq=excel%202010&pg=PA110#v=onepage&q=excel%202010&f=false





SHIFT-TAB = right to left
TAB= moves you left to right
SHIFT-ENTER= up wards move
F1 help or look for ?
CTRL-Z = UNDO MISTAKE
CTRL- SELECT


Basics of Excel
1) Excel 2010 Tutorial: Creating a Basic Worksheet
http://youtu.be/AtTTTy_Nu6s
2) Tutorial - Excel 2010 - 10 Things you must know
http://youtu.be/-SnBlC_1tSk

Conditional formatting
Formulas
Sorting
Concatenate
Basic Math
Aging Formula
Populating in Ascending order
Sorting Both Ascending and descending order
Working with selections
Removing Duplicate Selections
Styling

Lynda.com




Software training & tutorial video library. Our online courses help you learn critical skills. Free access & previews on hundreds of tutorials.
www.lynda.com
www.lynda.comhttp://www.learnmicrosoftexcel.com/free_tutorials/free_tutorials_with_video.htm?gclid=CPuiroKw3rACFYcZQgod3n7X2g

No comments:

Post a Comment