In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get g...
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...
The ExcelIsFun shows how to repeat a list of names seven times. He starts out by telling you a fast way to do this. He starts out by selecting the names already typed in then he presses Control C (Ctrl + c) on the keyboard. The next thing he does is move the cursor to a different column and in the first row. He presses Control V (Ctrl + v) to paste the names into the other column. By watching this video, you will find out how to quickly repeat a list of names 7 times or more.
This step-by-step instructional video shows how you can do it yourself for your next party or event decorations. Air and helium filled balloons were used along with other easy to find supplies. Make your obsession for twisting balloons useful.
The low price of speakers and MP3 players today make them ideal for adding a bit of sound to different items, and this tip from CNET reveals a few ideas. Add an MP3 player and a pair of speakers to a decoration, for example.
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 616th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the LARGE and SMALL functions to retrieve the 1st, 2nd, and 3rd largest values from a list. You'll also see how to do each of the following:
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 473rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract a unique list from a group of individual rows.
The low system requirements of Minecraft make it ideal for playing on an Android smartphone. If you're looking to find out how to download, install, and play Minedroid, a version of Minecraft designed for your Android phone, take a look at this walkthrough and check out the download options below.
Check out this video for creating a one piece mold using a repro laminating system. This is a professional video not for beginners. The repro laminating system is ideal for working on medium-sized projects, this process is easier, faster, and more economical than the epoxy laminating system. This process can be used in automotive, mechanical, fine art and film special effects uses.
Check out this video to learn how to make a professional epoxy fiberglass layup and epoxy laminating systems. This process is ideal for working on larger projects, a typical 'fiberglass layup' is a popular process for those who need a large, strong, and lightweight tool.This process can be used in automotive, mechanical, fine art and film special effects uses.
Check out this video for how to create simple one piece silicone rubber molds. This technique is ideal for smaller projects (less than 12" x 12"), this is the easiest process for creating parts, patterns, tools, & molds. We demonstrate creating a silicone rubber mold and then the casting of parts with Repro, epoxy casting resins and polyurethane elastomers. This process can be used in automotive, mechanical, fine art and film special effects uses.
Katherine and Kimberly Corp show you how to do a thirty minute (30 min) pilates workout to tone your abs, strengthen your core, and improve spinal flexibility. This is ideal for beginners, and advanced practitioners looking for a challenge.
Slack recently released a dark mode for its Android and iOS apps, and for the most part, it works great. Super dark gray backgrounds and light gray fonts, which is much easier on the eyes than blinding white backgrounds and black text. But there's one thing that is not affected by the new night mode setting — your sidebar.
The Start menu is finally back in Windows 10, but a lot has changed since we last saw it in Windows 7. From a visual standpoint, the first difference you'll notice is the addition of live tiles, which occupy the right half of the Start menu and provide quick information from your "Universal" Windows apps.
When I compare my iPhone 4S to my friend's iPhone 5, I notice that his elongated screen gives him an extra row of applications. Am I jealous? Yes, a little.
This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...
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 10th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create projections for sales numbers from a database using the SUMIF, VLOOKUP and COLUMNS functions and a percentage increase formula.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 81st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to a chart by creating a new column of data with a formula.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 87th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to quickly remove rows of a table where the row has a blank in column A.
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 331st installment in their series of digital spreadsheet magic tricks, you'll learn how to extract individual characters without extracting the leading zeroes through use of the MID, VALUE and COLUMNS functions.
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 307th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, ROWS, COLUMNS, LARGE, SMALL functions to create 4 different formulas that will invert a range of values.
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 246th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a waterfall profit chart from a stacked column chart.
The fly stitch can be worked both horizontally and vertically. In this video tutorial from Needle 'n Thread, you'll see the fly stitch worked vertically.Besides working fly stitches in horizontal rows or vertical columns, the stitch can also be isolated, to create "filled" (loosely filled) background areas, or to create small accent-like stitches across a "canvas." Experiment with it! It's a fun and quick stitch!
Don't want to shell out the big bucks for some fancy, expensive budgeting software? Well, if you have Excel 2008 for Mac installed, you can manage your budget right there. Personal financing doesn't get easier than this— even business finances are easy to keep track of. The Microsoft Office for Mac team shows you just how to manage your finances with pre-formatted Ledger Sheets in this how-to video.
Please only use the information in this video if you have lost your own car key or you are helping out a friend who has lost theirs! If you need to start a car without the key, this tutorial shows you how to find the wires in the steering column to find the eight cables underneath. Here's what to look for and then what to do so you can get your car running and go to where you need to be.
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.
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 with the ROW & COLUMN functions that will in turn permit you to create a set of permanently consecutive integers.
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 13th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a column chart from a frequency distribution for categorical data.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 88th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to remove rows of a table where the row has a blank in column A using a macro.
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 471st installment in their series of digital spreadsheet magic tricks, you'll learn how to sort horizontally with 3 different formulas that use the LARGE, SMALL, COLUMNS, IFERROR and IF functions.
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 149th installment in their series of digital spreadsheet magic tricks, you'll learn how to take a value in a table and then return the row or column value when there are no duplicate values.
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 336th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROWS, COLUMNS, MOD, ROUND, and WEEKDAY functions to increment numbers in Excel formulas.
"Twas the week before Christmas and all around the house, no decorations were outside, my wife called me a louse. The columns though pretty, were tall, white and bare, it soon became clear that candy canes should be there."
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 and Mr. Excel, the 2nd installment in their joint series of digital spreadsheet magic tricks, you'll see two methods for subtracting 35% from a column of values.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 63.5th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the advanced filter "Unique Records Only" option and the VLOOKUP, COLUMN, IF, ISERROR and IFERROR functions to merge 2 tables.
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 555th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF and VLOOKUP functions to make one of two types of commission calculations based on what is put in the referral column.
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 382nd installment in their series of digital spreadsheet magic tricks, you'll learn how to match values in lists and, where there are matches, take the second column from each table and put it in new table.
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 371st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the average time between customer orders by adding a new column to a data set with an IF function formula.
Once you learn some of the basics, Excel is an easy program to use. With the use of some simple formulas, you can streamline your whole data entry process. Just by typing in =SUM you can set a row or column to show the sum of other entries. It really is that easy. This video will show how to use these formulas and take advantage of Excel date math and time formatting.
Losing weight can be a battle, but why not be realistic about your goals rather than kill yourself striving for a size 0? A happier alternative to the cycle of weight loss and gain is to achieve a weight you and your doctor can both live with. In this tutorial, learn how to calculate your BMI and ways to figure what your "happy weight" is.
