data

Wed
28
May
Dennis Faas's picture

Converting Dates in MS Excel

A reader asked if there was any formula in Excel that would convert a date shown in the European format of day-month-year to the U.S. version of month-day-year. Technically, it may not be necessary to do this. Excel maintains dates as numeric values ... and displays them using various formats. If the dates are numeric values in your worksheet, then you can simply change the format and the dates will be displayed in the U.S. format. The day you see in a worksheet could instead be a text value rather than a numeric value. To see if the date is truly an Excel date or text value, you can change the ... (view more)

Mon
19
May
Dennis Faas's picture

Summing It Up With Two Keys in MS Excel

Most of you are familiar with the AutoSum feature in MS Excel and find it very handy indeed. All you have to do is click that icon on your toolbar and bingo! your formula for the sum of a data range is located just above whatever cell you have ... selected. I know that there are lots of folks out there like me who prefer to use the keyboard as much as they can because we like fewer keystrokes and saving time! So if you are one of those folks, here is another quick and easy way to sum in MS Excel.Select the cell below your column of data Then simply click ALT + = (Alt, plus the equal sign). Ta-da ... (view more)

Mon
28
Apr
Dennis Faas's picture

Control Electronic Devices from a Single Computer

Microsoft has joined the revolution, creating their own version of a data storage and web software system called "Live Mesh". Microsoft aims to further blur the distinction between software running on the Windows operating system and a number of ... other services that will be offered to all sorts of present and future electronic devices. Located through a web browser, Live Mesh will not be so much an online operating system as it will be a control page for document files. What is unique about the documents stored on Live Mesh is that they will have no specific location, allowing them to be sent ... (view more)

Fri
14
Mar
Dennis Faas's picture

The NSA's Big Brother Program

A startling report from The Wall Street Journal (WSJ) recently revealed details on what appears to be a domestic-spying program that was banned by Congress in 2003 known as the 'Total Information Awareness' (TIA) program. As noted by the American ... Civil Liberties Union (ACLU), the Orwellian program was shut down by Congress because it represented a massive and unjustified governmental intrusion into the personal lives of citizens. Despite the fact that Congress shut down the program, security agencies under the Bush administration pushed ahead anyway. The National Security Agency (NSA) has ... (view more)

Wed
27
Feb
Dennis Faas's picture

Popular Encryption Methods May Be Flawed

Researchers from Princeton University have found a simple way to crack popular encryption software, including the FileVault feature built-in to Apple's operating system and BitLocker, which is included in Windows Vista. The software aims to store ... data in a scrambled form making it indecipherable if in the wrong hands. Both programs use a federally approved algorithm that encrypts the information when it is written to, or read from, a hard disk. However, the keys allowing the computer to unscramble data are stored in the computer's memory. In theory, any information in a computer's memory ... (view more)

Tue
26
Feb
Dennis Faas's picture

Quickly Copy Formulas, Labels and Formats in Excel 2007

Why would you want to set up Sheet1 in your workbook and have it set up perfectly the way you want it only to have to do it all over again for Sheet2 and Sheet3? Well of course you wouldn't want to do that! And the good news is that you don't have ... to! To quickly copy formulas, labels or formats from a single worksheet to a group of sheets within a workbook, follow the steps below: Select the sheet that contains the data you want to appear in each sheet. Use CTRL + Click or Shift + Click to select the group of sheets to which you want to add the data. Select the data itself and click the Fill ... (view more)

Tue
26
Feb
Dennis Faas's picture

Google and Microsoft Want Their Fingers On Your Pulse

In October of last year, Microsoft launched HealthVault, a free online, encrypted storage area where individuals could manage their own medical record. Now, Google has tabled their own health storage offering called (surprisingly) Google Health. The ... battle for your medical record has begun. Both Google Health and Microsoft's HealthVault provide a secure place to store and maintain health data. The data that can be stored varies but will generally include records of vital statistics (e.g. heart rate, blood pressure, height, weight, etc.), patient family history, and disease or problem-related ... (view more)

Mon
28
Jan
Dennis Faas's picture

Can I See Some IP, Please?

Internet Protocol addresses (IP) are used to identify computers and the actions they take on the Internet. IPs are routinely stored by search companies and other online businesses to help improve search results and provide advertisers with complete ... billing data. While this practice has been questioned before, with Google's pending bid to purchase advertiser DoubleClick, European leaders are taking a hard look at these business practices. Peter Scharr, Germany's data-protection commissioner, believes that IPs are not just a tool for companies to use, but a form of personal identification that ... (view more)

Thu
20
Dec
Dennis Faas's picture

What Privacy? Security Survey Pessimistic

Scary: A recent survey sponsored by Deloitte ... (view more)

Fri
23
Nov
Dennis Faas's picture

British Government Leaks Bank Details of 25 Million

The British government has admitted losing a compact disc containing the personal details of 25 million people. The scandal has led to concerns that criminals could use the information for identity fraud or to access online bank accounts. The disc, ... which contains details of every family receiving child benefit (a form of social security paid for all children), was produced by a junior official at Her Majesty's Revenue and Customs (HMRC), the British tax department. The official put two passwords on the disc, but did not encrypt the information. They then sent the disc to another government ... (view more)

Pages

Subscribe to RSS - data