Microsoft Access Database Design
Recent projects include:
- Order processing -- steel building manufacturer
- Budget tracking -- office equipment company
- Cash clearing system -- insurance company
- Corporate donations -- financial institution
- Sales forecasting -- food manufacturer
- Customer location mapping -- insurance company
Microsoft Office Applications
- Custom designed Excel spreadsheets, Word documents
Publications
Beginning Pivot Tables in Excel 2007 by Debra Dalgleish
September 24, 2007 Amazon.com
Beginning Pivot Tables in Excel 2007 explains what Pivot Tables are, how you can benefit from using them, how to create them and modify them, and how to use their enhanced features. It's for those who are new to pivot tables, and those who have used pivot tables in other versions of Excel and want to learn about the new features in Excel 2007.
- Carefully explains the benefits of using Pivot Tables for fast data analysis
- Provides a step-by-step approach to those new to Pivot Tables
- Offers tips and tricks for working with pivot tables
Excel 2007 Pivot Tables Recipes by Debra Dalgleish
December 10, 2007 Amazon.com
This book assumes that you know the basics of Excel and pivot tables, and provides troubleshooting tips and techniques, and programming examples.
This book is for anyone who uses pivot tables, and who only reads the manual when all else fails. It's designed to help you understand the advanced features and options that are available, as you need them. Experiment with pivot tables, and if you get stuck, search for the problem in this book. With luck, you'll find a solution, a workaround, or, occasionally, confirmation that pivot tables can't do what you want them to do.
- Excel Pivot Tables Recipe Book by Debra Dalgleish
March 2006 Amazon.com Amazon.ca
e-book
Excel Pivot Tables Recipe Book is for anyone who uses Excel frequently. This book follows a problem-solution format that covers the entire breadth of situations you might encounter when working with PivotTables -- from planning and creating, to formatting and extracting data, to maximizing performance and troubleshooting.
The author presents tips and techniques in this collection of recipes that cannot be found in Excel's Help section, and she carefully explains the most confusing features of PivotTables. All chapters have been organized into a collection of recipes that take you step-by-step from the problem you are experiencing to the solution you are aiming for.
There's no fuss to this book, only clear and precise information to help you assess your situation--whether common or unique--and solve your problem. The book includes real-world examples of complex PivotTables, as well as numerous PivotTable programming examples.
Conferences
- Excel User Conference -- view upcoming events
Atlantic City, NJ -- Presented sessions and classes for intermediate and advanced Excel users. (April 2006)
Home Excel Tips Sample Spreadsheets
Last updated: May 3, 2008 0:07 AM
