Maritime Focused Intermediate Excel training


Speakers :
1) Shobha M 2) Capt. J.S Parhar
Seats :

Completed

Date & Time :
31/08/2022 at 7:00 AM IST
Price :
FREE
Duration :
412 hrs 30 mins

Event Sessions


Session 1 :
31/08/2022 at 7:00 AM IST   To   17/09/2022 at 11:30 AM IST  (412 Hours 30 Mins)


Content On Trainings



Features of the Training:

1. Instructor Led Training

2. 12 hours Training + 10 hours Assignment worksheets /Templates

3. Real Time Case Studies & Doubt solving after each session

4. Exclusive email support even after the course

Session I (3 Hrs) on 6th August 2022 at 10:00am-1:00pm IST

1. What is Excel & How will it professionally benefit persons onboard & ashore.

2. Basic Database Management in Excel 

  • Building An Excel Database
  • Performing Single / Multi-Level Sorts
  • Filters – Auto, Custom and Advanced

3. Cell and Workbook Protections:

  • Protecting Cells, Protecting Sheets, Protecting Workbooks

4. Working with Formulas:

  • Cell Addressing Or Referencing Methods
  • Absolute, Relative & Mixed Referencing
  • Naming References and Range
  • Referring To Other Sheets & Workbooks

Assignment / Exercise related to formulas and filters

Session II (3 Hrs) 7th August 2022 at 10:00am-1:00pm IST

5. Working with More Formatting Features 

  • Conditional Formatting
  • Formatting Data as table
  • Adjusting and Printing with worksheets

6. Data Validation 

  • Creating Data Validation
  • Working With List & Dependent List
  • Creating List with Dynamic Ranges
  • Creating Custom Validation
  • Handling Input And Error Alerts

Assignment / Exercise  

Session III (3 Hrs) 13th August 2022 at 10:00am-1:00pm IST

7. Database Management in Excel 

  • Basic and Dynamic Database Concepts
  • Subtotals
  • Text to Column concepts
  • Remove Duplicates
  • Import and Export data
  • Flash fill
  • Concatenate (Combining words or names )
  • Transpose

8. Working with Functions

  • Basic : Sum, Average, Max, Min, Count
  • Statistical: Sumif, SumIfs, AverageIf, AverageIfs, CountIf and CountIfs
  • Logical: Working With If, IFError, And, Or, Not, Nested IFS Functions
  • Look Up & Reference: VLookup,Reverse Vlookup, Vlookup with IF function, Vlookup With Indirect function , Vlookup with IFError, HLookup, Index and Match Function ,
  • Vlookup With Wildcards
  • Text Function
  • Date, Time Calculations In Excel

Assignment / Exercise

Session IV (3 Hrs) 14th August 2022 at 10:00am-1:00pm IST

9. Working with Charts

  • Working With Different Types
  • Creating Excel Charts
  • Pivot Charts & Formatting Charts
  • Working With Design And Layout Of The Chart
  • Creating And Applying & Removing Chart Template
  • Sparkline & Dynamic charts

10. Working with Pivot Tables 

  • Introduction and creation of Pivot tables

11. Overview and review of the assignments given

12. Debriefing and how you could continue using excel after the course. 

Get this Service by paying Rs.2999/-

For more details Call : +91 89288 96420/ +91 89761 24339



About the Speakers


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.




Capt. J.S Parhar
Master mariner,

He is a master mariner with more than 25 years of experience. He has sailed with P&O, Mitsui, Zodiac, K Line, Nakilat and has been using excel for past 23 years. He has sailed on Capesize Bulk / LPG and LNG vessels. He is someone who has learned excel through his own drive and much before google came into vogue. He has used excel to make GHA calculations, stability calculations, has extensively used Macros V-looks to make life easy on board a vessel for himself and for his colleagues. 





Similar Trainings



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

CV Prep/Evaluation
Education

Maritime/Logistics focused courses for you

Know more
More Jobs
Agency and Logistics

Delhi

Sales Coordinator
View more
Commercial Shipping

Mumbai

Chief Officer
View more
Agency and Logistics

Delhi

Operations Executive
View more
See all

From the Blog


Professional Development

All the Blogs related to professional development

Read more >>

General Blogs

All the general topic blogs will be included in this category

Read more >>
Browse all
Interview Prep/Mentoring

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

Know more

Contact Us