Maritime focused advanced Excel course (2023)
Data Analytics
12 Hrs
Sea and Beyond
Discover the world of maritime excellence with our specialized Excel courses tailored for maritime professionals. Dive into comprehensive training modules designed to enhance your spreadsheet skills, from data analysis to report building, all within the context of the maritime industry.
Our course provides detailed information, equipping you with the tools to efficiently manage maritime data, streamline operations, and make informed decisions.
The course is a divided into 4 sessions each of 3 Hrs in addition to assignments after every session. The topics covered include:
Session 1
- Basic data management
- Cell & workbook protections
- Working with formulas
- Assignment / Exercise related to formulas & filters.
Session 2
- Utilize Formatting features
- Data validation
- Assignment / Exercise
Session 3
- Database management in excel
- Working with Functions
- Assignment / Exercise
Session 4
- Working with charts
- Working with Pivot Tables
- Overview & review of the assignments given
- Debriefing & how you could continue using excel after the course.
Whether you're a shipping executive, marine engineer, or port manager, our Maritime Focused Excel Courses offer practical insights and real-world applications, ensuring you stay ahead in this dynamic and critical sector. Join us to unlock the potential of Excel for maritime success and navigate your career with confidence.
What you’ll learn
Sea and Beyond
At Sea and Beyond we strive for authenticity and honesty in our work. Our mission is to help “You take a well informed decision” and we try and support you through our various services like
- Mentoring
- Skill enhancement/Education
- Job Opportunities and
- Your branding (CV and LinkedIn preparation)
We have a team of writers who conduct thorough research to ensure the accuracy of the content and for the clarity in communication. We will be happy to support you wherever required
Rating:
(0 Reviews)
Price:
₹ 3999
Language:
English
Length:
12 Hrs
Intended for:
Everyone in the maritime community
Reference:
Not based on any reference
Topics:
3 Hrs
1. Maritime focused Advanced Excel Class| Session1| Building Fundamentals
Welcome to the 1st session of Maritime focused Advanced Excel class. It has got covered all the basics to build up the foundation. Below are the details of the topics which has been covered in the session:
- 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.
So, start you upskilling journey, watch the entire session and implement it for better performance. Happy Learning!
3 Hrs
2. Maritime focused Advance Excel | Session 2 | Advancing from Fundamentals
Here we begin with 2nd session of Maritime focused Advanced Excel class. This session continues with more depth and covering topics to advance level which will be further followed by other. Below are the details of the topics which has been covered in the session:
- 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
Let’s continue the upskilling journey, watch the entire session and implement it for better performance. Happy Learning!
3 Hrs
3. Maritime Focused | Advanced Excel Masterclass | Session 3
Welcome to the 3rd session of Maritime focused Advanced Excel class. In this session we have covered topics in greater depth with focus on practical implementation of all these learnings into daily life. As we come up with new sessions every weekend, the emphasis will increase more towards practical implementation of these tools. Below are the details of the topics covered in this session:
- 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
Let’s continue the upskilling journey, watch the entire session and implement it for better performance. Happy Learning!
3 Hrs
4. Maritime Focused | Advanced Excel Masterclass | Session 4
Welcome to the 4th and final session of Maritime focused Advanced Excel Masterclass. In this session we have got covered all the remaining topics in great detail and have also answered queries related to assignments given. As we navigate through the concluding part of our masterclass, we encourage you to share your insights, and make the most of this opportunity to enhance your Excel proficiency in the maritime context. Below are the details of the topics covered in this session:
- 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.
Let’s continue the upskilling journey, watch the entire session and implement it for better performance. Happy Learning!
