How To: Use the Mid and Find functions in Excel
Learn how to use text functions like mid and find to extract characters from a larger text string within a cell in Excel.
Main Characters Search Results
How To: Get a sex change on Elder Scrolls IV: Oblivion
Try some gender bending in Elder Scrolls IV (4): Oblivion and flip the sex of your character. To do so, enter the code ~sexchange.
How To: Create Stewie Griffin's head in Photoshop
This is a more advanced tutorial which shows you how to create an existing cartoon character in Photoshop. In particular, Stewie Griffin from Family Guy and his head!
How To: Play as Dedede and Lucario on Super Smash Bros Brawl
In this Super Smash Bros Brawl (SSBB) for the Nintendo Wii video, I showcase how Dedede and Lucario work, including their move properties and what I believe will be key strategies to learn with them in the long run. I came into this video with a plan, written on paper, so I showcase practically everything about these characters!
How To: Program artificial intelligence in Flash
A two-part tutorial series on creating artificially intelligent characters for your Flash-based games.
How To: Create an inventory for a Flash RPG
This tutorial teaches you how to create an inventory in a Flash-based RPG and how to move your character and have it pick up items.
How To: Animate a walking stickman with Flash
A tutorial on character animation in Flash that teaches you how to create a walking stickman or stick figure. You'll also learn how to mulilate him and create blood effects.
How To: Speak and read some basic Mandarin
Learn to say and read some basic Mandarin words/characters. This is one kind of Chinese language, the other being Cantonese.
How To: Colorize line art images using Photoshop
In this video tutorial you will learn to to colorize line art images using Photoshop. Learn to use the magic wand selection tool to make the selection you want. This example involves painting a monkey character.
How To: Use OCR scans in Acrobat 7 Professional
OCR is usually a bad word to most computer users, but in Acrobat it's the next best thing to sliced bread. Adobe Acrobat 7 Professional not only employs Optical Character Recognition for your text, it does Page Recognition to preserve the geometry of your pages. Everything stays in place and your paper documents become searchable, reusable text!
How To: Draw Daffy Duck
Learn how to draw Daffy Duck . This looney toons character can be drawn in just over one minute.
How To: Make Kyle from South Park your Call of Duty: Black Ops playercard emblem
Forget the callsigns and titles from previous Call of Duty video games, Black Ops gives you something new to play with— playercards. Playercards allow you to create virtually any emblem you can possible think of because they're fully customizable, and emblem images can be colored, moved, rotated, flipped, resized and stacked on top of each other, with up to 12 emblem images layered at once. And if you're making Kyle Broflovski from South Park your playercard emblem, you'll need all 12 layers!
How To: Model and animate a crowd of 3D models in 3DS MAX
Do you work with 3D graphics? Have you ever wanted to have one character that you've modeled destroy hordes of tiny other characters you've made? Well want no more. This video series will show you how to model and animate a small army of little models that will walk around and have basic interactions with each other. Really cool and really educational.
How To: Create a simple movie poster in Photoshop
This video tutorial from TutVid shows how to create a simple movie poster text effect in Adobe Photoshop CS4.
News: Google Adds Pac-Man, Hello Kitty & More Japanese Anime & Video Game Characters to AR Search
Gamers, anime fans, and those with an interest in Japanese culture are in for an AR treat courtesy of Google.
How To: There's an Easy Way to Turn Off Camera's Night Mode on Your iPhone 11, 11 Pro, or 11 Pro Max
Night mode on the iPhone 11, 11 Pro, and 11 Pro Max is a godsend if you want clearer photographs in dimly lit environments. But if you want to keep the image dark or full of shadows as an effect of sorts, it's not immediately obvious how to disable Night mode, which turns on automatically when the app thinks you need it. But it can be turned off.
How To: Change Your HBO Max User Profile Image
Many streaming services offer user profiles for different people in your household, some of which also include profile images. In most cases, you can set a custom profile image to better differentiate and personalize your account from the others, and HBO Max lets you do the same, albeit, with limited options.
How To: Double Tap Your Status Bar to Quickly Turn Off the Screen on Any Android — No Root Needed
Several popular custom ROMs and root mods let you double tap the status bar at the top of your screen to put the phone to sleep. It pairs perfectly with the double tap to wake gesture you'll find on pretty much any Android phone. But if you're not rooted, you'll be glad to know you can finally do this by installing a simple app.
How To: Check Real-Time Network Traffic on Google Wifi or Nest Wifi
For the most part, Google Wifi and Nest Wifi systems take care of themselves. But there are still a few manual features that might come in handy, like being able to check on network activity to see which devices are using the most bandwidth when your connection gets bogged down.
How To: Completely Change the Status Bar on Any Android Without Rooting
Despite Android's flexibility in regards to customization, the options available in stock Android are pretty barebones. It is only with the help of third-party apps that we can entirely transform sections of the UI to our liking. And thanks to a new app, we can modify another part of the OS, the status bar.
How To: Migrate Your First-Gen Google Wifi Pucks to the Google Home App
Google is known for merging older products into a new one's ecosystem for ease of use. The transition can take time, and that's the case with the old Google Wifi system now that Nest Wifi is out. Google is working on phasing out the dedicated Google Wifi app in favor of using the Google Home app for all your IoT needs.
How To: Everything You Need to Know About Pinning a Tweet
Pinning a tweet is a great way to get the point across because it's the first post people see when they visit your Twitter profile. When you pin a tweet, reply, or retweet, it sticks to the top of your profile, whether you create new tweets or not. It's the perfect spot to place one of your more popular tweets, a fantastic blog you wrote, or even just a joke that shows your personality.
News: Apple Adds Multiplayer AR Spy Game 'Secret Oops' to Arcade Subscription Service
With No Time to Die, the 25th installment in the James Bond saga, arriving in April and Black Widow, the first solo film for the Marvel Cinematic Universe's own secret agent, following a month later, what better way to get in the espionage mood than some augmented reality spy gaming?
How To: Instantly Share a Photo from Your Pixel's Camera App
The Google Pixel's camera is a status symbol of sorts. When someone sees you with one, you become the photographer of choice for social events. And where do those photos end up? Social media, of course. It's how we share our lives now, and the smartphone camera defines how we approach that.
How To: This Sneaky Trick Lets You Post Empty Tweets & Pin Retweets to Your Profile
On Twitter, you can pin one of your tweets or replies to your profile, so it's the first post people see when they visit your page. However, Twitter prevents you from pinning someone else's tweet. You can't even pin something you retweet. There is a clever workaround, though, and it also works for posting empty tweets.
How To: Remove the 30 FPS Cap for Black Desert Mobile on Android
Black Desert Mobile is one of the hottest new smartphone games around, but there seems to be something missing in the frame rate department. Gamers quickly noticed many Android phones are stuck on a 30 FPS cap when it comes to performance. It's not that the phones are too weak to handle higher frame rates, but that there is a particular list of approved devices that can achieve this.
How To: Check Which Apps Have Access to Your Google Fit Data
There's definitely some malware-ridden apps on the Play Store. When it comes to the third-party apps you've connected to your Google Fit account, some have a crazy amount of permissions they have no business accessing. For example, you probably don't want a heart monitor app having access to your personal location data.
News: iOS 13.3 Brings Back the Like & Dislike Buttons in Apple News Stories
Apple's upcoming iPhone update, iOS 13.3, doesn't add as many new features as iOS 13.1 or 13.2, but there's one under-the-radar change you'll love if you use Apple News on a daily basis.
News: Apple iOS-Powered Sesame Street Yourself App Turns Kids into Their Favorite Characters via ARKit 3's New Features
The longest-running children's television show in the United States, Sesame Street, hasn't survived 50 years without leveraging new technology along the way.
News: Snoop Dogg Becomes Snapchat AR Character for His Latest Record
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.
News: Hollywood Taps into Tech Paranoia Around Augmented Reality in 'Auggie'
Ever since Skynet took over the world in the Terminator film franchise, a large segment of the world's population has feared artificial intelligence.
How To: Can't Find the Accessibility Menu & Its Options in iOS 13? It Got a Huge Update Worth Checking Out
The iPhone's "Accessibility" menu is one of those options that's very easy to overlook but incredibly handy in certain situations. You can set AssistiveTouch to help navigate your device, use a Bluetooth mouse when your screen is acting up, and enable the red screen filter for nighttime escapades. For as long as the menu has been available, it's been in the "General" settings, but not in iOS 13.
News: 8th Wall Spins Up New 'Spider-Man: Into the Spider-Verse' Augmented Reality Experience for Blu-Ray, DVD Release
Hollywood loves sequels so much that studios and their marketing teams are not too proud to release a sequel of an augmented reality promotion.
How To: Get the Google Phone App with Spam Blocking & Business Search on Any Android Phone
The Google Phone app is one of the best dialers for Android today, especially with all of the unique and exciting features it brings to the table. Unfortunately, without owning a Pixel phone, you are unable to officially download the app, making a modified version your only option. However, this version of Google Phone is missing a few key features, such as spam protection and business search.
How To: Enable Dark Mode in Google's Contacts App for Android
With the rise of OLED displays, Android users have been begging Google for a true system-wide dark mode for years. While a system-wide solution is still somewhat unlikely, Google has given in by providing a dark mode for certain apps, including Contacts.
How To: Scan Food & Drink Labels in MyFitnessPal When Cooking at Home for More Accurate Nutrition & Calorie Info
In MyFitnessPal, you can search through a food database to add your meal into the app's diary and track your calories. Unfortunately, the sheer size of the database can make it hard to find exactly what you have just consumed, which is why MFP includes a barcode feature to make the process of adding food much smoother.
How To: Get Google's Digital Wellbeing Feature on Any Android Device
Living in this age of smartphones and always being connected can sometimes have us getting carried away with our devices. Whether it's an addiction to our phone or if we just feel like cutting back on some daily screen time, there's a great tool that can help with that — Google's official Digital Wellbeing app puts you in control by laying out all the stats you need to help curb your daily smartphone habits.
How To: Root Your OnePlus 6T with Magisk
With the recent launch of the OnePlus 6T, the company continues to impress us with some of the best phones when it comes to the rooting and modding. OnePlus has made it easy enough to get up and running with the rooting process as fast as possible. The OnePlus devices follow the same core principles Google uses for their Pixels, which is excellent news for both the user and the development side of things.
How To: YouTube Finally Has a Dark Theme on Android — Here's How to Get It
After months passed since Google first announced the feature, YouTube's dark mode has finally reached the Android masses. Sure, it just changes some colors, but it has been a highly sought-after feature since iPhone users got it months ago.
How To: Use BlackBerry Locker to Keep Your Files & Apps Private
Not all threats to our privacy come from hackers thousands of miles away. Often, we just want to keep our data safe from those around us, who may snoop in our phones or demand we reveal our secrets. That's where BlackBerry Locker comes in.