This is an Excel magic trick video in which the instructor shows how is time represented in Excel and how it is formatted before displaying it to us. He talks about the decimal representation of the time. He says that if O hour is mapped to the number zero and 24th hour of a day is mapped to number one then we can represent any time of the day in the format of a decimal number between zero and one. He shows the type of formatting that excel uses to convert the decimal number into a human read...
In this tutorial the author shows how to find the circumference of a circle. He says that the circumference of a circle can be calculated by using the formula circumference C = 2 * Pi * R, where R is the radius of the circle. He shows how to solve these kind of problems using some examples and calculating the circumference by substituting the value of radius in the formula. This video gives a good introduction on how to find the circumference of a circle.
For people who are learning basic math skills, this video will show you how to subtract larger numbers which involve borrowing. If the top number on your rightmost digit is smaller than the number before it, you will need to borrow from the column before it. To do this, you will have to cross out the left hand number, subtracting one from its value. You can then add 10 to your original number and continue with your subtraction. If the left hand number is 0 and too small to be borrow from, you...
In this tutorial video the author shows how to find the length of the median of a trapezoid. He starts to show that we first need to add the sum of the parallel sides of the trapezoid which are on the either side of the median. Now this obtained value is to be divided by two to get the length of the median. He explains that the length of the median of a trapezoid is nothing but the average of the lengths of the parallel sides of the trapezoid. If you want to learn how to find the length of th...
In this video the tutor explains the 5th Law of Exponents. He reminds the viewer that when polynomials are multiplied, their exponents get added. Now he states that when a polynomial is raised to another power, the exponents are multiplied instead of adding. The 5th Law of Exponents states that when a polynomial with a power 'a' is raised to a power 'b', then the final power of the exponents is the value of the product of the exponents, i.e., a * b. This video states the 5th Law of Exponents ...
This Excel Statistics series of video shows how to calculate proportions and percentages in Microsoft Excel. This video shows how to do percentage calculations using formulas in Microsoft Excel. To make a formula for a percentage, you need to first make a formula to calculate the total sum of objects you are going to use. To do that, use the sum formula. Now, divide the current object's value with the previously generated sum formula, which gives you the frequency. When you multiply this by 1...
In this video the tutors explain about the concepts of Circular Velocity and Acceleration. She explains the concepts using a real world small experiments. She shows that the equation to calculate circular velocity is v = (2 * Pi * r) / T, where r is the radius of the circle the object moves in, and T being its time period. Now she takes the values from the experiment and calculates the velocity of the other tutor who is the object that runs around in the circle for the experiment. She even co...
For anyone who has ever struggled with long division, this video offers some tips on how to perform this seemingly daunting task with relative ease. The example provided in this video is a very useful one and by following the steps of this video, you will be able to do long division easily. Starting from the right side of the number which is being divided, add 0's as place holders until you arrive at a number which can be divided by the number you want to divide by. Perform this one simple di...
To convert between diameter and radius just follow a few steps. Sometimes we aren't given the number directly so first we need to find the diameter.
In this simple tutorial the author shows the basic arithmetic operations like converting a terminating decimal into a fraction. He says that the complexity depends up on the number we are converting. He asks us to imagine the decimal as a fraction with an imaginary denominator of value one. Now he intends to remove the decimal in the numerator by moving it to the right of the number and he tells us to similarly move similar number of decimal places in the denominator to maintain the original ...
The step by step methods to isolate colors in Photoshop have been shown in the video. In a layer we have to place an image and first select the particular part to be isolated with the pen tool which has free form pen tool, add subtract, intersect and exclude overlapping path options. After that make a right click and select make selection option. Keep the feather be in 3 and click ok. Paste this in a new layer by pressing control+d keys. Create a copy layer of 2 and open Hue and saturation pa...
The video describes how to find 'x' in the algebraic equation -3x + 7x - 6 = 30
Need a little help on your shading technique? This tutorial on shading and shadowing techniques is hosted by Ed Beard, an internationally reknown fantasy artist known for his published works in Magic the Gathering and Tolkien. This video demonstrates how to choose a light source when shading, the values of dark to light, and how to ultilize shadows to embelish the three-dimensional depth to your drawing.
Scratches are unsightly and can alter the value and look of your car. Watch this automotive video tutorial to see how to fix scratches in your auto finish. You need to purchase primer paint made for use on an automobile. Pick a primer that is lighter in color than your car so it is easily covered by the touch-up paint in one coat. Use some mild laundry detergent to wash the scratch to remove any wax or coatings, which could effect your vehicle's paint job. The rest involves some sandpaper and...
Are you new to Google SketchUp? With the push pull tool, you'll be able to render any two dimensional shape into a three dimensional ojbect. Take a look at this instructional video and learn the basics on how to use the push pull tool in Google SketchUp. If you're concerned with the accuracy of your dimensions such as if you want an object to be approximately five feet in length or so, you can type in a value for it and it'll adjust accordingly.
With PivotTable reports in Microsoft Office Excel 2007, your sales report will sparkle with power, flair, and functionality. Take a look at this instructional video to learn how to show the big picture, show all the details, or show anything in between. Easily create multiple worksheets to switch back and forth between the various versions of your report. Sort, filter, and summarize your data any way you like. Show the details of any summary value in your report.
Take a look at this instructional video and learn how to analyze how a process or other area is actually performing by connecting data to the shapes in your diagram with Microsoft Visio 2007. You can also add different visual effects based on the data values. For example, you can link sales data from an Excel workbook to the shapes it relates to. When a phase of the sales process takes longer than guidelines recommend, the shape for that phase changes color or shows an icon that alerts you to...
In this video tutorial, Chris Pels will show how to share data in between JavaScript and server-side code by using a hidden field in an ASP.NET page. Next, learn how to use the RegisterHiddenField method in server-side code to programmatically create a hidden field on the client. In addition, see how to programmatically create a HiddenField server control for sharing data on an ASP.NET page. Finally, use the RegisterArrayDeclaration method to create a container in server code for storing mult...
In this video tutorial, Chris Pels will show how information can be passed from one page to another using a query string. First, see how to construct a query string including variable names and values from information on a data entry form. Next, see how to access the query string information when the page is posted including how multiple query string variables are handled. As part of the server side processing of query string information, see how to implement validation for existence of query...
Learn how to draw portraits in this series of videos which explain sketching, value, contrast, graphite and erasing.
Eric shares his latest Garden Smart Tip and Ideas. A wonderful addition to your patio garden would be an ornamental fruit tree. Eric shows us a beautiful example of a 'Moro' orange. It's a fantastic tree in a container. There is a lot of flexibility that you have with fruit trees in containers. You can move them around to sunny spots on the patio. In the wintertime you can move them indoors for protection. These trees have great ornamental value plus they have the added benefit of providing a...
Apps can learn a lot about you just by reading information about your smartphone. They can easily track what device model you have, your phone number, and in some cases, your hardware MAC addresses. Many third-party apps will only track your device values for advertising purposes, but some might be trying to snoop on your data for ill intentions.
Hacker's are always looking for new ways to exploit systems and exfiltrate passwords, even in hashed form. Sophisticated brute-force attacks powered by high-end GPUs can perform millions of password attempts per second. But Ubuntu and Debian users aren't completely helpless. There are ways to harden the hashed password to better defend against Hashcat attacks.
In this article, I'll show you how to send SMS messages with Python. You'll need Python 2.7 or later, urllib and urllib2. The code basically uses an online text messaging service to "POST" html data, as if a person was entering the data themselves. The uses for something like this are unlimited. For example, I modified the basic code so I would receive a text message letting me know every time someone rang my doorbell. The program could interface with Arduino through a serial port, and send d...
Last Friday's mission was to accomplish solving HackThisSite, realistic 1. This is the first in a series of realistic simulation missions designed to be exactly like situations you may encounter in the real world. This first mission, we are asked to help a friend manipulate the website voting system for a Battle of the Bands vote count in his favor.
So many of you like to save up your gold coins to buy things like castles, treasure cards and clothing. But sometimes when you buy something, an error message pops up. One of them is this extremely annoying one: "Transaction was not successful."This error happens mostly when buying clothes. Let's say you want to buy a robe, but it is too expensive. You change the color of the robe to brown, yellow or white and try to buy it. When you click Buy, the error pops up. You switch realms. No differe...
Step1. First of all you need to remove all the borders. Scroll up and then select all the text lines that have 'border' mentioned and then delete them.
Math always seems hardest until someone shows you how to do the problem and then it all seems just so simple. This video will walk you through the process of finding the surface area of a cone when you also have to derive the slant height. Use this example to help with your other cone problems.
Learn how to play straight gin. Grab a friend, pull out a deck of cards, and get comfortable. Straight Gin is easy to learn.
Illustrator's gradient mesh tool is a powerful one for vector artists... if you know how to use it. This tool can help create beautiful and vivid mesh-based vector portraits, as long as your skills are up to par. If not, try out some of the beginner tutorials on WonderHowTo for using the mesh gradient tool in Adobe Illustrator, then move onto mastery...
Firefox's hidden advanced menu gives you several ways to tweak the way it works under the hood. Here are a set of settings to change to get it to browse faster than ever.
The video shows you how to calculate capital budgeting with a Texas Instruments BA2+ financial calculator. Capital budgeting will help you determine cash flows for given investments for a certain number of years in the future, thus helping you determine if the investment is worthwhile. The buttons you will use are the CF (cashflows) button, the NPV (net present value) button, and the IRR (internal rate of return) button. The video uses the example of a $10,000 investment that will return $5,0...
Start by clicking start and type regedit in the search box. Hit enter and when the screen opens go under hkey current user and click on control panel and then desktop. Under desktop go to menushowdelay. Under menushowdelay right click and then click modify. In the box that pops up set the value to zero and click ok. Then close the registry editor. Next you will want to download ram booster 2. 0. Once you have downloaded and installed the ram booster program you will want to edit your options....
Open After Effects. Create a new composition by selecting "Composition" and "New" from main menu. Use default NTSC DV preset. Keep 30-sec default duration unless you need more time for the video scene to edit. Import several video clips by selecting "File," then "Import" from menu. Navigate to video files you want. Import at least 3 different video files using Import File dialog box. Double click on 1st video file you want to add to your timeline. The file will now open in a video monitor win...
Need to lighten or darken up a digital picture? You can make most of your lightening and darkening adjustments, even before you learn more complex Photoshop features like curves and levels; It's easy. Here's how.
Thinking of selling your car on the internet? Make sure you don’t get taken for a ride. You Will Need
As much as I love Scrabble, the iPhone and Android versions of the game are just not as much fun or as fast paced as Words with Friends. I play both, but I'm most active on Zynga's version of the mobile word game because it's quicker to make moves, doesn't take as long to update, and gives more immediate competition, due to the fact that it's not as intimidating as Scrabble is to a lot of my friends. It's laid back... which means I have a bunch of games going, and I like that.
There are at least 24,000 different Android devices, and they all have varying hardware components. This is why many developers publish several unique variants of their apps, which, among other things, helps accommodate all of the different display sizes and resolutions on Android phones and tablets.
Screenshots taken from a compromised computer can provide hackers with access to private emails, photographs, and information found in sensitive documents. This data can be used by the attackers to build profiles of a target for social engineering attacks and blackmail or even just to release the information out in the wild.
