Enter Searches Search Results

How To: Make Cream Cheese Brownies

On the Fourth of July, we like to celebrate by consuming lots of rich, savory (and unfortunately, belly engorging) food, including barbecued meats, hot dogs, and chips. So when it comes time for dessert, you're usually craving something less flavor-popping and spicy.

How To: Extract records with 1 criterion via Excel's AGGREGATE

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 670th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with one criterion. This is a lookup problem where you want to return multiple records from one lookup value. This formula is not an array formula because it...

How To: Extract records with 2 criteria with Excel's AGGREGATE

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 671st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with two criteria. This is a lookup problem where you want to return multiple records from two lookup values. This formula is not an array formula because it...

How To: Use the left-hand column options in Gmail

In this tutorial, we learn how to use the left handed column options in Gmail. First, log into your Gmail account, then click on your different emails. Open an e-mail by clicking on it, then click reply to respond to it. You can also save this, and it will save to your account. If you want to delete a message, simply select it and click on the delete button. It will now be moved to your trash, where you can keep it, or you can delete that, which will remove it forever. If you want to write an...

How To: Crochet an extra puffy puff stitch

In this tutorial, we learn how to crochet an extra puffy puff stitch. First, insert the hook and pull it through. Pull all the loops up even so the hook is horizontal, then wrap the yarn over and enter the hook through the top of the stitch. Pull the loop up and then wrap the yarn over, pull it through, then pull the loop up so the hook is horizontal with your work. Continue to repeat this process until you get to the end of the row. Place chains on the top to secure them, then you will have ...

How To: Teach your dog how to sit on your command

A dog who constantly follows you around the house wagging his tail is a dog who really likes you (or is hungry), but sometimes you're tired and just want your dog to sit and be still for once. Teaching a dog to sit is one of the most basic obedience training tricks out there, and one of the most important (especially in cases of your dog bounding onto friends who enter the house).

How To: Dip pretzels and mango slices in chocolate

Nutritionists recommend the "five a day" rule when it comes to eating right; specifically, getting five servings a day of fruits and vegetables. And while we'd never complain about crunching down on more succulent fruits like mangos and bananas, less palatable foods like celery could use a little extra kick in the flavor department.

How To: Extract the word that occurs most frequently 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, the 592nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract word that occurs most frequently from a column of survey results that contain customer preferences for a product using the INDEX, MATCH, MAX and COUNTIF functions. This is a way to get the MODE for data that is made up ...

How To: Setup a bluetooth mobile phone in OS X

In this video you will learn how to setup a Bluetooth mobile phone in OS X. To do this go at system preferences select Bluetooth click on Discoverable, Open Bluetooth Setup Assistance and Show Bluetooth Status in the menu. Then click Sharing and mark all the options. Now go at devices, select set up new device, mark mobile phone, click continue, wait until the device will find your mobile device, click continue and you will get a pass key. Enter that passkey. A window will pop-up where you ca...

How To: Build a tomato cage

A piece of concrete reinforcement wire is cut and separated by a bow cutter at about 4 feet. The wires on one side of the separated section is bent in the form of a hook to hold the next side. As it would be hooked together to hold a tomato tree in position. It was suggested that rope cover material or material with small holes that can absorb sunlight be placed around the cage and held together with a clothes pin. Doing so would prevent bug plant, frost bite, curly top viruses , squash plant...

How To: Start Windows in safe mode for troubleshooting

In this video tutorial, viewers learn how to start a Microsoft Windows computer in safe mode. Begin by turning on your computer. As your computer starts up, press F8 before Windows launches. Tap the F8 key slowly (about 1 second apart) as soon as the computer starts up. Keep tapping until the Windows Advanced Options Menu appears. The use the arrow keys to select the appropriate safe mode option and press ENTER. You may need to log into your User account. This video will benefit viewers who u...

How To: Use letters to dial on your BlackBerry

This helpful video explains how to use letters when dialing on a Blackberry. Many companies have words in their phone numbers so Darci Larocque shows us how to dial those letters. All you have to do is go to the call log, and hold the key in, and type in whatever word you are trying to dial. She also shows us another tip: if you are calling an office and you need to enter in someone's last name, you can do that the same way. Blackberry users should definitely view this video.

How To: Use the navigation system in a 2010 Prius

Learn how to use the navigation system in a new 2010 Toyota Prius in simple steps. It has DVD based navigation system with easy to use touch screen display. All the navigation routes of USA, Hawaii and parts of Canada are available in it supporting English, French and Spanish languages. When you start the car it opens the map and you can input the destination using voice command or entering text. You can also input your home address and five other special location address.

How To: Use the sparkline function in Microsoft Excel 2010

There is a new function in MS Excel 2010 called ‘Sparkline’ which helps you quickly find trends associated with a set of data. To create Sparkline, you can go to ‘Insert’ tab and then select ‘Sparkline’ section and then select the graph type. After you enter the data range and location range, the Sparkline will show up indicating the trend based on the data range you identified earlier. You can change the types and styles of your Sparkline easily. As the video demonstrates, whenever you use E...

How To: Use impasse on the chess-like game Shogi

Do you like chess? How about Japanese chess? Aren't there different chess variants in Japan though? Maybe, but this specific chess variant is called Shogi. The chess-like game Shogi is won by capturing the king, just like chess, but defeat is conceded at mate, or when mate becomes unavoidable.

How To: Work with multiple calendars in MobileMe Calendar

If you work with MobileMe Calendar, you can create individual calendars to help you keep track of what's going on in your life. Let's say you've just started a new book club and you want to create a new calendar for it: just click on the plus sign in the lower-left corner, then click "New Calendar"; next, give it a new title such as "Book Club." Now, with your new calendar selected, when you enter the kickoff meeting for Sunday afternoon, that event will be added to the book club calendar. To...

How To: Do 4 types of dumbbell punches

Get the shoulders of a boxer without ever entering the ring. This exercise builds your shoulders with a series of classic boxing moves, with weights in each hand to up the ante. Learn how to do dumbbell punches (the four types are: side-to-side, cross up, cross down, and hooks). Presented by Real Jock Gay Fitness Health & Life.

How To: Unlock Safari's Secret Dual-Search Engine Experience to Optimize Your Web Browsing

If you prefer to use Google or another search engine for everyday browsing in Safari but would also like a more secure browsing experience for all your secret searches, there's a simple way to switch between them quickly while also adding additional layers of security on top of your already clandestine browsing.

How To: Change the Owner of a Telegram Group Chat to Pass the Torch to a Different Member

Group chats are fun, effective ways of staying in touch with the many people in our lives. Whether it's the local friend chat or the group from work, we rely on these groups to keep connected. Running one of these group chats, however, can be a monster task. If you're feeling overwhelmed with administrative responsibilities, why not pass on that burden to another member of the Telegram group?

How To: Mine Twitter for Targeted Information with Twint

Open-source intelligence researchers and hackers alike love social media for reconnaissance. Websites like Twitter offer vast, searchable databases updated in real time by millions of users, but it can be incredibly time-consuming to sift through manually. Thankfully, tools like Twint can crawl through years of Twitter data to dig up any information with a single terminal command.

How To: Safely Browse the Web with Opera's Free VPN

Browsing the web can be dangerous. With all of the various threats out there, it isn't enough to just avoid bad links and visit only HTTPS websites. You need to take advantage of the tools available to you so you don't end up the victim of some scam. Fortunately, Opera is making this a bit easier.

How To: Find Songs by Lyrics in Apple Music for iOS 12 — With or Without a Subscription

Has this ever happened to you: You're singing a song in your head and want to look it up on Apple Music but you just can't think of its name or even who recorded it? In iOS 12, if you can sing it, you can search for it, as the update lets you find songs in Apple Music by lyrics alone. It's like Shazam, only instead of identifying music by sound, it uses the lyrics in your head.

The Hacks of Mr. Robot: How to Use the Shodan API with Python to Automate Scans for Vulnerable Devices

Shodan calls itself "the search engine for internet-connected devices." With so many devices connected to the internet featuring varying levels of security, the special capabilities of this search engine mean it can provide a list of devices to test and attack. In this tutorial, we'll use Python to target specific software vulnerabilities and extract vulnerable target IP addresses from Shodan.