Data Validation

By -
As a default, you can fill in just any text or Number etc. in any cell of your worksheet.
Databases and solutions however demand reliability.  The Data validation feature just does that. For example you might want to dictate the following rules to your electronic measurement book.

Comments

Post a Comment

Popular posts from this blog

WHY USE MS PROJECT FOR SCHEDULING AND MONITORING CONSTRUCTION PROJECTS?

By -
To begin with the single most important reason to adopt the MS Project is that activity sequencing with it is very easy. It is here assumed that your team is already using other MS office applications (2007 or later). The initiation of schedule preparation with MS Project would give rich dividends and justify additional cost and effort on this account only. In Indian scenario especially at locations where construction projects have suddenly grown both in size and complexities, gaining maturity in professional scheduling/work sequencing can be a boon. The construction projects scenario here can be summed up as below. 1.        Projects are getting more complex. 2.        Numerous sub consultants and subject matter experts are involved. 3.    Construction Industry has a tradition of consultants working in silos. 4.        Works have to be got done through subcontracting. if you have been in a complex building construction team, it is obvious to you that inadequate
Read more

Construction Billing with Excel Update

By -
Image
MS Excel has been used for construction billing from the very beginning of its launch. Excel 2007 with the introduction of Pivot tables made calculations like abstracts appear like magic. Other calculations like theoretical cement consumption etc. were also possible and yet total automation was not possible. Power Query and Power Pivot an addon to Excel 2010 were initially inaccessible have come of age now. The users of this blog would like to visit "Billing with MS Excel (V-1)" to see the possibilities of using pre-2013 Excel versions. The new data capabilities make Excel a gamechanger for billing and similar applications. Please look at the possibilities of this tutorial.
Read more