Expert Zone
Articles, interviews and news regarding Microsoft® Office products and data recovery. With a growing list of over 20 authors, the Expert Zone is your one stop resource center for Office tips and tricks as well as in depth articles.
-
Pivot Tables in Excel | Expert Zone
2006-12-11 You probably know how to create a basic pivot table. Here are some obscure pivot table tricks which will help you get the most out of pivot tables.
-
Automate Excel Functions | Expert Zone
2006-11-06 Macros, those do-it-yourself software programs, rank among Microsoft’s most useful tools. They automate many computer tasks that you otherwise would have to execute manually—from the simple task of creating customized worksheets to the very complex tasks of exporting journal entries in Excel into an accounting package and creating reports in Word.
-
Excel Performance Analysis the Professional Way | Expert Zone
2006-10-04 Analyzing performance data in Excel using array formula and dynamic range name methods.
-
How to Vary the Built-in Line Chart Markers | Expert Zone
2006-09-05 On first inspection the shapes of the built in line markers appear to be very limited.
-
Beyond Excel’s Holy Grail | Expert Zone
2006-08-08 Moving beyond a dependence on array formulae in Excel It's something of a rite of passage, really, the day when the intermediate Excel user discovers array formulae. If you haven't got to that stage just yet, stop reading now, but keep this article handy. When you get to the point (and you will) when you can't imagine life again without array formulae, take out this article and read it.
-
Printing Worksheets To A PDF File (Using Early Binding) | Expert Zone
2006-08-08 This article contains code examples to print worksheets to PDF files, using PDFCreator. Unlike Adobe Acrobat and CutePDF, which both require pro versions to create PDF's via code, PDFCreator is completely free! Download PDFCreator from Sourceforge here .