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 19th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHOOSE and RANDBETWEEN functions to randomly generate words.
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 328th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP when you do not have a first column to use for lookup.
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 319th installment in their series of digital spreadsheet magic tricks, you'll learn how to run a VLOOKUP in reverse order using the INDEX & MATCH functions and custom number formatting.
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 321st installment in their series of digital spreadsheet magic tricks, you'll learn how to match text substrings with an array formula that uses the AND, ISNUMBER and SEARCH 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 323rd installment in their series of digital spreadsheet magic tricks, you'll learn how to run a partial text lookup query using a VLOOKUP function with wild card criteria.
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 277th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUBSTITUTE and Morefunc EVAL functions to take a text string series of numbers and add them.
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 191st installment in their series of digital spreadsheet magic tricks, you'll learn how to how to extract part of a text string using a formula with the functions MID, LEFT and FIND.
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 579th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MOD function and date math to create a column of dates where each successive date is repeated twice.
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 578th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to grade student answers where more than one possibility exists using the IF and OR 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 181st installment in their series of digital spreadsheet magic tricks, you'll learn how to count words (case sensitive) using the SUM and EXACT functions in an array formula.
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 175th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT function and an array of TRUE & FALSE to count values between an upper and lower bound.
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 145th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will calculate the median when you have more than 1 criterion.
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 Excel tutorial from ExcelIsFun, the 554th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to weekends and holidays with Excel's NOT and NETWORKDAYS functions.
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.
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 Excel tutorial from ExcelIsFun, the 263rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a completely dynamic math equation system (function of x) with formulas, data points, charts and chart labels.
This video walks you through the steps of graphing quadratic funtions. This excellent video shows you a clean blackboard, with the instructors voice showing exactly what to do. Don't fret, any question you may have, will be answered. Watching this video will make you feel like your back in the classroom but rather comfortably from your home.
One of the first things you may want to know when learning how to animate in Flash is how to orient an object to a path — the path, in turn, serving as a sort of metaphorical track for your Flash element.
Canon recently released a firmware update to fix a lot of the v.1 bugs. This tutorial explains the process of updated the firmware from downloading on the Canon site to easily installing it on your camera.
You got a hold of some old vintage "sound transferring thing" on eBay... If it's a Goko, you're in luck. In this video, learn the basic functions of a Goko TC-20 Super 8mm sound film transfer machine.
A below elbow arm amputee demonstrates the device he uses in the gym. He shows you how to use a prosthetic for working out at the gym when you've suffer a limb amputation. This video is very helpful in describing utilities available for enabling individuals with amputations to workout or get around and function in a gymnasium setting. This is a video that addresses adaptive equipment for handicapped or disabled people.
Towel Hooks add function and a casual elegance to any style bathroom. AsktheDecorator.com host Meghan Carter demonstrates how to position all towel hooks and complete a towel hooks installation job. Why settle for messy towel bars when towel hooks keep a bathroom neat and tidy, while being stylish? Watch this how to video and learn how to install towel hooks when remodeling your bathroom.
Have you just installed Windows or are you looking to improve Window's performance. Learn how to make Windows function faster and more efficiently by adjusting system settings and using a few free tweaking programs.
Do you have an old computer that may be too slow to play video games? You may think it's totally useless, but CNET Video teaches you how to turn it into a network server that functions as a centralized depository for your files!
If you're paranoid about the security on your web-browsing activities, fear not. This Firefox add-on, called HTTPS Everywhere, was created by the Electronic Frontier Foundation (EFF) to help you protect you from curious sites. Installing this add-on will make most websites default to the more secure version.
In this tutorial, we learn how to block websites on Windows Vista. First, you will right click on the notepad and then run as admin. From here, you will click "file open". Then, go to the C drive and open up windows. Then, you will go to the system and find the drivers, then click on the host file. From here, go to the second local host and press enter twice. Then, type in "127.0.0.1" and press tab. Then insert all the directories that you want to block. From here, you will be finished blocki...
A scrollbar adds a little bit of user interactivity to your website, letting visitors navigate and helping you optimize page space as well. This tutorial shows you how to utilize the scrollbar component when you're building a website in Adobe Flash CS3.
Want to know how to block websites on a Windows XP PC by editing the HOSTS files? 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 five minutes. For more information, including step-by-step instructions, take a look.
In this clip, learn how to access and use the JAM! app for your iPhone or iPad to update your website from afar. Keep your visitors up to date on the go with this handy application. This tutorial will walk you through the steps you need for connecting JAM! to your computer and getting started.
To hack into Google images follow the following steps. You will first need to open a new internet browser window and go to Google, then load their images website. Next type into the search bar your image query and press search. Once you have gotten your search results paste the following code into your address bar:
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 cell phone.
Check out this video tutorial on how to use the Band Website Template. This is just a quick tour of it, explaining why it was built and why it can be useful for bands and their web designers. So, if your a band or a CSS web designer, check this out, because you're Internet page isn't getting any prettier.
Now that Thanksgiving is less than a week away, the holiday season is in full swing. And that means you're probably busier than ever, what with all the decorating, cookie baking, and present buying and wrapping.
In this video, we learn how to make a blog website on Blogger. First, go to Blogger and set up your account. Make sure to enter in all the correct information, then at the end you will be sent a confirmation e-mail. Once you verify your e-mail and information, you can get started with your blog. You can set up a layout and change the font and colors as you prefer. You can start to type in all your daily blogs and have other people start to bookmark yours. You can also watch other people's blo...
Google is the biggest and best search engine on Earth, and if you are a webmaster and want your website to be a big success it would really behoove you to know as much about how it works as possible. The Google Webmasters series of videos and website were created to teach webmasters, SEO professionals, and others how Google works by answering their questions and giving them insights into how they can best integrate and utilize Google's functionality to improve their business. This video will ...
Google is the biggest and best search engine on Earth, and if you are a webmaster and want your website to be a big success it would really behoove you to know as much about how it works as possible. The Google Webmasters series of videos and website were created to teach webmasters, SEO professionals, and others how Google works by answering their questions and giving them insights into how they can best integrate and utilize Google's functionality to improve their business. This video will ...
Google is one of the most powerful forces on the Internet, and their technology can be the key to helping you find success in whatever your online endeavor might be, from web design to filmmaking. This video is a part of their Google Webmaster Series, offering help to webmasters the world over on how to best utilize Google in their work. This video will show you how to restore your Google ranking after your website has been hacked. Hopefully you never will be, but if you are this video is her...
In this video tutorial, viewers learn how to run 4 Google searches in 1 tab. This task is very easy, simple and fast to do. Begin by opening your web browser and go to the website: GoogleGoogleGoogleGoogle. There, users will be provided with 4 windows of Google. There users are able to navigate 4 Google searches at once. Users are also able to close windows and type in website URLs. This video will benefit those viewers who use Google frequently, and would like to learn how to be able to make...
Are you using your website or blog for exposure or business? If you would like more people on the web to notice your masterpiece, check out this clip. In it, you will get real, helpful tips on how to get people to your site, so they keep coming back. There are plenty of ways to promote yourself and you will learn all about them here. So, grab a pen and take some notes and get ready to become the next Internet superstar.
Interested in creating your own website? Have access to a copy of Dreamweaver CS3? This video guide will get you started. Whether you're new to Adobe's popular WISYWIG HTML editor or a seasoned web development professional just looking to better acquaint yourself with the CS3 workflow, you're sure to be well served by this video tutorial. For more information, including a step-by-step overview, watch this free video guide.
Needing to load website content with AS2 into Flash? You've come to the right place. In the following video, learn how to load text from a text file sitting on a web server and display it in Flash using dynamic text and Actionscript 2.0. Also taught? How to load a jpg, gif, png, and/or swf file using Actionscript 2.0. All files loaded into the flash movie within this video will be loaded from an external web server.
