Excel Spreadsheet Authors

Is this Excel Site for Me?

Answer these questions…

Do you spend time and effort on the following things?

Correcting uncorrectable errors in your most important Excel Model written by a gone author
Deciphering your own formulas
Using no-purpose formatting
Complaining about too long formulas that overflow the Formula Bar
Being trapped in a growing-in-complexity-formula
Writing advanced Vlookup formulas

Are these things in your mind?

It is better to abandon that challenging Excel Spreadsheet just a step away of finishing
Your credibility is at risk, due to justified doubts about the results your model delivers
You sub utilize Excel Commands and Excel Functions

Think about above questions.

Then ask yourself:

Did I feel identified with some of the above inquiries?

Welcome on board!

But how will we take this journey?

Here’s how…

You know a lot of things about Formulas and Functions (maybe Macros and Vba) and the way Excel Commands work.

You will combine this existing knowledge with best practice advice and new information to take your Spreadsheets to the next level.

This site offers you more than Tips and Tricks.

testimonials chandoo Excel Spreadsheet Authors

July 15, 2009

“Hi John… you have very good content here.

I am subscribing to your blog for my daily reading list.”

Chandoo, Pointy Haired Dilbert

Chandoo.org

See more testimonials

Why?

No Excel Tip/Trick in the world works in the middle of a jungle of unresolved parenthesis.

You are no more solitary, this site is for you, the serious user who:

Create, Edit And Maintain Excel Spreadsheets
Wants their models make difference
Is looking for inspiration for a model
Is in a hurry for finishing a model and want new ideas about VLOOKUP, COUNTIF and other useful functions
Is looking for knowledge to make solid Spreadsheets
Want to do better the next model by implementing a formula more efficiently or by building a custom function library
Take by your hands the non-received advanced Excel training

There is a lot of space for improvement.

Below I will tell you about…

The Excel Spreadsheet Model that Inspired this Site…

In September 2007, my boss hired an International Tunneling Consultant to solve a complex budgeting process.

He started to work just after the meeting to define outputs and functionality.

He finished the Model after one month of hard work.

Once the consultant was gone, the problems started.

The peers of the Budget Department used the model and the Engineering Department provided the input (it was supposed).

The reality…

Nobody was able to decipher the Assumptions and Non-Assumptions Cells.

Additionally, you needed to open a chain of more than fifteen Workbooks to update the results (Books linked to Main Workbook and those linked to linked-Workbooks).

An email back to the Author resolved a doubt but generated five more.

testimonials keith gunaratne Excel Spreadsheet Authors

July 10, 2009

“I am a civil engineer by profession and developed many Excel applications for my own and others use enabling us to work smarter.

I visited your website; it is quite unique in its design and of course very informative. No doubt I will be visiting your website very often.”

Keith Gunaratne

Chartered Cvil Engineer and Information Management Consultant

Director at JIK Solutions

London, United Kingdom

See more testimonials

I put my hard hat and optimized the Spreadsheet; you may be astonished of the results:

The solution received:

72 folders
909 workbooks
216 MB in a CD ROM

The improved solution (there are no typo errors)

1 folder
8 workbooks
3.25 MB (this is almost two 1.44 MB diskettes)

I could not believe it, I said to myself that 98% of improvement is a large amount. I made some research on the web and found noise out there:

“A Survey of MBA Spreadsheet Users”

“What’s the first step in creating a spreadsheet? In our labs and classrooms, we usually observe students begin by entering numbers and then formulas directly into the spreadsheet. Best practice, on the other hand, calls for planning at the outset. Among our respondents, regrettably, the most frequent first step was to enter something directly into the computer, as shown in Table 4. Many started by borrowing an existing design, but less than 20% sketched the spreadsheet as a first step, and only a small percentage built an algebraic model at the outset. ”

by Kenneth R. Baker, Lynn Foster-Johnson, Barry Lawson, and Stephen G. Powell
Spreadsheet Engineering Research Project
Tuck School of Business
Dartmouth College
Hanover, NH 03755

The case at my hands was representative of what was happening outside: Spreadsheets have become so popular but also so abused.

Helping you to improve your Spreadsheets inspired me; the possibility to improve your models in significant ways inspired me even more.

So, this site adds a bit to the Art of Modeling with Spreadsheets.

Finally…

What will you gain from Excel Spreadsheet Authors?

You will take better decisions with solid Excel Spreadsheets.
You will gain productivity and improve your taking decision tasks constantly, by adding new functionality and effectiveness to your existing Excel Spreadsheets.

I hope you enjoy the journey!

Awesome Excel Spreadsheets and Templates

How to Use Microsoft Excel to Calculate Salary

Excel Spreadsheet Authors