Advance Your Maritime Legal Career with an International LLM - Swansea University. Advance Your Maritime Legal Career with an Interna... Register Now
MCA UK OOW Orals preparation MCA UK OOW Orals preparation
MCA UK Chief Mate Orals Preparation MCA UK Chief Mate Orals Preparation

Maritime Focused Advanced Excel and Power BI course


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

Completed

Date & Time :
02/12/2023 at 10:00 AM IST
Price :
FREE
Duration :
15 hours

Event Sessions


Session 1 :
02/12/2023 at 10:00 AM IST   To   02/12/2023 at 12:00 PM IST  (2 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)


Session 5 :
16/12/2023 at 10:00 AM IST   To   16/12/2023 at 12:00 PM IST  (2 Hours)


Session 6 :
17/12/2023 at 10:00 AM IST   To   17/12/2023 at 12:00 PM IST  (2 Hours)


Content On Trainings



WHY DATA ANALYTICS? 

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. 

 

WHO SHOULD ATTEND THIS COURSE?

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

 

PROGRAM SYLLABUS (MS EXCEL)


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.

 

PROGRAM SYLLABUS (Power BI)
 

SESSION 1 : (16th Dec - 2 Hrs)
 

  1. Introduction To Power BI
  • Why Power BI
  • Power BI Vs Excel
  • Installing Power BI Desktop
  • About the Project.

2. Getting Started

  • Settings
  • Power BI interface
  • Canvas settings

3. Connecting & Shaping Data

  • Type of data connectors
  • Query editor tools
  • Data categories
  • Defining hierarchies
  • Creating a rolling calender

4. Say Hi! to DAX

  • Calculated columns
  • Measures Quick
  • measures Basic
  • Math calculations

5. Creating Relationship in model view.

  • Many to Many
  • One to many
  • Cross filter direction

 

SESSION 2: (17th Dec - 2Hrs)
 

6. Building Reports

  • The Power BI report view
  • Inserting objects & basic charts
  • Formatting options.
  • Filtering options
  • Managing interactions
  • Adding and Linking bookmarks & buttons
  • “What if” parameters
  • Importing custom visuals
  • Preparing reports using Canva / Power Point.

7. Managing Power BI

  • Data refreshing
  • Sharing reports
  • Some best practices

 

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

 

PLEASE NOTE: 

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

23rd Dec - Assignment presentation by all candidates 

 

If interested, please email on javeria@seaandbeyond.com or connect on +91 8097847091.

 

Regards,

Sea and Beyond Team.



About the Speakers


Capt. Gaurav Rana
Founder, Sea and Beyond,

Capt. Gaurav is the founder of Sea and Beyond which helps mariners transition ashore. He has assisted more than 100+ mariners in the career progression. Through his company, Sea and Beyond, we have been able to assist maritime professionals by

a) Building awareness of various fields where a mariner could go

b) Understanding best fields for them through psychometry test

c) Counselling to get into a field

d) Upskilling through various courses with the network of colleges partnered with

e) Facilitating placement ashore through the network of 250+ companies partnered with Sea and Beyond.

Capt. Gaurav has

  • Sailed for 13 years
  • Worked as Technical Director in British Maritime Technology for 4 years
  • Completed MBA from IIM- Ahmedabad
  • Passed MICS with distinction in 2011
  • 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



Arunabh Kumar

Sea and beyond is a great platform, Thank you f....

Read more >>

Joe Thermadam

I have attended the latest webinar on It was a ....

Read more >>

Isar Hashmi

Really an information pack session with great k....

Read more >>

Charanpal Singh

Lot of things got cleared about chartering and ....

Read more >>

Amar Mudgal

My best regards for starting this wonderful pla....

Read more >>

Capt Shehwaz Riyaz

This is the first time I have attended a webina....

Read more >>

Capt. Kedar Chaudhary

Capt. Gaurav, I think it is a good platform and....

Read more >>

Maneshsankar Hegden

Sea & Beyond thank you for the lovely and v....

Read more >>

Capt Nachiket M. Warty

The Webinar “Opportunities as a Surveyor for ....

Read more >>

Naveen Nathan

Thank you Sea & Beyond for the Innovative i....

Read more >>

Joe Thermadam

Was good and informative. Got a chance to know ....

Read more >>

Sanket Mahajan

I am really thankful to you for giving me this ....

Read more >>

Akash Saraswat

The Webinar was good, focusing on management sk....

Read more >>

Capt. Rohan Upadhye

Appreciate your efforts...great platform to sha....

Read more >>

Capt. Akhil Malhotra

I am personally impressed with the webinar/foru....

Read more >>

Capt Shehwaz Riyaz

The webinar by Capt. Harsh Johri was a very inf....

Read more >>

Capt. Naim Zaidi

Thanks for organizing webinar, found excellent ....

Read more >>

Nilay Bipul

Firstly, I would like to congratulate your team....

Read more >>

Capt. S.S Tripathi

A great initiative which truly goes beyond its ....

Read more >>

Debanshu Roy

Eye opener for seafarers interested to shift as....

Read more >>

Arunabh Kumar

First of all, exited for getting a seat in spit....

Read more >>

Arjun Trivedi

I have attended a number of webinars organized ....

Read more >>

Capt. Aashish Gupta

This is a wonderful initiative. Sea and beyond ....

Read more >>

Pavan Lagishetty

I go through the profile and emails and really ....

Read more >>

Capt. Ankit Garg

A never before initiative. Can provide a whole ....

Read more >>

Capt Pratik Pawar

Thank you and your team for the educational web....

Read more >>

Sanjeev Rajan

Thank you for this noble initiative and giving ....

Read more >>

Capt. Arvind Agnihotri

I would like to thank Capt Gaurav Rana without ....

Read more >>

Gaurav Maithil

Kudos to Sea & Beyond Team The webinar was ....

Read more >>

Capt. Prema Sagar Siyyadr...

Great job done by Sea & Beyond Team 

Read more >>

Capt. Nivin J.Varkey

Dear Capt. Gaurav Rana, appreciate your efforts....

Read more >>

Vivekananda Bhowmick

It has been a great experience being a part of ....

Read more >>

Deepak Sasikumar

It was an enlightening experience with many of ....

Read more >>

Capt. Dushtant Modak

Sea & Beyond is a unique initiative & I....

Read more >>

Deepan Chawla

It was certainly a great experience to attend t....

Read more >>

Jeff Noronha

Thank you for the webinar yesterday. It is real....

Read more >>

Gourav Kullu

Hello everyone, I walked in to the bootcamp Fin....

Read more >>

Capt. Bijay Chakraborty

Thank you Capt. Harsh and Capt. Gaurav...Nice i....

Read more >>

Capt. Tarun Sehgal

With regard to Pole Star webinar, it was great ....

Read more >>

Sarvesh kargutkar

Well there were alot of self doubts & block....

Read more >>

Gurnoor Gandhi

I found the following success from the coaching....

Read more >>

Gaurav Mishra

Thank you very much for info and your valuable ....

Read more >>

Sandeep singh choudhary

Thanks a lot Mariem & Best regards to Sea &....

Read more >>

Pankaj

Thanks a lot for the valuable info

....

Read more >>

Maneshsankar Hegden

The Webinar “Opportunities as a Surveyor for ....

Read more >>

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

CV Prep/Evaluation
SeaCommerce

Shop maritime books & essentials

Explore
DG Medical Examiners

Find approved doctors near you

Open Locator
Tools & Calculators

Free maritime tools for seafarers

View Tools
Education

Maritime/Logistics focused courses for you

Know more
More Jobs
Ship management

Mumbai

Operations Executive
View more
Ship management

Mumbai

Admin Executive
View more
Ship management

Mumbai

Purchase Manager
View more
See all

From the Blog


Professional Development

All the Blogs related to professional development

Read more >>

Latest Trends

Environmental, social and governance is a framework used to assess an organization`..

Read more >>
Browse all
Interview Prep/Mentoring

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

Know more
customer icon

Contact Us