Of the main office applications used in professional firms, word processors are the least well used, spreadsheets the most overused, and databases the most underused.
Excel
When reporting actuals against budget, you often find that your budget categories don’t match the nominal codes in the accounts package.
One of the most disconcerting things you experience with the new version of Microsoft Excel is trying to find command options that you instinctively know in older versions, but cannot find in Excel
Data held in row and column format like budgets is difficult to analyse in a pivot table.
1
"The partnership philosophy has been a part of the finance department's thinking since the start," says Diageo GB’s BPM Director David Francis.
Printing in Excel may seem simple but there are a few key hints and tips that can make it easier and improve the quality of your printed reports.
3
When 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?
1
Microsoft's second-Tuesday security bulletin for February produced a bumper crop of 12 software updates to close holes in Excel, Word and the Windows Malware Protection Engine.
Legendary Excel guru John Walkenbach as turned up an interesting treat for the musically inclined spreadsheet user.
Microsoft has issued a security advisory notice warning of a zero-day vulnerability in Microsft Excel.
Pages
Most read: Excel
- New Range Name features in Excel 2007. By Simon Hurst 414,990 6
- Want to learn about Excel pivot tables? Start here. By David Carter 108,553 6
- ExcelZone's Five Minute Pivot Table Tips - Index 83,845
- Tutorial:.... Budgeting with Pivot Tables #1 [Excel 5 to 97] 69,056 2
- Exporting data from Sage Line 50 into Excel #1. By David Carter 62,134 10
