Free Apps 01/31/2013

Free Apps 01/31/2013

Who doesn’t like free stuff, here is a list of some free apps for the IPad or IPhone. These apps may only be free today so if you think they look interesting make sure you download them today!
You could save up to $37.86
Games

• Unknown Orbit (usually .99)
• Backbreaker 2: Vengeance (usually .99)
• 3volution (usually .99)

Health and Fitness

• runtastic Pro (usually 4.99)
• Backbreaker 2: Vengeance (usually .99)

Music

• Album Flow Pro (usually 2.99)

Photo and Video

• XnRetro (usually .99)
• Tube Downloader Pro (usually 3.99)

Productivity

• Penultimate (usually .99)
• MP3-Recorder (usually $1 .99)

Social Media

• Netbot for App.net Ipad edition (usually $4.99)
• Netbot for App.net Iphone edition (usually $4.99)

Travel

• Bern Travel Map (Switzerland) (Usually 3.99)
• Christchurch Travel Map (New Zealand) (Usually 3.99)

Title:    AppShopper

App Type: Utilities

Price:   Free

Device: IPhone, IPad, IPod touch (iOS 4.0 or later)

Wi-Fi: Yes

Developer: TouchArcade.com

Need to Setup Account: Yes

What Is The App All About?  

AppShopper allows you to keep up to date on changes in the App Store.  You can see the new apps, sale on apps, and freebie apps

What Is Cool About the App?

I love this app!  It is one of my favorites.  I used it several times a week to see what is free.  The Wish list is very easy to use, you click on the “Want it” check box and then you can get notification on when the app has a price change or an update.  You can filter app results by price, sort, device and category.  You can share apps to facebook, twitter, and email.

Where Should They Improve?

Love this App I see nothing to improve.

Comments:

I love this app it is definitely a must get!

YouTube Video Link: (not my video but thought it would be helpful)

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

Publish Date: September 14, 2012

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)

IOS 5 New Features

There are alot of new features in the IOS 5 for Ipad, Iphone, or Ipod touch.  Below is a link to 200 new feature and a video that talks about the IOS 5 operating system. 

http://www.apple.com/ios/features.html

There are a lot of great new features, below are a list of my favorites.

 

• Notification Center
• Reminders
• Photos
• Reading List
• You can setup your device without a computer
• Wi-Fi Sync 

Alert in SharePoint 2010

As the KnowledgeShare environment grows and the size of content increases, it quickly becomes apparent that you cannot possibly be aware of changes to all of the information that is relevant to you. In fact, the primary goal for introducing SharePoint is to provide users with quick and easy access to relevant information. Organizations are often challenged by updating people with information they might need, and individuals often have difficulty staying aware of changes to information they care about. Manually scanning information sources for new or changed materials would be extremely time consuming. For this reason, you want to use an alert.  An Alert is an email that is sent as specified by the user when changes have been done to the site, a list, a document, a calendar or many other items.

Below is how you setup an alert for a document library in SharePoint 2010:

1. Go to the library you want an alert on.
2. Click on Library (under Library Tools)
3. Click on Alert Me (under Share & Track)
4. Click on alert on this library
5. Change Alert Title if you would like
6. Make sure your name is in the Send Alerts To section. If you are setting this up for someone else you can put their name in this location.
7. Choose the type of changes that you want to get
8. Choose the kinds of changes you want
9. Choose how often you want alerts sent
10. Change the day and time if needed
11. Click OK

This is adapted from Microsoft Sharepoint Help.