Looking for a primer on how to create and work with array formulas 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 12th installment in his series of Excel array formula series, you'll learn how to create array formulas for stock portfolio return & standard deviation.
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 254th installment in their series of digital spreadsheet magic tricks, you'll learn how to do contribution margin income statement analysis across various units using a one-variable data table.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about the QUOTIENT and MOD functions. Note that, in urder to use these functions, you'll need to install the analysis ToolPak. For more information, watch this Excel how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using LEN to count word length. To get started using the LEN function for yourself, watch this how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using a pivot table to summarize data.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about adding hidden comments (and metadata more generally) to data cells. For more information on commenting, watch this Microsoft Office Excel how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about Using COUNTIF function to count the number of As, Bs and Cs. For more on using the Microsoft Excel COUNTIF fucntion, watch this how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using the HLOOKUP function to generate adaptable grades from marks. For more on using HLOOKUP across multiple documents, watch this Microsoft Office how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about concatenation using LEFT and RIGHT functions. For more information, watch this Microsoft Office how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about concatenation using cell references only. For more on textless concatenation, watch this MS Office how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about stringing text and data together by using an ampersand (&) concatenation. To learn more, watch this MS Office how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using conditional formatting in Excel to change background color. To get started learning about conditional formatting, watch this MS Office how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using VLOOKUP in one worksheet to look up values located in a second worksheet. For more on using VLOOKUP across Excel worksheets, watch this MS Office how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using VLOOKUP to look up values located in a table. To learn more about VLOOKUP, watch this MS Office Excel how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using nested IF functions to calculate a grade from an average mark. For more information on using conditional statements, watch this MS Excel how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using '$' to prevent excel from changing formulae when copying or filling ranges. For more on absolute cell referencing, watch this Microsoft Excel how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using Excel to calculate average values and to pick max and min values. For more on this handy feature of Excel, watch this how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about simple addition, subtraction, multiplication and division in Excel. For more on using simple formulae, watch this video how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this Excel tutorial, you'll learn about simple formatting, background colour, gridlines, alignment. For more information on formatting spreadsheets within MS Excel, watch this helpful how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. This Microsoft Office video tutorial presents an extremely introduction to Excel. In it, you'll learn about names of bits and really simple formatting. To get started using Excel for yourself, take a look.
Check out this instructional science video that demonstrates how to extract DNA from a banana. This is a great science experiment for students and kids to perform by following the simple step by step instructions outlined in this science tutorial video. Extract real DNA from a banana and analyze it under a microscope.
A PivotDiagram is similar to an Excel PivotTable report: It arranges data in a visual way. Check out this tutorial and learn how to look at the same data from different angles to establish and analyze relationships that you might miss in a table or a worksheet.
This video is a step-by-step analysis of each of the moves of the first bo kata, shu shi no kon, including what attack you are blocking and striking point on the opponent. A great way to learn these moves.
Most of us have probably seen excellently mastered or remastered photos and pictures and you can't help but wonder how someone can make a picture look so good! A computer software called Photoshop allows you to make vivid, realistic and creative images through a vast array of tools and settings. This easily followed video tutorial will quickly guide you in how to make an actual photo look as if it was hand drawn! Make sure there is a person in the photo! It also helps to have a wall-like feel...
Android has had predictive text for a while now, both with stock and third-party keyboards such as Fleksy, SwiftKey, TouchPal, et al. Apple is even getting on board, with stock predictive text and third-party keyboards for iOS 8, slated for public release later this year.
Looking for a primer on how to use "FlashMemoryToolkit" to analyze your flash memory-based devices? This clip will teach you everything you'll need to know. It's easy! So easy, in fact, that this home-computing how-to from the folks at Britec can present a complete overview of the process in just over two minutes. For more information, including detailed, step-by-step instructions, take a look.
This screencast tutorial from Matthew MacDonald, author of Access 2007: The Missing Manual, shows you how to use pivot tables to analyze data in Microsoft Access 2007.
This film is about gold. Gold diving. Use of the hookah rig to find gold. Gold flakes, nuggets, and platinum nuggets are shown. Gold and platinum are 15-19 times heavier than other streambed materials and concentrate in low pressure areas and cracks that run across rivers and streams. You look for a crack on the bank, and follow it out until you meet the "gold line" and there you suck it out with your dredge. Gold will be on the outside edge of a river gravel bar, at the head of the bar (larg...
Minecraft presents a vast, seemingly never ending landscape for exploration. How do you cover all of that ground? This video will show you how to build a train station, including a minecart call button and automating station. Watch this video to learn how to make a minecart train station in Minecraft beta.
People respond so much better to requests when you add the word "please" in front of them. So if you're stuck in a foreign, Spanish-speaking country, it's vital that you add "please" when necessary to establish good manners, so that people will help you out.
Let's be honest here: While the web opens up a whole new, vast world of dating opportunities, it simultaneously opens up the possibility of creeps, stalkers, and just plain crazy types.
How awesome would it feel to be a sexy undead ruler of a vast vampire kingdom? Only Sophie-Anne LeClerq, played by Evan Rachel Wood, would know, though she seems pretty happy in her position. The teenage vampire queen of "True Blood" is one sexy diva, wearing very retro makeup and hair.
This video goes out to all you Final Fantasy VII fans. Watch and learn how to create an ISO file to install and play Final Fantasy 7 PC. If you want to continue your journey through this storyline, this is the way to go. In order to play, you need to make the ISO files and burn to a disc.
Mastering Adobe Photoshop is quiet challenging and artists can find the transition from brush and canvas frustrating. Learning how to transition your artistic skills to the electronic arena can really offer a vast array of opportunities. Follow our artist as he takes us through the steps of creating a mountain landscape using the common tools in Photoshop. You will be amazed as our expert Photoshop artist creates an attractive mountain landscape in less than ten minutes, taking the viewer thr...
n this tutorial, we learn how to balance chemical equations. This is a straight-forward concept to balance out both sides of the equation of chemicals. To start, you will need to analyze how many atoms in each chemical you have on each side. Once you do this, you will need to find what you can multiply by on each side to make them equal to the other side. Once you do this and have equal atoms on each side, then the equation will be equal. Remember that you cant have a half of an atom, so that...
This video presents how to defragment and shrink a Windows Vista partition using Perfect Disk 2008 Professional program.First you need to download and install software application named Perfect Disk 2008.Type Perfect Disk 2008 into Google search engine, choose first link from the list.On the Raxco software home page choose Free Evaluation option from the list to the right.Download and install Perfect Disk 2008 Professional.Once it is installed, run the application. From Menu choose Analyze op...
Looking to get an FHA loan? The Federal Housing Administration, FHA for short, provides mortgage insurance on loans made by FHA-approved lenders throughout the U.S. Here's how to get your FHA-insured loan. Learn how to get one with help from this video.
Looking to get your family together somehow? Why not a family portrait? It's both a great keepsake and as an excuse to get everyone together. In this video, learn how to snap a great family portrait.
Using a technology we like to call "Hive Computing," several Android apps allow you to contribute idle processing power to help further scientific research. This basically means that when you're not using your phone or tablet, it can join forces with other idle devices to form a supercomputer that scientists can use to potentially make a world-changing breakthrough.
The best thing about going Gaga for Halloween is the variety of possibilities. Lady Gaga's wardrobe is vast and colorful: the Meat Dress, her trippy Anime Eyes, the scantily clad Caution Tape look, the Soda Can Hair Rollers, the light up Gothic Crown, the Cigarette Smoking Glasses, and, of course, the classic Hair Bow from Poker Face. It's my personal favorite, and the following illustration is easy to follow. If you don't feel like messing with your own hair and have a wig around the house, ...
