School of Technology, Innovation and Research (TIR)

MS Excel 10 Training Session Target MS Excel Orientation Worksheet orientation Cell Position   understanding Insert   row, Insert Column Delete   row, Delete Column Sheet  1 ............ Sheet n Inter sheet calculation Data Sort Formula Use Function use MAX() MIN () IF() RANDOM() TRIM() VLOOKUP() MOD() ROUND() UPPER() Macros Details: MS Excel 2019 version Rows = 1048576, Column= 16384, Sheets= Depends on memory Case Study 1: Find a result of school class. Find Total marks and corresponding grades.  Look at the solution given below. In the above worksheet, the result column is obtained based on the total column and IF formula.

  mvBevi Aciva I evsjv‡`k                                                                         cÖ‡KŠt †gvt Avãyi রশিদ www.rashid-bd.info   m~Pbv t †`‡k Z_¨ cÖhyw³i e¨envi w`b w`b †e‡oB Pj‡Q| †`‡k eZ©gv‡b ( জানুয়ারি ২০২২ ) B›Uvi‡bU e¨enviKvixi msL¨v ১২১ . ৮৭ মিলিয়ন | gyim   তত্ত ¡ g‡Z cÖwZ 2 eQi পর পর wظb nv‡i ( চিপ্সে ট্রান্সজিস্টর সন্নিবেশ ) cÖhyw³i cÖmvi NU‡e| hš¿cvwZ AvKv‡i †QvU n‡e I ÿgZv evo‡e| GiB avivevwnKZvq Kw¤úDUvi cÖhyw³i g~j wbqvgK gvB‡µvcÖ‡mmi gyi ZZ¡‡K Abymib K‡i Zvi ÿgZv evo‡Q| AvKvi †QvU n‡”Q I `vg Kg‡Q| mewKQz wg‡j cÖhyw³ mnRjf¨ nIqvq e¨envi evo‡Q| kn‡ii D”PweË n‡Z MÖv‡gi K…lK mevB B›Uvi‡b‡Ui ¯ú‡k© jvfevb n‡”Q| Acic‡ÿ Gi Ace¨envi I evo‡Q| GUv n‡ZB cv‡i| Z_¨cÖhyw³i GB Ace¨envi B AvR mvBevi Aciva wnmv‡e Av‡jvwPZ n‡”Q|   m...

XAMPP Software Download and Install You have to download and install the xampp for windows package software on your desktop or laptop.  What is XAMPP  Software?           It is an open-source Web Server Package. XAMPP is more popular for the PHP development environment. This packaged software complies with the following operating system (OS)-        Microsoft Window       Linux Unix       Solaris a           Mac OS X For the purpose of practice, you can install this XAMPP software on your PC or Laptop in the windows operating system environment. XAMPP package software contains- –         Apache Web Server –         PHP –         Filezilla  –         MySQL Database - FTP Service (Helps to Upload and Download files. It is a prot...

  Supervision of PGDICT4D Training Projects   Following projects had been ended under my direct supervision. Please look carefully.    Level Project Title Year Post Graduate Diploma in ICT (PGDICT) E-service for prisoners appointment with relatives 2013 Post Graduate Diploma in ICT (PGDICT) New ICT based business opportunity using 3G: Bangladesh Perspective 2013 Post Graduate Diploma in ICT (PGDICT) Web-based e-recruitment system 2013 Post Graduate Diploma in ICT (PGDICT) Develop application software for a school result processing 2013 Post Graduate Diploma in ICT (PGDICT) Study Moodle software: NAPD distance e-learning perspective 2013 Post Graduate Diploma in ICT (PGDICT) Study computer forensic: Bangladesh perspective 201...