Part-A] Spreadsheet Practice
The Interface – The Ribbon, Quick Access Toolbar, File Tab, Entering Data into Cells
Basic Formatting – Basic Formatting – Labels & Values, Calculating with Formulas, Copy a Formula with Autofill, Quick Addition with AutoSum, Save Your Work. Exercise –1 & 2
Formulas and Functions – Writing and Copying Formulas, Absolute References, The AutoSum Function, The Payment Function, Exercise
Tables & Charts- Create an Excel Table, Table Tools – Design Tab, Sort Your Data, Filter Your Data, Insert a basic graph, Move a chart to a new worksheet,
Extra Tools – Converting Text to Columns, Conditional Formatting, Using Count & Countif Functions, Removing Duplicates, Sheet Protection, The Excel Table Feature
Part-B] Professional PWD Quantity Estimating & Costing
a) Preparing Building Plan & Section for Estimating
b) Measurement Sheet using Excel – 60 Building Items
c) Using Current Schedule of Rates
d) Abstract Sheet using Excel
e) General Abstract Sheet using Excel
f) Material Quantity Calculation
g) Site Visit for Offline batch only
Trainee will be able to –
a) Prepare Complete Detailed Estimate of Building using Excel.
b) Use Current Schedule of Rate book published by PWD
c) Calculate detailed quantity of complete building items using Excel
d) Calculate Floor wise / Phase wise / Duration wise Cost using Excel
e) Calculate Complete Quantity of all material require for building using Excel
Fill Measurement Book from site work for preparing running bills.
