Career Guidance Workshop
Every Saturday, 10:30am Register Now
Master Data. Unlock Insights. Drive Smart Decisions.
The Advanced Excel Training Program at TGS Training Institute is designed for students, professionals, and business analysts who want to go beyond basic spreadsheets and become experts in data analysis, automation, and reporting using Microsoft Excel.
This hands-on program helps learners gain advanced-level skills in formulas, dashboards, pivot tables, VBA macros, and business data visualization all of which are essential for modern data-driven roles.
Whether you’re from finance, analytics, operations, or management, this course will enhance your efficiency, accuracy, and productivity in real-world business environments.
8th October
07:00 AM TO 08:00 AM
80-100 Days
Training
At JVSIT & TGS, our Advanced Excel Training Program focuses on transforming learners into Excel power users. You’ll learn how to automate repetitive tasks, handle complex datasets, create professional reports, and present insights visually through dynamic dashboards.
Our trainers, with real industry experience, guide you step-by-step through advanced formulas, data modeling, pivot charts, and macros ensuring you develop practical, job-ready skills for business and analytics roles.
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
You’ll learn formulas, pivot tables, dashboards, VBA, and data analytics for business use.
Students, professionals, accountants, and analysts looking to master Excel for business and data.
Basic Excel knowledge is helpful, but the course includes a quick revision of core concepts.
You’ll be able to automate reports, analyze data, create dashboards, and enhance productivity.
Yes, both online and classroom training options are available.
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