Back to Excel Newsletter Archives

OzGrid Excel and VBA Newsletter October 2007

Add to GoogleSearch Tips Excel Data Manipulation and Analysis

Here are some excellent ways to enhance your Excel skills and/or VBA skills with training and/or software

Build an Automated Stock Trading System |Build an Automated Sector Fund System |Build an Automated Spread Trading System |Technical Indicators Library Open Source |Code VB & VBA 50% Off|Smart VBA |Print VBA |ALL TRAINING...


Finance Templates 80% Off! |Active File Compare. YOU WON'T BELIEVE THESE PRICES |Excel 97-2003 Complete Excel Course. Levels, 1, 2, 3 and 2 VBA Courses. 50% Off | VBA - VB Coding Tools To Create VBA - VB Code Faster, Cleaner & More Efficiently. 50% Off

COMING SOON! Chance to win;
dbOrchestra - SQL Server [value $595.00 usd]
dbOrchestra - Oracle [value $795.00 usd]
dbOrchestra - MySQL [value $95.00 usd]
Kindly donated by: our Q&A forum for details.

This month I'm taking a whole new approach to the norm and I am going to try and answer the majority of your questions, without you even needing to ask.

But, before that, I would like to again voice my concern of the sheer number of people that use Excel in the complete WRONG way! Excel users on our free question and answer forum are constantly asking toconsolidate data from multiple Worksheets/Workbooks into 1 single Workbook and Worksheet (). Now, there is nothing at all wrong with wanting to have 1 single Workbook and Worksheet, in fact, this is my beef. That is, they should start with 1 single Workbook and Worksheet only and from that raw data Worksheet (laid out in a flat line database*) they can easily obtain statistics, calculations, reports, charts and just about anything they wish. Excel is designed for exactly this type of data and doing so opens a whole new World of features, 3 of my favorites are list below;

AutoFilter Tip: Save your filtered data as a Custom View (found under View on the main toolbar) for instant recall.

*A flat line database is one where headings go across row 1 and all data is laid out under the appropriate headings. No blank rows or columns and ideally, no blank cells either. Use Zeros for blank cells and, if you wish, stop them from showing via Tools>Options - View - Zero values. Remember, this is raw data so no formatting should be applied other that bold the headings and format dates as needed.

Ok, now I have got that off my chest, let me try and answer your questions without you having to ask. SeeSearch Tips and then go to our Forum Search and note the pre coded "Popular Searches" and give them a go. These are only a few, many more to come.

I cannot stress how important search is becoming in every aspect of our lives. At the same time, I'm amazed at the sheer volume of questions asked on our forum that have been asked and answered 100's, sometimes 1000's of times before! I would guesstimate about 70% of questions asked could be solved via a search. From what I see, most search for what they THINK is their answer, when one should always search for what they are wanting to do.

Now, of course many of you will never find your needs and that is ok. When no answer is found, then simply post your question.

Until next month, keep Excelling!

Got any Questions? Free Excel Help

Complete Excel Training Course Special!
We don't teach Excel from a manual, we teach Excel from experience!
Free Help Forum, not just Excel!

Instant Download and Money Back Guarantee on Most Software

Add to Google Search Tips

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Excel Data Manipulation and Analysis

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

FREE Excel Help