Learning Depending Search Results

How To: Use AGGREGATE instead of SUBTOTAL in MS Excel 2010

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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...

How To: Tape the butt end of a hockey stick

In this how to video, you will learn how to tape up a hockey stick. You will need hockey tape and a hockey stick to do this. First, take the tape and wrap it around the tip about two times to make sure it is on nice and tightly. Stretch the tape length to about chest length and then spin it. This will create a cord for more grip. Now, wrap it around the stick about for times with a spacing that matches your fingers. Create a nice spiral while doing this. After this is done, wrap it back up. T...

How To: Orient a map and use a compass as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How To: Hike five miles with a map and compass as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How To: Safely use a knife, saw and ax as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How To: Use tools to fuel a cooking fire as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How To: Recognize when to use a cooking fire as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How To: Light a fire and a lightweight stove as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How To: Cook a meal over an open fire as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How To: Participate in a flag ceremony as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How To: Identify animals in your community as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How To: Perform various first aid methods as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How To: Prepare a personal first aid kit as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How To: Identify and treat a 'hurry case' as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How To: Rescue someone in the water as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How To: Swim safely as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How To: Use the three R's of personal safety as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How To: Perform a stingray shuffle when surfing

Surfing: Hang Ten The ocean is a force of nature that refuses any effort to tame it. To throw one's self on the mercy of this beast is a courageous act. With the help of this trick guide, you can learn to harness that power and push your water-borne adventures to new heights. See how to perform a stingray shuffle when surfing.

How To: Solve a Rubik's Cube with famous speedcuber Tyson Mao

Tyson Mao is a renowned world competitor in solving the Rubik's Cube. Not only did this Californian become a world class solver, but he also formed the Rubik's Cube Association with fellow speed solver Ron van Bruchem, which holds competitive events for the Rubik's Cube. If you want to learn how to solve the colorful and mighty puzzle, then who better than to learn from then Tyson Mao?

How To: Apply a desert resistant finish door

Outdoor finishes can be one of the trickiest types of wood finishes to master. Why? Because there is never a one size fits all solution. As woodworkers, we are used to dealing with the seasonal wood movement of our interior pieces. But when one of our creations is destined to live outside, there is much more to consider. Depending on your region's climate, your project could experience anything from snow and ice to hot desert sand storms. How the heck do we prepare for that?!?! Well, it is st...

How To: Lock OneDrive Files with Your Fingerprint or Face ID

If you're concerned about someone accessing your OneDrive files, you may want to upgrade your protection by enabling fingerprint or Face ID unlocking. Your sensitive information deserves to be protected, and now you can do so easily. Worry no longer — if you need to let someone else use your phone, with a password-protected OneDrive, sneaky file grabbers will be out of luck.

How To: Choose Which Microphone Your Phone Uses When Recording Video in Fimic Pro (To Capture Clearer Audio)

When shooting video on your phone, you have two cameras at your disposal, the rear camera and the selfie camera, and you can switch freely between the two. As for microphones, you may have more than one but, unlike with the cameras, it's not easy to switch between them. Filmic Pro solves this problem by isolating the mics so you can choose the best option for the audio track.

How To: Disable the 'Good Morning' Message on Your iPhone's Lock Screen

I'm not a morning person, so getting a "Good Morning" message on my iPhone when I wake up makes me want to toss it across the room. If you feel the same way about this morning greeting, there's an easy way to stop it from showing up on your lock screen. This also applies if your "Good Morning" is actually "Good Afternoon" or "Good Evening," depending on your sleep schedule.

How To: Use the Hidden Thesaurus on Your iPhone in iOS 12 for Fast Synonym Searches in 'Look Up'

One gem that Apple added with iOS 12 is the perfect companion for the dictionary that's already available with the "Look Up" tool. I say gem because it's taken a backseat to all of the other new iOS 12 features, but it shouldn't, because a thesaurus is like the phloem to a dictionary's xylem, making it hard to believe that Apple didn't include this synonym finder from the start.

How To: Opt Out of Ad Tracking on Android

Most of the free apps you'll find on the Play Store have ads. These ads are personalized — in other words, they're for products and services Google believes you might be interested in. The way Google knows about your interests is by collecting data from your smartphone, including your location and app usage. While personalized ads have their advantages, the collection of data is unsettling.

Apple AR: ARKit & Machine Learning Come Together Making Smarter Augmented Reality

The world is a massive place, especially when you consider the field of view of your smartglasses or mobile device. To fulfill the potential promise of augmented reality, we must find a way to fill that view with useful and contextual information. Of course, the job of creating contextual, valuable information, to fill the massive space that is the planet earth, is a daunting task to take on. Machine learning seems to be one solution many are moving toward.

How To: Hide the Navigation & Status Bars on Your Galaxy S8 for Even More Screen Real Estate — No Root Needed

The Samsung Galaxy S8's almost bezel-less display is truly a sight to behold, especially when set to Immersive Mode. While transparent when on the home screen, the navigation and status bars on the S8 will often turn opaque depending on what app you're using at the moment. This, in turn, can detract from the overall experience when viewing anything from the S8's display, as the bars along the top and bottom of the screen bump the phone's aspect ratio down to lower levels.