Year Outdated English Search Results

How To: Count dates falling within a given year in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 632nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula using the SUMPRODUCT and YEAR function to count instances of the year 2009 or 2010 from a list of dates with different years.

How To: Understand the basics of apple tree pruning

Each year an apple tree should produce three things: new growth, fruit buds on last year's and older growth, and fruit on those fruit buds formed in previous years. In order to keep an apple tree in balance and fruiting, one must prune. However, pruning is too often done poorly. In this, the second installment of his series on practical apple tree pruning, Stephen Hayes of Fruitwise Heritage Apples looks goes over what to look for in a good secateurs, or pruning shears, and how to thin out sp...

How To: Play "100 Years" by Five For Fighting on the piano

Want to know how to perform Five for Fighting's "100 Years" on the piano? Learn how with this free video piano lesson, which presents a complete breakdown of the song and its chords. While this tutorial is best suited for intermediate players, pianists of all skill levels can play along given a little time and effort. For more information, and to get started playing "100 Years" on your own keyboard instrument, watch this how-to!

How To: Exploit Remote File Inclusion to Get a Shell

A simple security flaw can allow an attacker to gain a strong foothold with little effort on their part. When a web application permits remotely hosted files to be loaded without any validation, a whole can of worms is opened up, with consequences ranging from simple website defacement to full-on code execution. For this reason, RFI can be a promising path to obtaining a shell.

Hacking Twitter: See Who Unfollowed You with These Apps

Followers are everything. After all, you need someone to listen to your tweets about last night's episode of your favorite TV show. But what about when people unfollow your account? Not only have you lost part of your follower base, you have no idea who left. Luckily, there are tools out there to help you learn just that, even if Twitter itself won't give up the info.

How To: Get Rid of Google Assistant on Your Android Device & Switch Back to Google Now

Now that Google Assistant is coming to all devices running Android Marshmallow or higher, roughly one out of every three Android users will no longer be able to access the old Google Now interface. The Assistant, which was previously exclusive to Pixel devices, takes over your home button long-press gesture and completely replaces all of the old Google voice search functionality.

How To: Message Effects Not Working in iOS 10? Here's How to Enable Them

As iOS 10 makes its worldwide debut, many users are noticing that the promised iMessage effects feature in Messages is not working properly. Instead of seeing the actual effects, messages will come through like normal, but with text describing the effect they were sent with. On top of that, you can't send your own message effects if you're one of the affected users.

How To: Easily Tweak, Mod, & Customize Windows 10

Every time Windows gets a significant update, the vast majority of existing tweaking utilities become obsolete. For every option that you fine-tuned with one of these tools on Windows 7 or 8, there's a change in the registry or system settings that cause your tweaks to now point to a dead end. This was definitely the case with Windows 10, since there were so many sweeping changes that very few existing options carried over.

How To: 8 Menu Bar Apps Every Mac Power User Needs

The menu bar is a great place to perform quick searches, track battery life, and switch Wi-Fi networks on your Mac, but it can do way more than that if you let it. I've rounded up some menu apps below that not only have features that will boost your productivity, but are lightweight enough to run entirely from the menu bar.

How To: Save Battery Life on Android by Turning Off Pixels (No Root Required)

Many modern Android devices use a display technology called AMOLED. These screens differ from traditional LCD displays in that each pixel emits its own light, so a backlight is not required. Even better, when rendering a black element on the screen, AMOLED displays simply don't light up the associated pixels, meaning virtually no power is used. Since black pixels use little to no power on an AMOLED screen, more black pixels means lower battery consumption.

How To: Order coffee in English

A lot of the English you hear in the real world isn't taught in the classroom. This ESL tutorial gives some English advice on how to order a coffee. This video demonstrates ordering coffee with specific vocabulary. Watch this how to video and you will be speaking English in no time.

News: Book Review - The Power of One by Bryce Courtenay

The Power of One is one of those books that I really should have read years ago. I’ve certainly meant to read it for a long time so this was a satisfying title to cross off my list. It’s stunning that this was Bryce Courtenay’s first novel. I look forward to reading his others because if this is where he started, he’s a talented writer.

Books: Digital vs. Analog

Since the invention of the printing press, books have been a dominant and iconic paradigm in our culture and throughout the world. During my years in elementary and high school, the digital world was on the rise sparking the conversation: Are Books Obsolete. Over the last year (or 2 at the most) that the term "Book" has started to make the shift from a physical object to the concept of a written work.

Final Combat: Cheap Chinese Knock-Offs Come to Video Games

Team Fortress 2 (TF2) is one of the best multiplayer games of all time. It took nine years to make, and the developers have supported it with more post-release free updates than any other game ever. Four years after its release in 2007, it is still immensely popular, and although its price has gone down, Valve has managed to continue making a massive profit by introducing the first successful microtransaction model in a mainstream American shooter. That model has been so successful that it lo...