This course will enable the students to –
Cost-Based Designing:
Costing in MS Excel
Introduction, spreadsheet, workbooks, saving a file, opening an existing worksheet, Rows and columns, cell entries (numbers, labels, formulas),
Filling series, Functions and its parts, some useful Functions in excel (SUM, AVERAGE, COUNT, MAX, MIN, IF). Data sort, Renaming sheet, Printing worksheet.
Insert Picture, Rate of Metal & Gem stones, Labour, Wastage, Determination of Profit and selling price.