Скачать или смотреть Excel 2007 / 2010 Tricks For Making Your Job Easier: HCC Professional Development Day

Download workbook: http://people.highline.edu/mgirvin/Ex... (workbook at VERY bottom)
Learn how you can manage and manipulate data with great efficiency and fun!
Highline Community College Professional Development Day
Topics in Video:
1. Percentage Number Format (1:04 mins)
2. Fractions Show As Dates (1:45 mins)
3. SUM function adds incorrectly (3:34 mins)
4. Keyboard shortcut for SUM function (3:34 mins)
5. Date Math (5:13 mins)
6. Time Math (7:10 mins)
7. General Number Format to see what is REALLY in the cell (9:00 mins)
8. Entering Data Quickly in Rectangular Range (9:43 mins)
9. Don't Hard Code numbers into formulas (10:18 mins)
10. Relative and Absolute Cell References (10:59 mins)
11. Sorting (13:32 mins)
12. VLOOKUP function (14:50 mins)
13. 2007 Table Feature: Dynamic Ranges (21:59 mins)
14. 2007 Conditional Formatting (25:18 mins)
15. 2007 Filter Feature (28:56 mins)
16. 2007 COUNTIFS, SUMIFS Functions to add with 1 or more criteria (33:47 mins)
17. 2007 PivotTable interface Average GPA with two criteria (38:39 mins)
18. 2010 PivotTable Slicers (43:50 mins)
19. 2010 Sparklines: Cell Charts (47:09 mins)
20. 2010 Paste Special icons (49:38 mins)
21. 2010 Print Options and Print Preview (53:28 mins)
22. 2010 RANK function and RANK.AVE and RANK.EQ (55:00 mins)
Highline Community College Professional Development Day 2011