data

Wed
22
Oct
Dennis Faas's picture

IRS Slammed For Security Flaws

An official report says two IRS computer systems have serious security weaknesses. It also warns information about taxpayers is at risk of falling into the wrong hands. The report, by the Treasury Inspector General for Tax Administration, a federal ... agency which monitors IRS performance, details problems with a new billion dollar system which will eventually manage the data for all taxpayers. The Customer Account Data Engine (CADE) already handles 28 million tax returns, around a fifth of the total. The report also covers the Account Management Services (AMS) system, which provides quicker ... (view more)

Tue
02
Sep
Dennis Faas's picture

ISPs Tracked Customers Without Consent

Last fall, several communications companies reportedly conducted trials, in some cases lasting up to 6 months, of network-based technology designed to track a customer's Internet actions, attempting to amass refined data on web-surfer habits that ... may be sold at premium rates to advertisers. Cable One's 'trial' affected about 700,000 customers. Bresnan Communications conducted a similar 'trial' that was limited to about 6,000 broadband customers in Billings, Montana from April 1 to June 26, 2008. Knology tested it on about 230,000 of their customers from January until July 2008. WideOpenWest ... (view more)

Tue
12
Aug
Dennis Faas's picture

MS Excel's Top/Bottom Rule Allows for Rapid Data Analysis

MS Excel 2007 has a new feature called data visualization that will allow you to see when data in a worksheet has attained a certain value. You could use this nifty feature to see which departments in your company have attained above-average sales ... this quarter. Follow the steps below to learn how: Select the data cells you would like to analyze. Click the Home tab. In the Styles group, click Conditional Formatting. Select Top/Bottom Rules. Click Above Average. Click OK. All cells with above-average values will appear in red. If you would like to see the top 10% performers, follow these steps ... (view more)

Mon
23
Jun
Dennis Faas's picture

Data Entry Form in MS Excel

It can be daunting and more than a bit frustrating when the CEO of your company dumps a ton of data on your desk and expects you to hastily turn it into an MS Excel database. But it doesn't have to be daunting any longer -- it can even be easy using ... the Data Entry Form in MS Excel. This handy feature will allow you to enter an entire row of date all at one time, rather than entering each little bit of data one at a time. Sounds a lot better already doesn't it? So we have now established that data entry forms in MS Excel definitely bear investigating eh? Follow the steps below to learn how. To ... (view more)

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)

Pages

Subscribe to RSS - data