|
All
Blog Updates
I'm on Twitter
Contextures
on Google+
|
|
What's New
Blog - Hide Detail in Pivot Table
Website
- Data Entry UserForm Update
Microsoft Access Database Design
Contextures has been designing Access databases since 1996. Please contact
us for help with your project.
Sample 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
- Project time tracking -- forestry company
Microsoft Excel Design and Programming
Contextures has been designing Excel spreadsheets since 1987. Please
contact
us for help with your project.
Sample projects include:
- Pricing calculators for sales offices -- steel building manufacturer
- Insurance application forms -- insurance company
- Data entry form -- pet food company
- Production scheduler -- furniture manufacturer
- Customized sales reports -- food manufacturer
- Client location analysis -- pharmaceutical company
|
| |
|
|
|
|
|
Popular Excel Articles on Contextures
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
Publications
|
| |
|
|
Table of Contents
|
|
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
|
Table of Contents
|
|
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.
|
 
Table of Contents
|
|
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.
|
|
 
|
|
Pro
Excel Financial Modeling: Building Models for Technology Startups
by Tom Y. Sawyer
Technical Editor: Debra Dalgleish
April 6, 2009 Amazon.com
Learn the business thinking behind financial modeling and execute what
you know effectively using Microsoft Excel. Stepbystep approach to developing
financial models in Excel. Extensive case studies and Excel templates
provided.
What youll learn:
- Business thinking behind successful financial modeling aimed at investors.
- Communicate effectively with investors.
- Advanced modeling with Excel, including Cost of Information Technology,
Customer ROI, Cost of Sales and Marketing, Cost of Goods Sold, Team
and Staffing, Profit and Loss.
- Best practices for modeling using Microsoft Excel.
|
| |
|
|
|
|
|
|
