Tag Archives: Excel

Podcast

PTJ 119: Giving Thanks For Star Wars Trailers And Keyboard Shortcuts

Leave a comment

With the Thanksgiving holiday upon us here in the United States the team at PTJ HQ can’t thank you all enough for supporting us so passionately over these last few years. Both J.D. and I don’t have plans of stopping any time soon since we continue to have a wonderful time doing the show. We promise to keep serving up our special brand of insight and shenanigans—along with the occasional surprise—if you promise to keep coming back for more.

A very special thanks to the BROS!

When we say we wouldn’t be here without them that is a 100% accurate statement. They convinced us to make the leap to doing the show on our own and have supported us every step of the way.  A heartfelt bushel of gratitude from all of us at HeadStepper Media and Pop Tech Jam!

This week on the show, J.D. is thinking of linking and shares a slew of helpful keyboard shortcuts with us. In the news the FCC reaches an agreement with T-Mobile about their throttling practices; the Federal Aviation Administration is prepares a set of new rules for commercial drones; the European Union is expected to vote on breaking up Google’s business; Apple sees (RED); the United States and the United Kingdom are suspects behind a sophisticated series of cyber attacks against the European Union; Barbie (and Mattel) **** it up again; and the first teaser trailer of  Star Wars: The Force Awakens hits theaters this weekend.

(Hopefully) Helpful Hint, Episode Links

(Hopefully) Helpful Hint: Shortcuts to Shortcuts

Leave a comment

Tablets and smartphones may be making a lot of our productivity mobile, but for some people, getting work done means sitting down in front of a real physical keyboard and pounding those keys until the job is done. (And yes, this counts even if you add a Bluetooth keyboard to your tablet or phone.)

To make things even faster for repetitive tasks like formatting or navigation, many programs include keyboard shortcuts that save you the mousework and move things along. Some programs even let you add your own custom shortcuts, which can be handy, say, if you’re a southpaw and find the defaults awkward — or there’s an obscure menu command that has no built-in shortcut.

Sure, you can look in the Windows or OS X menus to see the shortcuts listed, but that can be time-consuming until you start remembering them. If you don’t know a lot of the commands off the top of your head, here’s the Pop Tech Jam roundup of keyboard quickies for common operating systems and popular programs.
Print ’em out and go.

Operating Systems

Productivity Suites

Webmail

Browsers

Social Media

Music & Multimedia

Adobe Creative Software

Want to see the all the shortcuts at once? Printable crib sheets listing Windows shortcuts can be found around the web with a quick search. Mac utilities like CheatSheet (free) and Dashkards stick with the stock shortcuts, but display them in an easy-to-read format on screen, KeyCue does the same thing with more customization options, but charges 20 euros for the full version.

If mere keyboard shortcuts aren’t enough, programs that let you use hotkeys to create and run your own macros can give your productivity an even bigger boost. Check out Hotkey Utility for Windows or AutoHotKey (also for Windows). Similar programs for Mac users include the $30 QuicKeys or iKey (also $30).

Siri, Cortana and OK Google aside, computing is still mostly a hands-on activity on one form or another. So until we get the next great input system in place, speeding up your clicks with the keys is one way to make the most of your time.

Episode Links

PTJ 72 News: Space Invaders

Leave a comment

Go, gamers, go! The Sony PlayStation 4 is out this Friday, November 15, and the Microsoft Xbox One arrives on November 22. Plenty of gaming sites will help you analyze the two and decide which one is best for you. And that Web ripple about the PS4 TOS prohibiting used games after all? A Sony exec took to Twitter to assure the faithful that they can resell and play previously owned games on the PS4.

In product news, Motorola will soon let customers with Verizon, Sprint and T-Mobile create their own personalized versions of the Android smartphone and Apple quietly released the iPad Mini with Retina Display this week.

spreadsheetThe AppleInsider site noted that not long after a Microsoft PR executive poo-poohed Apple’s iWork suite as “watered-down” imitation apps compared to Microsoft Office, the company put up giant billboards for its Surface tablet that showed the Excel software on the screen failing to correctly add up seven numbers on a spreadsheet. This led to much mocking online, but the TechCrunch blog says Microsoft did not get its math wrong, haters.

Google Glass wearers will soon have the option for stereo earbuds that let them listen to their Google Play music by commanding the Spendy Spectacles™. According to a report this month, the Motorola Mobility division of the company has filed a patent for an electronic, removable neck tattoo with an embedded microphone that can link up with a mobile phone. In addition to serving as a secret-agent way to make a mobile phone call without having the handset in site, the neck tattoo might have use as a lie detector. (Google’s also been busy with the Gmail this week, announcing several new enhancements to its Webmail service on its company blog; these new features add on to Gmail’s existing Inbox shortcuts.)

Want that sleek OS X/iOS look on PC hardware?  Check out the Pear OS 8, a Linux variation for desktops and laptops — and soon, tablet hardware is everything goes according to plan. Will this mean a Thin-Skinned Fruit War if Apple takes offense?

As some of you may have suspected, Netflix and YouTube are responsible for more than half of peak fixed network data in North America as confirmed by Sandvine’s Global Internet Phenomena report. Speaking of audio, a new beta build of Google’s Chrome browser lets you know which one of your many open tabs is the one streaming the loud audio file that you need to close right away.

On the security front, Trend Micro just put out its Q3 2013 Security Roundup Report, which shows an increase in online banking malware infections, particularly in the US, Brazil and Japan. The 22-page report, available online, also described a noticeable uptick in phishing sites aimed at Mac OS X and iOS users.

And you’re not even safe in space from malware. According to Russian security expert Eugene Kaspersky, the International Space Station was infected with malware that rode along on a USB stick used by a Russian cosmonaut. The malicious program was not Stuxnet, as originally reported by some organizations, but Kaspersky said the Stuxnet virus had also infected a Russian nuclear power plant. (At least the laptops used aboard the space station were converted from Windows XP to Linux last spring, but if the aliens attack, we may need to dig up those old Macintosh PowerBooks running System 7 to defeat them.)

And finally, the Roomba — the popular roving robot vacuum cleaner — has gotten a redesign. The iRobot Roomba 880 has ditched the brush cylinders and moved to a new AeroForce system of spinning thermoplastic polyurethane tubes. In addition to being a more efficient method of dirt removal, no brushes means: no hairballs. Now, if we can just get cats to switch to spinning thermoplastic polyurethane tubes…

Podcast

PTJ 72: Apples, Pears, and Penguins

Leave a comment

As relief groups and charities collect donations for much needed supplies to help the typhoon ravaged Philippines, how do you know which organization is best for your contribution? J.D. gives us the rundown on how to avoid the dirtbags and fly-by-night outfits when lending a hand. The snow has El Kaiser in a foul mood but he lightens up a bit to share more smartphone battery tips, this time for Android devices. In the news Sony assures gamers that they can indeed play used games on the PS4 despite what the terms and conditions read; Motorola drops the price of their Moto X and makes it easier to get; they also file a patent for a neck patch that can let you make phone call or act as a lie-detector; Apple vs. Microsoft sniping heats up over a Surface 2 billboard; Google Glass gets stereophonic sound; and dig out that Pentium desktop from the garage! A new Linux distro offers the look and feel of Apple’s newer operating systems on old gear.

Episode Links

Episode 43 News: Googley Eyes and Cable Ties

Leave a comment

While the numerous interface changes in Windows 8 may have kept a few people from voluntarily upgrading to the new system, some sources have told The Verge site that Microsoft is currently testing versions of Windows Blue (also known as Windows 8.1) that gives users the option to boot the computer directly to the desktop environment. With that, and maybe those third-party tools that restore the Start menu, future versions of Windows could be much more comfortable for some people. Word has it that Microsoft is also preparing for another whack at a smart watch of its own, since Apple and Samsung seem to be tinkering around with the notion. Hopefully this decade’s attempt will fare better than the Microsoft Smart Personal Objects Technology of Yore.

Ever wonder why there’s no official mobile version of the Firefox browser available for iOS? According to Mozilla’s departing chief executive, it’s because his company wants to use a different Web engine than the one Apple uses to power iOS browsers. So there probably won’t be an iOS Firefox browser for the next version of the iPhone, which could be going into production soon. The Wall Street Journal reports that Foxconn, the company that actually manufactures many Apple hardware products in China, has been recruiting about 10,000 assembly-line workers there since the end of March. (On the topic of Apple hardware, if your third-generation Apple TV is having flakey Wi-Fi issues, here’s some info about the replacement program underway.)  And in mobile-security news, a new report from NQ Mobile says that mobile malware threats were up 163 percent in 2012 — with 95 percent of that aimed at Android devices. Buckle up, ‘droids!

Facebook is said to be talking to Apple and Microsoft about bring some version of the immersive Facebook quasi-OS to the iPhone and Windows Phone handsets. No word on how those talks are going, but Facebook released an update to its iOS app this week and it includes a variation of Facebook Home’s “Chat Heads” visual messaging app.

Kobo has just announced a limited-edition Aura HD e-ink reader, which claims to be the highest resolution e-ink display currently on the market. In other e-book related developments, publisher Simon & Schuster has announced a 1-year trial program with the New York Public Library that makes its titles available for electronic lending.

The first wave of Google Glass spectacles are done and heading to the shipping department for those who signed up early. For those with a bucket of cash to burn, the craving to adopt early and the desire to Wear a Thing on Your Head, the company has also released the spec sheet for Google Glass.

TWCTVIn video news, Netflix is dropping Microsoft’s Silverlight multimedia plug-in for video delivery and is reportedly moving its streams to HTML 5. Comcast has confirmed that it’s starting to scramble its basic cable channels, a power the FCC granted last year as long as they help their customers with the transition by providing free or cheap adapters. The move is not so good for those who pilfer cable or record programs on the computer with the coaxial cable plugged into a TV tuner card.

Time Warner likely has happier customers, though, as a new version of the TWC TV app for iOS devices released this week now lets registered Time Warner customers watch video on demand and live TV programming from certain channels wherever they are — including away from their home Wi-Fi networks, which had been a previous limitation. Alas, Android users must wait a bit longer for the updated version of the app to come their way.

And finally, a noble number cruncher out there has created an extensive turn-based role-playing game called Arena.XIism inside a Microsoft Excel spreadsheet. True, the imagery may not quite be in the Battlefield 3 or BioShock Infinite league, but you probably won’t stress out your graphics card, either.