Overview:
Shipping industry is recognizing the value of data and is looking for professionals who can help interpret the data and can present them in the simplest form to make most of the technologies & the data available.
However, finding individuals with both maritime expertise and data analysis skills is challenging. To address this gap, we hosted a masterclass to introduce data analytics tools and demonstrate their application in maritime contexts, offering a solution to the industry's talent search issue. This masterclass will take you through the details of our training program and through a demo course.
The masterclass includes:
Session 1
- Working with Functions
- Basic functions:(Sum + Average + Max +Min +Count+ Auto Sum)
- Working with referencing
- Cell addressing/referencing methods (Absolute + Relative + Mixed + range and more)
- Logical functions
- If + And +Nested IF
- Utilize Formatting features
- Conditional formatting
- Assignment / Exercise
Session 2
- Database management in excel
- Static/Range and Dynamic Database Concepts +Tables+ Sort + Filter+ Remove Duplicates
- 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
- Creating custom validation, handling input, and error alerts
- Date/Time Calculations in Excel.
- Cell & workbook protections
- Assignment / Exercise
Session 3
- Text to Column Concepts
- Text Function to Clean and prepare data
- Look Up Reference functions.
- VLookup + Vlookup with IFError + +Index + Match
- Assignment / Exercise
Session 4
- Flash Fill +Transpose
- Working with charts
- Different Types, Creating Excel Charts, Pivot Charts
- Formatting, Design, and Layout of the Chart
- Creating, Applying, and Removing Chart Templates, 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.
This course will take you through the complete training for using Excel effectively, covering everything from basic functions and formulas to advanced data analysis techniques. By the end of the course, you'll be equipped with the skills to manipulate data, create insightful visualizations, and streamline your workflow, making you a proficient Excel user ready to tackle any spreadsheet task with confidence.
Regards,
Sea and Beyond
Skills you’ll gain
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:
Price:
₹ 3999
Language:
Length:
12 Hrs
Intended for:
Maritime professionals aiming to upskill and advance their careers.
Reference:
Topics:
2 Sections . 5 lectures . 12h 4m total length
4 min
1.1 Capt. Ashwin Dmello | Testimonial
"Empowering Maritime Minds with Data! 🚢💡 Hear from our last batch of participants on how our Excel and Power BI course has transformed their approach to data-driven decision-making in the maritime industry.
Ready to elevate your skills?
Join us on this journey and apply now
180 min
2.1 Session 1 | Working with Functions
Working with Functions
Basic functions:(Sum + Average + Max +Min +Count+ Auto Sum)
Working with referencing
Cell addressing/referencing methods (Absolute + Relative + Mixed + range and more)
The text cleaning concept
180 min
2.2 Session 2 | Logistical Function and Statistical Function
Logical Functions
Utilise Formatting Features
Database management in Excel
Statistical Function
Data Validation
Preparing working dashboard from vessel’s PMS data
Assignment / Exercise
180 min
2.3 Session 3 | Text to Column Concept
Text to Column Concepts
Text Functions to Clean & Prepare Data
Lookup & Reference Functions (VLOOKUP, IFERROR, INDEX, MATCH)
Assignment / Exercise
180 min
2.4 Session 4 | Working with Charts and Pivot Tables
- Working with Charts
Different Chart Types, Pivot Charts, Dynamic Charts
Formatting, Design & Layout of Charts
Creating, Applying & Removing Chart Templates, Sparklines
- Working with Pivot Tables
- Introduction, Creation & Dashboard Implementation
Additional Tools: Remove Duplicates, Import/Export Data, Flash Fill, Concatenate, Transpose
- Debrief: Continuing to Apply Excel Skills Beyond the Course
- Assignment / Exercise
Successful completion of this course will earn you a certificate of completion from Sea and Beyond. This certificate will be emailed to you and you could also share and show it on LinkedIn Please click on the button below to purchase the certificate.
Similar Courses
Reviews...
Melvin Maben On Jul 4th 2024
Dear Team , I recently....
Hyder Rangari On Nov 6th 2024
A great course for someon....
Gunjit Verma On Nov 6th 2024
I felt the course was fan....
Leroy Sampy On Nov 28th 2024
I recently completed the ....
Gaurav Bhardwaj On Dec 25th 2024
The course builds underst....
Contact Us