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 155th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the TRIM function to get rid of extra spaces when a VLOOKUP function should work but doesn't.
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 154th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a personal budget based on past data via the SUM function, cell references, subtraction and the VLOOKUP function.
The video demonstrates the way of calculating the interest rates for payday loans using MS Excel. The person presenting the video has got his MS Excel sheet with all the formulas and data ready. He first starts with the nominal & effect & future value tab. He gives us an example where you give the lenders a check of $250 that has a date 25 days in future and get $200 loan today. Now he teaches us hot to calculate APR and EAR. HE has got the data ready there, the period of the loan which is 25...
Excel dilettantes and seasoned Microsoft Office professionals alike may be surprised to learn that in Excel one can make a drop down list based upon a second drop down list (or, similarly, data validation list that is based on a second validation list).
This video shows you how to calculate weighted average cost from a transactional data set using SUMPRODUCT function. It explains things very clearly. If you're working with a very large database transactions the SUMPRODUCT function makes it. It works as text if you do the formatting first and then type the number. We put the number in first and then format as text, then press F2 and ENTER.
In the last iteration of how to train your python, we covered basic string manipulation and how we can use it to better evaluate user input. So, today we'll be covering how to take user input. User input is very important to scripting. How can we do what the user says if we can't tell what the user wants? There are multiple ways to take input, we can give the user a prompt and take input from them directly, or we could use flags/switches, and take their input before the script is even execute...
With a simple social engineering trick, sudo passwords can be captured in seconds without the target's knowledge. The passwords can then be saved to a file or exfiltrated to another computer on the network.
While attempting to hack a web app, there may come a point where the attacker may have to escape the default directory in order to access unauthorized files. This is known as a directory traversal attack. Much as the name implies, this attack involved traversing the servers directories. But in order to move to an unauthorized directory, we need to know where those directories are. Today we'll be building a tool to brute force these directory locations based on HTTP response codes. Before we g...
For roasted chicken, you would expect it to have a nice, brown crispy skin. You would expect it to be moist inside with great flavors throughout. By using the rotisserie function (very common in France) on the Cuisinart Brick Oven. Check out the recipe for this delicious herb-roasted chicken from Chef Hubert Keller.
This Houdini 9 software video series focuses on examples of when and how to use Attribute Transfer. Part 1 covers Attribute Transfer One Point:
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...
A CNC router machine is probably the most useful tool a hobbyist can own, but the price for a CNC machine on the market is way more than the average hobbyist is willing to spend. You can build your own CNC with very basic tools, little knowledge of machinery, mechanics, or electronics, but be warned, these machines are inherently dangerous, so wear the proper protection and use common sense. At the very least, read the instructions and precautions on every tool you use.
NOTICE: Ciuffy will be answering questions related to my articles on my behalf as I am very busy. Hope You Have Fun !!!
The split view display is a useful function of an iPad application, which, by virtue of a larger screen, was not available to iPhone developers. This tutorial shows you how to work with a split view app, especially when changing your orientation.
Swype is a function for the Android phones which lets you input words by dragging your fingers across the keyboard instead of tapping. While newer phones have this feature, some older phones may not. This tutorial shows you how to equip your Android phone with Swype.
Having clean, functional valves is essential to proper engine function. Honda cars need to have their valves adjusted when they start to make noise. In this video you will learn how to adjust the valves on a 1996 Honda Civic.
This animation can be very useful to create banners, and shows you how to use ActionScript 3 and the timeline function of Adobe Flash CS3 to set the background of mountains and a moon. Then create a few flying bats and animate them to fly across the screen in a loop!
You don't need a high definition television to take advantage of AppleTV! This tutorial shows you how to set up your Apple TV to function with a standard definition television set. You'll need an HDMI to DVI cable anda VGA to DVI adapter, and use the yellow composite video cords. Then adjust your settings, and you're ready to start watching your new Apple TV!
This video will explain to you how to preform one of the more fundamental but confusing tasks in 3D Studio MAX: setting up textures as a template background for you models. Doing this will make sure that your models are displayed in front of the proper background and that said background will function properly. If you need a little help setting the scene for your 3D modeling, watch this video.
See how to use the Maps application and the iPhone's built-in GPS function to find your exact location when out and about. Whether you're the proud owner of an Apple iPhone 4G or perhaps just considering picking one up, you're sure to benefit from this free video tutorial. For more information, including a detailed overview, watch this iPhone user's guide.
See how to enable the multisite function in WordPress 3.0. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.
You've already got your clothing hanger plus scarf earring holder in place to organize your huge collection of earrings, but how do you deal with the leftover pile of bracelets and rings?
In this tutorial, learn how easy it is to pair your Bluetooth enabled cell phone to a 2010 Kia automobile. If your new Kia is equipped with this function, follow along with this video and you will see just how easy it is to set up a safe and simple Bluetooth connection.
Learn how to use the new Smooth Bind function in Maya 2011. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with the Maya 2011 workflow, you're sure to be well served by this video tutorial. For more information, watch this free video guide.
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 612th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Year Category for a PivotTable from dates entered as text using the RIGHT function and the ampersand (&) join symbol.
New to Excel? Just looking for a few new tips and tricks? Whatever the case, you're sure to enjoy this free video software tutorial, which will walk you through how to sesarch table arrays within Microsoft Excel 2007. Learn how to dynamically search table arrays in Microsoft Excel 2007 using the built-in VLOOKUP function.
New to Microsoft Excel 2010? Looking for a few good tips and tricks? In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the very first installment in his series of Excel 2010 video tutorials, you'll learn how to use use the RANK.AVE function to average rank scores in the event of a tie. See the new Excel 2010 RANK.AVE and RANK.EQ functions.
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 installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to find the partial derivative of a vector-valued function using a calculator to perform...
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 installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to find the partial derivative of a vector-valued function with higher-value roots.
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 18th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to calculate (and sum) subtotals in Excel. See how to do subtotaling with the SUM 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 40th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to perform eleven VLOOKUP tricks including how to use VLOOKUP with the TRIM function to remove spaces from first column of lookup value.
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 44th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the SKEW function to calculate the skew in a distribution of data.
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 36th installment in his "Excel Business Math" series of free video lessons, you'll see how to make credit card calculations using the ROUND function.
Looking for a primer on how to create and work with arrays 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 2nd installment in his series of Excel array formula series, you'll learn how to use the array TRANSPOSE function to transpose a table, switching rows and columns to columns and rows.
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 536th installment in their series of digital spreadsheet magic tricks, you'll learn how to list all modes in a given multimodal data set using Excel 2010's MODE.MULT 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 385th installment in their series of digital spreadsheet magic tricks, you'll learn how to generate random letters without RANDBETWEEN function using the formula =CHAR(65+INT(RAND()*26)).
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 370th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to even and odd numbers using a TRUE/FALSE formula with the MOD 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 347th installment in their series of digital spreadsheet magic tricks, you'll learn how to round to an increment when you do not have MROUND 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 341st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX and MATCH functions together to retrieve a cell reference that the OFFSET function can use for its reference argument.
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 332nd installment in their series of digital spreadsheet magic tricks, you'll learn how to insert text into a test string with the REPLACE function as well as how to insert a part of a product ID into a longer product ID.
