10 tasks completed by VBA

July 22nd, 2010 | Posted by iip in Spreadsheet tips - (1 Comments)

Here some tasks that can handled by Visual Basic Application (VBA) –a programing language developed by Microsoft.  Experts say, VBA is the tool that people like to develop programs that control Microsoft Excel.

I realize, that some of you maybe have read Excel VBA Programming for Dummies –this is a good guidance for most of us who like to learn VBA from the begining. That’s okay, I’ll only put a few things of the VBA capacity to finnish some tasks. Here:

(more…)

How to reveal hidden tab in Word 2007

December 29th, 2008 | Posted by iip in Spreadsheet tips - (1 Comments)

In the default view mode of Word 2007, there are seven tabs presence.  Tabs showed in the Ribbon are Home, Insert, Page layout, References, Mailings, Review and View. A hidden tab could be revealed through excel options.  What are in the hidden tab?

(more…)

Excel provides shortcuts of various command, from formatting to printing. Find your favorite shortcuts of excel when dealing with data analysis task. Here the useful shortcuts:

(more…)