Java
We embark on an exciting journey into the world of programming with one of the most versatile and widely-used languages, Java. Whether you’re a novice taking your first steps into the coding realm or an experienced developer looking to refine your skills, this course is tailored to accommodate all levels of expertise.
Java has become a cornerstone in the software development landscape, powering a myriad of applications from mobile apps to enterprise-level systems. This course is crafted to provide you with a comprehensive understanding of Java’s fundamentals, syntax, and principles, laying a solid foundation for your programming endeavors.
Our exploration will begin with the basics, covering topics such as variables, data types, and control structures. We’ll gradually progress into more advanced concepts, including object-oriented programming, exception handling, and multithreading. You will gain hands-on experience through practical coding exercises, reinforcing theoretical knowledge with real-world applications.
As we traverse through this syllabus, we’ll not only focus on Java’s core features but also delve into the broader ecosystem, exploring libraries, frameworks, and tools that enhance your development capabilities. Whether your goal is to build robust applications, explore backend development, or delve into the world of Android app development, this course is designed to equip you with the skills needed to succeed.
So, fasten your seatbelts and get ready to code! The Java Syllabus Course is your gateway to mastering this powerful language, empowering you to create efficient, scalable, and innovative solutions. Let’s embark on this journey together, where logic meets creativity, and your coding potential knows no bounds.
Java Syllabus
- Syllabus of Excel and Advanced Excel Course in Bangalore
Module 1: Basic Excel (Duration: 10Hrs )
Text to Columns
Concatenate
The Concatenate Function
The Right Function with Concatenation
Absolute Cell References
Data Validation
Time and Date Calculations
Conditional Formatting
Exploring Styles and Clearing Formatting
Using Conditional Formatting to Hide Cells
Using the IF Function
þÿChanging the Value if false Condition to Text
Pivot Tables
Creating a Pivot Table
Specifying PivotTable Data
Changing a PivotTables Calculation
Filtering and Sorting a PivotTable
Creating a PivotChart
Grouping Items
Updating a PivotTable
Formatting a PivotTable
Using Slicers
Charts
Creating a Simple Chart
Charting Non-Adjacent Cells
Creating a Chart Using the Chart Wizard
Modifying Charts
Moving an Embedded Chart
Sizing an Embedded Chart
Changing the Chart Type
Chart Types
Changing the Way Data is Displayed
Moving the Legend
Formatting Charts
Adding Chart Items
Formatting All Text
Formatting and Aligning Numbers
Formatting the Plot Area
Formatting Data Markers
Pie Charts
Creating a Pie Chart
Moving the Pie Chart to its Own Sheet
Adding Data Labels
Exploding a Slice of a Pie Chart
þÿData Analysis “ Overview
types of Data Analysis
Data Analysis Process
Working with Range Names
Copying Name using Formula Autocomplete
Range Name Syntax Rules
Creating Range Names
Creating Names for Constants
Managing Names
Scope of a Name
Editing Names
Applying Names
Using Names in a Formula
Viewing Names in a Workbook
Copying Formulas with Names
Difference between Tables and Ranges
Create Table
Table Name
Managing Names in a Table
Table Headers replacing Column Letters
Propagation of a Formula in a Table
Resize Table
Remove Duplicates
Convert to Range
Table Style Options
Table Styles
Cleaning Data with Text Functions
Removing Unwanted Characters from Text
Extracting Data Values from Text
Formatting Data with Text Functions
Advance Excel (Duration: 15Hrs)
Module 2: Date Formats (Duration: 2Hrs)
Converting Dates in Serial Format to Month-Day-Year Format
Converting Dates in Month-Day-Year Format to Serial Format
þÿObtaining Today s Date
Finding a Workday after Specified Days
Customizing the Definition of a Weekend
Number of Workdays between two given dates
Extracting Year, Month, Day from Date
Extracting Day of the Week from Date
Obtaining Date from Year, Month and Day
Calculating Years, Months and Days between two dates
Module 3: Conditional Formatting (Duration: 2Hrs)
Highlight Cells Rules
Top / Bottom Rules
Data Bars
Color Scales
Icon Sets
New Rule
Clear Rules
Manage Rules
Module 4: Sorting (Duration: 2Hrs)
Sort by Text
Sort by Numbers
Sort by Dates or Times
Sort by Cell Color
Sort by Font Color
Sort by Cell Icon
Sort by a Custom List
Sort by Rows
Sort by more than one Column or Row
Module 5: Filtering (Duration: 2Hrs)
Filter by Selected Values
Filter by Text
Filter by Date
Data Analysis with Excel
Filter by Numbers
Filter by Cell Color
Filter by Font Color
Filter by Cell Icon
Clear Filter
Advanced Filtering
Filter Using Slicers
Module 6: Other Topics (Duration: 2Hrs)
Subtotals with Ranges
Subtotals
Nested Subtotals
Quick Analysis
Quick Analysis with TOTALS
Sum
Average
Count
%Total
Running Total
Sum of Columns
Module 7: Lookup Functions (Duration: 3Hrs)
Using the VLOOKUP Function
Using VLOOKUP Function with range lookup TRUE
Using VLOOKUP Function with range lookup FALSE
Using the HLOOKUP Function
Using HLOOKUP Function with range lookup FALSE
Using HLOOKUP Function with range lookup TRUE
Using the INDEX Function
Using MATCH Function
Module 8: Pivoting (Duration: 2Hrs)
PivotTables
Creating PivotTable
Recommended PivotTables
PivotTable Fields
PivotTable Areas
Nesting in the PivotTable
Filters
Slicers
Summarizing Values by other Calculations
PivotTable Tools
Using Pictures in Column Charts
Band Chart
Thermometer Chart
Gantt Chart
Waterfall Chart
Sparklines
Pivot Charts
PivotChart from PivotTable
PivotChart without a PivotTable
Working with Multiple Sheets
Multiple Worksheets with same Structure
Creating a Formula across Multiple Worksheets
Summarizing Data in Multiple Worksheets
What-If Analysis