How to Quickly Count Items in Different Ranges with Excel

When analyzing data, you often need to split values into different ranges so you can see how they are distributed. For example, you might group students into 80-100 points, 60-80 points, and failing, then count how many students fall into each group for analysis. That’s where the FREQUENCY function in Excel (or Google Sheets) comes in very handy! ...

August 3, 2017 · 2 min

Struggling to Record GIFs? Let LICEcap Help You!

The GIF format nearly disappeared for a while, but recently, with the rise of Facebook and Twitter, more and more people use GIFs to make animations or as stickers in Messenger. I use them for the tutorial videos in my blog posts. GIFs have the advantages of small files and quick loading on web pages. For certain rough motions, GIFs work very well for tutorials. Today I want to share LICEcap, which can record your screen to make GIF files. It supports Mac and Windows and has a simple interface. All the recent GIFs on my blog were recorded with LICEcap. ...

January 21, 2017 · 2 min

Tired of Typing File Paths? Let the Sublime Text Package AutoFileName Solve It for You!

Among the things I hate most when writing code, typing file paths is definitely near the top. Every time I need to type a file path, such as loading a JS or CSS file in HTML, or opening a file in Python, I have to switch to Finder to copy the file name. But if you are a Sublime Text fan like me, using it for every programming language, then let AutoFileName be your helper! ...

January 8, 2017 · 1 min

Homebrew - Error: Unknown command: cask

If you’re a Mac developer, you’re surely familiar with Homebrew, and you’ve probably used brew-cask to install apps. Today, when I tried to install a program with brew cask, I kept getting the error “Error: Unknown command: cask” every time I ran brew cask install xxx, even though I had confirmed that brew cask was installed successfully. After searching the issues, I learned that this seems to be a bug in an older version, which has since been fixed. ...

December 23, 2016 · 1 min

WinX HD Video Converter Deluxe: A Powerful and Easy-to-Use Video Conversion Tool!

WinX HD Video Converter Deluxe is the first paid software I’ve written about. Its main job is video conversion, and one feature I personally think is pretty nice is that it can download videos from YouTube~ But to be honest, before writing this post my thinking was: “Conversion software? There’s tons of free stuff like that online—who would dare charge money for it?” But… when I actually used this software, I found it wasn’t as ordinary as I’d imagined XD ...

February 29, 2012 · 3 min

How to Turn a Video into Music: Extracting the Audio Track with MediaCoder

This post shows you how to turn a “video” into “music.” Often you might download a great music video from a video-sharing site (for example, YouTube), but the file is in a video format such as MP4 or FLV. In that case, you can use the audio track extraction feature built into MediaCoder to convert the video into an audio file! ...

January 28, 2012 · 1 min

FastestTube: A YouTube Video Downloader for Chrome, Firefox, and IE with Built-in Conversion

FastestTube is a Chrome extension that lets you grab YouTube videos. Its big feature is built-in conversion. Most YouTube downloaders on the market can only save videos in FLV format, but FastestTube can save MP4 as well as FLV. You can send the MP4 straight to your phone or iPad and watch it there, without an extra conversion step. ...

January 27, 2012 · 2 min

Calibre: Convert, Edit, and Read E-books in One Place, and Send Them to Your Kindle

If you read e-books, I’d like to recommend a program called Calibre. If you read on your computer, you probably don’t need to convert anything. But many people read on e-book readers like the Kindle or Nook, and for them, Calibre is essential. The Kindle doesn’t support the EPUB format. It only supports formats like AZW, MOBI, and PDF. If the book you have is in EPUB format, you can’t read it directly on a Kindle. Most books from the well-known e-book site Haodu are in EPUB format, and that’s where Calibre comes in to convert them for you. ...

January 26, 2012 · 4 min

Send to Kindle: A Chrome Extension for Sending Web Pages to Your Kindle

Send to Kindle is a Chrome extension that every Kindle user should install!! You often come across interesting articles or tutorials online. Some people bookmark them, others export them to PDF. If you have a Kindle, you have one more option: send the page to your Kindle. That’s exactly what the Send to Kindle extension does. ...

January 25, 2012 · 2 min

[Chrome Plugins] Save as PDF: Save a Web Page as a PDF to Keep It

Sometimes you bookmark content you like, but if the site goes down or the article is removed, the bookmark is useless and you can no longer read the article. In that case, saving it as a PDF is a good choice. PDFs are also a great fit when you want to read offline~ ...

September 3, 2011 · 1 min