Maritime Focused Advanced Excel Course


Speakers :
Jayshree Tawari
Seats :

20

Date & Time :
09/11/2024 at 10:00 AM ist
Price :
₹ 6499
Duration :
12 hrs
  Add to Calendar   

Event Sessions


Session 1 :
09/11/2024 at 10:00 AM ist   To   09/11/2024 at 1:00 PM ist  (3 Hours)


Session 2 :
10/11/2024 at 10:00 AM IST   To   10/11/2024 at 1:00 PM IST  (3 Hours)


Session 3 :
16/11/2024 at 10:00 AM IST   To   16/11/2024 at 1:00 PM IST  (3 Hours)


Session 4 :
17/11/2024 at 10:00 AM IST   To   17/11/2024 at 1:00 PM IST  (3 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:  (3 Hrs)

 

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 

 

SESSION 2:  - 3 Hrs)

 

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 : ( 3 Hrs)

 

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 : (3 Hrs)

 

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.



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





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
Ship management

Mumbai

Master Mariner
View more
Ship management

Mumbai

Chief Engineer
View more
Ship management

Work From Home

Data Analyst
View more
See all

From the Blog


Mental Wellbeing

Blogs related to Mental Wellbeing

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

Contact Us