The last few Excel upgrades have enhanced the way it works with data imports and analysis.
pivot tables
Like many Excel users, David Carter was initially repelled by the Ribbon interface in Excel 2007.
21
Simon Hurst continues his KPI reporting casebook by incorporating some of the more advanced features available with Excel 2010, including PowerPivot.
5
I've never really dealt with csv files up until now. But a client has just emailed me their Sage reports in csv format. When I open the file, it is just rows and columns of data.
8
A stash of David Carter’s popular articles has been discovered in the ExcelZone archives and reunited with their sample files.
PivotTables aren't just for show. Simon Hurst shows how some subtle enhancements in Excel 2007 can help you managed aged debtors better.
I have created a worksheet for a client to use and want to protect it to stop accidental messing up.
4
