1st lesson free
Sivasankaran's profile, diploma and contact details have been verified by our experts
Sivasankaran
- Rate TSh 5,392
- Response 4h
-
Students20
Number of students Sivasankaran has accompanied since arriving at Superprof
Number of students Sivasankaran has accompanied since arriving at Superprof
TSh 5,392/hr
Contact
1st lesson free
- Microsoft Excel
Excel for Data Analyst for both beginners and intermediate learners with practical knowledge
- Microsoft Excel
Lesson location
Super Prof
Sivasankaran is one of our best Microsoft excel tutors. They have a high-quality profile, verified qualifications, a quick response time, and great reviews from students!
About Sivasankaran
Hi, I am a software engineer working in an IT company I completed my graduation in BE ECE with distinction from KCE college affiliated to Anna University. I have knowledge in programming and 2 years experience in IT so I am interested to share my knowledge
See more
About the lesson
- Primary school
- Ordinary Level
- Form 5
- +21
levels :
Primary school
Ordinary Level
Form 5
Form 6
Terminale
Ordinary Diploma
Tertiary Education
Adult Education
Bachelor’s Degree
Master’s Degree
Diplomgrad
PhD / Doctorate
Other
PGDLP
Bar Professional Training Course
Qualified Lawyer Transfer Scheme
MBA
Nursery
Beginner
Intermediate
Advanced
Professionnel
Autres
Children
- English
All languages in which the lesson is available :
English
What you are going to learn with spending daily 1 hour
Week 1: Introduction to Excel
Understanding the Excel interface, including the ribbon, toolbar, and workbook
Basic data entry and cell formatting
Managing worksheets and workbooks
Understanding Excel file types and saving files
Week 2: Basic Excel Formulas and Functions
Introduction to Excel formulas and functions
Basic mathematical calculations, such as addition, subtraction, multiplication, and division
Using cell references in formulas
Common Excel functions, such as SUM, AVERAGE, MAX, MIN, and COUNT
Week 3: Data Manipulation and Analysis
Sorting and filtering data
Working with Excel tables
Data validation and conditional formatting
Using logical functions, such as IF, AND, OR
Introduction to pivot tables and pivot charts
Week 4: Advanced Excel Formulas and Functions
Advanced mathematical calculations, such as percentage, exponentiation, and rounding
Text functions for manipulating text data, such as CONCATENATE, LEFT, RIGHT, and LEN
Date and time functions, such as DATE, TIME, TODAY, and MONTH
Lookup and reference functions, such as VLOOKUP and HLOOKUP
Week 5: Data Visualization
Creating charts, such as column charts, line charts, pie charts, and bar charts
Customizing chart elements, such as titles, axes, and legends
Using Sparklines for mini-charts within cells
Creating dynamic charts with data ranges and formulas
Using conditional formatting to create visualizations
Week 6: Advanced Data Analysis
Working with advanced Excel features, such as data tables, scenarios, and goal seek
Using Solver for optimization and scenario analysis
Performing statistical analysis, such as calculating mean, median, and standard deviation
Using Excel's built-in data analysis tools, such as regression analysis and histogram
Introduction to Power Query for data cleaning and transformation
Week 7: Advanced Excel Features
Working with Excel templates and themes
Protecting worksheets and workbooks
Customizing Excel options and settings
Using Excel in collaboration, including sharing and tracking changes
Introduction to Macros for automating tasks in Excel
Week 8: Final Project and Review
Applying the skills learned throughout the syllabus to a real-world project
Reviewing and practicing key Excel concepts and skills
Troubleshooting and resolving common Excel errors
Q&A session for any questions or clarifications
See more
Recommendations
Recommendations come from relatives, friends and acquaintances of the teacher
5
He is good teacher
Yeah. I learn from him. He explained me complex problems easily with example so It is easy to understand.
Sivasankaran is a really good teacher, he is patient and has all the knowledge to help you learn the skill in the IT field. I recommend
His teaching is very good for grasping
He teaching is nice and understandable
View more recommendations
See more
Rates
Rate
- TSh 5,392
Pack prices
- 5h: TSh 26,960
- 10h: TSh 53,920
online
- TSh5,392/h
free lessons
The first free lesson with Sivasankaran will allow you to get to know each other and clearly specify your needs for your next lessons.
- 45mins
Similar Microsoft Excel teachers in Tiruppur
Mourad
Paris 12e, France & Online
- TSh 136,040/hr
- 1st lesson free
Billy
Bullhead City, United States & Online
- TSh 130,125/hr
- 1st lesson free
Erica
Fairfield, Australia & Online
- TSh 111,126/hr
Ireneusz
Gdańsk, Poland & Online
- TSh 85,485/hr
- 1st lesson free
Arbaz
New York, United States & Online
- TSh 117,113/hr
- 1st lesson free
Matthieu
Tigery, France & Online
- TSh 90,693/hr
- 1st lesson free
Adi
Toronto, Canada & Online
- TSh 94,619/hr
- 1st lesson free
Ben
Southampton, United Kingdom & Online
- TSh 156,969/hr
- 1st lesson free
Ilian
Paris 8e, France & Online
- TSh 75,578/hr
- 1st lesson free
Marc
New York, United States & Online
- TSh 325,313/hr
Patricia
Madrid, Spain & Online
- TSh 75,578/hr
Inès
Paris 1er, France & Online
- TSh 136,040/hr
Abhishek
Noida, India & Online
- TSh 24,230/hr
- 1st lesson free
Zammad
New York, United States & Online
- TSh 130,125/hr
- 1st lesson free
Doğukan
Küçükçekmece, Turkey & Online
- TSh 45,685/hr
Moreno
Monza, Italy & Online
- TSh 151,156/hr
- 1st lesson free
Cassandre
Lehigh Acres, United States & Online
- TSh 153,548/hr
Massimiliano
Ancona, Italy & Online
- TSh 90,693/hr
- 1st lesson free
Matthew
London, United Kingdom & Online
- TSh 136,040/hr
- 1st lesson free
Gabriel
, Brazil & Online
- TSh 60,903/hr
- 1st lesson free
-
See Microsoft Excel tutors
