Valued Clients Search Results

How To: Use the F5 Networks' BIG-IP Edge Client

Learn how to use the BIG-IP Edge Client and its Smart Connect, Location Awareness, Customization, Deployment features. Whether you're new to F5 Networks' popular network appliance or are a seasoned network administrator just looking to better acquaint yourself with BIG-IP, you're sure to benefit from this free video software tutorial. For more information, including detailed instructions, take a look.

How To: Upload & download files with the FileZilla FTP client

Need to send large files across the Internet? An FTP site is a great resolution to emails that bounce back due to attachment overload. By uploading your file to an FTP site, it will allow your recepient to download the file from the site with ease. In this tutorial, learn how to upload and download files using the FileZilla FTP client.

How To: Decrease values 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 and Mr. Excel, the 2nd installment in their joint series of digital spreadsheet magic tricks, you'll see two methods for subtracting 35% from a column of values.

How To: Extract items not having a given text value in 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 and Mr. Excel, the 25th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to extract records from databases that do NOT contain a given text value.

How To: Use Excel's SUMIF, RANK & IF functions

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 30th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the SUMIF function to add with one criteria, the RANK function to rank highest values to lowest values (one to five) and the IF function to assign a bo...

How To: Make present value calculations in Excel

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 58th installment in his "Excel Business Math" series of free video lessons, you'll learn how to make simple value calculations for the present.

How To: Sum the 3 largest or smallest values in a set in Excel

Looking for a primer on how to create and work with array formulas 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 5th installment in his series of Excel array formula series, you'll learn how to create array formula for adding the 3 largest or smallest values in a data set.

How To: Set up a VPN client on Mac

This is a video tutorial that is showing its audience how to set up your own VPN client on your Mac computer. The first step in setting up a VPN client is to go to your system preferences on your computer. Next select network and then select the plus button and type in that you will be making a VPN network. Next you should select the type PPTP and enter your server name. Then you can click on create and it will create a new network for you. Next you should enter your service address and your ...

How To: Autohighlight the highest value in a row in 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 268th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply a conditional format that will highlight the maximum value in a row using a true/false formula.

How To: Give a lymphatic drainage massage

This video shows the viewer how to give a lymphatic drainage massage of the head and neck. A pillow elevates the head slightly to help the drainage process. Using a light oil, she applies the oil to the neck and the face of the client. She puts her fingers inside the clavicle bone at the base of the neck and pumps to start the fluid moving down. Encourage the client to take deep breaths as this helps the fluid to move down. This is a great massage to get in the spring time when allergies are ...

How To: Calculate averages in Microsoft Office Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using Excel to calculate average values and to pick max and min values. For more on this handy feature of Excel, watch this how-to.

How To: Use FileZilla FTP client to upload files to the web

In this video tutorial from Matt Overwine of the Instructional Design Group at Northern Kentucky University, you'll find instructions on how to use the FileZilla FTP, or file transfer protocol, client to upload to the web. FileZilla is available for both Mac OS X and Windows XP and Vista. For more information, and to get started using FileZilla for yourself, watch this handy how-to.

How To: Do a chair massage for arms and hands

The hands are one of the more overworked parts of the body. Watch this video to learn massage techniques that can be used to relieve aches, pains and knots in these regions while the client is relaxing on a chair. A word of advice though, use lotion instead of oil because most clients go back to work after a massage and you do not want to leave their hands greasy.

How To: Use a unit circle to find trig values

In this tutorial, we learn how to use a unit circle to find trig values. The unit circle has a radius one, use the definition of the trig functions to figure this out. Write them down if you need to, to remember what they are. You will also need two special triangles to help figure this out. Make sure you know the short side is opposite 30 degrees. Now, draw out your graph and find the ordered pair of pie, then find the y value of it. From here, find the cosine, tangent, and other units using...

How To: Determine if a point lies on a line in standard form

In this video, we learn how to determine if a point lies on a line in standard form. In order to do this, you will need to substitute the X and Y value with the ordered pair that is given. The X value is the first number and the Y value is the second number. Re-write your equation, substituting in the numbers to the appropriate spots. Now, simplify the equation by doing multiplication with the negatives and positives (if given). When you get through the equation, you will end up with the solu...

How To: Understand Ohm's Law

This video teaches the basics of Ohm's law, which is an important equation in electrical engineering. The three variables which are used in this equation are V, which stands for voltage, I for current, and R for resistance. The equation for the law itself is I=V/R. This law defines the relationship between these three very important electrical properties. The host of the video further explains what voltage, current, and resistance are and how they work in relation to an electrical current. Gi...

How To: Use the INDEX & MATCH functions 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 45th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the INDEX & MATCH functions.

How To: Use rounding functions & paste special values in 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 28th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use Excel's rounding functions, how to paste special values – and quite a lot more besides. Specifically, this video addresses each of the following topics:

How To: Work with Microsoft Excel's LOOKUP 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 42nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn ten tricks involving the LOOKUP function:

How To: Compare exponential expressions

In this video the tutor shows how to compare exponential expressions and judge if they are equivalent. He shows how to do this using examples to simply exponential expressions. Now after simplifying the numerator and denominator separately he reduces the fraction to arrive at a simple value. Now using this simple values we can compare them and judge if both their values are equivalent. This video gives a good introduction on how to simplify the exponential expression and how to compare them a...

How To: Make a quartile diagram (aka, box and whisker plot)

This is an interesting mathematical instructional video on how to make a quartile diagram. This example is about 34 grades obtained by chemistry class students. We need a minimum value, a maximum value, Q1, Q2 and Q3 values to make a quartile diagram. The minimum is 43 and the maximum is 92. To calculate Q2 median formula (n+1 over 2)is used. The Q2 median is 17.5. So the average of 69 and 71 is 70 and hence Q2 70. Similarly Q1 is calculated as 61 and Q3 is calculated as 79. Now you can draw ...

How To: Prove angle-side-angle congruency

This is a tutorial about how to prove the congruency (equality) of two triangles when the values of two angles and an included side of each triangle is given. The author of this video instructs the viewer that it should be first determined whether the values of two angles of one triangle are the same as those of two angles of the other triangle. Then one must seek to determine the equality of sides included in those angles in both the triangles. When it is found that these three values in one...

How To: Find percent

Finding the percent of a given value is made simple and easy in this math tutorial video. In step one you must divide the part or the portion by the whole. As a result we obtain a decimal number. In step two, we must then move the decimal point two places to the right in order to convert the number into a percent value. This brief video tutorial illustrates the process in these two steps and makes it simple for anyone to be able to obtain a percent value for a portion of a whole.

How To: Make a scroll bar in Dreamweaver

Down, down, down! Yep, what you want is lower on the page and you want to get there faster. SO, why not scroll baby scroll! Ever wanted your website to have a scroll bar? Well, now you can by watch the following video. This how-to will show you how to use Dreamweaver to insert a scroll bar to allow for easy navigation for your or your client's website. It's not too hard, so follow the bouncing ball and learn what to do.

How To: Use SSLStrip to remove encryption from browser

You should encrypt everything. These are what you need: BackTrack 4,0, modify IP tables, Python and ARPspoofing. Program the PC to flip to forwarding mode. Adjust the programming in the IP tables. You are convincing the host and the client that the man (PC) in the middle is the host and capture passwords, user names and other information from unsuspecting clients. This program strips the "S" from "https" which make your computer vulnerable to hackers. You need to observe the address bar and m...

How To: Find decimal place values in basic arithmetic

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. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to find the place value of a decimal number.

How To: Build a Stealth Port Scanner with Scapy and Python

As we're all aware, recon is vital to a successful hack. We need to know everything we can about the target in order to perform the best possible attack. Port scanning is a basic recon concept that is introduced very early in learning proper reconnoissance. The issue with port scanning is that is makes a lot of noise. Every connection to every port will be logged. This is where stealth scanning comes in. Also known as SYN or half-open scanning, stealth port scanning is a bit quieter, and is l...

How To: Evaluate functions

In this tutorial, we learn how to evaluate functions. A function is an equation with an input and an output. For the value of "X" there is going to be a value for the rest of the values that are in the equation. To start, write out the equation, then substitute the "x" with the appropriate number. After this, substitute the "x" in the rest of the equation where it belongs. Once finished, work out the rest of the equation in the appropriate order. Now you will be able to finish it and get the ...

How To: Calculate compound interest using a TI-84 and solver

This is a video tutorial in the Electronics category where you are going to learn how to calculate compound interest using a TI-84 and solver. Press the apps button on the calculator and press enter to load the TVM Solver which is the 1st choice. Here the meaning of various notations are N is time, I% is the percentage, PV is present value, PMT is payment, FV is future value and C/Y is compounding period. The problem is find the compound amount and the interest earned on $12,903.45 compounded...

How To: Calculate weekly gross pay from time values in Microsoft 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 722nd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate gross pay for the week from time values using the SUMPRODUCT function. Also see what to do if you get a #VALUE! error from blanks in cell using the IF function and an array logical test.

How To: Look up approximate values with VLOOKUP in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 112th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to solve a common VLOOKUP problem — how to look up approximate values. If the lookup table for the VLOOKUP function is looking up approximate values, the first column of the table must be sorted in ascending order. Learn to love digital spreadsheets more p...

How To: Find, replace & sort in MS Excel

In order to Find, Replace, and Sort, using MS Excel, become familiar with your home tab. When you click on Sort, it will give you the opportunity to sort in different ways: e.g. alphabetically. If you accidentally shift your table, you can undo it by using Ctrl + Z. Custom Sort will allow you to be very specific in the way you want your data sorted. You can add or remove a filter with the same drop down menu, in order to be even more precise.