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?
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.
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
Career Opportunities For Turk...
Career Transition – What Shou...
Career Transition For Mariners
Certification Course On Angel...
Find Your Pole Star
Leveraging LinkedIn
Maritime Writing: From Writin...
Masterclass On Angel Investme...
MSc Shipping Operations & Man...
Simplified Hydrodynamics And ...
Maritime Focused Intermediate...
Find Your Pole Star Bootcamp 2.0
Maritime Informatics - Introd...
Introduction to Finance for S...
Intro course on Finance for S...
Maritime Focused Advanced Exc...
Maritime Focused Power BI Course
Maritime Focused Advanced Exc...
MCA UK OOW Orals preparation
MCA UK Master Orals Preparation
MCA UK Chief Mate Orals Prepa...
Maritime Focused Advanced Exc...
Maritime Focused Power BI Course
Maritime Focused Excel and P...
MCA UK COC Class 2 - Oral and...
Introduction to Commercial Sh...
Advanced Course on Commercial...
Maritime Focused Excel and P...
Maritime Focused Power BI course
Give your career a boost with S&B professional services.
CV Prep/EvaluationMumbai
Mumbai
Work From Home
Environmental, social and governance is a framework used to assess an organization`..
Find your polestar with the host of experts available on our platform
Know more