Maritime Focused Intermediate Excel training
Speakers :
Seats :
Completed
Date & Time :
Price :
Duration :
Event Sessions
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
Tushar Ugale
Manager,TechniculDr. Antonis Violaris is the Programme Director, managing and coordinating the MSc in Shipping Operations & Management. He has extensive experience in shipping investments and analysis of the international markets Shipping, Oil and Energy, Foreign Exchange and has been instrumental in setting up and successfully managing a number of investments in the shipping sector. During his career he has successfully established a broad network of relationships with businessmen and companies.
Furthermore, he is leading an information technology solutions company and, in his capacity, as financial advisor, is member of the board of Directors of other companies. Besides this, he was a visiting lecturer at Cyprus University of Technology and has previously served as Lecturer in other local Universities and colleges and at University of Durham. Antonis has graduated with a BSc. in Accounting and Finance from The Philips College, holds a M.Sc. in Business Finance from Brunel University and a Ph.D. in Finance and Economics from University of Durham, UK.
Key points covered in the webinar will be:
- Overview of the Business School,
- Aim of the Course and its philosophy
- The structure of the course including Curriculum, Pedagogy, exams, attendance and internships
- Application requirements including the minimum qualifications required, tuition fees
- How the key courses add value to the life of a participant including the company connect, placements and typical job roles
- Relevance of this course to mariners
- Work Visa provisions after the course
- Connect with the mariner alums
Javeria Ansari
Executive,Sea & Beyondhcvdcvwefuwk
gcv djgcvjwv
- hcvjwwhjvdh
- chedb chndvc
- hce vhdev c
ebc edbgc v
test
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
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
Testimonials from our customers...
See allGive your career a boost with S&B professional services.
CV Prep/Evaluation
Prep Service More Jobs
Mumbai
Master Mariner / Chief Off..
Mumbai
Business Analyst
Navi Mumbai
Manager Legal and Claims
From the Blog
Science & Technology
Dive deep into scientific discoveries, space exploration, and tech innovations that..
Read more >>
Travel & Adventure
Embark on virtual journeys to exciting destinations. Read about travel experiences,..
Read more >>
Interview Prep/Mentoring
Find your polestar with the host of experts available on our platform
Know more
Contact Us