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.
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...
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.
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.
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...
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 315th installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use the SUMIF & SUMPRODUCT functions.
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.
Open Microsoft Office Excel. Across the top notice letters (columns), along the sides are numbers (rows). The columns and rows can be extended by highlighting sections and right clicking and choosing the high of the row. You can also select to add a border, and change the orientation of your cells.
In this video tutorial, viewers learn how to graph a linear equation in 3 different ways. The first way is to use the table of values. It is the slowest method but it always work. It is the most useful. The second way is to use the slope-intercept. It is more faster than the table of values and is very versatile. The third way is to use the intercept-intercept. It is the fastest and easiest method to do. This video will benefit those viewers who are learning about graphing in mathematics and ...
This is a video about "How to Hack: Demolition City 2" by Travis. This is a flash game. To begin hacking, go to the game and enter the first level. At this point, you do not have any cash. Specify that you are using Mozilla in the cheat engine. After you have completed the first level, write "double" variable in value type and then type the value for the first level, and you can easily notice the game appearance seems to be changed, because the second level of the game consists of first level...
The first operations you will need to know when learning to use algebra to solve for an unknown variable “x” will be using addition and subtraction. You can check you work by checking the balance of the equation when you are done.
Trevor4Ever595 teaches you how to hack the game Space Attack using Cheat Engine. You start the game, select a level and pause it using P. Open up Cheat Engine, open the process list, select Firefox or whatever internet browser you are using. Then you will want to use the search box to search for the amount of money you have in the game. A lot of values will come up to the left of the search box. Go back to the game, earn more money and then search for that new amount. Cheat Engine will only r...
In this video the tutor shows how to graph a straight line using the rise over run method. The rise over run trick allows you to graph a straight line as long as you have a starting point and a slope value in the form of a fraction. The first step is to graph the starting point. In the second step he states that the numerator of the slope is rise and the denominator of the slope is run. He says that the rise is vertical and the run is horizontal and shows how do rise and run using those value...
In this tutorial the instructor shows how to find the Y-Intercept given the equation of the line in Point-Slope form. He shows how to do this with an example. He tells to substitute the value of x to zero to find out Y-Intercept as Y-Intercept is nothing but the point where the line meets x-axis, where the value of x co-ordinate is zero. By watching this simple tutorial you can easily compute the Y-intercept of an equation in point slope form.
This video will show those who would like to learn more about math how to easily compare fractions with different denominators using a simple technique. You will be able to compare the fractions to each other by multiplying the numerator of each fraction with the denominator of the other, in a process called cross-multiplication. Keeping the numbers on the proper side of the equation, compare the two products which you receive from each cross multiplication and you will be able to compare the...
This is a mathematical educational video on how to find extra points for a parabola. In the first two examples there is no need for finding extra points as they have five points and have zeros of the parabola. In example 3 we need to find extra points. The equation is y=4xsquare-4x+4. You can take x= -1 and get the value for y. You will get a point now. Similarly you can substitute -2 for x in the same equation and get the value for y. Now you get another point. Now you can draw the parabola.
In this tutorial, the instructor shows how to compute the surface area of a regular pyramid. A regular pyramid has four equal sides which are in triangle form, and the base in square form. Its surface area is four times the area of its side plus the area of its base. He goes on and takes an example with sample values and demonstrates how to compute the final value using the formula. He reminds the viewer to use square units in the final answer, as square units equal the area. To find out the ...
In this video tutorial you will learn about a very powerful feature in Houdini called Copy Stamping.
The following video shows how you can make a keylogger in Visual Basic 2008. Follow the steps below to create your own keylogger. First you will want to open a new application and name it according to your preferences. Then you want to click on the toolbar button and click textbox. In the textbox values, you will want to select the value of true for 'Multiline' option and the value of True for 'Read only'. On the toolbar, select the 'Behavior' tab and mark it as 'Window'. Go back on to the ma...
You start the game from the Kongregate website and then run Cheat Engine. Look for your browser in the Process list. It could be Firefox, Chrome or Internet Explorer. Set the value type to Array of bytes. Then check the Hex box above and use the values from the description to apply the effects there, like no mp drain, chain doesn't end on hit and unlimited chain time. After you've searched for the value, click New scan and then add it from the left to the bottom by double clicking it. To acti...
This film explains how to count cards in black jack to gain an advantage. Every suit in a deck is said to add or minus up to a count of zero. So the whole deck has a count of zero. There's some synthesized high speed music in the middle while the presenter extracts the spades to show us. Ten to ace have a value of minus one. Seven, eight and nine have a value of zero and the numbers below seven have a value of plus one. The pluses and minuses cancel each other out to produce zero. The numbers...
Compromised uTorrent clients can be abused to download a malicious torrent file. The malicious file is designed to embed a persistent backdoor and execute when Windows 10 reboots, granting the attacker remote access to the operating system at will.
With the release of Apple's ARKit comes endless possibilities for education and learning. One of those possibilities is an AR rotating model of our solar system in your room, another is using AR to instantly know the nutritional value of food items.
While the numbers may not always seem to agree, the message remains the same: augmented reality is a growth segment. This week's edition of Market Reality starts with two new reports outlining the expected good fortunes for the industry and concludes with an example of a company capitalizing on their own growth.
Recently, I've been learning Ruby as a second scripting language. But one topic I never covered with the many lessons online were sockets. So I did some research and came up with a very simple client/server connection that sends a string over the socket.
If you've been watching the latest USA TV Series Mr Robot, you will have seen the Raspberry Pi used by Fsoeciety to control the HVAC system. OTW covers this very well here with his take on setup they may of used.
Welcome back, my budding hackers! In my continuing effort to build your basic Linux skills for hacking, I want to show you how to build a secure "tunnel" to MySQL.
This video is a simple guide about adding automatic page numbering to your document in Adobe's InDesign. It can be a tricky task, but there's no need to fear, this how-to will get you up and numbering in no time. Whether you're making your own document or presentation, or you're working for a huge client and it's got to be right - learn how to set up auto pagination and rest easy, knowing your 1 precedes your 2 and your three then comes next.
Longboarding is one of the most fun things that you can do in a dry, hilly, sparsly-populated (if you value your life) area. This video will teach you how to do a cool downhill longboarding trick, a toeside predrift. It's gnarly, dangerous, and totally awesome.
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 241st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a data validation drop-down cell list where the list shrinks as you select values.
Artist Matt Busch shows how to render a full value monotone comp for his STAR WARS 30th Anniversary movie poster. In addition to getting into the nitty gritty of light and shadow in sketches, see Matt show you how to draw Stormtroopers, as well as busting out his killer happy dance! Learn how to sketch Star Wars by watching this video drawing tutorial.
Watch Jeffrey Scudder demonstrate his GData Python Client Library extension that makes it easy to use Google Spreadsheets as a database in the information cloud.
In this tutorial, we learn how to access Hotmail and Gmail through a local email client. First, Google search "webmail Mozilla" and go to the official website. From here, you will click on the hotmail link and any other e-mail links you want for the add-on. Next, you will right click and save this to your computer. After this, go into your e-mail and go to the settings. From here, you will click on the "forwarding" tab at the top and then click "enable pop for all mail". Save these changes an...
In this tutorial, we learn how to get started with the AdWords API PHP client library. First, download the library by going to the API documentation online. From here, set the authentication information and then open up the library. Now, save the changes to the file and use a sandbox environment. The examples folder has all versions that the API library supports. You can browse the campus folder with the search button, just type in the command of what you want to see. After you do this, you c...
This video shows how to enter an IRC chat with a program called Pidgin, which is normally an instant messaging client. First, you should open Pidgin and open the protocol IRC, selecting or creating a username and changing the server to irc.freenode.net in order to connect to the Linuxjournal channel. After connecting to the channel, wait until you are connected. At this point, you should still not be able to see anything, so you have to go to "Add Chat" and join a channel, in this case #Linux...
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 718th installment in their series of digital spreadsheet magic tricks, you'll learn how to find the Absolute Value Max of a set of integers (positive, zero and negative) using the MAX and ABS functions.
This tutorial explains to us how to get started with AdWords API Python client library. First, download the library by going to the API documentation at code.google.com/api/adwords. Once you download this, open it up and install it to your computer. Once this is finished, set the authentication and configuration information. This will launch an interactive script, so use a Sandbox account for best results. Continue to enter in information as the boxes come up, then you will be ready to run th...
In order to convert Celsius to Fahrenheit, you will need to use this formula: F = 9/5C + 32. Therefore, you will need to solve for C or substitute values and solve in that manner.
In this tutorial, we learn how to upload HTML files without a FTP client. First, go to your HTML files and name the home page "index". Next, go to Zymic and sign up with the website. Next, go to your account management, then click "create new web host account". You will now enter in your website, then login. Now, you will click on file manager and click "upload files". Browse to find your index page and anything else you want to upload. When finished, copy your URL, then test it out to see if...
In order to cut a long layer haircut, you will need a good pair of scissors. You must stay in the exact same standing position the entire time. Bring all of the hair together on each side, in order to cut it.
