Maritime Focused Advanced Excel course

Speakers :
1) Capt. Gaurav Rana
2) Shobha M
3) Mr. Gourav Kullu
Seats :


Date & Time :
02/12/2023 at 10:00 AM IST
Price :
Duration :
3 Hours

Event Sessions

Session 1 :
02/12/2023 at 10:00 AM IST   To   02/12/2023 at 1:00 PM IST  (3 Hours)

Session 2 :
03/12/2023 at 10:00 AM IST   To   03/12/2023 at 1:00 PM IST  (3 Hours)

Session 3 :
09/12/2023 at 10:00 AM IST   To   09/12/2023 at 1:00 PM IST  (3 Hours)

Session 4 :
10/12/2023 at 10:00 AM IST   To   10/12/2023 at 1:00 PM IST  (3 Hours)

Content On Trainings


Data analysis is the compass steering operations, optimizing voyages, and curbing emissions, a critical tool enhancing safety, logistics, and decision making. By harnessing data, professionals navigate challenges, steering the industry toward a more sustainable and resilient future. 



  • Junior Officers / Engineers
  • Operational level officers and Engineers
  • Senior Officers / Engineers
  • Management level officers and Engineers
  • Mariner and Technical superintendent and Manager



SESSION 1: (2nd Dec - 3 Hrs)

  • Basic data management
    • Excel database creation + sorts + Filters
  • Cell & workbook protections
  • Working with formulas
    • Cell addressing/referencing methods (Absolute + relative + mixed + Naming + range ..and more)
  • Assignment / Exercise related to formulas & filters.


SESSION 2 : (3rd Dec - 3 Hrs)

  • Utilize Formatting features
    • Adjusting + Printing + Table and Conditional formatting
  • Data validation
    • Creating and working with lists, dependent lists
    • Creating custom validation, handling input, and error alerts
  • Assignment / Exercise


SESSION 3 : (9th Dec - 3 Hrs)

  • Database management in excel
    • Basic and Dynamic Database Concepts
    • Subtotals and Text to Column Concepts Remove
    • Duplicates + Import/Export Data + Flash Fill + Concatenate +Transpose
  • Working with Functions
    • Basic functions: (Sum + Average + Max +Min +Count)
    • Statistical functions:(SumIf + SumIfs +AverageIf + AverageIfs + CountIf +CountIfs)
    • Logical functions: If + IFError + And + Or +Not + Nested IFs + Look Up
    • Reference functions: VLookup + Reverse Vlookup + Vlookup with IF + Vlookup with Indirect +Vlookup with IFError + HLookup +Index + Match + Wildcards in Vlookup
    • Text and Date/Time Calculations in Excel.
  • Assignment / Exercise


SESSION 4 : (10th Dec - 3 Hrs)

  • Working with charts
    • Different Types, Creating Excel Charts, Pivot Charts
    • Formatting, Design, and Layout of the Chart
    • Creating, Applying, and Removing Chart Templates, Sparkline, and Dynamic Charts
  • Working with Pivot Tables
    • Introduction & creation of pivot tables
  • Overview & review of the assignments given.
  • Debriefing & how you could continue using excel after the course.


Final Assignment

  • Doubt clearing Sessions
  • Report presentation


Bonus Add-On

Integrating Chat-GPT with Excel and Power BI

  • The AI World
  • Prompt engineering (Tips & best practices)
  • Chat GPT for Excel
  • Chat GPT for Power BI



18th and 20th Dec - Doubt clearing session (1 Hrs each) 

23rd Dec - Assignment presentation by all candidates


If interested, please email on or connect on +91 8097847091.



Sea and Beyond Team.

About the Speakers

Capt. Gaurav Rana
Founder, Sea and Beyond,

Capt. Gaurav is the founder of Sea and Beyond and has

  • Sailed for 13 years
  • Worked as Technical Director in British Maritime Technology for 4 years
  • Worked in IBM for 4 years where he program managed large data analytics projects
  • Passionate about Learning and development and growth of maritime community

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.

Mr. Gourav Kullu
Master Mariner,

He is a master mariner with 21 years of sailing experience on oil tankers. He also has 2 plus years of experience as a marine faculty. Currently, he is working as an independent consultant doing navigation audits and Remote VDR analysis and provides solutions to clients with extensive use of Power BI. He has also completed a course from Maven Analytics on Microsoft Power BI desktop for Business Intelligence.
In addition, being an NISM-certified personnel, he uses Power BI to optimize his trading strategy to meet his investment goals.

Similar Trainings

Give your career a boost with S&B professional services.

CV Prep/Evaluation

Maritime/Logistics focused courses for you

Know more
More Jobs
See all

From the Blog

General Blogs

All the general topic blogs will be included in this category


Professional Development

All the Blogs related to professional development

Browse all
Interview Prep/Mentoring

Find your polestar with the host of experts available on our platform

Know more