Bimanik Administrator May 7, 2022

Bimanik: Basic Excel And Advanced Excel

Ready to Learn More? Enroll Now.
Basic Excel And Advanced Excel

Bimankik (Hindi Name for Actuarial Science) is a parallel course that focuses on the growing needs of Actuarial Aspirants. With this course, you will develop an in-depth understanding of actuarial and statistical concepts from a practical aspect.

With the advent of IFOA Curriculum 2019, the IFOA is baking R Programming in Actuarial Science Course. Therefore, Sankhyiki has taken an initiative to hone the skills of the actuarial aspirants and prepare them for the corporates.

Hence, as a part of Initiative, Sankhyiki is training its actuarial students on Excel, VBA, SQL and R Programming.

Owing to the market scenario for actuarial jobs, we have analyzed that the companies need people who are good in excel because most of the insurance/actuarial firms work on excel and a big opportunity arises if the person is skilled in this particular software.

The companies clearly state that they are looking for people who have knowledge of advanced excel and Macros/VBA. Hence, we have created the curriculum in such a manner that it caters to the need of the actuarial aspirants and most of the learning is accompanied through CAPSTONE PROJECTS which will make the person ready from the day one.

The learnings include Loan Calculators, Data Visualization, Exploratory Data Analysis, Understanding Statistics and Application in the field of Insurance along with Actuarial Case Studies such as Run of Triangles, Computing Cashflows, Running Regression and doing predictions. The list is long…

The key to emerge as a winner in this domain is – Practice and Practice.

Syllabus
 
  1. Advanced Formula
  2. Pivot Tables
  3. Data Validation
  4. Reporting
  5. Analyzing Data
  6. Advanced Charting
  7. External Datasets
  8. Capstone Project
  1. Writing First VB Macro
  2. Errors and Debugging
  3. Range, Cells, Active Cells and Offset
  4. Worksheets, Charts and Sheets
  5. Variables and Objects
  6. Message and Input Boxes
  7. With & IF Statements
  8. Select Case and Loops
  9. Creating Functions
  10. On Error, Resume and GoTo
  11. Userforms, Text Files and Event Procedures
  12. ActiveX Data Objects
  13. Query DB
  14. Modify and SQL Statements
  15.  
  1. Installing R
  2. Setting up on Machine
  3. Setting up R Studio
  4. Why Learn R in comparison to Excel
  1. R Command Script
  2. Comments
  3. R Script Files
  1. Vectors, Lists, Matrices and Arrays
  2. DataFrames and Factors
  1. Creating Variables
  2. Data Types of a Variable
  3. Finding and Deleting Variables
  4.  
avatar-1577909_960_720
Akshay Chauhan Founder & Director
Faculty for CS1, CS2, Data Science with R and Bimankik
TESTIMONIALS
Recommendations From The Industry Professionals
Akshay sir is a superb mentor, I have taken actuarial coaching from other teachers...
Profile_avatar_placeholder_large
Mansi Malik Assistant Manager - DHFL Pramerica
The best Actuarial professor today, he has in-depth knowledge of the subjects and guides...
Profile_avatar_placeholder_large
Sneha Poddar Actuarial Analyst - Aon-Hewwit
Akshay is a quality professor for actuarial science . The technique of concept development.
Profile_avatar_placeholder_large
Ankit Chhajer Actuarial Analyst-RR Donnolley