Typically Valued Search Results

How To: Count note values on the drums

This video lesson teaches Jared Falk's note value exercise. Basically, this exercise is designed to help you practice quarter notes, eighth notes, eighth note triplets, sixteenth notes, sixteenth note triplets, and 32nd notes around the drum kit - all at the same time.

How To: Disable (prank) the Shut Down button in the start menu on Windows XP

If you love computer pranks, this is one of the easiest ones to pull. This video will show you how to remove the Shut Down button from the start menu in Windows XP. Actually, it does't remove the shutdown button, it just disables it, giving the user a restriction message, stating "This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator."

How To: Validate data with dynamic VLOOKUP functions 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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...

How To: Sum values after a deadline 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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM only the values after a deadline using a dynamic range formula using INDEX Function. Also see a SUMPRODUCT function method.

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: Hack Sandcastle with Cheat Engine (01/08/10)

In this video, we learn how to hack Sandcastle with Cheat Engine. First, start the game and then click the process list icon. Now, use the Firefox browser and then type in the amount of gold you have into the value section. Now, buy something and then click the frozen box and change the value to 999. Next, when you buy something it will say that you have unlimited amount of cash. You will be able to buy all of the things you want, and you won't have to gather more coins to do so! This is a ve...

How To: Simplify expressions involving absolute value

Need to know how to simplify expressions involving absolute values? It's an absolute cinch. Learn how with this free video lesson. 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 free math tutorial, you'll learn how to divide one fraction into an...

How To: Create & work with pivot tables (PivotTables) 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 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:

How To: Look up a time value with Excel's VLOOKUP function

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 48th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP, ISTEXT, ISBLANK, OR and IF functions in one formula to look up a time value. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Use the PERCENTILE & QUARTILE functions in MS Excel

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 248th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the PERCENTILE and QUARTILE functions to calculate percentiles, quartiles and deciles in basic statistics.

How To: Use the COUNTIF function in Microsoft Excel

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 180th installment in their series of digital spreadsheet magic tricks, you'll learn how to count specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values that are NOT equal to an amount, words that end in es, all words, all numbers, all content, all blanks, all things which aren't words ...

How To: Find averages & standard deviation in Microsoft Excel

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.

How To: Perform the mind blowing trick "card text"

First of all you need to a set up deck. You need to learn about two things. First you need to learn about calculating the numerical value of the card and also work out the suit the card. First take out a card and lay it face up. This is 4 of clubs. The rule here is that next card shall be 3 more in numerical value because this deck is a set up. So pick the next card that is 7(4+3) of hearts then 10 of spade (10+3) and then king of diamonds (10+3). Now remember the phrase "chsd", c for club, h...

How To: Get the Classic Volume Controls Back in Windows 10

Windows 10 definitely has a sleek and modern look to it, but some of these visual changes have been made at the expense of functionality. For instance, the slider that appears when you click the volume icon in your notification tray now sports a completely minimalist look that lacks the quick link to the full volume mixer from past Windows versions.

Hack Like a Pro: The Basics of the Hexadecimal System

Welcome back, my novice hackers! It has become clear from some of your questions that quite a few of you are unfamiliar with the hexadecimal system, or simply, hex. The hexadecimal system is used throughout computing and if you have never studied this Base16 numering system, it may appear relatively opaque.

How To: Graph x & y intercepts on a TI-84 Plus calculator

In this video the teacher shows us how to use a TI-84 plus graphing calculator to graph a function, adjust the view window, and determine the values of several types of critical points on the graph such as x-intercept, y-intercept, local maximums, and local minimums. After entering the function in the Y= editor she presses the ZOOM button and selects Z-Standard this adjusts the view window to a range of -10 to 10 on both axis. To find each of the critical points requested the teacher uses the...

How To: Calculate the circumference of a circle

This video shows how to calculate the circumference of a given circle. The video first describes the circumference or perimeter of a circle as the distance around the outside of a circle. To find the circumference we need either the radius or the diameter of the circle. When you know the diameter of the circle, the formula to find the circumference denoted by 'C' is 'pi' times the diameter, where 'd' is the diameter and 'pi' is a constant, the approximate value being 3.14. And when you are gi...

How To: Solve a linear system by elimination method

This video is about using the elimination method to solve a linear system. The lady presenting this video says that elimination method means that one of the two variables has to be eliminated while adding up the two linear equations. She then explains the example equations 6x-2y=66 and 5y=-29-2x. She asks you to first line up x and y. So the second equation is rewritten as 2x+5y=-29. Then she says that, to eliminate a variable, we should have their variables equal in value but of opposite sig...

How To: Find the equation of a line easily

This is the video about how to Find the equation of a line. The equation of a line with a defined slope m can also be written as follows: y = mx + b where m is the slope of the line and b is the y intercept of the graph of the line. The above form is called the slope intercept form of a line. Step1 Set m to a fixed value (m = 1) and change b (b = 1, 2, 3, 4, -1, -2, -3, -4). Compare each value of b to the y-intercept of the line obtained. Step2 Set b to a fixed value (b = 1) and change m (m =...

How To: Create a road in Illustrator

Illustrator denotes how to create a road. First select the pen and draw a path. Now go to stroke. It depend 130. Deselect dash line. Now move our path a little bit upper. Now select our path. Now duplicate of our path several times. Now turn off the new layers. Focus on our first path. Turn on the second path. Change the stroke weight value to 125 and change the color to gray. Now go to the next path. Select our path and change the stroke weight value to 115 and leave the black color. Now go ...

How To: Play war

Watch this video tutorial to learn how to play war. Not only is War a great way to pass the time with a friend, but it's so easy to learn that both children and adults can play.

How To: Retrieve the cell address of the minimum value in a column 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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve the cell address of the minimum value in column. To accomplish this, you'll use the ADDRESS, MATCH, INDEX, MIN, ROW and LOOKUP functions.

How To: Look up and return two values to one cell 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 702nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up two values at once and return then both to one cell using 2 VLOOKUP functions and concatenation (Ampersand &) or two cells using a single VLOOKUP and the COLUMNS function.

How To: Create value-based formatting using data bars in Excel

See how to create value-based formatting using data bars and color scales in Excel 2007. See how to use the Format Cells dialog box and the pop-up mini-toolbar in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, w...

How To: Find a weighted average cost ending inventory value

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 43rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to calculate weighted average cost ending inventory value from transactional records on 2 different sheets using the COUNTIF, SUMIF and SUMPRODUCT functions.

How To: Create an array constant from cell values in MS 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 10th installment in his series of Excel array formula series, you'll learn how to create an array constant from values in cells. This is a great trick that can save tons of time when you want your array stored in memory.

How To: Build confidence intervals & test hypotheses in Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 47th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the NORMSINV function for critical values and the NORSDIST function for p-values. Compare building confidence int...

How To: Extract the top 5 values from a given list 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 40th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the filter and advanced filter tools to extract the top 5 values from a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Write and graph an equation in slope intercept form

This video teaches us the method to write an equation in slope intercept form and to graph it. The equation of line is y = mx + c. m is the slope and c is the y intercept or the point where it crosses the y axis. Let us find the equation of line if it crosses (8,6) and m=1/2. Substituting the values of x,y and m we get 6=(8)(1/2)+b. Simplifying we get b=2. Substituting the values in the equation of line, we get y = m/2 + 2. Suppose we want to find the x coordinate of a point on the line given...

How To: Validate data & look up 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, the 5th installment in their series of digital spreadsheet magic tricks, you'll learn how to name a cell range, use data validation to add a drop-down list, and how to use the VLOOKUP function to look up values.

How To: Return every tenth value in an Excel spreadsheet

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 278th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX and ROWS functions to write a formula that will return each 10th value and place them all in a column.

How To: Find the midpoint of a line segment

A good place to start when you want to learn how to find a midpoint of a line is a circle. Take the diameter of a circle, for instance if the coordinates of the starting point are (1,6) and the coordinates for the ending point are (11,6). The midpoint of a line is the exact central point where a line through these two points would meet. Now the value of y is a constant one as the line runs parallel to the x-axis, the value of x changes by 10, the half of which is 5, this is not the midpoint t...

How To: Use VLOOKUP with multiple lookup values in Excel

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 488th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP with multiple lookup values. You'll also learn how to add an extra column with a unique identifier to data set using ampersand concatenate.