1st class free
ExcelSchooling profile and their contact details have been verified by our experts
ExcelSchooling
- Rate ₹450
- Response 2h
-
Students13
Number of students accompanied by ExcelSchooling since their arrival at Superprof
Number of students accompanied by ExcelSchooling since their arrival at Superprof
₹450/hr
Contact
1st class free
- Microsoft Excel
Advanced Microsoft Excel Training - No basic Knowledge required we teach from baasic
- Microsoft Excel
Methodology
- Classes 1 to 5
- Classes 6 to 8
- Class 10
- +12
levels :
Classes 1 to 5
Classes 6 to 8
Class 10
Classes 11 & 12
Class 12
Adult Literacy
Undergraduate
Masters
PG Diploma
PhD
Beginner
Intermediate
Advanced
Professional
Children
- English
All languages in which the class is available :
English
Price : ₹6000.00 - Place : Chennai (600000)It include - Basic - Level-1, Intermediate - Level-2 and Advanced - Leve-3
Basic Topics - Level 1
Introduction to Excel
Improvements in Excel from 2003 to latest version
What’s new in latest versions
Excel Options
Commands/Shortcuts in Excel
Protection of cells, Sheets, Workbooks
Data Import, Export
Cell Referencing In Excel
Sheet Options
Normal layout
Page Layout
Page Break Preview
Basic funcation
TRIM
CONCATENATE
LEN
LEFT
MID
RIGHT
Intermediate Topics - Level 2
We discuss about how to use Function/formuals effectively ?
Count
Counta
Countif
IF
Sumif
Summifs
Averageif
Lookup
Vlookup
Hlookup
Index
Match
Iferror
Max
Min
Advanced Topics - Level 3
Advanced Conditional formatting
Chart
Slicer
Flash Fill
Spark Lines
Hyperlink
What if Analysis
Nesting of functions
Linking In Excel Across Sheets/Workbooks
Pivot Tables with Advance Features
Creating Pivot Table Using Wizard / Layouts
Formatting Pivot Table With Auto Formats and
Creating Pivot Charts by using Source data
Modifying The Pivot Charts
Creating a Pivot Table Report
Slicers and its usages
Working and editing with Hyperlinks
Record Macro
Modify VBA Macro
See more
Class planning
We not strict the timing, If you are not familiar with any specific topics we will arrange one more class for the same topic.
as per the chapter all the 3 levels will complete in 16 Hours.
We also do tailor made course as per your convenient.
See more
Practical information
- Price of the workshop : ₹6000.00
- Place : Chennai (600000)
- Maximum number of students during the training course : 25
- Audience concerned : all
- Course materials are provided to each participant
- Validity of the workshop : all year around
Rates
Rate
- ₹450
Pack prices
- 5h: ₹2250
- 10h: ₹4500
online
- ₹450/hr
free classes
This first free class with ExcelSchooling will allow you to get to know each other and to specify the exact learning requirements for the upcoming classes.
- 1hr
