Excel

Technology

Microsoft releases new security patch, as do scammers

Microsoft released its new security patch this week, and scammers were quick to get on the bandwagon, releasing a patch of their own via e-mail messages that are sure to confuse computer users.Microsoft's update was the June entry in the company's regular monthly set of security patches. This month, the patches include repairs that protect Windows users who visit web sites infected with malicious code and users who open infected e-mail messages with Outlook Express or Windows Mail.
Technology

Microsoft announces new era in business intelligence...again

Earlier this month, Microsoft hosted a conference on business intelligence in Seattle to reinforce the message that it is going to provoke a major shake-out."Microsoft is charting a course to transform the BI marketplace as we know it," claimed Jeff Raikes, president of the Microsoft Business Division."By fundamentally changing the economic model for BI and delivering unprecedented ease of use, we’re enabling the broadest deployment of BI possible so employees can better contribute to a company’s overall business performance."There wasn't much new about that particular statement,
Technology

SumIf's little known function

SumIf is a great function that a lot of Excel users don’t know up about. Basically it combines two very popular functions - the Sum function and the IF Function. SumIf tests specified cells and if those cells meet certain conditions or “criteria” then selected cells are summed up. Think of the possibilities: You may wish to sum up receipts by different lockboxes or sum up the value of past-due invoices. Or you may just want to add up negative numbers in a column quickly or add up the returns or overtime for a particular day. I am using a very simple example to illustrate SumIf.
Technology

Microsoft Office converter to disinfect virus files

Microsoft programmers are working on a file conversion program that will disable infected Office 2003 files by converting them into the new, XML-based Office 2007 formats, AccountingWEB's John Stokdyk reports.Called the Microsoft Office Isolated Conversion Environment (MOICE), the converter will be available in a few weeks time and was previewed by Microsoft security technologist David LeBlanc.Malformed Office document files are becoming an increasingly popular means for gaining control of remote PCs - for example to build so-called spam "botnets".
Technology

Microsoft Releases New Patches

Microsoft released fixes for 19 security flaws in several of its products, including the new Internet Explorer 7, Office 2007 and Exchange 2007. The company published seven security bulletins, all tagged "critical," its highest security rating. Critical vulnerabilities typically allow an attacker to gain full control of an affected system with very little, if any, action by the user.
Technology

How to Create List Reports in Excel

List-type reports such as customer addresses, lists of invoices and lists of products are vitally important in running the daily operations of a business. So it is vital that you be able to write your own when you need them. If your package has a full-strength Report Writer function, writing your own list reports may prove difficult. As an alternative approach, try writing them instead in Excel using the Sub-Total and Import External Data commands.
Tax

Security Update: Microsoft Issues Critical Vista Patches

Just before Easter, Microsoft broke from its usual security alert program to issue a bulletin and patches for a vulnerability that could allow malformed Windows animated cursor files to give hackers remote control over infected PCs.
Technology

Microsoft Access: Best Spreadsheet Add-In

By Simon HurstOf the main office applications used in professional firms, word processors are the least well used, spreadsheets the most overused, and databases the most underused. Part of the reason for this is that database applications are often seen as being the preserve of experienced developers, who use them to create comprehensive database applications.
Technology

IT Zone Guide to Budgeting Systems

By John StokdykFive years ago, I wrote, "In recent years, budgeting has been getting a bad press." Not much has changed on that front. Budgeting remains an entrenched habit - and some would argue a weak spot - in financial management. Even when companies do embrace the concept of business performance management, suppliers report that the most common inquiry they get is for tools to help customers automate and manage their budgeting processes.
Technology

Google’s New Business Software Includes Spreadsheets

Web search leader Google has introduced a subscription business software package that includes spreadsheet functions.Google Apps Premier Edition, a new version of Google’s hosted services for communication and collaboration designed for businesses of all sizes, is available for $50 per user account per year, and includes phone support, additional storage, and a new set of administration and business integration capabilities.With the addition of Google Docs & Spreadsheets, Google claims teams can easily collaborate on documents and spreadsheets without the need to email documents back a
Technology

Technology Trends to Watch in 2007

By John Stokdyk and Gail Perry A new Vista for WindowsIt's been almost four years since we last saw a major Windows upgrade from Microsoft (if you discount the XP Service Pack 2 release). However, this year will see the arrival of Windows Vista - "the most significant product release in Microsoft history" - accompanied by the new Microsoft Office 2007. The most visible differences will be glitzy new interface designs for both products, which incidentally are likely to place extra demands on users' PCs.
Technology

Embedding Data from an Excel Spreadsheet in a Power Point Presentation

Embedding data from an Excel spreadsheet into a Power Point presentation is especially useful if the basic presentation is used repeatedly and frequently. When data is embedded in a presentation or document it allows the data in the presentation to be updated automatically when the data is updated in the source spreadsheet. Presuming both the source spreadsheet and the destination presentation already exist and are open in separate windows, follow these steps to embed the data: Select the range of cells you want to copy in the Excel spreadsheet.
A&A

Avoiding Spreadsheet Slip-Ups

Spreadsheets help individuals and business organizations record financial data efficiently. Excel is probably the most common spreadsheet application used by businesses today. Users program formulas and macros to automate calculation of financial data as well. The seemingly simple financial logic inside spreadsheets can also cause embarrassing errors.
Practice Management

Security Alert: Microsoft Warns of Excel Zero-day Vulnerability

Microsoft posted a warning on Friday stating that a previously unknown flaw in Excel is being exploited by opening a malicious Excel document. The vulnerability is considered extremely critical because, according to a prepared statement from Secure Elements, it is locally and remotely exploitable by Trojan.Mdropper.J, which drops Downloader.Booli.A on the affected system.
Practice Management

The Impact of Compliance and Risk Management on Archival Storage Strategies

Electronic net media such as e-mail and instant messages have changed business to business transactions. The bulk of important business transactions such as contract negotiations, order issuance and acceptance, corporate communications and marketing programs, supply chain management, service and support, and investor relations are now done primarily using the Internet and these electronic media.
Technology

5 Tips for Improving Spreadsheet Readability

Have you noticed that some spreadsheets are easier to read than others? Of course, there isn’t much to read in most spreadsheets just column and row labels and formulas. So why do some spreadsheet authors seem to have a magic touch? They just know and follow these five simple rules:1. Be Consistent. Many names can be expressed in more than one way. Pick one and use it in all the spreadsheets you create.2. Be Brief. Short names are easier to read than long ones.
Technology

The Best Shortcut Keys in Microsoft Excel

Provided by ExcelTip.comCtrl+ZUndoCtrl+C Enter, Ctrl+V Ctrl+XCopy, Paste, Multiple Paste, CutCtrl+F, Ctrl+HFind, Find&ReplaceCtrl+P, Ctrl+S, Ctrl+F4, Alt+F4Print, Save,
Technology

Save Customized Microsoft Excel Chart Styles

If you create charts in Excel, chances are good that you adjust the formatting of the standard chart style each time you create a new chart. You may change the size of the font, perhaps you add some background color, you might include your company logo on the chart, you may prefer the currency format for your numbers, or you may prefer a line graph to the default column style.
Technology

Excel Tip: Overriding and Removing Page Breaks

Excel automatically determines where page breaks will occur, but you can create your own page breaks in your worksheets by forcing Excel to begin printing on a new page at the location that is best for you.To create a horizontal page break, follow these steps: Place your cellpointer in Column A in the row below the row in which you wish to insert a page break.Choose Insert, Page Break from the Excel menu.
Technology

Five Quick and Easy Excel Tips

Complimenets of ExcelTip.comTip 1: Searching all Sheets in a WorkbookTo search for text, use the keyboard shortcut Ctrl+F or choose Edit, Find. To search and replace text, use the keyboard shortcut Ctrl+H or choose Edit, Replace. Searching and replacing all sheets in the Workbook From sheet tab short cut menu choose Select all sheets.

Pages