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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...
Want a more interesting screensaver? If you find any Shockwave Flash file, turning it into a screensaver is as easy as a single click with InstantStorm! This clip will show you how it's done. It's simple! So simple, in fact, that this home-computing how-to can present a complete, step-by-step overview of the process in just under three minutes. For more information, including complete, step-by-step instructions, take a look.
Repeating a task using a For...Next loop : Excel: VBA in Depth from lynda.com Watch the entire course at http://www.lynda.com/home/DisplayCourse.aspx?lpk2=62906&utm_source=youtube&utm_medium=viral&utm_content=youtube&utm_campaign=youtube
This sculpter's guide presents a look at how to create reptilian scales with alpha maps as a custom brush. The tutorial makes use of both Blender 2.5 and Photoshop. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step instruction...
Ozymandias, the smartest man in the world, is certainly one of the most intriguing of the many intriguing characters from the comic The Watchmen. This video features detailed instructions for making a custom Ozymandias Lego minifigure. Combine with the other Watchmen hero minifigures and act out whatever scenes from the comics your like!
The Watchmen are one of the most intriguing set of characters in the history of comics. If you love both the comics and Legos, then this video is for you. It features detailed instructions for making a custom Lego minifigure of Rorschach using basic hobby tools. Make the whole team, and start solving some tiny crimes!
Before you can work in Word 2010, you'll need to learn how to work with it. See how to change and style fonts within the Microsoft Word 2010 user interface with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started using custom font settings in Word 2010 yourself, take a look.
In this clip, learn how to make a fast, cheap and super easy mount for your your bicycle to display safety lights. Wearing bike lights at night will help you stay safe in the dark and if you want to avoid the cost of getting lights custom fitted, this hack is perfect for you. All you will need is some PVC pipe and some grip tape (like the kind used for tennis rackets). Follow along and get started. This mount is flexible and fits most standard lights or flashlights.
This video is a demonstration of how to cut up a T-shirt, inspired by 80's rock band fashions. Use a regular white T-shirt and start by cutting a deep scoop neck out of it, starting about an inch outside the neckband. Turn the shirt over and fold it in half Snip horizontal lines down half of the shirt all the way down. Then stretch out the thin strips. Cut the other side of the shirt the same way. Cut the sleeves off completely so it's more like a tank top. Wear the shirt over another tank to...
Learn to record audio with the Camtasia recorder by watching this video tutorial. First, if you want to record audio click on the mic. It's easier than clicking on capture. Next, you'll find on the same menu a selection for custom or full screen modes. After you've made these selections you have cursor selections to choose from. Those options are listed under the effects tab. Are you a silent mouse or a squeaker? If you want your viewers to hear your clicks then under the same tab there is an...
Tired of the lame dull background in Finder windows? Conveniently, Apple integrated a feature which allows you how modify the color or image that is displayed in Finder windows. This video will show you how to modify these settings to snazz up your Mac.
Check out this DIY video tutorial from Curbly, the best place to share pictures of your home, find design ideas, and get expert home-improvement advice.
This origami video shows how to make a simple dove-like bird. I then go on to show you how to turn it into a hanging decoration. This would be great as a Christmas tree ornament or some other holiday decoration to represent peace. This simple project is a great holiday craft. All you need is paper, your hands, and origami skills! Voila! A custom holiday decoration.
In this video tutorial, Chris Pels will show how to create a web service in ASP.NET and then call the service from another ASP.NET web site. First, learn how to create an .asmx component which represents a web service in an ASP.NET web site. When creating the web service learn how to control several aspects of the web service functionality with web service attributes. Next, see how to test the web service in the Visual Studio web service test page. Then learn how ASP.NET allows many .NET data...
Apple hasn't refreshed its text tones on iPhones since iOS 7. That's six years of the same sounds. And while text tones like Bamboo and Hello have undoubtedly aged like fine wine, that's still too long to live with the same old sounds day after day. Let's take matters into our own hands — let's make our own text tones, right in Music on macOS 10.15 Catalina.
According to a study done by Kaspersky, 7.6% of Android users root their phones. That may not sound like a lot, but with over 2 billion Android devices out there, the math works out to over 150 million rooted phones — more than the total population of Russia, Mexico, or Japan — so root nation is an important demographic that deserves being catered to.
So, you just updated to Android 10, ready to explore all of the new features Google has to offer. There's just one hiccup — those gesture controls everyone talks about? They don't work. In fact, the option is completely grayed out, taunting you from the get-go. What's going on here, and how can you restore functionality to a staple Android Q feature?
The updated Reminders app in iOS 13 makes productivity a little bit more seamless on the iPhone. The overhauled user interface makes it easier to find your reminders, the new Messages integration makes it simpler to remember to-dos regarding your contacts, and the new toolbar provides shortcuts to tasks that were once clunky and confusing.
Samsung's popular Good Lock app has been updated to work on One UI and now lets you take full advantage of its awesome add-ons to customize your S10 in a few simple taps. One add-on in particular lets you get rid of mostly redundant indicators like the NFC "N" for a cleaner status bar.
After weathering an executive departure and reports of a failed sale to Apple, Leap Motion is getting back to the business of pushing the envelope for augmented reality development and interaction.
The OnePlus 6T is easily one of 2018's best value phones for many reasons, especially when it comes to rooting and modding. But like many new phones, it's plagued with the single bottom-firing speaker that left us wanting more in the sound department. The speaker is decent on its own, but it appears to have some hidden potential at the same time.
No matter how good a display is, the idea of perfect color calibration is subjective — some prefer warmer more saturated colors, while others prefer the calmer cooler side of the color spectrum. It is almost impossible to create a single color calibration that everyone can agree on out of the box. The display on the Pixel 2 XL was specifically calibrated with a more realistic color profile in mind.
Samsung's Good Lock app has has breathed much needed life into its TouchWiz UI by giving us the ability to customize our Galaxy phones in ways that previously would've required root or a custom ROM. One companion app in particular even lets you personalize your lock screen to set it apart from the rest of the crowd.
Samsung's Galaxy S9 was recently announced with features like AR Emoji and Dual Aperture, but great functionality lives underneath them — such as the ability to have your home screen auto-rotate to landscape mode. It's a nice feature, but with a little work, you can already do this on any Android phone.
If you need to scan a large number of domains for a specific web app vulnerability, Dorkbot may be the tool for you. Dorkbot uses search engines to locate dorks and then scan potentially vulnerable apps with a scanner module.
Oh, Uber. It's not often to hear your name in the news and have it mean something good. You're being sued, you're crashing, your driverless program is falling behind. But I have to hand it to you; when the world is crumbling around you, you continue to fight against it. You've even made it to Canada.
Cyanogen, Inc., the for-profit company that spun off from its CyanogenMod roots several years ago, has announced that they're shutting down all of their services. The company's impending demise shouldn't directly impact many Android users, but the announcement does have one major repercussion: The servers that used to host the popular CyanogenMod custom ROM have now been shut down.
The Google Pixel and Pixel XL have an exclusive set of navigation buttons that you can't get on any other device without some tinkering. But aside from just being solid, filled-in shapes, the real treat in the Pixel's nav bar is the Google Assistant animation that gets activated by long-pressing the home button. The four colored dots that animate outward give you some visual feedback for triggering the Assistant, but really, it's just a nice little touch.
Android Nougat has a new API that lets apps create their own custom Quick Settings tiles. A similar feature was buried in Android Marshmallow, but that required a hacky workaround, and most manufacturers disabled it in their custom versions of Android 6.0. But since this is an official API now, all phones that run Android 7.0 and higher should be able to use custom Quick Settings tiles going forward.
Google's Material Design guidelines have finally brought some consistency to the look and feel of Android apps, bringing most of the user experience on par with what you would see on iOS. However, some developers are still using non-compliant home screen icons, even though Material Design calls for specific padding, size, and layouts.
Rooted users have been able to remap their hardware buttons since the earliest days of Android, allowing them to change the functionality behind one of the most centralized methods of interacting with a phone or tablet. Up until now, however, non-rooted users have been left out in the cold, meaning these buttons could only perform the functions assigned to them by the device manufacturer.
It's a given that if you're driving, you or someone you know has Waze as a go-to on their smartphone. The Google-owned crowdsourced navigation app is one of the best for avoiding traffic, roadblocks, and even cops.
If you find yourself switching between Android devices frequently—for instance, your Nexus 6P and a Samsung tablet—you've probably noticed how the button placement can be different. Normally, it's back, then home, then the recent apps button, from left to right. But Samsung devices have this backwards, which can lead to frustration when muscle memory kicks in and the back button isn't where you expect it to be.
Much like the Chromecast, Android TV devices such as the Nexus Player and Nvidia Shield TV have always had those beautiful background images as their default screensaver. However, unlike the Chromecast, these "Backdrop" images, as they're called, weren't always customizable on Android TV.
Starting a few months back, you might have noticed that some text messages you received from certain friends or family members had blank or missing characters. This was because Apple included all of the new Unicode 8.0 emojis in an update to their iPhones, but Android devices didn't have some of these just yet, so they weren't capable of displaying them.
The Galaxy S6 already has one of the best cameras on the market, but a few minor annoyances still linger. Full-sized photos are stored with heavy compression that can cause artifacting, burst mode shots aren't taken at 100% quality, and the camera flash cannot be used when your battery is below a certain threshold.
Sony has a gorgeous line of smartphones using the moniker "Xperia," and the latest and greatest model is the Z3. The firmware for the Xperia Z3 was just updated to Android Lollipop, and many system apps of course got tweaked and refreshed with this latest version.
Android 5.0 brought a lot of changes to the world's most popular mobile OS, but few were more central to the user experience than tweaks made to the "Overview" menu (more commonly known as the "Recent Apps" menu). Aside from a visual overhaul, Chrome tabs now exist as separate entries in this list, as do Google searches and a few other activities.
Finding the right mix of custom ROM, kernel, and tweaks for my OnePlus One has left me flashing every new release I come across. This has led to many hours going through thread after thread trying to find the latest and best software out there for my phone. While I do enjoy the hunt, I would rather have a centralized location that covers all my bases, so that's why I have started using OnePlus One, an app by Alex Inthiaano.
Android "Lollipop" introduced a ton of cool new functionality. Unfortunately, the Nexus 5 didn't get all of these features, as some were exclusive to other devices. For example, the Ambient Display function on the Nexus 6 that shows new notifications as they come in with a black-and-white lock screen. Sure, the new Nexus phablet has an AMOLED display that doesn't waste any battery to power black pixels, but it would be nice to have this feature as an option on the Nexus 5, wouldn't it?