Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 45th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the SUMPRODUCT & TEXT functions together in 1 formula to sum the month's sales. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Sony offers a set of free games to its PlayStation Plus subscribers every month, but it's easy to miss out if you're not constantly around your console. Perhaps you're traveling, or maybe you've stayed up one too many nights playing Uncharted, leading to a period of PlayStation detox. No matter what the case is, the good news is that you can use the PlayStation app for Android or iOS to claim these monthly free games without getting up from your seat.
We all know the internet isn't exactly a safe place. While plenty of its users are innocent and kind, you won't last long unless you treat every new screen name like a criminal (we're all this cynical while surfing the web, right?). Well, that cynicism is proven correct today, a post on Medium uncovered a group of scammers on the iOS App Store that are costing victims up to $400 a month.
Give an 18-month-old a shoe, check back 10 minutes later, and it's a very big maybe he will have it on his foot. But give him your smartphone, and in a mere five minutes, he can take 100 pictures of the carpet, send weird messages, and delete essential apps. Imagine what your child could do if they were able to harness this technical aptitude and put it to good use — and they can, with learning apps.
Are you a parent to a toddler? Do you need information on how to effectively teach your baby about the potty? Then stay tuned as you learn the effective ways in teaching kids potty training. The 3 stages to potty training is bladder, bowel and night control. The key to mastering it is by starting at the right time. Start training when you see your child uncomfortable with a full nappy. You may decide to head on to toilet training or use a potty. Or you may also want to try to buy some roll-up...
Not exactly enthused about who your daughter chose to marry? Turn lemons into lemonade by getting along with a deadbeat son-in-law – despite how you may feel about him.
A major software tool first promised during the reveal of the HoloLens 2 earlier this year is finally available.
Magic Leap has been promising to launch a developer conference for years, and now the company is finally making good on that promise. On Wednesday, Magic Leap sent out the official announcement for its first L.E.A.P. conference, which will be held in Los Angeles in October.
Apple Arcade actually looks like a refreshing change of pace for subscription services. The platform costs just $4.99 a month and includes access to over 100 unique and exclusive games. That's not to mention the one-month free trial each new user can claim. But know this: you shouldn't cancel that free trial until you're ready to give up Apple Arcade.
While AT&T is gradually showing off the powers of its 5G technology in the US via the Magic Leap One, another major wireless company is doing the same in the UK using the world of fashion.
You just brought a brand new Pixel 3 from the Google Store, and you insert your SIM card only to find the phone won't recognize it at all. No matter what you do, the SIM card won't register and your Pixel won't connect to your carrier network. That's what happened to me and several other Pixel 3 owners. The good news is a fix is coming, the bad news is Google doesn't have a date for that fix.
GE Aviation and their software partner Upskill are seeing success by giving their mechanics smart tools and smart glasses, the latter in the form of Google Glass.
Apple Music offers a cheaper subscription option to those of you who look for it — only $99 for a year. If you are already an Apple Music user, you can access the option right now. Otherwise, you have to sign up for a normal monthly plan first, then switch to this plan to get a better deal after.
It seems like everyone wants to be flying without wings these days, and some big players in the autonomous car industry want a piece of that airborne action. Google co-founder Larry Page just invested in flying car startup Kitty Hawk, while Uber is adamant that its own-brand of flying vehicles will be zooming around the US come 2020.
It's been a long time coming, but Google's Calendar app for Android has finally received a visual makeover. In the spirit of Android Lollipop, Google's new Material Design permeates throughout the update.
At last month's I/O event, Google demonstrated a set of cool new features that were said to be coming to the Chromecast soon. While we may not be able to set custom backgrounds or cast content without being on the same WiFi network just yet, the biggest feature of them all has started rolling out to devices today: Screen mirroring.
Thanks to everyone who submitted ideas in last month's Mad Science contest. The question called for your best idea for using Sugru, a temporarily malleable silicone modeling clay that self cures for a soft-touch permanent bond. It's a marvelous product for at-home quick fixes and for even making some cool DIY bumpers and grips for your electronics. William scoured through all of the comments and chose the two winners he felt best deserved a pack of Sugru.
The augmented reality business was all about audiences this week. Vuzix looked for an audience with the Supreme Court of New York regarding a defamation lawsuit against an investor. Magic Leap held an audience with royalty, showing off the Magic Leap One in a rare public appearance. And Snapchat wanted to remind its consumer audience of all the things its camera can do.
It turns out that the government of Saudi Arabia has managed to do something last month's Game Developers Conference couldn't — give us a few new glimpses of the Magic Leap One being worn by someone other than Shaq.
Google has done it again—they've pushed another broken OTA update for the Nexus 6. Except this time, it almost completely softbricks your Nexus 6 instead of just screwing up Android Pay and SafetyNet. Apps are force-stopping left and right, making the phone practically unusable.
Many home chefs are deterred from whisk-intensive recipes such as mayonnaise because they seem to require more than two hands—which is obviously the maximum number we possess. One hand is required to stabilize the bowl, another must be whisking constantly... and a third hand is needed to pour a steady stream of oil.
While Apple's smartglasses development reportedly moves forward behind-the-scenes, the company continues to build on its AR software foundation in its mobile ecosystem with further iterations to its ARKit platform and the introduction of new AR development tools.
Reading the augmented reality news lately has felt a bit like reading a John Grisham novel, as the business side of things has dripped with legal drama.
Augmented reality startup Nreal was a hit at this month's CES event, with some even calling the device a worthy challenger to the Magic Leap One.
At an event in Mountain View, CA, and watched by fans via live stream on YouTube, Google announced a slew of new products today. Over the last few weeks, there was no shortage of rumors and leaks about what might be unveiled, but now the secrets are out.
Protein powder is a fad in the same way that Justin Bieber's music is: you either love it, or you hate it. Everyone I know has a strong opinion about protein powder, ranging from "daily necessity" to "utterly useless."
With new iPhone models out, you'll have updated cameras to try out, a faster processor, and new colors to choose from. The only thing that could stop you from picking one up yourself is, well, your current iPhone. Here's how to check if you're eligible to upgrade to iPhone 11, iPhone 11 Pro, iPhone 11 Pro Max, or any other iPhone still being sold.
Who said sports need parity to be fun? For the third year in a row, the Cleveland Cavaliers are facing off against the Golden State Warriors on the NBA's biggest stage, and basketball fans everywhere couldn't be more excited.
Months before London-based Jonathan Moon would turn 30, he started musing over how to celebrate. While he had rung in past birthdays at home, he wanted to do something out of the ordinary as a farewell kiss to his twenties. A short ski vacation with friends felt like the perfect idea.
Your smartphone is likely full of COVID-19 news and coronavirus panic. These are scary days, and there doesn't seem to be any end in sight. If you're having trouble coping with the stress and anxiety the virus brings with it, know that your iPhone or Android device can actually help you, rather than just bring you further down.
Apple's iOS 14.5 overhauled the Podcasts app, combining new aesthetics with smart and efficient features. While you might find the app better at playing your favorite podcasts than past versions, you might also find something negative about the update on your iPhone: it may be eating up your storage.
Apple's successor to the iPhone X is a beautifully made smartphone with much of the same characteristics, including a 5.8-inch OLED screen, two storage choices, and Face ID. But many features set the iPhone XS apart from its predecessor, as well as the other 2018 lineup of iPhones, making it a worthy choice to upgrade to if you're in the market for a new mobile device.
If it has an internet connection, it's got a huge attack surface for hackers. But what makes your phone even more dangerous is its portability and the collection of sensors it houses that can be just as good at tracking you as the camera and mic.
Last year, your iPhone's Weather app received some great features, but things are even better now with the latest iOS 17 version.
Apple doesn't include its Calculator app on the iPad and never did. One almost appeared over 12 years ago but was nothing more than a blown-up version of the iPhone app. Since then, the company still hasn't made an iPad-optimized calculator, and there is no shortage of third-party alternatives to fill the gap. It may happen one day, but for now, these are the best calculator apps for your iPad.
Last month, Mel gave us tips for improving shots on uneven lies. In this month's installment of Mel in Motion, Mel shares the secrets of dealing with sidehill lies: shots where the ball is either above or below your feet. Club selection and swing technique both play a part. Watch this video golf tutorial to learn more about sidehill lies.
Made by Joel features a collection of beautifully designed paper dollhouse furniture, featured in this month's La Petite Magazine. Joel's designs are quite elegant, and best of all, he offers a free template to make your own. Why not put your discarded fancy magazines to good, kid-friendly use?
Thank you to everyone who entered the photo contest for a chance to win a cool lucid dreaming goggles kit from Mad Science. This month's winner was Cerek, who submitted this great camera shutter release project photo:
The Illusion Contest of the Year recently announced their top ten finalists, and the overwhelming crowd and jury favorite is Impossible Motion: Magnet-like Slopes by Koukichi Sugihara of the Meiji Institute for Advanced Study of Mathematical Sciences in Japan.
It's only been ten years? Where has all of the time gone? When RuneScape came out in January of 2001, the world was a different place. There were no such thing as Xboxes, normal gamers didn't care about the number of cores on a processor, and the World Trade Center Towers dominated the Lower Manhattan skyline.