ICITSS (INFORMATION
TECHNOLOGY) PROJECT
REPORT
SAAHIL SANOJ
Saahilsanoj
, INTRODUCTION
CONTENTS
ms word ....................................................................................................................................................
Project 1: macros.................................................................................................................................... I
Project 2: mail merger ........................................................................................................................... III
Ms excel ............................................................................................................................................... XIII
Project 1:data validation and conditional formatting ................................................................................ XIII
Project 2: tax computation ................................................................................................................... XIX
Project 3: pivot table creation ............................................................................................................ XXIV
Project 4: phone directory (VLOOKUP) ............................................................................................. XXVI
Project 5a: what if analysis (PMT and goal seek) .................................................................................. XXX
Project 5b: what if analysis (scenario manager).................................................................................... XXXI
PowerPoint ..................................................................................................................................... XXXVII
PowerPoint using slidemaster ......................................................................................................... XXXVII
MS access ....................................................................................................................................... XXXVII
Project 1: employee database ......................................................................................................... XXXVII
Project 2: form .................................................................................................................................. XLII
Project 3: import and export ............................................................................................................... XLIII
Project 4: report ................................................................................................................................ XLV
Project 5: student database ................................................................................................................. XLVI
Tally ................................................................................................................................................ XLVIII
Idea ................................................................................................................................................... LXIII
Zoho .................................................................................................................................................. LXXII
E-itr filing .................................................................................................................................... LXXXVIII
Itr PowerPoint........................................................................................................................... LXXXVIII
Income tax calculation ............................................................................................................... LXXXVIII
MS word
, ICITSS (INFORMATION TECHNOLOGY) PROJECT REPORT
Project 1: macros
SRO0840832 MR SAAHIL SANOJ I|P a g e
, ICITSS (INFORMATION TECHNOLOGY) PROJECT REPORT
SRO0840832 MR SAAHIL SANOJ II | P a g e
TECHNOLOGY) PROJECT
REPORT
SAAHIL SANOJ
Saahilsanoj
, INTRODUCTION
CONTENTS
ms word ....................................................................................................................................................
Project 1: macros.................................................................................................................................... I
Project 2: mail merger ........................................................................................................................... III
Ms excel ............................................................................................................................................... XIII
Project 1:data validation and conditional formatting ................................................................................ XIII
Project 2: tax computation ................................................................................................................... XIX
Project 3: pivot table creation ............................................................................................................ XXIV
Project 4: phone directory (VLOOKUP) ............................................................................................. XXVI
Project 5a: what if analysis (PMT and goal seek) .................................................................................. XXX
Project 5b: what if analysis (scenario manager).................................................................................... XXXI
PowerPoint ..................................................................................................................................... XXXVII
PowerPoint using slidemaster ......................................................................................................... XXXVII
MS access ....................................................................................................................................... XXXVII
Project 1: employee database ......................................................................................................... XXXVII
Project 2: form .................................................................................................................................. XLII
Project 3: import and export ............................................................................................................... XLIII
Project 4: report ................................................................................................................................ XLV
Project 5: student database ................................................................................................................. XLVI
Tally ................................................................................................................................................ XLVIII
Idea ................................................................................................................................................... LXIII
Zoho .................................................................................................................................................. LXXII
E-itr filing .................................................................................................................................... LXXXVIII
Itr PowerPoint........................................................................................................................... LXXXVIII
Income tax calculation ............................................................................................................... LXXXVIII
MS word
, ICITSS (INFORMATION TECHNOLOGY) PROJECT REPORT
Project 1: macros
SRO0840832 MR SAAHIL SANOJ I|P a g e
, ICITSS (INFORMATION TECHNOLOGY) PROJECT REPORT
SRO0840832 MR SAAHIL SANOJ II | P a g e
