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 34th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a formula that will calculate the taxable earnings for a payroll period when there are ceilings (hurdles maximum) for taxable earnings (above which ...
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 41st installment in his "Excel Business Math" series of free video lessons, you'll learn how to calculate deductions from paychecks when there is a ceiling or max taxable amount or hurdle.
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 100th installment in their series of digital spreadsheet magic tricks, you'll learn how to replace a long IF formula with a simple MIN/MAX formula (or an even simpler MEDIAN function). See 3 amazing examples. When you have a hurdle such a Commission Hurdle or a Payroll Taxable Earning Hurdle, and you are using an IF function fo...
This video instructs the viewer about the basics of cloud computing, using more than one computer and managing your computing needs online. The instructor explains, "Cloud computing is a metaphor for using the Internet for your computing needs." A program called cloudo, allows the user to store information online through an interface that looks like a regular computer desktop; then the information can be accessed via password from any computer with an internet connection. Other programs also ...
Learn how to take advantage of Microsoft SharePoint 2010's new social computing tools. Whether you're new to Microsoft's popular content management system (CMS) or a seasoned MS Office professional just looking to better acquaint yourself with the SharePoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started taking advantage of SharePoint's social computing features yourself, watch this free video guide.
The latest business move by Magic Leap could result in a significant boost to its spatial computing platform's performance and headset design.
A pyramid is a three dimensional figure with the base in the form of a triangle and three slant sides to it. To find the surface area of a pyramid you have to find the area of the different pieces that make it up. The pyramid base can be triangle or even other geometric figure like pentagon. So first draw the base of the pyramid separately and compute its area first. Now compute the area of each sides separately. The area of each side can be same if the pyramid is a regular pyramid. Some time...
Need some help figuring out how to use the Downloads folder on an Apple compute running Mac OS X? It's easy! So easy, in fact, that this home-computing how-to from the folks at MacMost can present a complete overview of the process in just over five minutes. For more information, including step-by-step instructions, take a look.
Looking better (but equally free) way to burn DVDs from within Apple's Mac OS X? See how to use Burn, the open-source optical media authoring tool, acheive just that with this home-computing how-to. For details, including step-by-step instructions, and to get started burning your own discs with Burn, watch this home-computing how-to.
A tutorial on using LogMeIn.com to set up remote computing on your computer so that you can always access your computer from anywhere with the Internet.
A percent problem is one in which you are given a quantity and asked to compute the value of a percent of it. You may also be given the whole quantity and a part of it and asked to compute the percentage of the part in the whole. To do these kind of problems you need to use the rule which states that the ratio of the part to the base it equal to the ratio of the percent to hundred. That is part/base = percent/100. This comes from the definition of percentage which states that percentage is eq...
Looking for a guide on how to calculate ratios in basic mathematics? Look no further. This free video math lesson will show you how it's done. 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).
In this tutorial the author explains how to compute the area of a complex figure. Now he first defines what a complex figure is by saying that a complex figure is a figure made up of two or more basic shapes. He uses an example to convey his idea and breaks that sample figure into basic squares and rectangles. Now he computes the areas of these individual units separately and finally puts them together to arrive at the final area of the complex figure. If you are looking to compute the area o...
In this clip, you'll learn how to get started using Secure Computing's Secure Web Protection proxy service. It's easy! So easy, in fact, that this helpful how-to can present a complete overview of the app in just over five minutes. For more information, including detailed, step-by-step instructions, take a look.
If you are a user of FileMaker Pro then this video teaches you how to use calculation and summary fields in it while making new files. In Filemaker you can create a various kind of fields that you want your file to contain. In Filemaker a calculation is a data that gets computed depending up on the formula that is set in the Filemaker database settings. Calculations are very critical in file management. Open the Manage Database and there you can find some of the calculation fields. There in t...
In this video the tutor shows how to calculate the area of a rhombus. He gives the formula for the area of a rhombus as area a = ( D * d ) / 2 where D is the length of the longer diagonal and d is the length of the shorter diagonal. He shows how to solve such problems by taking an example of rhombus with lengths of longer and shorted diagonal and computes its area by substituting the values in the area formula. This video shows how to compute the area of a rhombus when the lengths of its long...
In this tutorial the author shows how to derive a slope-intercept equation of a line given an X-Y table. He explains that the general form of slope intercept form which is y = m*x + b. Now he intends to find value of slope, i.e. m first. Now slope is change in y over change in x. He computes the slope using the X-Y values from the table. Next he substitutes a pair of x, y value in the equation to compute the value of y intercept b. Now finally substituting the values in the equation the slop-...
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 ...
Long before Nvidia figured out how to embed neural networks in its graphics processor units (GPUs) for driverless vehicles, it and other chipmakers were already making the same kinds of devices for 3D games and other apps.
Two dimensional objects are measured in terms of perimeter and areas. A perimeter of a two dimensional object is the distance around that object. If you want to find the perimeter of an object, all you need to do is add up each one of the lengths of sides of that object. If you have a small figure like triangle, first compute the length of the three sides. Now adding these three sides gives you the perimeter of the triangle. A larger or more complicated shape might have more number of sides. ...
In chemistry you come across problems which ask you to find the percent by mass and percent composition of each element in a chemical compound. To do this the first step is to compute the molar mass. Use the periodic table to look up the mass of individual atoms and multiply it by the number of atoms to find the mass of that element. Now add up all the masses to arrive at the molar mass of the compound. Now to find the percent composition of an element divide the total mass of each element by...
Some savings plan pays interest 365 days in a year but you make deposit monthly. You can use Excel functions to calculate the maturity value of the of the monthly plan. To do this you have to use the nominal and effect functions before using the future value functions. First enter the know data like the monthly payment, the number of years of payment, the number of days in a year, and the annual percentage rate. First take the nominal rate and calculate the effective rate with the help of eff...
In this video the instructor shows how to find out an equation of a perpendicular line. If you need to find the equation of a line passing through the given point and is perpendicular to another line, the first thing you need to do is compute the slope of the given line. Obtain the slope of the equation by writing it in the form of y = mx + b. Now the product of slopes of two perpendicular lines is a negative one. So the slope of our required line will be the negative inverse of the slope of ...
In this video, the instructor shows how to identify the percentage change using proportions. When a given quantity increases or decreases by certain amount then we can calculate the percentage change in the quantity, which can be either increase or decrease based on the new value of the quantity. To solve these kind of situations you should know that the ratio of amount of increase (or decrease) of an amount to its original amount is equal to the ratio of percentage increase (or decrease) to ...
In this video the instructor shows how to find out an equation of a perpendicular line. If you need to find the equation of a line passing through the given point and perpendicular to another line, the first thing you need to do is compute the slope of the given line. Obtain the slope of the equation by writing it in the form of y = mx + b. Now the product of slopes of two perpendicular lines is negative one. So the slope of our required line will be negative inverse of the slope of given lin...
In this tutorial the instructor shows how to compute the Surface Area of a Cone. He explains that you need to find the individual surfaces areas first. Hence the bottom part of the cone which is circular can be calculated as Pi*r*r, where r is the radius of the base circle. Now for the sides surface of the cone, it looks like a sector and he derives its area thorough some deduction. Now he adds both the base surface area of the cone, and the lateral surface of the cone which finally gives the...
In this video tutorial the instructor shows how to derive the formula to compute interest compounded annually. He starts with explaining the basic concepts like principle which is the amount you borrow and the rate of interest or annual percentage rate (APR), which is the rate at which you pay the interest up on the borrowed principle. He shows that the amount after the end of one year is amount A = P(1+APR),and he goes on and generalizes how to compute it for n years. This video shows how to...
This tutorial the shows how to find out the measure of an exterior angle of a regular polygon. He shows the formula to find it which is 360/n, where n is the number of sides of the regular polygon. He goes on further to explain the formula by taking an 18-sided regular polygon as example and computes its exterior angle as 360/18, which is 20 degrees. If you are looking to compute the exterior angel of a regular polygon, follow the procedure given in this tutorial.
In this video tutorial the author shows how to find the perimeter and area of a complex figure. He shows that a complex figure can be subdivided into standard geometric figures. In the current example he divides the complex figure into a rectangle and a triangle. Now he computes the perimeter by adding the three sides of the rectangle and the two sides of the triangle. Similarly he computes the individual areas of the rectangle and the triangle and finally adds then up to find the area of the...
In this tutorial the instructor shows how to find the surface area of a sphere. He explains the equation to calculate the surface area of a sphere as 4 * Pi * r * r , where r its the radius of the sphere. Now if you have the radius of the sphere, by substituting its value in this equation and substituting the value of Pi, you can obtain the surface area of a sphere. If you want to compute the surface area of a sphere watch this video where it is clearly explained how to compute it along with ...
In this tutorial the instructor shows how to compute the area of irregular shapes. He demonstrates this with an example showing an irregular area and says that as there is no direct formula to calculate it, you need to break up the irregular area into identifiable simple geometric figures. He goes on and breaks the irregular shape into a square, a triangle and a trapezoid. Now he computes the individual areas using a standard formula and sums them up to arrive at the final complete area of th...
Those of us who are actively developing for the HoloLens, and for the other augmented and mixed reality devices and platforms that currently exist, are constantly looking for the next bit of news or press conference about the space. Our one hope is to find any information about the road ahead, to know that the hours we spend slaving away above our keyboards, with the weight of a head-mounted display on our neck, will lead to something as amazing as we picture it.
In this home-computing how-to from the folks at Tekzilla, we learn how to use the Energy Saver preference pane to program an Apple Mac OS X computer to shut itself off or turn itself on at a specified time. For all of the details, and to get started using this lesser-known trick on your own Mac, watch this video guide.
Want to make sure a message doesn't fall into the wrong hands? Try embedding it in a web image. With the Mozaic Encrypt web app, it's both quick and simple. For all of the relevant details, and to get started adding secret messages to image files yourself, watch this home-computing how-to from Tekzilla.
In this clip, you'll learn how to use the quickly lock the screen of an Apple Mac OS X computer with the Shift + Control + Eject keyboard shortcut. For more information, including a complete demonstration and detailed, step-by-step instructions, watch this helpful home-computing how-to from the folks at Tekzilla.
Wish finding Greasemonkey scripts were easier? With the Greasefire Firefox addon, it's super easy! So easy, in fact, that this home-computing how-to from the folks at TekZilla can present a complete overview of the process in just over two minutes. For more information, including step-by-step instructions, take a look.
In this clip, you'll learn how to synch bookmarks between two or more installations of Chrome. It's easy! So easy, in fact, that this home-computing how-to from the folks at TekZilla can present a complete overview of the process in just over two minutes. For more information, including step-by-step instructions, take a look.
Interested in creating a map of all of your Facebook friends? With Microsoft's Bing, it's easy! So easy, in fact, that this home-computing how-to from the folks at TekZilla can present a complete overview of the process in just over two minutes. For more information, including step-by-step instructions, take a look.
When it comes to closing applications in Mac OS X, there are more options available than just clicking the little red circle in the left-hand corner of an application window. There are, in fact, 10 different ways in which a person can quit an app. And this handy home-computing how-to demonstrates each and every one of them.
Want to put the extend the OS X menu bar to a second monitor? This clip will show you how it's done. It's easy! So easy, in fact, that this handy home-computing how-to from the folks at Tekzilla can present a complete overview of the process in about two minutes' time. For more information, including detailed, step-by-step instructions, take a look.
