Curriculum
Overview of the screen, navigation, and basic spreadsheet concepts
Various selection techniques
Customising Excel (Ribbon, AutoCorrect, default options)
Basic functions (Sum, Average, Max, Min, Count, Counta)
Absolute, mixed, and relative referencing
Formatting (currency, dates, special formats)
Conditional formatting
Mathematical functions (SumIf, CountIf, AverageIf, nested IF, IFERROR)
Text functions (Upper, Lower, Proper, Trim, Len, Exact, Concatenate)
Date and time functions
Advanced paste special techniques
New features in Excel 2013/2016/365 (charts, slicers, Power Map, Power View, etc.)
Introduction to Java
Variables, data types, and operators
Control structures (if, switch, loops)
Object-oriented programming (classes, objects, inheritance, polymorphism)
Exception handling
File I/O
Collections (lists, sets, maps)
Multithreading
JDBC (Java Database Connectivity)
Basics of SQL (SELECT, INSERT, UPDATE, DELETE)
Joins, subqueries, and views
Indexing and optimization
Stored procedures and functions
Triggers
Transactions and locking
Python syntax
Data structures
Functions
File handling
Exceptions
Basics of Linux operating system
Command-line interface (CLI) usage
File system navigation and management
Permissions and user management
Shell scripting
Get Free Career Counselling
We are happy to help you 24/7