Data Management Search Results

How To: Create a histogram using data analysis in Excel

A histogram is a summary graph showing a count of data points that fall in various ranges. Histograms are used in statistics and other forms of mathematics. In this video, learn how to create your own histogram using data analysis on the computer. This tutorial will show you how to create a frequency distribution, a cumulative frequency distribution, a histogram chart and an ogive chart with the data analysis add-in.

How To: Create drop down menus in Excel

In this software video tutorial you will learn how to create drop down menus in Excel using Data Validation. This example will show you how to display a list of parts in a drop down menu. Create the list of parts somewhere in your worksheet. Then in the cell underneath the one where you want to display the parts, go to the data validation window and enter the data. For this select the cell and then press 'Alt + D + L' to bring up the data validation box. Here you click on 'settings' and selec...

How To: Use container fields with FileMaker Pro 10

This lynda.com video tutorial shows how to use container fields with FileMaker Pro 10. When you want to create fields in FileMaker database you have the choice on what kind of fields you want to make. Many general fields are self explanatory like text, date etc., but there is a special kind of field called the container field. FileMaker Pro container field is a versatile data type in that it can store any kind of binary data. Container fields can be used to hold binary data in four broad clas...

How To: Collect, organize, and visualize data in InspireData

This tutorial on the companion Tech Ease for Mac site shows you how to use Inspiredata to collect, organize, and visualize data using several types of diagrams supported by the program. The movies were recorded on a Mac, but Inspiredata is a cross-platform program so the steps shown should work on the Windows version of the program as well. Inspiredata works like a database system that allows you to add notes and more.

How To: Secure your data with an SSH Tunnel

This new episode of Full Disclosure shows you how to use a SSH Tunnel to secure your data when you are on an untrusted LAN (ex. Coffee Shop, School's network, or Defcon). Furthermore, you can use the SSH Tunnel to bypass the LAN's internet filters. The SSH tunnel protocol works by encapsulates your data into an encrypted payload and transmitting it to the SSH Server which is setup on a trusted LAN.

How To: Plot data with Microsoft Excel's REPT & COUNTIF tools

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 27th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a quantitative data dot plot chart using the REPT and COUNTIF functions.

How To: Cross tabulate categorical data in Microsoft Excel

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 16th installment in his "Excel Statistics" series of free video lessons, you'll learn how to cross tabulate & do percentage cross tabulation for categorical data using a pivot table (PivotTable).

How To: Cross tabulate categorical data with formulas in Excel

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 17th installment in his "Excel Statistics" series of free video lessons, you'll learn how to cross tabulate & do percentage cross tabulation for categorical data using formulas rather than pivot tables.

News: Taqtile's HoloMaps Gives HoloLens Users Ability to View, Scale & Draw on 3D Maps

HoloMaps, an application by Seattle-based Taqtile, is available for free on the Windows Store. Taqtile, whose Vice President of Product Management was Microsoft's former Director of Business Development, is one of the few partners currently in the Microsoft HoloLens Agency Readiness Program. This interactive 3D map they have created, powered by Bing, offers more than just a top-down view of the world on the HoloLens.

How To: Intubate a patient (endotracheal intubation procedure)

ER showed the world what goes on inside the emergency room, and in every episode, we experienced a common but very important procedure— intubation. But ER never made it seems easy; it showed just how hard it is for medical students to successfully intubate a patient due to fear and naivety. And for real-life doctors and medical practitioners, learning the art of airway management is just as difficult.

How To: Make a shrinking data validation list in MS Excel

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 241st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a data validation drop-down cell list where the list shrinks as you select values.

How To: Use an Excel macro with relative & absolute references

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 264th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a recorded macro to take a data set and add a new column, concatenate data from 3 columns, and delete unwanted columns.

How To: Completely erase all the data on your hard drive

In this video the instructor gives tips on how to erase a PC hard drive. An MIT study shows that 74 percent of the discarded hard drives contain private data on them that can be read and recovered by others. So you should learn how to completely erase all the data so that no one can recover or read from it later. Now formatting the drive or deleting a few files wont do it. For this you will need to have a proper software that meets or exceeds that US Department of Defense standards for data r...

How To: Connect to a database & add data in PHP & MYSQL

MySQL is a database for serving data on the web. This video teaches viewers how to connect to a database and add data in PHP & MySQL. PHPMyAdmin is an interface that allows you to interact with MySQL more easily. Use the form in the program to create a database; choose the name for your database and select 'create'. Next you can create tables within your database, also using the forms provided. Within the tables you can set your variables; PHPMyAdmin has fields that allow you to choose the ty...

How To: Create fire and smoke using Pyro FX in Houdini 10

The new Pyro FX in Houdini 10 are very impressive with improved workflow. The Pyro FX are great for creating 3D fire and smoke effects. And in this video tutorial series, you will learn the Pyro FX workflow in-depth and the parameters used to create fire and smoke effects. You will also see how volumetric data is created and recorded, and how to visualize it.

How To: Use the ListView control in Visual Studio

Microsoft ASP.NET is a free technology that allows programmers to create dynamic web applications. ASP.NET can be used to create anything from small, personal websites through to large, enterprise-class web applications. All you need to get started with ASP.NET is the free .NET Framework and the free Visual Web Developer.this video tutorial will demonstrate the new ListView control in Visual Studio 2008. Because the ListView is data-driven, you will need a data source. You can use any data so...

How To: Use the ListView control in Visual Studio 2008

Microsoft ASP.NET is a free technology that allows programmers to create dynamic web applications. ASP.NET can be used to create anything from small, personal websites through to large, enterprise-class web applications. All you need to get started with ASP.NET is the free .NET Framework and the free Visual Web Developer. By creating a new website, this video tutorial will demonstrate the new ListView control in Visual Studio 2008. Because the ListView is data driven, you will need a data sou...

How To: Summarize budget data via PivotTable in MS Excel 2010

Learn how to create a summary of your budget data. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started summarizing your own budget data, watch this free video guide.

How To: Sort and group data with data grids in ColdFusion 9

Quickly and intelligently organize your information through use of ColdFusion 9's ever-useful data grid feature. Whether you're new to Adobe's popular rapid Internet application development platform or simply wish to become better acquainted with the program, you're sure to find benefit in this free video software tutorial. For more information, including specific, step-by-step instructions, take a look.

How To: Back up your data to an external hard drive

Want to know how to back up your data to an external hard drive? Protect yourself against data loss and heartbreak with this free home computing how-to from the folks at CNET TV, which offers complete instructions on how to back up your important files either manually or automatically. For specifics, and to get started backing up your own stuff, watch this handy how-to.