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
Career Opportunities For Turk...
Capt. Amarinder Brar
Career Transition – What Shou...
Capt. Harsh Johari
Career Transition For Mariners
Capt. Harsh Johari
Certification Course On Angel...
Anchal Taatya, Saurabh Kumar,
Find Your Pole Star
Capt. Harsh Johari
Leveraging LinkedIn
Capt. Harsh Johari
Maritime Writing: From Writin...
Capt. V.S Parani
Masterclass On Angel Investme...
Anchal Taatya, Saurabh Kumar,
MSc Shipping Operations & Man...
Dr. Antonis Violaris
Simplified Hydrodynamics And ...
Capt. Puneet Malhotra
Find Your Pole Star Bootcamp 2.0
Capt. Harsh Johari
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 Power BI Course
Capt. Gaurav Rana, Shobha M,
Maritime Focused Advanced Exc...
Capt. Gaurav Rana, Shobha M,
MCA UK OOW Orals preparation
Capt. Sherry
MCA UK Master Orals Preparation
Capt. Sherry
MCA UK Chief Mate Orals Prepa...
Capt. Sherry
Maritime Focused Advanced Exc...
Capt. J.S Parhar, Jayshree Tawari,
Maritime Focused Power BI Course
Mr. Gourav Kullu
Maritime Focused Excel and P...
Capt. J.S Parhar, Mr. Gourav Kullu,
MCA UK COC Class 2 - Oral and...
Oceanlink MariTime ...
Testimonials from our customers...
See allGive your career a boost with S&B professional services.
CV Prep/Evaluation
Prep Service More Jobs
See allFrom the Blog
Latest Trends
Environmental, social and governance is a framework used to assess an organization`..
Read more >>
Interview Prep/Mentoring
Find your polestar with the host of experts available on our platform
Know more