Episode 67: Broken Screen

Hi Everyone,

There was a time in our lives when we were able to function without a phone in our pockets. Today however, it’s an impossibility...well, that’s what my kids say. Here’s a couple tips for those uh-ohs in life.

Apps: Recovering Apps
Have you ever accidentally deleted an app or maybe you let a little one play with your iPhone/iPad and now you are missing some apps. No fears, just go the Apps Store > Purchased > Not on this iPhone\iPad and download it from the cloud (click on the icon that looks like a cloud with an arrow pointing down). This works with songs that you purchased as well.

Calendar: Add an event
There are several ways to add an event to your calendar. You can select a day from the month view and then select the + icon. Did you know that if you press and hold on the day, it will bring up the "Add Event" window? Try turning the screen on its side and it will change from the month view to a weekly view. Press and hold on the date and time to create an event. Want to use Siri, just to make an appointment.

Workbench: Broken Screen
Okay, you broke your screen and you didn’t buy insurance for your iPhone. All is not lost. You do have a couple options out there. If you’re not mechanically inclined, there are local shops, mall kiosk or online shops that will fix your device. It can cost around $70-$100 to replace your iPhone screen.

Have you ever wondered what was behind the screen. It’s really not too hard to replace your screen. There are several vendors out there to order the parts and they even have tutorials and videos to do the job. Always shop around for the best prices. I use phonepartsusa.com to order my parts. Yes, I’ve replaced 1 iPhone screen, 1 Home button and 2 iPad screens.

Excel: Name Box
Are you working with multiple worksheets and use vlookup in your Excel formulas? Do you manually select a worksheet and the array when entering your formula? Try naming the array with the Name Box (Fig. 1.01) and then use that name in your formula. So, instead of =VLOOKUP(A2,Resource!A:C,2,FALSE) where you select the worksheet and then the array (Resource!A:C), you now just type "District" in its place.

=vlookup(a2,district,2,0)

Did you notice that my formula was not case sensitive and that I used a 0 instead of false? That’s another tip. Want to learn more fun things you can do with Excel? Just come by my desk or send me an email.

Fig. 1.01

 

Hope you enjoy these tips and I hope that last one was not Greek to you,