Microsoft excel is a powerful tool used to work with numbers and data by filling them down in rows and columns of a table. Excels also supports macros, which are small scripts to automate certain functions. In Microsoft Excel you can select entire rows and columns using the ra ...more
In this video tutorial, viewers learn how to define an indefinite integral in calculus. Finding the anti-derivatives of a function is called anti-differentiation. The f(x) is the derivative of F(x), while F(x) is the anti-derivative of f(x). If F(x) is the anti-derivative of f ...more
When using Adobe Photoshop being able to crop and resize an image is essential. This live demonstration shows you step by step directions for these useful functions. To crop, select a certain area and hit enter, everything not selected will be deleted. If you mess up you can u ...more
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. With this video tutorial from ExcelIsFun, the 376th installment in their series of digital spreadsheet video tutorials, you'll learn how to an array formul ...more
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 202nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more
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 273rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the top (i.e ...more
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 480th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate a percen ...more
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 518th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, SMA ...more
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 533rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula t ...more
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 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub ...more
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 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt cel ...more
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 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two cond ...more
In this video tutorial, viewers learn how to simplify expressions involving numeric radicals. This can be very frustrating to work with if you have not memorized the tables of square, cubes and fourths. If you are taking the square root of a number that is not a perfect square ...more
In this video tutorial, viewers learn how to simplify expressions involving algebraic ratios. In some ways, simplifying algebraic radicals is easier than numeric radicals. When we are working with square roots, we need to find the highest even power of a variable to act as out ...more
JustMathTutoring This video shows the procedure of finding derivatives using the Chain Rule. The Chain Rule states that the derivative of a composition of functions is the derivative of the outside function evaluated at the inside multiplied by the derivative of the inside. Th ...more
Mastering your Excel skills? Have a busy Excel workbook or spreadsheet that needs to some organizing? In this two-part tutorial, learn how to pull text from cells & separate them into multiple columns in MS Excel. You will learn how to use the LEN(), FIND(), LEFT(), and RIGHT( ...more
This how-to video is about how to enable the commenting tools in the free Adobe Reader using Acrobat 9 Pro and Acrobat 9 Pro Extended. To do this, open any PDF document and go to the "comments" menu and select "enable for commenting and analysis in Adobe Reader". Once we choo ...more
In this tutorial, viewers will learn how to use the synthesizer functions of the Yamaha PSS-780 keyboard. Starting with the basic piano voice, the presenter shows how this can be modified to create a new sound. He shows how the attack rate of the sound can be modified with one ...more
This instructional video by GoogleNexusOne shows you the features and how to set up a recently unboxed Nexus One Android phone. First the functions of the indicators and buttons are explained, and the different ports and jack are highlighted. After that the back of the phone i ...more
Here you'll be shown how to take the equation of a circle, and convert it into standard form. Also, it will be explained just what standard form is, while running through the process of conversion. You'll be able to use techniques to quickly work off the numbers on the equatio ...more
Bruce Dorn from Canon breaks down the exposure and Speedlite controls on the Canon 5D Mark II. His explanations are especially helpful as he gives certain shooting scenarios in which tweaking these settings will improve your overall image quality. Explorer of Light Bruce Dorn ...more
Get to know how to use Logic Pro's arrange page in this short tutorial. Use the arrange area to work with the audio of your song. Change the timeline by choosing a time and beat. Use the toolbar area to do some functions. Use the icons to easily open up media and list areas. U ...more
iTunes offers the ability to extract and copy data with its rip and burn functions. Ripping lets you import songs into your iTunes library from a variety of sources. Burning lets you write audio files on to a CD. Once you customize the audio file playlist that you wish to have ...more
Dan Larsen from Elevate Polymeric shows us how to complete a polymeric drill. By practicing this drill frequently you can increase your ability to run faster, jump higher and improve your agility. Great for runners or any athlete! If you've never heard of polymeric exercises b ...more
This video shows you how to get the quadratic equation for the quadratic function with roots; (5,0), (12,0) which passes through the point(8,6). It shows a man solving this problem using a black board and chalk to clearly demonstrate the method of plugging in the respective co ...more
This video shows the details of DNA in the process of understanding their functions. The video is simple and easy to understand. The video starts with the description of the basic structure of DNA. It describes the various components of DNA. The video describes the base pairs ...more
A video from PC Remedies that explains how to transfer your personal files from your Old-PC (Windows XP) to your New-PC (running Windows 7) using Windows Easy Transfer. The entire procedure is explained in a simple way showing all the steps required to achieve the above. This ...more
A video from free math tutoring that teaches you a method of factorization of a complex polynomial. The tutor shown in the video demonstrates how to factorize common functions of a variable by the factor method. This video isn't for advanced learners of mathematics. It is for ...more
Illustrator is a great tool for creating individual artwork. Creative and clever, it has many functions, one of which is mosaic. If you want to make your illustration or design appear to have a myriad of tiny 'squares' like a Roman mosaic, this guy can help you do it. The shor ...more
Ever dreamed of becoming an architect? Well in this video, the viewers will be instantly thrown into the world of an architect. The video demonstrates and shows how to design like an architect with nothing much than just asymmetrical designs. The video goes in-depth with the i ...more
If you want to be serious about using Adobe Illustrator, then learning how to use type is an essential part of your skill set. Type can help you with a wide range of assignments, from designing logos to image building and much more. There are a number of settings and functions ...more
In this three-part video tutorial, learn how to manage loans with an amortization table in Excel. The three parts of this video go over the following: Part 1: Create a mortgage (loan) payment calculator with an amortization table (payment schedule) for detailed payment inform ...more
Hacker Defender is one of the most widely deployed rootkits in the world. It is a user-mode rootkit that modifies several Windows and Native API functions, which allows it to hide information (files, processes, etc.) from other applications. In addition, Hacker Defender implem ...more
Check out this instructional DJ video that shows you the basic and advanced features of the black VCI-100 Special Edition designed by Ean Golden for Vestax. This tutorial covers the basics of the unit in the first part, to the advanced aspects of the unit in the second video. ...more
In this Rhino video tutorial we cover how to make a sine and cosine curve with Explicit History (Grasshopper). The initial set up for this Rhino tutorial can be used to test any of the math functions. We set up a a simple interface to drive range parameters which can then conn ...more
Cosmo Crow and Mark Hannah take you on a tour of the Sony DSR cameras in these how-to videos. The first video segment deals more with setting up the camera tripod. Then, Mark and Cosmo continue their tour of the Sony Camera with an in depth explanation of the Lens and all its ...more
Lymphatic drainage helps to detoxify your body, which has several functions: Removing free radicals, clearing up your skin, and giving your more energy and immunity to diseases and sickness. Sounds pretty good, right? Best of all, lymphatic drainage massage is a very pleasant ...more
This is a simple Adobe Flex Photo Viewer. It uses a number of techniques that are not found in any one place in the literature - data shorting, tile repeater, xml http services, inline mxml actionscripting, click on double functions, use of CDATA Tags, tooltip, glow and fade e ...more
In this video tutorial you will learn about a very powerful feature in Houdini called Copy Stamping. This is a very simple introduction to how a stamp function is defined in a copy sop. We then generate a series of stamp functions applied to a box, copied to a stationary grid ...more
While we personally like to learn a new software program by playing around with its buttons and various functions, sometimes it's a nice primer to actually read the instruction manual. And when it comes to video editing, knowing the particularities of each and every function i ...more
This 3 part Movie Maker tutorial explains all the main functions of Movie Maker and how to use them. Part one starts with importing video clips, editing clips, adding video effects and transitions, etc. Part two covers basic sound control, adding titles and credits, and puttin ...more
Shows how the BMW HD Radio & iPod Kit Integration Kit by DICE functions and is used. (This kit works for most 1996 and newer BMW's). This video demonstrates: Controlling your HD Radio in your BMW, setting presets and browsing presets. Part 1 of 2 - How to Use a BMW HD radio an ...more
Motion trails in Autodesk Maya can be very handy at times when animating your scene. Keying a bone/joint or other object every so many frames can take up quite a bit of time and can sometimes be a big hassle, too. I have found many times when I could have really used one. I al ...more
Google Chrome is finally here, and everyone can benefit from a faster, streamlined web browser. This video will cover all the basic functions and features of the new Chrome we browser, so if you're thinking about switching, this is a must-see. Google claims their new browser ...more
This video is a useful one to restore sound in our PC. If the audio or sound systems does not functions in your system this video will surely help. This video has many solution to the problem and any of these solutions will certainly help you to rectify the problem. First this ...more
This video shows you how to connect your laptop to your mixer. First you will need two different sound sources from your laptop to your mixer. This is so that you can use all of your mixer functions on two different channels. The way to do this is to run a 1/8" RCA cable chann ...more
This video tutorial is going to show you how to use Skype over the 3G network on your iPhone. For this purpose you will need a jailbroken iPhone. Go to Cydia and launch it. This will take a bit of time. Make sure you have the latest Mobile Substrate & Skype. If not, follow the ...more
In this video the instructor shows how to repair the volume on your iPhone. This video advices caution and is not responsible for any damage caused to your property. While using iPhone people often face different kinds of problems with volume like low volume or no volume at al ...more
This innovative handset makes user convenience its priority. Created with the aim of overcoming the limitations of existing mobile phones, every function is available through a flexible layout of navigation keys. Fixed keypads are a thing of the past with the LG KF600 Venus ce ...more
With the LG KU990 Viewty, you can take and view a crystal clear photo. Packed with high-quality camera features, this camera phone enables you to capture a high-definition image using a 5 MP camera lens certified by Schneider-Kreuznach and edit your photo on a large, clear, 3- ...more
Microsoft Excel is one of the most widely used tools in the professional sphere. It's also one that's difficult to master beyond a superficial understanding of how to input data. The All-In-One Microsoft Excel Certification Training Bundle can teach you how to make this multif ...more
Microsoft Excel is one of the most useful tools you can bring into your professional life. However, as useful as Excel is, it can also be difficult to learn on your own. The All-In-One Microsoft Excel Certification Training Bundle is an incredible tool that will take you from ...more
On iPhones, the share sheet is a powerful yet largely underestimated tool. For the uninitiated, the share sheet is the menu that opens whenever you tap the share button (the box with the up-arrow). This menu features sharing options to first and third-party apps, as well as ex ...more
For the uninitiated, it can be difficult to buy that special hacker in your life a perfect holiday gift. That's why we've taken out the guesswork and curated a list of the top 20 most popular items our readers are buying. Whether you're buying a gift for a friend or have been ...more
The road to becoming a skilled white hat is paved with many milestones, one of those being learning how to perform a simple Nmap scan. A little further down that road lies more advanced scanning, along with utilizing a powerful feature of Nmap called the Nmap Scripting Engine. ...more
A core concept that has resonated through societies of the world over the course the last few hundred years is "knowledge is power." And understanding that concept gives us the drive to push further forward and learn as much as we can on a subject. At the moment, that subject ...more
The next-generation Audi A8 to launch in July is expected to be the world's first Level 3-capable production car to go on sale in retail channels. But aside from demo drives scheduled for journalists and analysts Audi plans to organize this month, the model's advanced driving ...more
The problem with HIV is that it attacks and kills the very cells of the immune system that are supposed to protect us from infections — white blood cells. But a new technique, developed by scientists at The Scripps Research Institute (TSRI) in La Jolla, California, offers a di ...more
The evolution of our infection-fighting systems may have something to teach modern scientists. That's what a group from the University of Granada in Spain found when they studied a protein that's been around for over four billion years. Their work, by senior author José Sánche ...more
The modern age of techno-dating has made an interesting landscape for social interactions when there is some modicum of romance (or lust). For those of us born before the internet evolved into the prolific monster it has become, we first met our love interests face to face. To ...more