Tour Of Excel: Formulas, Formatting, Sort, Filter, PivotTables, Charts, Keyboards

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm (all the way at bottom in "Other Excel Series" section)

Highline Community College Science Seminar: The Wonders Of Excel, May 20, 2011

Learn about the wonders of what excel can do with a tour of the different things that Excel can do:
1 Copy & Paste Special (2 Examples) (00:48 minute mark)
2 Keyboard Magic (3 Examples) (03:45 minute mark)
3 Number Format (06:03 minute mark)
4 Decimal (6:11 minute mark)
5 Date (5 Examples) (07:32 minute mark)
6 Percentage (15:02 minute mark)
7 Formulas and Relative Cell References (18:26 minute mark)
8 Formulas and Absolute Cell References (2 Examples) (21:47 minute mark)
9 Sorting (4 Examples) (27:27 minute mark)
10 Filtering (32:27 minute mark)
11 PivotTables (2 Examples) (35:19 minute mark)
12 Charts (6 Examples) (43:31 minute mark)

Category:

Science & Technology

Tags:

• Excel
• 2010
• Copy
• Paste
• Special
• Keyboard
• Magic
• Number
• Format
• Decimal
• Date
• Percentage
• Formulas
• and
• Relative
• Cell
• References
• Absolute
• Sorting
• Filtering
• PivotTables
• Charts
• PivotCharts
• Pivot
• Table
• Mike
• Gel
• excelisfun
• Girvin
• Highline
• Community
• College
• Science
• Seminar
• The
• Wonders
• Of
• May
• 20
• 2011

[Harvey3101]

Really great! I am allways thinking, that you cannot do another video, because you have handeled everything in Excel, but there is allways another video.

[ExcelIsFun]

Cool! I am glad that the videos continue to help!

[cyberprof]

Incredibly useful, thank you.

[ExcelIsFun]

You are welcome!

[GoddessIncognito]

Sooooooo fun!!!

[ExcelIsFun]

Cool, That is the intent!! :)

[MikeBolton10]

Game of 13 teams play for 26 weeks with each team playing each other twice & 2 byes. Each match is best of 5, each game to 121 points. Therefore a 5-0 score would have a 605 point aggregate against 600 or less. The list has columns for Position, team name, matches played, won & lost, games for & against, this weeks score for, against & aggregate & lastly the total aggregate & number of 600's scored. How do I rank positions by 1 won, 2 for & 3 total aggregate? & have them change weekly?

[ExcelIsFun]

You are welcome!

[ExcelIsFun]

You are welcome!

[loyaus]

I learnt more about Charts & Graphs

Thanks for this video