Excel

Technology

Want to learn about Excel pivot tables? Start here. By David Carter

Pivot tables come free with Microsoft Excel and are a must for anyone who wants to analyse their data. AccountingWEB has been spreading the word for a long time now, and we published our first self-teach tutorial on pivot tables as far back as 1999. There's now a full suite of these tutorials and they have been accessed over 100,000 times. Why tutorials?There are dozens of books out there which will explain to you how to create a pivot table.
Practice

How to protect data - a quick reference

The latest technologies and gadgets make it incredibly easy for your data to be stolen from right under your nose, unless you take steps to protect it.
Technology

Microsoft brings MAC Excel users up to speed

Microsoft's monthly security patch for July featured a fix to some key elements of its spreadsheet program Excel. The patch, however, failed to address the issue for MAC computers.Microsoft has now revised its security bulletin MS07-036 to include a MAC fix as well.
A&A

Google launches new search engine for small businesses

Search engine giant Google is expanding its range into business site search engines facilities with a new search engine starting from $100 a year.The company claims that the hosted Google Custom Search Business Edition can be implemented on a business website in less than 10 minutes and will give visitors better search results once they arrive.The new service expands on the free Custom Search Engine, which includes Google AdWords links alongside the site's own search results and offers some faciliti
Technology

Cracking BlackBerry addiction: First follow these rules

Has technology made us super-efficient, multi-tasking worker bees or just stressed-out, time-wasting drones?The debate is not likely to be settled any time soon in this digital age, but anyone who has given a presentation at a meeting, only to eye their coworkers discreetly scrolling through e-mail messages, would agree that some restraint is needed. And that's not even counting the more egregious displays of over-the-top wireless behavior, such as texting while driving.How important is it to be connected to e-mail at all hours of the day?
Technology

Automating retirement programs can increase savings, retention

Enhancing 401(k) programs with automatic features can generate a double-barreled investment success, enabling employees to save more for retirement and employers to better recruit and retain those employees.That key finding is in a new AARP-commissioned report, "Enhancing 401(k) Value and Participation: Taking the Automatic Approach," released this week by AARP and prepared by global professional services firm Towers Perrin."AARP believes workers should have access to effective retirement plans, and automatic retirement programs are a double-barreled investment success," noted Jon Dauphi
Technology

Critical Excel vulnerability features in July's 'patch Tuesday'

Excel 2007 featured in the security updates issued by Microsoft on July 10, the traditional second Tuesday scheduled for the company's monthly bulletins.The Excel vulnerability could allow malicious code to be downloaded and run by causing a "buffer overflow" when a user opens a specially crafted Excel file.
Technology

New study: Today's technology hype is tomorrow's small business reality

Tomorrow's successful small business owners will be far more reliant on technology than their current counterparts.
Technology

Excel 2007 Tip #2: Formatting is now done via the right mouse menu

One really disconcerting change to Excel 2007 is the disappearance of the toolbars. Features you use all the time seem to have disappeared back to into the menus.People with prior versions of Excel usually have two toolbars permanently on display – Standard and Formatting. The Formatting toolbar contains the icons for adjusting fonts, centring, bold, italic decimals, colors and so on.In Excel 2007, formatting is no longer done via toolbars, but via the right mouse menu.To illustrate, open up a worksheet, then right click on it. The right mouse menu appears.
Technology

Excel 2007 tip #1: Make your data visible to other Excel users by saving in Excel 97-2003 format

Files produced by Excel 2007 are in the new .xlsx format. No other version of Excel can read them unless a special compatibility pack has been installed. If you plan to share your Excel 2007 files with other Excel users, you can set Excel 2007 to save your files automatically in Excel 97-2003 format. This will allow other Excel users who have not upgraded to Excel 2007 to read your files.How to set Excel 2007 to automatically save files in Excel 97-2003 format: Start up Excel 2007. Open an empty worksheet.
Technology

Excel tips! Two-minute tips from David Carter

Here are four quick Excel tips, each of which you can master in two minutes or less! These tips are courtesy of Excel guru David Carter and our sister site, Accountingweb.co.uk.Excel 2min Tip #1: Sort data with the =RIGHT function: by David CarterWhen Excel sorts a column of items, it looks at the initial character of each item, that is, the characters to the LEFT. But suppose you want to sort according to characters on the right? For this you need to use the =RIGHT function.
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.

Pages