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 ...
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and work with pivot tables (PivotTables) in Microsoft Office Excel. Specifically, this video covers the following topics and examples:
As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 2nd installment in his "Beauty of Excel" series of free video lessons, you'll learn how to set up the input/assumption area for formulas so that subsequent formulas, functions and charts update beautifully. Learn how to build Excel spread...
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 589th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula for a stem and leaf chart for decimal numbers using the IF, COLUMNS, SUMPRODUCT, INDEX, INT, RIGHT, SMALL, ROW and TEXT functions.
Is the battery life on your Ipod diminishing? Watch this video as the folks at Repairs Universe show you how to replace the battery on your 1st generation Ipod. First you need some tools to pry open your Ipod. Flathead screwdrivers and razors work well. Take the razor and slowly inch your way around the opening to pry it open. Then take off the back cover. The battery is black and has a serial number and the Apple symbol on it. Don't confuse this with your hard drive. Watch the video for the ...
In order to make A Building Block Birthday Cake, you will need the following: a 13 x 9” cake, marshmallows, scissors (pre-treated with nonstick cooking spray), and bright colored frosting.
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.
In this video, Extension Horticulturalist Curtis Smith talks with Master Gardener Marsha groves about controlling harmful pests that are damaging to plants throughout the year in both outdoor garden and greenhouse environments. The first part of the video covers the issue of plant eating snails, and how they might best be dealt with. Smith explains that there are a number of non-toxic methods which one can use to rid a plant of snails. The process of introducing predatory creatures such as tu...
In Chemistry weight of some elements are measure in the form of Average Atomic Mass. Isotopes are found in different abundances in nature. Certain elements have many isotopes and certain elements have few isotopes. Regardless of the number of the natural isotopes, the weighted average mass takes into consideration not only the mass of each isotope, but what also its natural abundance in terms of percent as found in the nature. So when you have the mass of two isotopes of an element and are gi...
New to 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 Excel tutorial from ExcelIsFun, the 274th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate various probabilities for a binomial distribution when there are additional complicating factors. This is accomplished with recourse to Excel's BINOMDIST, NORMSDIST, SUMIF, SUM, INDEX and MATCH functions. See also how to create th...
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 243rd installment in their series of digital spreadsheet magic tricks, you'll learn how to find typical values, or averages – a single value that allows you to talk about all the data points in a given spreadsheet. Specifically, you'll learn how to find the mean, median, mode and standard deviation for a set of numbers.
The man was requested to solve a short, basic chemistry exercise. He starts by explaining the meaning of the terms involved in the problem: molecular mass, empirical formula and molecular formula. He also explains the way the are connected, for a better understanding of the way the exercise is solved.
Olivia and Andrea created a song to the tune of "I'll stand by you" by the Pretenders to teach you how to balance chemical equations. A chemical equation requires coefficients in order to be balanced. You can balance a chemical equation by making use of the Periodic table. The example reaction in the song is that of aluminum and oxygen to produce aluminum oxide (Al + 02 -> Al203). You can systematically add coefficients to the reactants and products to balance the equation. A chemical equatio...
In this video tutorial, viewers learn how to hack the flash game, Palisade Guardian 2: Modern Combat with Cheat Engine. Begin the game by entering your name and play the first level. After that, open up Cheat Engine and select your internet in the process list. Change the Value Type to Double and Truncated to Rounded (default). Enter in the value of your cash and press First Scan. Then buy something to lower your cash and enter in your new value. There should be only 1 address. Check the froz...
Learn how to use a 'do while loop' in your Java programming. 1. Set up an 'int' variable named 'counter' and assign it a '0' value. 2. Set up a standard 'do' loop. Make sure to add a counter, so the loop will end 3. Then write the 'while' condition. Make sure that you set the condition to the same variable name that you used in the counter from step 2. Set the variable to '=' 10 (or any number desired)
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.
Photoshopuniverse shows you how to simulate a watercolor painting on Photoshop. With this you can take any photo and make it look like it was a water color painting. Take any photo and then duplicate the layer 3 times including original. Focus on the first layer go to cut out. You want a high edge fidelity, and add the number of levels no more than 5. Add some simplicity and the change mode too luminosity. Go to the second copy layer do a dry brush increase size to maximum. add just a little ...
This video shows how to fold an origami paper game using ordinary paper. The instructor recommends you use double sides and colored paper. The first step instructed is to make four congruent folds. You then bring all four corners to the middle of the paper. The instructor tells you to fold the bottom sheet outwards to make the origami paper game design. The last step is to draw numbers and fortunes on all the different label sides. The instructor has many other video listed text instructions.
There are a number of ways to deal with screw holes that are visible. You can buy some wood buttons and put them in the holes. You put a little wood glue in the hole and then tap the wood buttons into the holes using a hammer. This is a decorative solution to cover up screw holes. If you want to completely cover up the holes completely put a plug cutter on your drill and cut a plug out of a piece of wood that matches the wood that the hole is in. Take the plug put a little glue on it and tap ...
Grand Illusions is a site for the enquiring mind. This how to video demonstrates how to make Japanese origami tumblers. Your wonderful & charming host represents Grand Illusions, an amazing toy, magic & illusion web shop and gallery.
Want to see whether your PC is being accessed by hackers? Netstat (network statistics) is a command-line tool that displays network connections (both incoming and outgoing), routing tables, and a number of network interface statistics. It is available on Unix, Unix-like, and Windows NT-based operating systems. This video tutorial presents a basic introduction to working with the netstat tool. Determine whether you've been hacked with this how-to.
The good old Zip Drive introduced by Iomega in late 1994 served its purpose as a medium-capacity removable disk storage system until obsolescence kicked in as it was replaced by flash drives as well as rewritable CDs and DVDs. This video presents a number of fun, DIY art projects that you can do with your old Iomega Zip Drive. Specifically, this how-to looks at how you can take your old Zip Drive and make of it a USB driver enclosure. For more, or to get started on your own Zip Drive project,...
Ever wonder how to estimate the length of tail when knitting? Watch this knitting demonstration video and soon you will be a pro at estimating the length of tail.
This software tutorial takes a look at how to design an icon set in both Photoshop and Illustrator. An icon set is a set of icons that you can integrate into a number of different projects, like a website or a company letterhead, logo and identity set up. Having an icon set readily available for all your project needs will make your workflow faster and simpler. So watch and see how to make an icon set first in Photoshop and then in Illustrator.
Contact groups in MobileMe Contacts are a great way to help you easily find the people you want. Sometimes you just want to scroll through all of your contacts, looking for someone or someplace. Sometimes you just want to see your favorites. This video tutorial from Apple will show you how to do it, all from the Internet on your MobileMe account. You can even see your phone numbers from your iPhone or iPod Touch.
Check this PopSci 5-Minute Project out to see how you can make your very own gadget charging station.
In this how-to video, photoshop wizard, Brandon Jackson, explains how to create an animated gif from your images and from video. More specifically, he explains how to limit the number of times/cycles your gif animates, how to specify the duration of each specific frame in your animation, and how to automatically add in between images - tweening. Animated gifs are a great way to express information in place of just a single image and even works on older computers and web browsers (unlike Flash...
How to easily fix the missing tags in your MP3 collection using free software called Fixtunes. The tags on an MP3 file identify things like the Song Title, Recording Artist, Album Name, Genre, Track Number, etc. When you buy songs from places like the iTunes Music Store or MP3.com these tags are complete. Some of the songs in your iTunes library may have incomplete tags. This is how you fix them.
Malevolent hackers can divert your incoming calls and texts to any number they want, and they don't need to be a criminal mastermind to do it. Even friends and family members can reroute your incoming calls and messages so that they know exactly who's trying to reach you, and all it takes is seconds of access to your iPhone or wireless account. These secret codes can help uncover them.
For Android smartphones, the latest craze is high refresh rate displays, and many popular flagships have them. But until now, there has been no way to confirm it is, in fact, running at higher hertz besides a menu option. Android 11 changes this.
As long as you're on the internet, you can be hacked. With an estimated 2.65 billion social media users, these apps are prime targets for hackers.
When Google introduced the Call Screen feature with the Pixel 3, I had never been more excited to get a Pixel device. This AI feature provided real protection against rising spam and robocalls, which billions of people deal with each year. After a recent update to the feature, you can reduce robocalls and other spam calls to nearly zero.
Your Pixel has a few hidden features you probably don't know about, like the ability to clean up your funky contacts list. Since I'm sure you haven't manually organized your contacts since the inception of Android, there are likely some incomplete and duplicate contacts. Thankfully, your phone can fix this automatically.
Adobe is best known for its photo and video editing software, but they also have a number of lesser-known apps that you may be interested in. Adobe Fill & Sign, available on iPhone and Android, is the best way to electronically fill out important documents on your smartphone with a third-party app.
Two-factor authentication (also known as 2FA) adds a necessary additional layer of security to your username and password in many important apps. On Instagram, 2FA requires you to confirm it's you attempting to log in, with a special code sent to you via text message. Enter the code and you're in ... but what happens when you need to log in and don't have access to your phone?
While iOS 12 is arguably the best iteration of Apple's mobile operating system yet, one major fault so far is security. On Sept. 26, Videosdebarraquito discovered a passcode bypass that gave access to contacts and photos from the lock screen. Apple has since patched that security flaw, but Videosdebarraquito has discovered a new one that affects all iPhones running iOS 12.1 and 12.1.1 beta.
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.
Front and center for iOS 12 this year is Group FaceTime, which allows users to chat with up to 31 additional people at once. While that ambitious feature is sadly delayed, don't cast away FaceTime just yet — you can always pick up your iPhone and start a call with any single contact directly from the Messages app.
Now that the Magic Leap One is officially out in the wild, users are already beginning to find out exactly how it works and what it might be useful for in the augmented reality space. But there are still other, more unique questions that remain unanswered.
Last week, we told you about Microsoft's Alex Kipman and his nomination for the annual European Inventor Award, presented by the European Patent Office (EPO). And while that's big news in and of itself, it turns out we overlooked a very important detail buried in the EPO's video presentation. What was it? Only one of the most sought-after data points related to the HoloLens since its launch: how many have been sold.
