Display archivesLarge number of genetics papers contain errors because of Excel

August 26th, 2016
About 20% of genetics papers contain errors because Excel sometimes converts gene names to dates or random numbers. For example, it will change the name of gene SEPT2 to September 2. That’s why it’s important to know how to format cells properly.


Article at the Washington Post: http://wapo.st/2bE5kGU



Display archivesMigrate WordPress installations using the Duplicator plugin

August 16th, 2016
Nice WordPress plugin I just used is called Duplicator. It let me migrate a site from development to a new production server. I used the free version of Duplicator, and there’s also a Pro version. Only glitch: I had to manually create the database and user on the production server. It looked like the plugin would do that for me, but it didn’t. Could be an issue specifically with the host.


Find out more info and download the plugin at http://lifeinthegrid.com.



Display archivesHow to Calculate Percentages in Excel with Formulas & Functions

July 5th, 2016
Article and screencast published by Tuts Plus:





Display archivesHow to Use Built-In Mobile UI Screens in Adobe XD

June 1st, 2016



Display archivesNew course: Rapidly Create Mobile App Prototypes with Adobe XD

May 26th, 2016
Adobe XD, a/k/a Experience Design, lets you create realistic prototypes of apps rapidly, accurately, and without having to write any code. Since XD is made by Adobe, you may find the user interface and the tools familiar. But it also has unique features, like the dynamic Repeat Grid and Prototype mode.


Once you’ve completed your project, you can use Adobe Creative Cloud to share the prototype with other people and view it on your own device, without having to deal with security issues. This way, you can see how your app will look and behave before you start programming.


In this course, we complete a small project from start to finish, using all the tools and features of XD. All the class files and fonts are included. XD currently runs only on the Macintosh, and Adobe said they will release a Windows version towards the end of 2016. If you learn the Mac version, you’ll probably be able to use the Windows version without much trouble.


Rapidly create mobile app prototypes



Display archivesProtecting yourself from ransomware

May 14th, 2016
Ransomware is a serious problem: rather than harming your data or stealing your identity, ransomware can encrypt your computer or your whole network until you pay a fee. The perpetrators and their accounts are typically overseas and they usually ask for untraceable money, like Bitcoin. Some large companies have been forced to secretly pay the ransom to get their networks back.


Wired magazine said one avenue for infection is compromised ads on trusted websites. So avoiding questionable sites is no longer enough. And to read the article on Wired’s web site, they make you disable ad blockers! You can’t make this up.