|
Problems and Solutions |
Problems and Solutions |
Problems and Solutions |
Problems and Solutions in Excel You can purchase and download the spreadsheets offered as solution. |
It gets frustrating trying to add dollar signs to my adresses to make my references absolute. Suggestion? Click on the address in the formula bar (above the grid) and use the F4 key. See more on this interesting functionality in Excel chapter 12 |
How can I avoid error messages in my formulas like #DIV/0!, #Value! or #NA!? You need to encase your formulas with and ISERROR function. See how easy it is in Excel chapter 10 |
I want to develop a dashboard in Excel combining a few tables and charts. How can I do this? You develop your full-size tables and charts on different sheets. Then you take pictures of these elements with the camera that is integrated within Excel and you assemble them on your dashboard. These pictures are dynamic. It means that when you make changes to your full-size tables and charts the pictures are automatically refreshed. See how it is done with step by step explanations on how to activate the camera and use it in "excel-tutorial-camera.xls" |
Purchase and Download immediately 50 Excel Spreadsheets All 50 spreadsheets in On Line Payment by Credit Card or Check Three different secure servers will accept your payment: |
50 Excel spreadsheets, 2 Ebooks and Video Clips |
|
Excel Solutions: Advanced Level