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 83rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma (population standard deviation) in NOT known using the TINV function.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 62nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP and INDIRECT functions to look up values from different tables. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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.
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.
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.
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.
In this video tutorial, Chris Pels will demonstrate how to create a custom user control in ASP.NET that can be used throughout a web site or across many web sites. Start out by learning the basics of creating a user control that will be used in multiple pages including validation, controlling formatting using style elements, and loading/saving data for the user interface elements. Throughout the video considerations for building user controls that can be easily maintained and used across mult...
In this quick tutorial, I show you how to compare data using an in-cell bar graph in the Open Office Calc Program by using the '=REPT' formula.
This Delphi tutorial looks at how to take advantage of the OnDrawColumnCell event on the TDBGrid component. In particular it examines how to make every second row a different colour (Sky Blue) and how to change the appearance of the text depending on the data.
