Career Guidance Workshop
Every Saturday, 10:30am Register Now
Turn Data Into Decisions. Build Smart Business Solutions.
The Advanced MS Excel Course at JVSIT & TGS Training Institute is designed for professionals who want to transform raw data into meaningful insights.
This practical program dives deep into advanced Excel techniques—covering automation, analytics, dashboards, and data visualization—to help you make smarter business decisions.
Whether you’re in finance, HR, operations, or business analytics, this course will make you an Excel expert capable of simplifying complex tasks and improving efficiency in any organization.
8th October
07:00 AM TO 08:00 AM
80-100 Days
Training
At JVSIT & TGS, our Advanced MS Excel Program bridges the gap between basic spreadsheet skills and professional data analytics.
You’ll gain the expertise to manage, clean, analyze, and visualize data using Excel’s most powerful features.
Through interactive lessons and real-world exercises, you’ll master advanced formulas, pivot tables, Power Query, and automation tools like VBA—everything you need to handle data efficiently in today’s digital workplace.
Day 1
Types of applications
Roles in software industry
Responsibilities of each role
Introduction to What WG
Day 2
Software development life cycles
Types of SDLC
Day 3
Water Fall Model
V Model
Circler Model
Day 4
Agile Model
Domain choosing
Project choosing
Modules and functionalities finding
Day – 5
Introduction to UI-UX
Introducing FIGMA tool
Day – 6
Optimal design principles of database, business logic
Time and Space complexity
Day 7
GitHub with sample HTML page
Creating Repos
Creating LinkedIn account
Day 8
Difference between platform and domain
Requirement gathering for 2 real time scenarios using Agile
Day 9
Deployment methods on hostings
Knowledge about servers and load balancers
Day 10
Power of AI and prompting (webinar)
Using Copilot tool
Using ChatGPT
Day – 1
Day – 2
Day – 3
Day – 4
Day – 5
Day – 6
Form tags and Attributes
MultiMedia tags
Assignment – Naasongs.
Assignment – Sample login, register, forgot password pages
Day – 7
Day – 8
Day – 9
Day – 10
Day – 11
Day – 12
Day – 13
Day – 14
Day – 15
Day – 16
Day – 17
Day – 18
Day – 20
Day – 21
Day – 1
Day – 2
Day – 3
Day – 4
Day – 5
Day – 6
Day – 7
Day – 8
Day – 9
Day – 10
Day – 11
Day – 12
Day – 13
Day – 1
Day – 2
Day – 3
Day – 4
Day – 5
Day – 6
Day – 7
Day – 8
Day – 9
Day – 10
Day – 11
Day – 12
Day – 13
Day – 14
Day – 15
Day – 1
Day – 2
Day – 3
Day – 4
Day – 5
Day – 6
Day – 7
Day – 1
Day – 2
Day – 3
Day – 4
Day – 5
Day – 6
Day – 7
Hibernate and Spring
Day – 1
1.Introduction to Spring Boot
2.Setting Up Spring Boot and Creating a Basic Program
If you need the sample Spring Boot application code as text:
java
}
Day – 2
text
// Sample application.properties
spring.datasource.url=jdbc:h2:mem:testdb
spring.jpa.hibernate.ddl-auto=update
Day – 3
text
// Sample Actuator Configuration
management.endpoints.web.exposure.include=health
Day – 4
java
// Sample JPA Entity
@Entity
public class User {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
private String name;
// getters and setters
}
Day – 5
java
// Sample Security Configuration
@Configuration
@EnableWebSecurity
public class SecurityConfig extends WebSecurityConfigurerAdapter {
@Override
protected void configure(HttpSecurity http) throws Exception {
http
.csrf().disable()
.authorizeRequests()
.antMatchers(“/public/**”).permitAll()
.anyRequest().authenticated();
}
}
Day – 6
java
// Sample REST Controller
@RestController
@RequestMapping(“/api/users”)
public class UserController {
@GetMapping
public List getAllUsers() {
// return list of users
}
@PostMapping
public User createUser(@RequestBody User user) {
// create and return user
}
}
Day – 7
text
# Sample Dockerfile
FROM openjdk:11-jre-slim
COPY target/demo-0.0.1-SNAPSHOT.jar app.jar
ENTRYPOINT [“java”, “-jar”, “/app.jar”]
Day – 8
java
// Sample Eureka Server Configuration
@SpringBootApplication
@EnableEurekaServer
public class EurekaServerApplication {
public static void main(String[] args) {
Day – 9
java
// Sample Microservice Configuration
@SpringBootApplication
@EnableDiscoveryClient
public class MicroserviceApplication {
public static void main(String[] args) {
SpringApplication.run(MicroserviceApplication.class, args);
}
}
SpringApplication.run(EurekaServerApplication.class, args);
}
}
Day – 10
java
// Sample Asynchronous Method
@Service
public class MyService {
@Async
public CompletableFuture AsyncMethod() {
return CompletableFuture.completedFuture(“Async Result”);
}
}
Day – 11
text
# Sample Kubernetes Deployment YAML
apiVersion: apps/v1
kind: Deployment
metadata:
name: spring-boot-app
spec:
replicas: 2
selector:
matchLabels:
app: spring-boot-app
template:
metadata:
labels:
app: spring-boot-app
spec:
containers:
– name: spring-boot-app
image: spring-boot-app:latest
ports:
– containerPort: 8080
Students, professionals, accountants, data analysts, and anyone looking to enhance Excel and analytical skills.
Basic Excel knowledge is helpful but not mandatory. Our course starts with a quick recap before diving into advanced tools.
Unlike basic Excel classes, we focus on automation, dashboards, and advanced analytics that are directly used in corporate environments
You’ll work with Power Query, Power Pivot, and VBA for automation, along with Excel’s latest AI-powered features.
Yes. After completion, you’ll receive an Advanced MS Excel Certificate from JVSIT & TGS, widely recognized by employers.
Empowering careers with tech and hands-on learning. 15,000+ trained, 10,000+ placed, 20+ global partners.
All Rights Reserved Web Rocz.
Sitemap | FAQs | Cancellation & Refunds | Privacy Policy | Terms & Conditions | Feedback
Note: The certification names and logos are the trademarks of their respective owners. View Disclaimer.
WhatsApp us