Your on the go and need to capture or produce an image from your phone? Let’s say, for instance, that you are planning of finally redeeming that Groupon you purchased. Or, perhaps, you plan on flashing your e-ticket to the airline check-in attendants. These would be bad times for your 4G or WiFi connection to fail. In preparing for hi-stress situations you are best served if you plan for technology to fail. Sure; one way to mitigate against an awkward moment by printing is by producing a printout of your ticket or voucher. My, how old skool!
Another, less retro, failsafe involvles capturing a screenshot of your e-ticket or voucher prior to use, while your internet connection is rock-steady. That way, if you lose connectivity, you still have the image on your phone to present when needed. And, yes, these methods also work with instant messenger apps (e.g. Snapchat).
At the same time, press the On/Off switch and the Volume down buttons. The image is captured and added to your Picture album/gallery.
Newer Samsung users: In addition to the above Android instruction, with newer Samsung phones (e.g. Galaxy 4) you can capture a screen with a hand gesture. The setting activated by going into your System Settings, under Motions and gestures.
At the same time, press the Power and the Home buttons. The image is captured and added to your Camera Roll
Windows 8 phone
At the same time, press the Start and the Power buttons. The screenshot is captured and added to the Screenshots album in the Photos Hub
note: The methods listed here are neither model nor version specific and may not apply to all makes and models: your mileage may vary 🙂
Using Consolidate you can summarize data from separate worksheets onto one master sheet. Data Consolidation performs a statistical function (e.g. Sum, Average) on a series of ranges (lists). And the best part: the lists need not have identical content.
Watch this 2+ min. video to learn all you need to know.
Performing the Data Consolidation
Click here to open Toy List Consolidation.xlsx sample spreadsheet
Prep: Sort each list by the first column and remove all blank rows and columns within the lists.
Tip: Use Define Name to set name each list.
On the summary sheet, select the upper-left cell where the consolidation is to appear.
On the Data tab, in the Data Tools group, click Consolidate.
In the Function box, select function (i.e., Sum).
In the Reference field, type the name or cell references of first list (including column and row headings), then click Add. Repeat this step for each list to be summarized.
Check Use labels in Top row and Use labels in Left column.
Somewhere in a computer file system folder, tucked within a series of folders, locked in an archive compressed to a fraction of its original size (inside an encryption riddle, wrapped in a digital mystery) are all my old email files from when I used to use Lotus Notes, now known as IBM Notes. Lotus Notes! I realize some of you still use it, and this is not me chuckling quietly.
No, this is just me letting you know that Google in 2013 is finally going to catch back up with a program that’s been around since the late 1980s: until today, you couldn’t extract Gmail or Google Calendar information for archiving vis-a-vis an intuitive (and more importantly, native) Gmail or Google Calendar switch. You had to either trust Google to keep your stuff safe and backed up somewhere, or play a kind of digital version of Twister to extract said information by…
The year is 1985. Soviet leader Gorbachev meets with American President Reagan. Cocoa Cola unveils New Coke. Actor Rock Hudson dies of aids. Singer Madonna’s starts her first tour.
And on November 20, 1985, Microsoft releases Windows 1.0.
Unveiled in 1983, it would not be available for purchase until two years later. Arguably, that makes Windows 30 years old, but since many tricenarians, have a hard time with that milestone, we extend her two years grace..
Over time her share of sales and public favor has varied, as illustrated by this infographic.
Timeline: Windows Logo Evolution
Like most twenty-somethings, the Windows logo has had her own experiments with style. Here’s a look back at fashions past.
Flashback: notice how similar the current Windows 8 logo is to the original!