Diploma in Information Technologies

MS-Excel

Introduction to Excel, Basic Calculations, Basic Functions, Text Functions, Date and Time Functions, IF Condition, Lookup Functions, Mathematical Functions, PMT Functions, Conditional Formatting, Cell & Table Formats, Insertion and Deletion, Sorting and Filtering, Pivot Table and Pivot Chart, Slicer & Timeline, Cell Name Management, Formula Auditing, Calculations, Import & Export Data, Data Tools - Text To Column, Flash Fill, Remove Duplicates, Data Validation & Consolidate, What If Analysis - Scenario Manager, Goal Seek & Data Table, Group, Ungroup & Subtotal, Sheet & File Protection, Freeze Panes, Macros

Excel VBA

Basics of Excel VBA, Macro Recordings and Check Codes, Basic Syntax and Variables, If Condition, Loops, Procedures & Functions, Introduction to Excel Objects, Manipulate Cells & Ranges, Working with Worksheets and Workbooks, User Forms & Controls, Event Handling, Importing & Exporting Data, Create Dashboards with VBA, Working with Pivot Tables and Charts, Custom Classes & Objects, Array Handling

HTML 5

Introduction to HTML, Document Structure, Meta Tags, Lists in HTML, Images in HTML, Hyperlinks, Tables, Forms in HTML, IFrame in HTML, Basic SVG, Audio & Video Tags, Entities

CSS 3

Where and Why we use CSS, Selectors of CSS, Colors in CSS, Backgrounds in CSS, Borders in CSS, Width and Height in CSS, Margins & Paddings, Fonts & Text Styling, Box Model, Display Property, Flexbox, Floating, Navbar Project, Card Projects, Banner Projects, Advance CSS Selectors, Transformations, Transition Animation, Advance Animation, Display Grid, Media Query

JavaScript

JavaScript Introduction, Outputs in JS, Variables & Constants, Operators, Functions in JS, Arrays in JS, Loops, Array Functions, Objects, String Functions, Math Functions, Date and Time in JS, For In & For Of Loops, New Loop Functions in JS, DOM Introduction, DOM Forms, DOM CSS & Classes, DOM Event Listener, DOM Animation, BOM Introduction, Form API, History API, Fetch API, Storage API

C Programming

Introduction To C Programming, Comments & Output in C, Variables & Data Types, Constants, Operators, IF Condition, Switch Condition, Loops - While, For and Do...While, Arrays in C, String in C, Pointers, Functions in C, File System in C, Structures and Enums

C++

Introduction to C++, Variables, Inputs and Outputs, Operators, Strings in C++, Math Functions in C++, IF & Switch Conditions, Loops, Array & Structures, Pointers, Functions, OOPs Introduction, Constructors & Access Specifiers, Encapsulation, Inheritance, Polymorphism, Filesystem in C++, Exceptions

Python

Introduction to Python, Variables & Comments, Strings in Python, Python Operators, Lists in Python, Tuples in Python, Sets in Python, Dictionary in Python, IF Condition, While Loop, For Loop, Functions in Python, Lambda, Python Classes and Objects, Inheritance, Iterators, Polymorphism, Modules in Python, Dates in Python, Built-in Math Functions, Regular Expression, Try...Except, Filesystem in Python, MySQL in Python, Python and Mongo DB

Java