IPad Keyboard Display Issues

If you find that your keyboard on your Ipad screen is not displaying as you want it to, do the following.  Tip is from the Apple discussion group, there is a lot of good information on there site.

 

https://discussions.apple.com/community/ipad

  Re: My keyboard all of a sudden is in the middle of my screen. How do I get it back to the bottom?

Apr 19, 2012 2:14 PM (in response to Jabbr5)

 

Tap and hold down the keyboard icon in the lower right corner of your keyboard

And you can move it were you want on your screen

Excel Cell References 15 Examples Formulas, Conditional Formatting & Data Validation

Here is another great Youtube Video series:

http://www.youtube.com/watch?v=_PBPU_5jTUA

This is what it covers!

Download file: http://people.highline.edu/mgirvin/excelisfun.htm
This 50 minute video shows 15 examples of how to use Cell References:
1)Relative Cell References
2)Absolute Cell References
3)Mixed Cell References With Column Locked
4)Mixed Cell References With Row Locked
5)Formula for Commissions
6)Formula for Deduction Calculation
7)Multiplying Table for Memorization Trick
8)Financial Forecast Formula (Budget Formula) 4 examples
9)Markup On Cost and Profit Formula
10)Running Total Formula
11)Conditional Summing Formula SUMIFS and SUMPRODUCT Formulas
12)Conditional Averaging Formula AVERAGEIF and SUMPRODUCT Formulas
13)Conditional Formatting Formula for Row In Bank Reconciliation Table
14)Conditional Formatting Formula for Highlighting Duplicates
15)Data Validation Formula for Preventing Duplicates

Make sure you download the spreadsheet it has a great Cell References tab!!

Great Videos on Conditional Formatting in Excel 2010

http://www.youtube.com/watch?v=LOaezdoyJDE&feature=related
I found a great series on Conditional Formatting on Youtube you should check them out.  Here is a list of the subjects covered:

1. Above Average for Sales (1:24 minute mark)
2. Below Average for Sales ( 3:18 minute mark)
3. Top 5 ( 3:30 minute mark)
4. Greater than 600 ( 4:09 minute mark)
5. Data Bars ( minute mark)
6. Color Scale ( 4:58 minute mark)
7. Icon (6:00 minute mark)
8. Highlight Sales that are on 5/25/2011 ( 7:19 minute mark)
9. Highlight Entire Row for invoices sold on 5/25/2011 ( 12:30 minute mark)
10. Highlight Entire Row for invoices #10501 ( 17:00 minute mark)
11. Highlight entire row when sales are above average ( 18:23 minute mark)
12. Highlight every other row with MOD function ( 19:55 minute mark)
13. Highlight Row In Checkbook when Reconciled ( 23:43 minute mark)
14. Highlight Entire Row for the 3 Biggest Values ( 24:50 minute mark)
15. Highlight Entire Row for Sale Rep Moe AND Sales Greater Than500 (AND Criteria) AND function ( 28:28 minute mark)
16. Highlight Entire Row for Sales Rep Moe or Joe (OR Criteria) OR function ( 30:44 minute mark)
17. Highlight Entire Row that contains a date between two dates ( 32:10 minute mark)
18. Highlight Entire Row based on both AND Criteria and OR Criteria AND and OR function together ( 33:33 minute mark)
19. Highlight entire row based on Approximate Value VLOOKUP function ( 36:27 minute mark)
20. Highlight entire column based on Exact Match (36:27 minute mark)
21. Highlight Intersecting Value based on both an approximate match for row header and Exact Match for column header (36:27 minute mark)
22. Highlight row based on two row headers ( 44:57 minute mark)
23. Highlight entire column based on Exact Match (44:57 minute mark)
24. Highlight Intersecting Value based on row header and column header Exact Match (44:57 minute mark)
25. Gantt Chart for Days (48:41 minute mark)
26. Highlight Weekends and Holidays NOT WORKDAY.INTL NETWORKDAYS.INTL function (48:41 minute mark)
27. Data Validation Custom Formula for preventing Sunday and Holiday Dates to be entered in cell (48:41 minute mark)
28. Highlight Duplicates: Built In Feature ( 01:04:54 minute mark)
29. Highlight Duplicates Formula ( 01:05:10 minute mark)
30. Highlight Row when Actual Exceeds Budgeted ( 01:07:20 minute mark)