Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 58th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the Excel 2007 table dynamic range feature with a data validation drop-down list without using the table name!
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 43rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn use a data validation drop-down list to change conditional formatting in a table. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 324th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic list of dates for a data validation drop-down 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 322nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an advanced filter to extract with AND and NOT 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 212th installment in their series of digital spreadsheet magic tricks, you'll learn how to records from an Excel database/ table/list with a filter and copy-paste trick.
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 242nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a sudoku puzzle using array formulas, the INDEX function with criteria and data validation.
Want to remotely connect to your iPhone or iPod Touch from your Mac OS X computer? With an SSH client, it's easy. So easy, in fact, that this 4-minute guide can present a complete overview of the process. For the specifics, and to get started transferring and manipulating data and applications on your iPhone & iPod from your primary computer, watch this free video 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 177th installment in their series of digital spreadsheet magic tricks, you'll learn how to format a column as text numbers to avoid data validation trouble.
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 140th installment in their series of digital spreadsheet magic tricks, you'll learn how to save time in updating a system of data and information by using sheet cell references in formulas.
Creating arrays in PHP is simple once you know how. And, if you don't know how, this free video guide will sort you out. For more information, and to get started building and using data arrays in your own PHP projects, watch this programmer's how-to.
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.
Adding formatting to plain Excel spreadsheet is a wonderful way of increasing the readability and improving the overall look and feel of your data. With this software how-to from ExcelIsFun, you'll learn all about using the Microsoft Office program's formatting features. As an added bonus, you'll learn about the ROUND function, which is also useful for cleaning up charts where great precision isn't required.
Trojans, viruses, and malware can be more than a simple nuisance to your computer--they can destroy data and ruin your system. This video tutorial shows how to get rid of malicious software on your computer. When combating a virus, it's best to use multiple applications to insure system extraction.
This video shows you two methods to connect to XBox Live using a laptop. For the first method, go to your start menu and open up your control panel. In the control panel window find the area marked Network and Internet and select the option View network status and tasks. In this new window, select Change adapter settings in the left hand pane. You will be presented with another window that has your network connections listed. Right click on your Wireless Network Connection and select properti...
Steve Lee Ignacio explains the procedure to be followed to build a Bart PE Professional Rescue CD. He says that the basic requirements for completing this process is a Windows XP Pro or Home CD, a Bart PE builder, a Windows Computer, a program to burn .ISO files and a CD burner. He then explains the various steps involved in building the Bart PE CD, the first of which is to download latest version of Bart PE Builder using a search engine like Google. Then he explains the second step which is ...
In this video the instructor shows how to map a network drive in Microsoft Windows XP. Network drive is similar to the disk drive that is present on your computer like C drive, D drive but instead of pointing to a hard disk on your computer it points to a server that has enabled shares. Shares allow you to create or edit files and folders. By mapping that server share to a folder in XP you can use that share as a normal drive. To do this go to start menu, right click on My Computer and select...
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.
Veronica from Tekzilla teaches you how to monitor network activity on Windows 7. Go to ITSamples and download the Network Activity Indicator program. Install it and run it. This will add a new icon on your system tray. It blinks to reflect incoming and outgoing packets. You can right click to see a more detailed report. You also get statistics and a menu for your network and firewall settings. So to get the popular windows XP type network indicator icon all you need to do is follow the steps ...
This video shows you how to calculate weighted average cost from a transactional data set using SUMPRODUCT function. It explains things very clearly. If you're working with a very large database transactions the SUMPRODUCT function makes it. It works as text if you do the formatting first and then type the number. We put the number in first and then format as text, then press F2 and ENTER.
This video shows you how to access your iPhone if you forgot your passcode (or if someone unknowingly set one for you). Most importantly, this method details how to do this safely without losing any valuable data. Breaking the passcode on the iPhone will return it to the same condition (only without a passcode).
There comes a time in a phone's life where it needs a completely fresh start. Delete contacts, photos, and more on the iPhone using the "Erase iPhone" function.
Learn After Effects: the best digital motion graphics software programs out there.
Low battery – two words you never want to hear. Banish them with these tips. You Will Need
Tinkernut shows you how to burn CD and DVD copies. Infrarecorder is a program that lets you record music/data/mixed CD's, DVD's and dual layer DVD's.
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 stringing text and data together by using an ampersand (&) concatenation. To learn more, watch this MS Office how-to.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using Access to create a search engine type query that can adapt to fragments of data. For more on using Google-style queries in MS Access, watch this how-to.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating a table clone and appending data to it. To learn more about using append queries in Microsoft Office Access, take a look.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using mathematical operands and other logical operators to select data in queries. For more information on using logical operators in your own Microsoft Access queries, take a look.
Custom fields are a great asset to OnTime, and there are several different ways that you can use them. This installment from Axosoft's own series of video tutorials on the OnTime Project Management Suite covers creating and using custom data inside projects. Take a look.
The User Dashboard in OnTime is a great way to look at items across types and edit them. See how to view and search through data regardless of its type (Defect, Feature, Task, Incident) by taking advantage of the User Dashboard. For detailed instructions on using the dashboard, watch this installment from Axosoft's own series of video tutorials on the OnTime Project Management Suite.
Looking for an easy way to implement Ajax into your ASP.NET projects? This ASP.NET video tutorial takes a look at the Infragistics UltraWebGrid, which will allow you Ajax data access without writing any code. For more information on this handy UI tool, as well as to get started using UltraWebGrid for yourself, take a look.
In this überbrief video tutorial, you'll find instructions for adding a CNAME record to tinydns. The steps, demonstrated in the video, are as follows: Open up the data file, type a capital C, the domain you'd like to use, or subdomain, the IP address of the machine or destination you'd like that hostname to route to and the TTL or time to live. Save the changes, type make, and test it out!
This how-to video will walk you, step by step, through the process of upgrading the hard drive on your MacBook. More specifically, this tutorial addresses saving your old data by creating a copy, or cloning, your MacBook hard drive with SuperDuper, removing it, and installing the new drive. For precise instructions, press play!
Ever wish you could switch between users on your Mac without having to kill all of your applications (and losing all your data) in the process? In this tutorial, Molly Stanberry from MacMost.com Shows how to enable fast user switching in Mac OS X Leopard.
This tutorial shows you how to build web services with MapForce. Load an existing WSDL file and build a complete web service by retrieving data from databases or XML files and using a visual function builder. It's easy to build web services in MapForce as this tutorial shows.
In Microsoft Office Excel 2007, you can hide rows and columns in several ways to change your view of the worksheet. When you finish your task, you can unhide the rows and columns to return the worksheet to its original state. This instructional video shows you quick ways to temporarily hide the data you don't want to see — so you can focus on what you do want.
Learn about drag & drop XSLT stylesheet design using Altova StyleVision, a visual style sheet design tool. Learn to publish XML and database data in HTML, PDF, and MS Word in this video.
Check out this tutorial and learn how to use Excel Calculation Services to handle processor-intensive calculations from your Microsoft Office SharePoint Server 2007 team site and to control access to external data.
Ever wanted to take apart your Western Digital "My Book" enclosure? If you also happen to think that the drive inside that enclosure runs too hot, this brief how-to video will also guide you through the process of placing the drive in another enclosure with a fan and an eSATA port. As always, be careful, use a set of high-quality tools, and be certain to backup the data on your My Book hard drive.
