.webp)
Gayazuddin Sheik
Skills :
About :
I am Gayazuddin Sheik, an SAP consultant and corporate trainer with eight years of experience delivering hands-on programmes in FICO, MM, and BTP. I focus on real project scenarios…
Gayazuddin Sheik
Skills :
I am Gayazuddin Sheik, an SAP consultant and corporate trainer with eight years of experience delivering hands-on programmes in FICO, MM, and BTP. I focus on real project scenarios...
FindMyGuru is a tutor discovery platform that helps students find and connect with experienced tutors and institutes across a wide range of subjects and skills. Students can explore tutor profiles, compare expertise, and contact tutors directly for online or in-person learning.FindMyGuru facilitates discovery and connections between students and tutors or institutes. All classes and learning arrangements are handled directly between students and the respective tutors or institutes
Courses by Gayazuddin Sheik
Online
60 Hour
English
Ekkatuthangal, Chennai, Olympia Platina
6000 INR
Week Days / Weekends
Course Content
1. Introduction to Microsoft Excel
Overview of Excel interface
Workbook, worksheet, and cell basics
Navigation and shortcuts
2. Basic Excel Functions & Formulas
SUM, AVERAGE, COUNT, IF functions
Date, text, and logical functions
Relative vs absolute referencing
3. Data Management & Formatting
Sorting, filtering, and conditional formatting
Data validation and protection
Table creation and formatting
4. Advanced Formulas & Functions
VLOOKUP, HLOOKUP, INDEX-MATCH
Nested formulas and advanced IF statements
Array formulas
5. Data Analysis Tools
PivotTables and PivotCharts
Power Query basics
Data summarization and visualization
6. Charts & Graphs
Creating and customizing charts
Using sparklines and conditional charts
Dashboard creation
7. Macros & Automation
Introduction to macros
Recording and editing macros
Automating repetitive tasks
8. Practical Projects
Real-world Excel scenarios
Financial data analysis
Business reporting dashboards
9. Tips & Tricks for Efficiency
Keyboard shortcuts
Productivity hacks
Troubleshooting common Excel issues
Get institute location
Location: Olympia Platina, Ekkatuthangal, Chennai, Tamil Nadu
Locate on Google map