Must Have Functions Search Results

How To: Install a garage door opener for your car

Having a garage door opener installed makes life much easier for you and your family members. With so many garage doors out there, opening it by hand can be difficult and result in serious injury. Having an opener installed, helps prevent any injuries from taking place and won't be a burden on your body. So check out this tutorial to find out more. Enjoy!

How To: Use the LARGE and SMALL functions in Microsoft 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 616th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the LARGE and SMALL functions to retrieve the 1st, 2nd, and 3rd largest values from a list. You'll also see how to do each of the following:

How To: Find the sides of a right triangle with trig functions

Learn how to use trigonometric functions to calculate the sides of a right triangle. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to ...

How To: Build and use array formulas in Microsoft Excel

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 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas in Microsoft Excel.

How To: Force a function to becom an array in Microsoft Excel

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 39th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how if an array or range is put into a function argument that is expecting a single value, the function becomes an array and delivers an array of values instead o...

How To: Build a raised garden bed for sustainable living

Having a raised garden bed is great in the city because you can fill it with good soil and create a healthy environment for your plants. Install a hoop house made from PVC pipe. To build the raised bed, use 2x10x8 lumper. Predrill the holes at the corners to make it easier to assemble. Butt the ends together and use exterior deck screws to assemble it. If you want the raised bed higher, build another box the same size and stack them. Fasten a wire screen onto the underside of the frame to ke...

How To: Use differential equations to represent growth

This video shows the method to use differential equations to represent growth. Consider the function y=multiple of C & e raised to kx or Ce^(kx). Differentiating it with respect to x, we get dy/dx=kCe^(kx) or ky. So, the solution of the differential equation dy/dx=ky is Ce^(kx). There are two possibilities in the function y=e^(kx). It can be exponentially growth or decay function. This depends on the value of k. If k is greater than 0 or k>0, we get an exponential growth function. On the othe...

How To: Trust him being friends with an ex

Dan and Jennifer help people with relationship issues. In this video segment, Dan and Jennifer were helping a woman from Germany. She was having issues with her boyfriend having a relationship with his ex. Dan and Jennifer told her that she needed to truly focus on the issue. She stated that her boyfriend was going behind her back by sending his ex-girlfriend her favorite magazine online every week. Dan and Jennifer told her that she needs to really think about if he is really sneaking behind...

How To: Solve 3 equations with 3 variables

You can solve 3 equations having 3 variables. Here are the 3 equation examples: x+2y+z=10. 2x-y+3z=-5. 2x-3y-5z=27. The goal is to reduce to 2 equations having 2 variables. Multiply bottom equation by (-1). Rewrite 2nd and 3rd equation. 2x-y+3z=-5. Add -2x+3y+5z+-27. Equals 2y+8z=-32. Go back to original equations and multiply by (-2). Then you have -2x -4-2z=-20. plus 2x -y +3z. When you add these 2 equations, the answer is -5y +z = -25. You have now reduced the equations from 3 equations do...

How To: Meet hot women by being playful & goofy

David Wygant discusses how to meet hot women by being playful and goofy. Being playful and goofy during everyday life will attract attention from women. Women often wants to know who you really are. Being goofy shows that you are being playful. It also shows that you are being yourself and attracting positive energy. Women will want to be around you to discover this positive energy for themselves. You don't need pickup lines to meet and attract hot women. Simply be yourself and focus on havin...

How To: Open a fifth generation video iPod

Having trouble opening the 5th generation iPod video? Check out this instructional electronics video that shows you how to open your fifth generation video iPod. Try this simple trick if you are having a bit of difficulty getting the iPod video open, shown to you here by a technician. Fix your iPod and start listening to music again with this tutorial video.

How To: Listen for clave patterns in salsa music

Having trouble with the claves? Take heart, aspiring timbaleros and timbaleras. Eguie Castrillo, having played with everyone from Tito Puente to Steve Winwood, is one of the world's most prolific timbale artists. In this installment of his video tutorial series on the fundamentals of timbale playing, Eguie suggests techniques for the important, if oft-overlooked, skill of listening and learning from recorded music.

How To: Relic an electric guitar

Today, having a beat-up old guitar is preferable to having a bright shiny new one. Luthier Steve Soest summarizes what he did to relic two guitars. These easy steps will transform your brand new guitar and make it look like it has the scars of a road warrior.

How To: Set up a formal dinner place setting

Ever wonder which side of the plate to put a fork? This video will show you piece-by-piece how to create a formal place setting for two different meal sizes. This is useful if you are hosting a fancy dinner, or are just having friends over for a nice meal. Some people even enjoy having a formal setting on their dining room table all the time.

How To: Ignore hidden rows with MS Excel's AGGREGATE function

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 662nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add or average while ignoring values in hidden rows. In addition you can ignore both Hidden Rows and Error Value.

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: Ignore filtered values making calculations in MS 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 665th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to make calculations on filtered data. The SUBTOTAL function only has 11 functions, whereas the AGGREGATE has 19 plus options to ignore errors, hidden rows and nested SUBTOTAL or AGGREGATE functions.

How To: Integrate exponential functions in calculus

Looking for a primer on how to integrate exponential functions? This free video calculus lesson will teach you how. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just study for that next big test).

How To: Graph trigonometric functions

Learn how to graph the amplitude and periods of sine and cosine functions in basic trigonometry. Learn how to use trigonometric functions to calculate the sides of a right triangle. Need to know how to solve a matrix-form linear equation in algebra? From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your h...

How To: Use VLOOKUP function formulas in Microsoft Excel

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 7th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with VLOOKUP function formulas in MS Excel. Specifically, you'll see the following:

How To: Look up formulas in Excel with the CHOOSE function

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 557th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHOOSE function look up a formula or function depending on your drop-down selection. See also how to create combo box form controls and data validation lists with the VLOOKUP function.

How To: Put out a fire with a standard foam extinguisher

WhatHappensNow talks with Edina Minnesota Fire Marshall Tom Jenson who explains how to properly use a fire extinguisher. During the video Tom briefly offers a helpful tip, suggesting to remember the P.A.S.S. acronym when it comes to using a fire extinguisher. P stands for pull, your first step having to pull the pin that holds the extinguishers lever in place. The letter A stands for aim, the second step having you aim the nozzle of the extinguisher at the fire. The third letter S stands for ...

How To: Rotate your Windows desktop images with photos from Flickr with a free utility

Having cool photos as your desktop can make your computer a welcome sight, but having to find a fresh one every so often can get pretty stale fast. Thankfully, freeware utility Flickr Wallpaper Rotator for Windows PC's can import images for your desktop from Flickr automatically at intervals you set. You can even set it to use photos from a Flickr search or show favorites from a specific user.

How To: Build dexterity and strength in your hands on the guitar to solo faster

A key element to making any guitar player, whether lead or rhythm, a great player is having good muscle memory and plenty of dexterity and strength in both your left hand and right hand. For those just getting started, or for those who have been playing for a while but are still having a hard time pulling off bends or holding down chords and barre chords, it's crucial to exercise your hands and build that dexterity and strength. In this fantastic video you will learn various exercises to help...

How To: Use the TODAY and NOW functions in Microsoft Excel 2010

Learn how to make time-based calculations with the TODAY and NOW functions in MS Excel 2010. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.

How To: Use the DATEDIF function in Microsoft Excel 2007

Looking for a primer on how to use the DATEDIF function in MS Excel 2007? You're in luck. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2007 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.

How To: Use the TODAY and NOW functions in Microsoft Excel 2007

Need an introduction to Excel's useful TODAY & NOW time functions? You're in luck as this clip provides just that. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2007 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.

How To: Stop a panic attack

In this tutorial, we learn how to stop a panic attack. Start by reminding yourself that you are having anxiety and do not get upset with the situation. Realize you are just having heightened sensations and that you are not in any danger at the moment. Don't close down, let your sensations run through your body and process the fear. Travel through the anxiety to become free of it. The act of welcoming will change your attitude, and let you flow with the experience. You can mentally feel the se...

How To: Use names in formulas and functions in Microsoft Excel

Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 1st installment in his series of Excel name tricks, you'll learn to use names in formulas and functions as well as how to edit them. See how to name a cell or range of cells with this free video lesson.

How To: Use the ADDRESS function in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 98th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the ADDRESS function to make labels in templates easier for users to understand.