Learn Computer Skills
MS EXCEL
Duration: 12 Hours Fees Rs: 3000/
Introduction to Excel
Navigating worksheets
Formatting and conditional formatting
Security and protection
Absolute /Relative Reference
Data Table
Working with formulas and function
Reference Function
Filter , advance filter
Sorting and data validation
Names Ranges
Creating Chart and Graphics
Simple Chart
Pie chart
Logical functions using excel
AND ,IF,OR ,TRUE,FALSE
CONCATENATE ,LEFT,RIGHT,MID,LEN,TRIM,UPPER,LOWER,PROPER,etc.
FIND,SEARCH,REPLACE, SUBSTTTTUTE,IFERROR,DATE
Analyzing Data with excel
Consolidating Worksheets, Array, Hyperlink.GoTo.FreezePanes,PasteSpecial
(VLOOKUP/HLOOKUP,INDEX,MATCH,etc) Offset ,what if, Goal seek, Cumulative
Pivot tables
Mathematical functions
SUM,COUNT,COUNTA,MAX,MIN,AVERAGE,SUMIFS, COUNTIF,COUNTBLANK,SUMIF,SUMPRODUCT
3 Real Life Case Study
MS VBA
Duration: 25 Hours Fees Rs: 4000/
Introducing VBA
What is Logic?
What is VBA?
Introduction to macro Recordings, IDE
How VBA works with excel
Working in the Visual basic Editor
Introducing the excel object Model
Using the Excel Macro Recorder
VBA sub and Function procedures
Key Components of Programming language
Essential VBA Language Elements
Keywords & Syntax
Programming statements
Variables & Data types
Comments
Operators
Working with Range objects
A Look at some commonly used codes snippets
Programming constructs in VBA
The With –End with Block
Control Structures
Looping Structures
Functions & Procedures in VBA- Modularizing your programs
Worksheet & workbook functions
Automatic procedures and events
Objects & Memory Management in VBA
The NEW and SET Key words
Destroying Objects – The Nothing Keyword
Error handling controlling accessibility of your Code –Access specifies
Code Reusability – Adding references and components to your code
Communicating with your Users
Simple Dialog Boxes
User Form Basic
Using User From Controls
Accessing your Macros through the user interface
MS SQL + ACCESS
Duration: 14 Hours Fees Rs: 4000/
Introductions to Ms Access
What are databases
Create and Modify Tables
Working with Tables
Form Designing
Report Designing
What is SQL – A Quick Introduction Getting Started
SQL Management Studio
Utilizing the object Explorer
Understanding basic RDBMS concepts
Schema –Meta Data –ER Diagram
Looking at an example Database design
Data Integrity Constraints & type of relationships
Basic concepts –Queries ,Data types & Null Values, Operators and Comments in SQL
Data Manipulations –Reading & manipulating a single table
Basic Select statement
Additional components –where ,Group , By, Order by & Having clauses
Data manipulation – Basic Functions
Union clause –Use & constraints
Reading & Manipulating Multiple Tables
Join & Aliases
Data based objects creation (DDL Commands)
Creating , Modifying & Deleting Tables
Create Tables & Create Index statement
Insert , Update & Delete statement
Drop & Truncate statement –Users & Differences
Alter Table & alter Column statements
R
Fees Rs: 4000/
Introduction to R
1. Download and setup of R Studio
2. Understanding the R Studio IDE
3. Understanding variables and data types
4. Vectors, Matrices, Factors, Lists, Data frames
Programming in R
1. Relational operators and Logical operators
2. Conditional statements
3. Loops - while loop, for loop etc
4. using in built functions
5. Apply family of functions
6. Data manipulation functions and regular expressions
7. Working with time series data
8. Introduction to R packages
Writing functions in R
1. Creating your own functions
2. Functional coding
3. Advanced functional coding
4. Creating robust function and error handling
T2S Talent to Success
Duration: 1 Month Fees Rs: 6000/
Future Track has launched online course T2S in India which is developed by qualified actuary of UK and duration of this course is One month which will help you
to get a job in company, interview and CV preparation and basic software skills (MS-Excel, MS-Access, VBA) exercises on real time data like (Reserving, claim
Analytics, Investment, Future Payment).This product is considered as an internship project, as you get feedback for each Exercise by Fellow Members from UK.
T2S is specially developed for Actuarial Science students. The price of this course is Rs 6000. After paying fees a student will get login id and can complete course
Anywhere with help of internet. For more details please visit www.futuretrack/org/internship.php
Duration 3 Hours
Why should you attend this session?
Every organization wants to hire people who will help them grow and add to its success factor. Organizations that are serious about attracting and retaining the best talent
use this tool to access their candidates. While people often talk about the obvious measures like - technical skills and subject knowledge, they fail to gauge the importance
of soft skills like attitude, communication skills, body language etc. all of which are being taken into consideration by recruiters.
This session will help you to understand how this test works and how recruiters use this tool subtly to understand if you are a right fit for the organization.
Topics to be covered!
The topics that we aim to cover in this session are as follows:
a) What is a Psychometric test and its relevance in the Actuarial domain
b) Are recruiters looking for right answers or right attitude?
c) Most commonly asked questions in this test
d) Real life case studies
Duration 3 Hours
Time Management
Workshop!
Why should you attend this session?
Time management is the epicenter of our being. Every success story is backed by an efficient time management. Time management is “extremely” important in everyone’s
life.
This is a highly effective and powerful workshop where the participant will go through some life changing processes. Each participant will be going through a journey of self-
realization and will be introduced to some of the best time management techniques which are used across top B schools and organizations.
What to expect from this session?
Meet the unexpected side of you
Intense live brainstorming sessions
Step by step guide for effective time management
Powerful “2-list” strategy to push you towards success
A transformed lifestyle
Duration 3 Hours
Making Smarter Presentation Workshop
Presentation plays a vital role in
e-learning and has revolutionized
the concept of providing
knowledge at all levels. Whether it
is on initial stages like schools and
colleges or it is on the corporate
front, learning has taken a new
edge with advanced technology.
Why should you attend this session?
In today’s fast moving world, where we are dealing with plethora of numbers and facts, it is a challenge to present the information to the audience (which can range from a
fresher to the CEO of the company) in a short, precise and impactful manner. While many people use PowerPoint, very few use it effectively.
A lot of hiring processes, professional papers, project works, and internships involve extensive use of PowerPoint and having knowledge about this tool would definitely give
you an edge over other. It is unfortunate that a lot of times people, despite having all the talent, do not succeed, because they fail to present their view points in the right
way.
This session will give you a thorough understanding on:
a) What are the three types of presentation and why they are used?
b) The art of storytelling through presentation
c) What are the four skills that need to be considered while making a presentation?
d) Some secret tools available that will help you create magical presentations!
e) Extensive use of ribbons
In a profession like Actuarial, we are constantly dealing in PowerPoints. Be it exams, interviews, project work, corporate work or even presenting new ideas, this tool will
definitely be an advantage to you.
TECHNICAL TRAINING
Duration 6 Hours
A workshop on ULIP which will cover following aspects:
Financial mechanics of the life insurance company
Roles played by the actuaries in the life insurance company
Type of life insurance products
ULIP - Customer point of view
ULIP - Insurance Company point of view
Inputs required for projecting CF’s
Source of Inputs
MADs for reserving requirement
IRDAI Solvency requirement
Starting with a simple excel ULIP model
Validating an Actuarial model
Duration 6 Hours
A workshop on TERM which will cover following aspects:
What Actuary does?
What Actuary can does?
Why Actuary is restricted to insurance particular in India?
Then briefing about all the actuarial functions done in an Insurance companies ( Help to understand the student job profile and understand things better)
What is an term plan
Ingredients required to manufacture it
IRDAI regulations ( soft copy will be shared & relevant regulations will be shown)
Source & actuarial standards for assumptions like investment, expenses, mortality, lap station
Building an cash flow model on excel
Projecting premium, expense, death and reserving cash flows
Validating the model to find out any error in the model.
Duration 12 Hours
A workshop on Reserving in General Insurance which will cover following aspects:
Reserving - a concept
Regulations
Data preparation and Data manipulation
Reserving methods
Practical reserving models, Diagnostics and reasonability of results
Contact Us:
Future Track Edutech Private Limited
Visit us on: www.futuretrack.org
Email: [email protected]
Phone: 011-45024949, +91-9910024949
116-118, Basement, Mall Road,
Near GTB Nagar Metro Station Gate No: 3
Delhi -110009
