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 and Mr. Excel, the 20th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to summarize survey data with a pivot table (grouping & report filter), COUNTIFS function (4 criteria), SUMPRODUCTS formula, SUMPRODUCTS & TEXT functions and DCOUNT database function.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 15th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with tables in Excel 2007. Specifically, you'll see the following:
In this video Lori Winders shows us how to make ghee from regular butter. Her method takes about two hours to complete but she says that this way you can obtain much more ghee at one time. First, put two pounds of butter in a large cast iron skillet and then put it in the oven at a temperature of 250 degrees for two hours. After this is complete you take the pan out of the oven and with the help of a strainer and lots of layers of cheesecloth you filter the obtained gee in a jar. You will see...
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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter tool with criteria to extract a unique list of employees for each department from a huge data set with transactional records.
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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.
Danny with Top Ten Reviews will show you how to monitor social network activity with the Net Natty program. This will be helpful for monitoring social networking accounts on websites such as Facebook and MySpace. First, open Net Nanny. Go to the dashboard and select Additional Settings under Filtering. With this section, social networking sites that have been used on the computer will be listed. You can check whichever account you want to monitor. Under the dashboard, go to Reports and select...
This video provides tips to make great photo slideshows. Many people have found photo slideshows are a great way of celebrating memorable occasions, commemorate milestones or reminisce. First, choose your photo images carefully. Filter out irrelevant or blurry photos. Try using a photo editing program to improve your photos. Next, choose a theme for your slideshow. Then select transitions, being cautious to limit your use of transitions. Consider your use of intervals in the slideshow. Also, ...
This video shows how to use a French press coffee maker. We need 8 0'clock coffee regular or course grind, teaspoon measure long handled spoon, Pyrex measuring cup, the French press coffee maker and a cup to drink from. Heat to boiling just enough filtered water to fill the French Press beaker. Measure out one level teaspoon of coffee for each 6 ounce cup of coffee you are preparing. When the water has ceased bubbling add it to the French press beaker and stir with the long handled spoon. Wai...
John White and Rosemary Maddox address garden problems concerning heat and sun damage on their plants. Rosemary grows tomatoes that grow healthily, but are dry and cracked at the top. John identifies the problem as an excessive exposure to heat and sunlight, and recommends putting a netting over the plants to filter and moderate the sunlight. Rosemary also has a similar problem with her roses. The leaves on her rose plants become yellow and brown and eventually die off. John calls it "heat sc...
Let FiveSprockets help you get rid of the green screen effect in your videos and add great backgrounds to your movies at home! By using the Final Cut Pro program, follow along as you set your green screen clip in the display. From there you select the Effects, then Video Filter and follow it down into the Key menu. Grab the eyedropper and select the green color and make it fade away with just a few simple clicks. You can crop out any areas that didn't fade away, or use the softening tool to f...
If the bass sounds in a song need to be amplified, learn how to beef up the bass using Reason 4.0 with this video tutorial. Nick from PrimeLoops shows how this process can be done first by creating a copy of the bass patch that can be altered with a filter and reverb. This new sound can then be mixed back into the original bass sound. Nick shows step by step what to do in Reason 4.0 to create the desired effect.
This video shows you how to create a glowing object in Adobe Flash CS3 Professional software. This is a tutorial video for beginner level viewers. Making objects glow is one of the many effects that can be applied in Flash. In this video the narrator draws a shape, converts the shape into a movie and adds a glow filter to the object. Watch this video and learn the correct parameters to be supplied to the program to get the desired glow effect.
The Smart Pond system can be used to create a water feature in a backyard. Ponds can be made above the ground or in the ground using a preformed pond. Various types of ponds are shown, which would be appropriate for various locations. The location of a pond is discussed; it shouldn't be under trees to avoid debris and too much shade. Draw out the plan for your pond and dig one or two feet deeper than the depth of the pond. Determine the size of the liner, place it in the hole and anchor it wi...
This video tutorial explains how to use Adobe Photoshop in order to create a unique metallic black and white effect. This simple technique (accessible to both newbies and experts) allows one to easily make photographs appear metallic. This technique requires minimal prior knowledge, walking viewers through the steps, from the application of filters (such as high pass) to the introduction of a black & white gradient. Finally, a subtle sepia tone completes the effect. This technique is useful f...
This video shows you in 6 simple steps how to make a perfect cup of coffee. You should buy whole coffee beans that you keep in an airtight container. You will need a coffee grinder. You can find them in kitchen stores. You should run the water you use through a filter before making your coffee. You want to use 2 tablespoons of coffee grinds per cup. 1/4 of a teaspoon of salt will take out any bitterness. 6 oz of water per cup is what you should use. You can now make your coffee.
Don't know how to create the night vision effect using Photoshop? Well, this video is the solution for you. First of all, select the image that you want to create the effect on. Then you need to open up a new black and white adjustment layer. In the setting box that pops up, go under the preset drop down box and select red filter. Next, go down and check the tint box. After wards, the viewers can set their own photo and saturation base on their own preference.
It is a tutorial that how to make an ice text effect on Photoshop. First create a new layer select paint bucket tool switch black color and paint the layer now create an other layer, choose type tool then switch the white color and create a text "ice text" after go to layer pallet merge the layers after that again create another layer select paint bucket tool and select black color now select ice text layer then go to image menu rotate canvas click clock wise then go to filter choose crystall...
This is Cartoonsmart's introductory lesson on how to draw using vector illustration Flash CS4, CS3 or Flash 8.
Photoshop Mama shows us another way to render a watercolor from a photo using filters in Photoshop in this video series. This method produces subtle pencil sketch lines in addition to the luminous watercolor effect. This is a detailed tutorial that is going to take some time but you will learn a lot in the process!
This new episode of Full Disclosure shows you how to use a SSH Tunnel to secure your data when you are on an untrusted LAN (ex. Coffee Shop, School's network, or Defcon). Furthermore, you can use the SSH Tunnel to bypass the LAN's internet filters. The SSH tunnel protocol works by encapsulates your data into an encrypted payload and transmitting it to the SSH Server which is setup on a trusted LAN.
The universal solvent is back. It looms, floating in a condensed visible mass, then bursts from its vaporous state, streaking to the earth at teminal velocity. Those blurred droplets called rain are a pretty simple thing to create, it's just a couple of filters and you've got it. Bert takes it a few of steps further to create a whole stormy scene with rain, lightning and an ominous sky. Oh, and there's a pirate ship in there too.
When you expect to take photos of landmarks, buildings, landscapes, and other outdoor scenery with clear blue skies in the background, you may end up with nothing but overcast weather, resulting in a completely different mood in your pictures. Instead of forgetting about all your images with dreary gray skies, try turning those grays to blues for happier, more shareable photos.
Night Shift, Dark Mode, Reduce White Point, and Zoom's Low Light Filter all help reduce the harmful effects on your body's clock that bright iPhone and iPad screens have at night. But there's another option on iOS and iPadOS that turns your entire display red, and it's useful for so much more than just late-night browsing in bed.
Since the start of the COVID-19 pandemic, Google has packed new functionality into Google Meet to compete with Zoom, Microsoft Teams, and other video conferencing platforms.
Newer businesses, or older businesses looking for more traffic and sales, often offer enticing deals to attract customers. On Yelp, any business has the option to provide a deal to users, which is essentially a Groupon-like coupon. But how do you find these deals in the Yelp app for Android or iOS?
In iOS 12, Apple included new, Snapchat-like effects and stickers for photos and videos in Messages. While these new options are fun, they're missing something that takes away from the appeal, especially since Snapchat, Instagram, Facebook, and similar apps already let you do it.
HBO is only a couple of episodes into the second season of Westworld, the television version of the classic science fiction movie about a robot resort gone awry, and the fan theories about the show are already reaching Season 1 levels of weirdness.
While you were slaving away at work or school or whatever you were so busy doing over the last seven days, people have been hard at work creating a variety of new Snapchat lenses for your enjoyment. These lenses are hot off the presses, and I'm honestly really impressed with this week's crop.
On average, an office worker receives 121 emails a day. Many of these emails are trivial and don't require immediate attention. While Gmail's automatic spam filters catch plenty of irrelevant emails, some still make their way into your inbox. Fortunately, Gmail's tools aren't limited to just spam filters.
Cuphead may have taken the indie gaming scene by storm, but its "introduction" to the iOS App Store is what everyone in the smartphone world is talking about. There is no official Cuphead game available for iPhone, and that's what is so surprising — a fake version was approved and released for iOS devices, and at this scale, incidents like this just don't happen for Apple.
Augmented reality is making many of our childhood dreams from Star Wars come true. A week after Lenovo gave us the ability to actually play Holochess, Apple has now made it possible to take live video of ourselves and layer on a (non-3D) hologram-like effect, closely resembling the famous Star Wars hologram scene featuring Princess Leia decades ago.
Face ID is one of the big selling points of the iPhone X, and the reception has been fairly positive so far. It's pretty impressive to watch the iPhone X magically unlock just by looking at it, but it's even more impressive to see how Face ID works its magic.
Lenovo has been no stranger augmented reality, both in products for consumers and services for developers.
Download a popular, legit app from the Google Play Store. Decompile it. Add malicious code. Repackage the app. Distribute the now trojan-ized app through third-party Android app sites. This is how advertising malware Ewind, what Palo Alto Networks calls "adware in applications' clothing," infects Android users.
The newest version of Snapseed features three awesome new tools for you photo-editing enthusiasts. The 2.17 update for the editing app was rolled out on Tuesday, March 21, and its new additions are something to behold.
When alcohol tastes bad, there's little you can do to save it—or so you think. While it might seem easier to toss your entire bottle of old, opened wine, or to give up and drink crappy vodka anyway, there are creative ways to turn a spoiled or just plain bad boozy beverage into one you actually want to drink.
Researchers have discovered a "severe vulnerability" that allows attackers to use eBay to distribute malware, and the online auction company has no plans to fix the problem.
Smelly foods are what make my culinary world "go 'round," so to speak. I grew up with fish sauce, learned to cook with and love fermented beans and veggies, and am one of the biggest garlic advocates I know... other than my husband, who thankfully shares the same smelly food sensibilities. (Let's put it this way: anyone that can stomach stinky tofu can handle anything I could possibly cook up.)
Fresh loaves of bread from the bakery are both delicious and often free of the preservatives that come with buying sliced, bagged bread off the supermarket shelves. However, these same loaves of bread tend to become stale much more quickly when sliced. It's quite the dilemma, especially for those who want to avoid throwing away and wasting stale bread (or are tired of turning said stale pieces into breadcrumbs or croutons).
Although I am a loyal premium Spotify subscriber, I still regularly use Pandora in hopes of stumbling across new artists and songs. If I'm fortunate enough to come across something I enjoy, it's easy to use the Like feature in Pandora to locate the song later.