Tips and Help on Excel and VBA for Excel

 

Problems and Solutions
Excel Beginners Level

Problems and Solutions
Excel Intermediate Level

Problems and Solutions
Excel Advanced Level

 

Problems and Solutions in Excel
(Advanced Level)

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
(Beginners, intermediate and advanced)

50 Excel Spreadsheets
Hundreds of formulas and macros
(exercises, examples, templates)
Nothing hidden nothing protected
Just use them or copy and paste what you need

All 50 spreadsheets in
a single easy and quick download
$60US

On Line Payment by Credit Card or Check

Three different secure servers will accept your payment:
 Download Site 1:  ClickBank
Download Site 2:  2CheckOut
Download Site 3:  Paypal (EBay)

 

50 Excel spreadsheets, 2 Ebooks and Video Clips
A single download that will teach you
Simple ways to do more with Excel
(For beginners, intermediate and advanced users)

 

    Tips and Help on Excel and VBA for Excel

 Excel Solutions: Advanced Level