Excluding Search Results

How To: Count days excluding Sundays in Microsoft 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 189th installment in their series of digital spreadsheet magic tricks, you'll learn how to count all the days except for Sunday using an array formula for a given date range with a specified start and end date.

How To: Find a mean for data set while excluding 0s in 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 and Mr. Excel, the 13th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will calculate the AVERAGE excluding zeros (0) in the original data set.

How To: Perform the "don't blink" card trick

This videos shows the instructor performing the don't blink card trick. The video begins with the instructor holding six cards all of spades and numbers excluding the ace card. He then said his friend asked him why he does not play poker anymore and he responded with " Well the last time i played i zapped somebody". The instructor then slides his fingers over the cards and they reveal as completely different spade cards with no explanation of how the trick was done. The instructor does note t...

How To: Make date & time calculations (sans weekends) in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 533rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to calculate the difference between start date/time & end date/time excluding holidays and weekends. This is accomplished with recourse to Excel's NETWORKINGDAYS and MOD functions.

How To: Cook Jamaican Jerk pork

We are sure you've heard and maybe even had Jamaican jerk chicken, well here is a recipe for jerk pork. The funny thing about Jamaican jerk seasoning is that it goes great with almost any kind of meat. In this cooking how-to video Tracy cooks some authentic Jamaican jerk pork. Follow along and learn how to prepare jerk pork.

How To: Use This Trick to Quickly Select All Photos & Videos on Your iPhone to Bulk Delete or Share

With high-resolution photos and 4K videos being standard these days, it's no surprise that media hogs most of the storage space for many iPhone users. If that's you, there's always iCloud, but you only get 5 GB free, and a paid 50 GB or 200 GB plan can fill up fast. To save money and reclaim storage, you can just delete content from the Photos app, and there's a trick to doing it faster.

How To: Get a Game Boy Advance (GBA) Emulator on Your BlackBerry, iPhone, Android, PSP, Mac, or PC

For those of you still using a BlackBerry smartphone, this article will show you the tips and tricks to installing emulators and playing some classic Game Boy Advanced games on your device. You can find a few tutorials and videos out there on getting Game Boy Color or NES games on an Android device, but the most elusive mobile emulator is for Game Boy Advanced (GBA) on a BlackBerry.

How To: Team Up with Friends to Raid Fortresses in Harry Potter: Wizards Unite

If you've read or watched anything Harry Potter before, you know friendship and teamwork are huge parts of the story. The same goes for Harry Potter: Wizards Unite, with its "Wizarding Challenges." Here, you can tackle Fortresses full of Foes alone, but why do that when you can battle with up to four other friends at once? Here's how it all works on Android or iOS.

How To: There's a Quick Gesture to Open Hidden Camera Settings on Your iPhone

The camera on models in the iPhone 11 series includes an ultra-wide lens to take wider images, Night mode for taking better-looking photos in low-light environments, and a 16:9 frame for shooting. With these new features comes a slightly redesigned interface in the Camera app, one that even the second-generation iPhone SE received despite only having one of those three features.

News: 10 Things Android Users Hate About iPhones

I'm an Android user. Over the course of the past seven years, I've owned ten different smartphones—all of them powered by Android. This isn't due to some blind trust in Google or some unfounded hate for Apple, either, because I've always made sure to get my hands on each iPhone iteration along the way to see what it had to offer.

How To: Demonstrate Newton's law of inertia

This short video clip shows seven demonstrations of Isaac Newton’s first law of motion– the law of inertia. Newton’s law of inertia states that objects moving at constant velocity will continue moving at constant velocity, unless acted upon by an outside unbalanced force. Six of these demonstrations (excluding number six) are from Tik Liem’s book Invitations to Science Inquiry.

Prev Page