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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn about a robust formula for counting unique items in a list using the SUMPRODUCT, COUNTIF and an array formula component. You'll also see an array formula that uses SUM, IF, FREQUENCY, MATCH and ROWS functions to achieve the same.
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 119th installment in their series of digital spreadsheet magic tricks, you'll learn how to determine if a particular item is in a list of items using two formulas: a ISNUMBER & MATCH function formula & a COUNTIF function formula.
This how to video is about how to transfer items from List box To Listbox by using two different forms. This video is set to some interesting techno music in the background. It is presented by VB net. The man who made this video made it because of a request he received the night before from someone. This is a tutorial that is an on screen video of a computer screen probably using some form of hypercam to show the process. He creates a random list of items in each of the list boxes and forms i...
With help from this free video tutorial, you'll learn how to style list items with CSS. Whether you're using a fancy WYSIWYG (or what-you-see-is-what-you-get) page editor like Adobe Dreamweaver CS5 or a barebones text editor like Notepad, if you want to build websites, you'll need to have some understanding of HTML (for the structure of your web pages) and CSS (for their style). And this free coder's guide will get you started along that path.
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 170th installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting to hide or show items in a list using a TRUE/FALSE formula.
Want to program your own Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will have you coding your own Java apps in no time flat. Specifically, this lesson discusses how to use the Collection framework when writing code in the Java programming language. For more information, including detailed, step-by-step instructions, watch this helpful programmer's 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 156th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will check two tables and find the values that do not match and then create a new list.
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 187th installment in their series of digital spreadsheet magic tricks, you'll learn two different array formula types for creating a unique list of items for a large list containing duplicates.
In this video, Gary from MacMost demonstrates how to select items on a Mac computer. He explains that there are different ways of selecting items, both with the mouse and with the keyboard. Click to select a single item, and click an empty space to clear the selection. Hold Command or Shift to add to a selection or remove items from the selected group. Drag around an area to select multiple items, and use Command and drag to add more areas. To select items in a list, click to select a single ...
Market boxes are an integral part of the player experience in Animal Crossing: Pocket Camp, but using them effectively can be a tricky task. The item-trading tool between human friends is the locale for both junk and diamond-in-the-rough deals, and it can greatly increase the number of bells you earn if you play your cards right.
Duplicating, or "duping" items has been around for as long as PC RPG's, and allows you to use glitches to duplicate your items in the game. This video will teach you how to use the stunningly easy-to-use dup glitch in Dragon Age 2 to duplicate as many of any item you have 2 or more of your want, up to 999. This essentially gives you unlimited money and items.
I love the holidays, but man am I sick of receiving oversized sweaters as Christmas presents. As well as people think they know us, their gifts often say otherwise. Instead of stocking up on useless items and articles of clothing you'll never wear, it's high time to create a wish list that's easily sharable amongst family and friends, and it's incredibly easy to do on Android.
In this Computers & Programming video tutorial you will learn how to Use save file dialog and stream writer with a list box in VB.Net. Open up a ListBox and you will have a ListBox1 with a blank text box, Add Item and Save Item buttons on your screen. It will also have a save file button at the bottom. On the top of the panel, click Form1 and thereafter, the video shows the various parts of the code on the screen. Then click on Debugging, and add text in the blank text box and click Add Item....
hether 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 43rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the MATCH function to find the ordinal position (relative position) of an item in a list.
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 627th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create, edit and otherwise work with FREQUENCY array functions.
This video involves beauty tips on how to get rid of chapped lips. The video starts out by listing items needed to take care of chapped lips; the first item listed is chap stick. The video specifically recommends a chap stick that has SPF protection. The other items needed are a tooth brush and a clean towel. The video next explains to rub chap stick on your lips. Next, a tooth brush is used on the lips in circular motions to remove dead skin cells. The purpose is to allow your lips to heal m...
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 381st installment in their series of digital spreadsheet magic tricks, you'll learn how to merge two lists into one list while keeping unique items from list 1 and list 2 and removing duplicates.
If you use Google Keep, you'll be happy to know that you can add items to lists and even start new ones with "OK Google" voice commands on Android, and it works fairly well. (Hat tip to Reddit user rambantu for finding this trick.)
This video will go over how to insert a check box in Microsoft Word for printing or for electronic distribution. With just a few clicks you can get a check box. You can even add different symbols or styles for your check box.
Android's share intents system is great in theory, but the execution can sometimes be frustrating. When you tap the "Share" button next to a link, app, or file, you see a list of apps you can share that item with. But it seems like every time you use this function, the list of apps is in a different order — especially when it comes to the Direct Share targets at the top.
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 609th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the COUNTIF, IF, COLUMNS, INDEX, TEXT, SMALL and COLUMN functions in an array formula to return multiple items (e.g., list free periods for a list of students).
We've all been there. Lost in the supermarket for what feels like hours trying to figure out where the hell the macaroni and cheese is and why it isn't with the rest of the pasta items. The labels at the top of the aisles aren't always helpful or accurate, and items often get misplaced or lost in the masses of food on each shelf. Thankfully, the augmented reality gods have answered our prayers as a new demo shows the future of finding the items you need using Apple's ARKit.
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 309th installment in their series of digital spreadsheet magic tricks, you'll learn how to check to see if an item in first list is second another list, even if there is text before or after the item using the LOOKUP, SEARCH and ISNUMBER functions.
Rafael and Zappos How To demonstrates how to pack your luggage efficiently. First, make a packing list to determine what you will need to bring on your trip. Go through your day in your mind and add things to the list accordingly. Don't forget your toiletries. Ideally bring one pair of shoes and coordinate your wardrobe accordingly. Lay out everything you will be packing and group them by like items. Don't put piles in your suitcase. Instead, roll your garment to prevent wrinkles and save spa...
Buttermilk is a great thing to have around in your kitchen. Unfortunately, most of us don't have buttermilk on our regular grocery list, so those buttermilk pancakes will have to wait for another day. Think again! You can easily make tasty buttermilk alternatives with common refridgerator items. This video will show three easy ways to make a buttermilk substitute.
HBO Max's watchlist, dubbed "My List," is a great tool that lets you collect and sort the video content you're interested in. That way, you don't need to sift through HBO Max's enormous catalog every time you open the app — just open your personal list of saved titles and start binging.
The checkbox component is a useful addition to websites in a myriad of ways, which will allow your users to add or remove chosen items from a particular list. This tutorial shows you how to create a dynamic checkbox list and add it to your website.
This how to video shows you how to use drop down lists in Microsoft Excel. This will be useful for stores and avoiding people ordering items that are not available. First, type the items in a column. Select them and then click in the name box. Type the name of the list. Note that it must be one word. Now, go back to the order sheet. Select the cell where you want the list to be placed. Go to data and select validation. On the settings tab, choose list and type in = and list name. You can pres...
In this video, the instructor shows how to schedule tasks in Microsoft Windows XP. Scheduled tasks are nothing but programs you want your computer to run at specific reoccurring intervals like daily, weekly, monthly, etc. This can be a very helpful feature if you want to update a particular software or run a system virus scan at regular intervals. To do this, click on the start button and go to run. In the Run command prompt, type in 'tasks' and hit enter. Now this opens up the schedule tasks...
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 724th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if quantities are the same in two lists and show the differences if not, list the word "equal" if they are the same, and "not in list" if the lookup items is not in list using the MATCH, INSA, VLOOKUP and IF functions.
Back when I was a kid, I didn't get many awards or trophies, aside from perfect attendance three years in a row. If only there was an award for procrastination. While there are apps out there for my iPhone like Clear and even the stock Reminders app, they still don't push me hard enough to get things done on time—or at all.
This is a Computers & Programming video tutorial where you will learn how to startup configure a Mac. This is a very simple, easy and quick process. In order to change what programs start when you switch on your computer that is running on Mac, first go to ‘System Preferences’ from the drop down menu and then click on System Accounts. In the next box that pops up, go to ‘Login Items’. Here a list of programs will be displayed that run when you start up your computer. Here you check box next t...
In this how-to video, you will learn how to speed up your computer for free. You need a computer running a Windows operating system and access to the Microsoft Configuration Utility. First, open the start menu and click on run. Once this is doing, type in "msconfig" and click okay. Press the startup tab on the window that has opened. Here you will see a list of items that start when the operating system starts. You can uncheck the items that are not required to properly run the system. You ca...
If you want to sell all of the old electronics lying around your home, it takes a lot of work. If you go the eBay route, you have to take tons of pictures, describe it accurately, wait for a week until someone bids on it (or not), then package it, ship it, and wait for feedback. Craigslist is a little bit easier, but usually requires you driving somewhere to meet the buyer in a public place (if you want to play it safe).
Apple makes it easy to access your favorite and most recently used applications and documents in Mac OS X. You can simply add your favorite apps and folders to the dock, and you can always visit the Apple menu from the menu bar to see a list of your most recently used apps and docs.
Starcraft 2, like it's predecessor before it, has a very robust level editor that allows you, the DIY modder, to create nearly any scenario within the bounds of the Starcraft 2 engine that you could imagine. We have compiled videos on how to do all sorts of fun things with it, from making RPG's and Tower Defense games to just making you dream Starcraft 2 level. This video will teach you how to work with items and loot in your custom levels. You'll learn how to create items, create ancillary i...
Checkboxes let users to your site select or deselect items in a list (such as adding products to a shopping cart or selecting multiple answers to a quiz or poll). This tutorial shows you how to build and incorporate checkboxes to your website or other Flash project.
Because life's just not fun unless someone is getting pranked. Whether you need to pull these pranks out for a party or to get back at your younger brother for stealing that last piece of fried chicken, you'll learn a whopping list of 8 different pranks in this video.
It seems like there's never any breaks in air travel when it comes to money. The airfares just keep rising, and now most major airlines charge for all checked baggage, so carry-ons are the way to go. But you need to know how to take it easy with your packing list. Pack light and travel without the burden of that extra $15 or more per bag.
