Maritime Focused Excel and Power BI Course Oct 2025
Speakers :
Seats :
Completed
Date & Time :
Price :
Duration :
Event Sessions
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: 25th Oct 2025 : (3 Hrs each)
- Working with Functions
Basic functions:(Sum + Average + Max +Min +Count)
- Working with referencing
Cell addressing/referencing methods (Absolute + relative + mixed + range ..and more)
- Logical functions
If + IFError + And + Or +Not + Nested IFs +
- Utilize Formatting features
Conditional formatting
Assignment / Exercise
PROGRAM SYLLABUS (MS EXCEL)
SESSION 2: 26th Oct 2025 : (3 Hrs each)
- Database management in excel
Static/Range and Dynamic Database Concepts +Tables+ Sort + Filter
- Statistical functions
(SumIf + SumIfs +AverageIf + AverageIfs + CountIf +CountIfs)
- Name manager
Naming the range + Using the name range in formulas
- Data validation
Creating and working with lists, dependent lists
Creating custom validation, handling input, and error alerts
- Cell & workbook protections
Assignment / Exercise
SESSION 3 : 01st Nov 2025 : (3 Hrs each)
- Text to Column Concepts
- Text and Date/Time Calculations in Excel.
- Look Up Reference functions
- VLookup + Reverse Vlookup + Vlookup with IF + Vlookup with Indirect +Vlookup with IFError + HLookup +Index + Match + Wildcards in Vlookup
- Assignment / Exercise
SESSION 4 : 02nd Nov 2025 : (3 Hrs each)
Remove Duplicates + Import/Export Data + Flash Fill + Concatenate +Transpose
- 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.
PLEASE NOTE:
Doubt clearing session (1 Hrs each)
Assignment presentation by all candidates
PROGRAM SYLLABUS (Power BI)
SESSION 5 : 8th Nov 2025 (2 Hrs)
- 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 6: 9th Nov 2025 ( 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 :
Doubt clearing session (1 Hrs each)
Assignment presentation by all candidates
Regards,
Sea and Beyond Team
About the Speakers
Jayshree Tawari
Trainer & Educator | Advance Excel | Power BI |,Freelance Advanced Excel trainer and other MS-Office technologies with 8+ years of Experience. She has imparted training on Advanced Excel, Professional PowerPoint, Power BI, Python.
She Has strong hands on analysis of data and Knowledge of various analysis tools available in Excel, inspired her towards the training for Excel to working professional, as data is important integral part of business and plays key role in taking decision for the growth of business.
she is also regular visiting faculty of ICAI (The Institute of Chartered Accountants of India), Pune
Aaquib Jawed
SCD Partner,As an accomplished Supply Chain consultant, currently working with AP Moller Maersk and certified data analyst with over 10 years of experience in optimizing operations, enhancing supply networks, and driving cost efficiencies.
Education
- Micromasters in Supply Chain, Massachusetts Institute of Technology (MIT)
- MBA in Finance, Andhra University
- B.Tech in Mechanical Engineering, BIT Sindri
I specialize in training corporate professionals and students in Power BI, Microsoft Excel, and PowerPoint, empowering them with practical skills for data-driven decision-making and business excellence.
Over the past 4 years, I have successfully trained more than 200 professionals and students in Microsoft Excel, Power BI, and PowerPoint.
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
Maritime Focused Intermediate...
Shobha M, Capt. J.S Parhar,
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 ...
Advanced Course on Commercial...
Capt. Ashok Sharma, Dr. Abhay Singh Thakur,
Maritime Focused Excel and P...
Mr. Gourav Kullu, Jayshree Tawari,
Maritime Focused Advanced Exc...
Jayshree Tawari
Maritime Focused Power BI course
Mr. Gourav Kullu
Advanced Course on Commercial...
Capt. Ashok Sharma, Dr. Abhay Singh Thakur,
ICS Exam Tutorials: Shipping ...
Capt. Gaurav Rana
ICS Exams Tutorials - Tanker ...
Capt. Gaurav Rana
ICS Exams Tutorials - Introd...
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
Shipping Disputes and Prevent...
Mr. Jagmeet Makkar
Digital Transformation For Ma...
Uttam Kumar, Capt. Shailesh Bham...,
Maritime Focused Advanced Exc...
Jayshree Tawari
Maritime Focused Power BI cou...
Aaquib Jawed
Shipping Disputes & Prevention
Mr. Jagmeet Makkar
Ship Finance & Investment Dec...
Mr. Jagmeet Makkar
Shipping Contracts Management
Mr. Jagmeet Makkar
Ship Sale & Purchase Part 1 &...
Mr. Jagmeet Makkar
Testimonials from our customers...
See allGive your career a boost with S&B professional services.
CV Prep/Evaluation
Prep Service More Jobs
Ship management
Hazira
Technical Superintendent
Ship management
Singapore
Voyage Manager
Commercial Shipping
Dubai
Chartering Broker
Interview Prep/Mentoring
Find your polestar with the host of experts available on our platform
Know more
Contact Us