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 580th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the REPLACE, MID, COLUMNS and SEARCH functions to extract numbers to the right of a decimal into their individual cells.
310tutoring shows viewers how to easily convert Grams to Moles for Chemistry. If you have 120 grams NaOH and we want this in moles we need a periodic table. Now, you need to figure out what the mass is of each individual element in NaOH. You need the mass of Na, O and H. Na mass is 23, O has 16 and H is 1. Add all of these up to get the molar mass of NaOH is 40 g/mol. Now use this to convert 120 g to moles. Now take 120 grams NaOh and multiply this by 1 mol NaOH/ 40 grams NaOH. You can cancel...
This video demonstrates how to do a wet foot test and how to choose running shoes with the results of a wet foot test. The wet foot test is simple. Get your foot wet and place it on a piece of heavy duty paper which will create a foot print. The foot print shows what type of arch you have. There are three types of arches: high, medium and low. High arches require a lot of cushion for running. Medium arches require a reasonable amount of cushion for running. Individuals with low arches or flat...
This Photoshop tutorial on performing a nose job using Photoshop contains detailed instructions on the use of Photoshop tools to, depending on taste, enhance the appearance of an individual. The person narrating the tutorial specifies the necessity of subtlety with the modification of the picture in order to remove any appearance of modification. The way described is essentially to select the general nose area, feather the selection by an optional amount, and set it in a separate layer. Then ...
This video shows how to cook Arroz Caldo the panlasangpinoy way. Arroz Caldo (literally translated as warm rice) is a type of congee (or lugaw) that closely resembles the risotto. Though ,this dish is of Chinese origin, the (new) name was actually given by the Spaniards ,because of pronunciation issues.
Looking for a fun and easy project for the kids that won't leave you with a big mess? This step-by-step video will teach you how to make an origami dog box in as little as five minutes. The video introduces you to an origami expert who walks you through each individual step of creating your own adorable dog box. The finished project can be used as party favors or just a fun little box that will help the kids get organized. Great project for a rainy day!
Have you ever had to close an application with private info in order to let someone else use your PC? LockThis! is a windows application that lets you secure individual programs without the hassle of having to save your progress and closing the program. To use LockThis! just hold the control key and click on the application that needs to be locked and simply enter your password on the dialog that pops up and your done. Now anyone can use your pc without you having to look over their shoulder....
A lot of people know how to make homemade popsicles, but Karen Solomon, author of "Jam It, Pickle It, Cure It," provides us with an ingenious way of making these cool, delicious treats.
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...
This video series is designed specifically for individuals who are interested in learning the basics of how to create dynamic Web applications using ASP.NET 2.0 and Visual Web Developer 2005 Express Edition with the Visual Basic programming language. In this lesson, you will begin to see the creation of the Quiz Engine. This will allow you to exercise the skills developed in the earlier videos.
In this video tutorial, Chris Pels will show how to extend a standard ASP.NET server control and customize it for a specific purpose. Specialized controls provide an convenient way to implement standardized user interface elements for multiple web sites for individuals or teams of developers. In this example, see how to extend the DropDownList control to create a special purpose year selection control. Learn how to add properties for custom attributes that control the behavior of the range of...
In this ASP.Net video tutorial, Chris Pels will show how to use nested master pages to create individual master pages that represent different standard content layouts for a web site. First, see how several major commercial web sites use a standard set of content layouts. Next, see how to nest a master page within another master page, and use the design time support in Visual Studio 2008. Then, learn the considerations for establishing a “page architecture” which represents the major types of...
It's sometimes possible to recognize when you've recently contracted HIV from signs and symptoms such as fever, rash, or swollen lymph nodes. This video will teach you how to recognize signs and symptoms of primary HIV infection that are experienced by between 40 and 90% of individuals after they are first infected with HIV. Primary HIV infection occurs during the first few weeks or months after a person first becomes infected with HIV. Symptoms include rash and/or fevers, possibly in combina...
This video tutorial from easycomputercoach shows how to easily attach pictures to email addresses. In Windows XP you can send pictures resizing them in the process, in case you have large file sizes.
1. Type in WWW.sendthisfile.com in the web toolbar and press enter 2. Click on Register found on the top right side
If you've changed jobs or transferred your old Rolodex onto the computer, you will have a ton of left over business cards. Why not go green and reuse the cards as something unique? Check out this video for tips on what to do with all those tiny squares of paper.
Have you ever walked around in public and heard the same handful of default ringtones over and over again? How do these people know who's calling without looking first? It's tough to tell when they all sound the same, but there is something crafty you can do to help with that. Using a different ringtone for certain contacts will allow you to differentiate between them instantly.
The last few months have delivered some great new Magic Leap releases, but that doesn't mean the development team is resting on its laurels when it comes to the platform itself.
There's actually more to the dialer screen on your OnePlus than meets the eye. Besides its obvious purpose of calling people, there's a vast array of secret codes that you can input to troubleshoot your device, in addition to revealing important information, making anonymous phone calls, and so much more.
Netflix currently lets parents block content based on maturity rating, but it isn't a perfect system. Not all titles rated PG-13 are equal, for instance. That's why it's good news that Netflix is adding more controls for parents, by allowing account holders to bar individual movies and TV shows they deem inappropriate.
Life is all about spending time together with loved ones, experiencing new places together to enjoy and create memorable moments. Luckily, Google has made it easier for us to rendezvous with friends and family at specific places by letting us broadcast our locations using Google Maps.
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.
Yellow fever has emerged again in Brazil, causing death and disease to people unprepared for this mosquito-borne illness.
Jostled in the airport, someone is coughing in line. The air looks empty but it is loaded with microbes that make their way into your body. You get sick. You give it to your family, and that's pretty much it. But what if you were so contagious that you spread it to your entire community and beyond?
Android has separate volume levels for various system sounds like incoming calls, notifications, alarms, and media. This means that when you want to adjust volume levels for just one of these categories, you usually have to press the physical volume rocker, tap a button to expand the volume menu, find the category that you want to adjust, then finally raise or lower the volume.
Pokémon GO, the biggest augmented reality sensation ever, broke app store records this opening weekend. But it also did something even more important: it gamified physical activity.
With iOS 9.3.5, as well as all of the versions prior to that, you had two choices when it came to "Read Receipts" for iMessage — either on for everybody or off for everybody. So if you weren't comfortable with one or two of your contacts knowing whether or not you've read their messages, you had to keep the feature disabled and miss out on Read Receipts for people you're a bit closer to.
Soon all Android users will be able to use Samsung's cool Soundcamp app to write and record music. The announcement was made at the Samsung Developer Conference 2016, stating that the app, which was released last year for Samsung devices only, will become available to all phones and tablets running Android 5.0 or higher very soon.
Last week, the U.S. Justice Department issued criminal indictments against seven Iranian hackers. These hackers, working for private companies in Iran, are accused of orchestrating DDoS attacks against U.S. financial institutions from 2011-2013 as well as intruding into the control panel of a small dam in Rye, New York. It is thought that these attacks were a response to the U.S. tightening financial restrictions on Iran during those years and the NSA-based Stuxnet attack on their uranium enr...
I mentioned in 2015 I wanted to start a 'DoXing' series, and since I havent seen this on Null Byte, I am now going to introduce this to the community.
It's easy to grab a box of pre-prepared microwave popcorn at the grocery store. Yet with so much salt, butter, and other unpronounceable ingredients, microwave popcorn can go from a healthy snack to a complicated one.
Being the bearer of bad news is unpleasant; there's nothing more uncomfortable than offering up a spoonful of negativity. Whether you're a supervisor who spends a lot of time interviewing and rejecting candidates, or simply someone who has to say "no" to a friend, it's never fun to break bad news. But sharing unpleasant words or feedback with another person can become less of a burden with a few simple steps.
Whether you're a celebrity or someone with something to hide, Facebook allows you to keep your "friends list" private so you can protect the identities of your Facebook friends. But it only kind of protects them.
Cloud storage looks pretty good compared to the heavy restrictions that hard drives and other types of external memory carry. The cloud is not only limitless in what it can hold, but it can also easily be accessed from any device that has Internet—your smartphone, work computer, personal laptop, tablet, and more. While accessing a specific cloud storage system like Dropbox or Google Drive may be easy on your Samsung Galaxy Note 2, managing all of them individually can not only get confusing, ...
Humans clearly demonstrate altruistic tendencies towards other members of groups with which they identify.
In this tutorial, we learn how to make caramel candies. Ingredients include: 1 cup granulated sugar, 1/4 c light corn syrup, 4 tbsp salted butter, 1 c heavy cream, and 1 tsp vanilla. To create this, you will combine all your ingredients in a large pot, stirring a little bit. Once the mixture has turned into caramel, stick a thermometer to make sure it's reached 250 degrees. When it is finished, pour this into a baking dish. Once you do this, smooth it out to cover the surface, then wait for i...
In this video, we learn how to clear Firefox location bar and browsing history. To get rid of an individual one, use your keyboard to go to the one you don't want. Then, press shift+delete and that one will be deleted. To remove them all, go to tools then click on "clear private data". Check the box of the browsing history, then click on the button to clear all the data. If you still have items in the list on your browser, then that means you have those websites bookmarked. To remove those, y...
The drum beat pattern for jazz drumming is sometimes called 'spang a lang' or 'ride cymbal pattern.' This is a very common, groovy drum pattern. In this video, the pattern is broken down into individual beats using both the ride cymbal and hi hat drums.
Think there's only one way to apply makeup? While it's true that the same general rules apply to shaping your brows and applying foundation, certain makeup tasks like putting on eyeshadow and blush vary in method depending on individual traits like the shape of your face and your eye color.
In this tutorial, we learn how to create a Gwen Stefani inspired pin-up hairstyle. Start off by brushing your hair out, then use a curling iron to curl individual section of hair, then when you are done with each section, pin it up in a cylinder like shape. Continue to do this throughout your entire head of hair. When you are done, take your hair out of the pins and gently brush through it. Make sure to brush easy to avoid making your hair too frizzy. After this, use hair gel and comb through...