will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.
About
Thanks for visiting the Contextures blog, which is focussed on Excel tips and Excel tutorials, and is published Monday, Wednesday and Friday. There will occasional posts on other topics, including Microsoft Office programs and computer productivity tips.
For a large collection of Excel tutorials, videos and sample files, please visit my web site:
I’m Debra Dalgleish, an independent computer consultant who specializes in Microsoft Office programming and development. Self-employed since 1985, I’ve learned a lot about business efficiency through my own experiences and experiments (some successful, some not so much). I’ve also seen the wide variety of systems and practices that my clients use, and have learned much from them.
Also, I’m proud to have received the Excel MVP award from Microsoft, every year since 2001.
Publications
I’ve written three books on Excel pivot tables, and you can read the outlines here:
How It Started
When my business started, it was mainly word processing, and I did everything on a Macintosh (upgraded to 512K), with an external floppy drive, and no hard drive. The first two programs that I used were MacPaint and MacWrite. Soon I got MultiPlan and Microsoft Word, and was excited by all the new things they could do. The next big program I got was Excel, and I expanded my business into that area. There were a few new Macs along with way, including a Mac Plus, a PowerBook and an LC 475.
In the mid 90s, when Windows 3.1 was released, I gradually switched to a PC, because that’s where the money was. I did computer training, wrote training manuals, still did some word processing, and created spreadsheets. In 1996 I was asked to teach an introductory course in Access 2.0, so I learned that too. At the end of that year I created my first database for a client. Since then, we’ve converted the database to newer versions, but it’s still going strong!
Now my working hours are about 40% Excel programming, 40% Access development, and 20% other Microsoft Office stuff. A few clients are still using Office 2000, a couple have upgraded to Office 2007, and the rest use Office XP or Office 2003. It’s a challenge to remember where the commands are in all those versions!
Contact Me
Email: Debra Dalgleish — ddalgleish AT contextures.com
Phone: (905) 824-1853
______________________________
