Maritime Focused Intermediate Excel training
Speakers :
Seats :
Completed
Date & Time :
Price :
Duration :
Event Sessions
Content On Trainings
Features of the Training:
1. Instructor Led Training
2. 12 hours Training + 10 hours Assignment worksheets /Templates
3. Real Time Case Studies & Doubt solving after each session
4. Exclusive email support even after the course
Session I (3 Hrs) on 6th August 2022 at 10:00am-1:00pm IST
1. What is Excel & How will it professionally benefit persons onboard & ashore.
2. Basic Database Management in Excel
- Building An Excel Database
- Performing Single / Multi-Level Sorts
- Filters – Auto, Custom and Advanced
3. Cell and Workbook Protections:
- Protecting Cells, Protecting Sheets, Protecting Workbooks
4. Working with Formulas:
- Cell Addressing Or Referencing Methods
- Absolute, Relative & Mixed Referencing
- Naming References and Range
- Referring To Other Sheets & Workbooks
Assignment / Exercise related to formulas and filters
Session II (3 Hrs) 7th August 2022 at 10:00am-1:00pm IST
5. Working with More Formatting Features
- Conditional Formatting
- Formatting Data as table
- Adjusting and Printing with worksheets
6. Data Validation
- Creating Data Validation
- Working With List & Dependent List
- Creating List with Dynamic Ranges
- Creating Custom Validation
- Handling Input And Error Alerts
Assignment / Exercise
Session III (3 Hrs) 13th August 2022 at 10:00am-1:00pm IST
7. Database Management in Excel
- Basic and Dynamic Database Concepts
- Subtotals
- Text to Column concepts
- Remove Duplicates
- Import and Export data
- Flash fill
- Concatenate (Combining words or names )
- Transpose
8. Working with Functions
- Basic : Sum, Average, Max, Min, Count
- Statistical: Sumif, SumIfs, AverageIf, AverageIfs, CountIf and CountIfs
- Logical: Working With If, IFError, And, Or, Not, Nested IFS Functions
- Look Up & Reference: VLookup,Reverse Vlookup, Vlookup with IF function, Vlookup With Indirect function , Vlookup with IFError, HLookup, Index and Match Function ,
- Vlookup With Wildcards
- Text Function
- Date, Time Calculations In Excel
Assignment / Exercise
Session IV (3 Hrs) 14th August 2022 at 10:00am-1:00pm IST
9. Working with Charts
- Working With Different Types
- Creating Excel Charts
- Pivot Charts & Formatting Charts
- Working With Design And Layout Of The Chart
- Creating And Applying & Removing Chart Template
- Sparkline & Dynamic charts
10. Working with Pivot Tables
- Introduction and creation of Pivot tables
11. Overview and review of the assignments given
12. Debriefing and how you could continue using excel after the course.
Get this Service by paying Rs.2999/-
For more details Call : +91 89288 96420/ +91 89761 24339
About the Speakers
Shobha M
Corporate Trainer,She is based out of Bangalore and has been teaching excel for past 10 years and has carried out a lot of trainings to corporates.
Capt. J.S Parhar
Master mariner,He is a master mariner with more than 25 years of experience. He has sailed with P&O, Mitsui, Zodiac, K Line, Nakilat and has been using excel for past 23 years. He has sailed on Capesize Bulk / LPG and LNG vessels. He is someone who has learned excel through his own drive and much before google came into vogue. He has used excel to make GHA calculations, stability calculations, has extensively used Macros V-looks to make life easy on board a vessel for himself and for his colleagues.
Similar Trainings
Maritime Writing: From Writin...
Capt. V.S Parani
Career Transition For Mariners
Capt. Harsh Johari
Leveraging LinkedIn
Capt. Harsh Johari
Simplified Hydrodynamics And ...
Capt. Puneet Malhotra
Career Transition – What Shou...
Capt. Harsh Johari
Find Your Pole Star
Capt. Harsh Johari
Find Your Pole Star Bootcamp 2.0
Capt. Harsh Johari
Masterclass On Angel Investme...
Anchal Taatya, Saurabh Kumar,
Certification Course On Angel...
Anchal Taatya, Saurabh Kumar,
MSc Shipping Operations & Man...
Dr. Antonis Violaris
Career Opportunities For Turk...
Capt. Amarinder Brar
Maritime Informatics - Introd...
Jussi Poikonen, Wolfgang Lehmacher,
Introduction to Finance for S...
Mr. Vinay Naidu
Intro course on Finance for S...
Mr. Vinay Naidu
Maritime Focused Advanced Exc...
Capt. Gaurav Rana, Shobha M,
Maritime Focused Advanced Exc...
Capt. Gaurav Rana, Shobha M,
Maritime Focused Power BI Course
Capt. Gaurav Rana, Shobha M,
Maritime Focused Advanced Exc...
Capt. J.S Parhar, Jayshree Tawari,
Maritime Focused Excel and P...
Capt. J.S Parhar, Mr. Gourav Kullu,
Maritime Focused Power BI Course
Mr. Gourav Kullu
Advanced Course on Commercial...
Capt. Ashok Sharma, Dr. Abhay Singh Thakur,
Maritime Focused Advanced Exc...
Jayshree Tawari
Maritime Focused Excel and P...
Mr. Gourav Kullu, Jayshree Tawari,
Maritime Focused Power BI course
Mr. Gourav Kullu
Advanced Course on Commercial...
Capt. Ashok Sharma, Dr. Abhay Singh Thakur,
ICS Exams Tutorials - Tanker ...
Capt. Gaurav Rana
ICS Exams Tutorials - Introd...
Capt. Gaurav Rana
ICS Exam Tutorials: Shipping ...
Capt. Gaurav Rana
Maritime Focused Excel and P...
Jayshree Tawari, Tiju Chandy,
Maritime Focused Advanced Exc...
Jayshree Tawari, Tiju Chandy,
Maritime Focused Power BI cou...
Mr. Gourav Kullu
Digital Transformation For Ma...
Uttam Kumar, Capt. Shailesh Bham...,
Maritime Focused Advanced Exc...
Jayshree Tawari
Maritime Focused Excel and P...
Jayshree Tawari, Aaquib Jawed,
Maritime Focused Power BI cou...
Aaquib Jawed
MCA UK Chief Mate Orals Prepa...
Capt. Sherry
MCA UK OOW Orals preparation
Capt. Sherry
Testimonials from our customers...
See allGive your career a boost with S&B professional services.
CV Prep/Evaluation
Prep Service SeaCommerce
Shop maritime books & essentials
DG Medical Examiners
Find approved doctors near you
Tools & Calculators
Free maritime tools for seafarers
More Jobs
Ship management
WFH
Compliance Analyst
Ship management
WFH
Voyage Senior Financial An..
Ship management
Singapore
HR - People & Culture Advi..
Interview Prep/Mentoring
Find your polestar with the host of experts available on our platform
Know more
