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 631st installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting to a transactional record when the date is 90 days past due using the TODAY function and mixed cell references in a logical TRUE-FALSE formula.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Want to play "My Blue Heaven" by Walter Donaldson and George A. Whiting on your ukulele? Learn how with this free video ukulele lesson from Ukulele Mike. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started ...
Want to play the Beatles' "Mother Nature's Son" on your ukulele? Learn how with this free video ukulele lesson from Ukulele Mike. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing "Mother Nature's...
In this video tutorial from Get Connected TV, hosts AJ Vickery and Mike Agerbo, will show you how to extend Widows Media Center to your XBox 360 using Windows 7. This video assumes that your XBox is already connected to your home network, so you may want to be sure to do that first. With this configuration, you will be able to not only watch movies, but view, pause and record TV on your personal computer, as well. You will learn how to access the Media Center section of your XBox, and get the...
MAKE and Kipkay brings the do-it-yourself mindset to all the technology in your life. Make Magazine celebrates your right to tweak, hack, and bend any technology to your own will.
John Park from Make Magazine hacks a Nintendo Wii controller and turns it into a personal flight recorder that can sense and measure the stomach-churning G forces of roller coasters and other high-speed, high-risk activities.
How to easily fix the missing tags in your MP3 collection using free software called Fixtunes. The tags on an MP3 file identify things like the Song Title, Recording Artist, Album Name, Genre, Track Number, etc. When you buy songs from places like the iTunes Music Store or MP3.com these tags are complete. Some of the songs in your iTunes library may have incomplete tags. This is how you fix them.
You've boxed up and shipped all your other possessions for the big move and all you're left with is the little issue of how your getting your car there. There are companies out there that will ship your car to you, just make sure your car is prepped for the journey.
Missing out on a good night’s sleep can leave your feeling groggy and unproductive. Make sure your always get the z’s you need by creating a good sleeping environment, avoiding stimulants and getting enough exercise.
No matter who you are, a little self-confidence can go a long way toward making your dreams come true.
The Department of Biological Sciences at the University of Alberta brings you this video tutorial specifically relevant to your student laboratory courses, specifically microbiology. If you're a student at any school of biology, this information will be helpful for learning how to use the Ultrospec UV-visible spectrometer and HP printer in the lab.
Learn how to set up a basic home recording studio. Teaches about different types of microphones and other equipment.
This week's Apple earnings offered a report of solid performance and guarded optimism about future iPhone sales, which may be impacted later this year by issues around the current coronavirus epidemic in China.
New year, new me. You finally committed to working on the best physical you by going to the gym multiple days a week. Except about an hour in, you start getting really tired of it all. Before you run to the exit, pick up your phone.
Will the name "slofie" ever catch on? Probably not. But that won't stop the feature from being a hit. Slo-mo selfies aren't new in the smartphone world, but they are new to iPhone, arriving for the first time on iPhone 11, 11 Pro, and 11 Pro Max. Here's what you need to know before you start shooting your first slofie.
Facebook Messenger Lite is an official, de-bloated version of Facebook Messenger for Android. It's snappier and it's a lot more battery-friendly, but this is because there are fewer features complicating everything. One feature they didn't leave out, however, is the ability to send audio messages.
The biggest change this year for iPhones comes with the cameras. All three iPhones get a new ultra-wide camera, which allows the device to capture more of what's in front of you. Not so new this year is the 64 GB base storage, which will fill up fast when shooting in 4K at 60 fps. A new feature will also add to your storage concerns, however, a feature that captures more video than it really should.
He might be an O.G. rapper, but Snoop Dogg has officially entered the cutting-edge of technology via a hidden feature included with his newest music release.
If you have a modern iPhone, you have an excellent video recorder at your disposal. Every iPhone since the 6S has the ability to shoot in 4K resolution, and each new iteration has brought new capabilities to the table. But even the best mobile shooter can use a little extra help. That's where these video recording apps come into play, to ensure the footage you capture is as good as can be.
You see them all over your Instagram Stories feed — post after post, video after video of dramatic, silly, or otherwise fun zooms. Your friends are showing off their lives through the lens of a Hollywood blockbuster, and you can do the same. Luckily, it's quite easy to accomplish, whether you're running iOS or Android.
The idea of a perfect phone is a myth. There are lots of pros when it comes to OnePlus devices, but there are also a few things that could be better. And even if there were a phone without flaw, there are still things that you might want to customize for personal preference. That's why we set out to find the very best tweaks for OnePlus phones, and to make it easier for you to apply them.
One word to sum up this batch of Snapchat lenses: complex. Lens creators like ApocTheLegend and Jinnie the Wew have been at it long enough to start making some really cool stuff, stretching the limit of what's possible using Lens Studio. I'm really looking forward to what they continue to pump out in the future.
One of the most successful rock bands still making music has just made augmented reality an integral part of its upcoming tour. Irish rock band U2 has announced a new mobile app experience that allows you to preview the group's live performance in your own home in AR.
Although more and more smartphones are introducing portrait modes with their cameras, there are still plenty of devices out there — especially devices older than one or two years — that do not. While your particular smartphone might not offer you that bokeh effect, Instagram can, as it gives all smartphones software-based portrait modes.
Apple's iPhone X now has the power to turn anyone into a Japanese anime character, thanks to a new app that harnesses the device's TrueDepth camera.
HoloLens developer Arvizio has expanded its collaboration suite of tools for enterprises with a device that can stream and record mixed reality experiences in high-definition for local and remote audiences.
3D Touch is only available on the 6s and 7 series iPhones right now, and likely future models, so those with older devices are missing out on all the cool "Quick Actions" available for app and settings icons. But the new iOS 11 is finally bringing some of those helpful shortcuts to iPhones without 3D Touch built in.
All you paying Spotify users are about to get another exclusive privilege besides getting out of all those annoying "Ever wonder what it would be like to have Spotify premium?" ads. The Sweden-based company is looking to lower the royalty fees they have to pay to major record labels for their music, by compromising on their policy that all their music be free to paying and nonpaying users. Spotify would for a limited time restrict access on major album releases to their paying subscribers.
In December of last year, Australian Feliks Zemdegs broke the human world record for solving a Rubik's Cube with a time of 4.737 seconds. Well, this robot did it way, way faster by solving one in under 1 second. Don't tell me a robot takeover isn't real possibility.
Snapchat accidentally—and then intentionally—announced their digital eyeglasses, known as Spectacles, over the weekend. While we'd hoped their augmented reality-heavy platform would result in related hardware, Spectacles unfortunately seek to "reinvent" little more than a video camera.
Instead of the still image we've been accustomed to since the inception of Facebook, you also have the option to apply a seven-second video as your profile image, which definitely mixes things up a bit with GIF-like animations. Best of all, this can be done straight from your iPhone or Android device.
For most of us, the primary reason we capture videos on our iPhones is to post on one of the various social media platforms out there, like Facebook, Instagram, Snapchat, or Twitter, providing instant gratification by receiving a proverbial nod from our followers.
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.
With the purchase of my new Apple Watch, the days of striving to be a James Bond-like spy have never been closer to fruition. Granted, talking to your wrist in public can look pretty pretentious, and I may very rarely do it, but let's get real—you look like 007!
Just recently, Snapchat decided to implement a feature that it had long been lacking—the ability to play music and record a video at the same time. For those of us that are jailbroken, we've had this feature for some time, but now that everyone has the ability, how should you use it?
Any beer aficionado who's been to Ireland will always talk about how the Guinness there "just tastes different." But save your eye rolls, skeptics: it turns out your favorite lagerhead actually has a valid point.
While chatting in Hangouts on Android, inserting an emoji or animated sticker can instantly make the conversation more fun, but they'll eventually lose their charm, as most things do. Even if you add GIFs to your texting arsenal, things could get stale. That is, unless they're personalize GIFs you actually make yourself (the process is really simple).
Anyone who has rooted their Android device has likely used a tool called Android Debug Bridge, better known as ADB, at some point during the process. For most, that is their only interaction with the ADB, but to be a true Android power user, you need to really know the tools at your disposal.
With the Samsung Galaxy S5 all but assured to be showcased in a just a few weeks, we've got our hands on some fresh details of the upcoming flagship device.
