Rated 4.8 out of 5
based on 750 Student Reviews
Goecode Technology Training Institute offers Excel and Advanced Excel course for the students and professional to learn more advanced features of Excel.The topics covered in Advanced excel course include latest and best real-time examples that are aimed to help students in getting the right job so after the completion of Training. We offer the best advanced excel course workshop in Bangalore and training with us would give you an edge over others at office or in interviews.
Introduction to Excel
-
- 20 Shortcut keys
- Formatting (Applying borders, Colors and Font styles)
- Conversion of Formats (Number, Text, Date etc)
- Merging and Wrapping the text
- Conditional formatting
- Formula based conditional formatting
- Format as Table
- Insert/delete row and column, Sheets
- Row height & column width
EXCEL FUNCTIONS
-
- IF and Nested if
- MID, FIND, REPLACE
- LEN,REPT
- Min/Max, Count/CountA/CountBlank/CountIf/
- Average/AverageA/AverageIf/
- Sum/SumIf
- Round/RoundUp/RoundDown
- Freeze Panes- Three ways
NAMING RANGES
-
- Defining a Range Name
- Using a Range Name in a Formula
- Moving to a Named Range
CHARTING IN EXCEL
-
- Charts & graph – Chart properties
USING DATA VALIDATION
-
- Setting data validation
- Creating the Input Message
- Creating List
WORKING WITH PIVOT TABLES
-
- Creating Custom Formats
- Explaining the Grouping Options
- Adding Formulas to a Pivot Table
AUDITING
-
- Displaying all formulas within a worksheet
- Adding comments
- Displaying comments
- Removing comments
- Editing commen
About our Excel course in Bangalore
Our best Excel and ADVANCE Excel Training Institute is education and certification training provider in Indiranagar Bangalore, offers job oriented IT training courses.The courses are delivered by a dedicated team with several years of experience.We aim to deliver the best possible training to our students to get good positions and ensuring rewarding careers for them.
Eligibility for EXCEL course Bangalore
Anyone who have interest in this field have Eligible to join EXCEL Course.
EXCEL course duration :20 days
Fast Track EXCEL course :15 days
Crash EXCEL course :10 days
Excel course Certification:
All the participants who fulfilled course assignments, case studies and final exams would be awarded with Certification in EXCEL Training Bangalore .
Testimonial:
I am a person who loves to play with gadgets, wanted to do EXCEL Training & Embedded Systems Training, Trainer there helped me to get new job. Now I am working. - MADHU
Goeocde Technologies , most popular locations
where students / professionals are lining up
to get trained with us.
EXCEL Training in Indiranagar
EXCEL Training in Domlur
EXCEL Training in Jeevan Bima nagar
EXCEL Training in HAL
EXCEL Training in Ulsoor
EXCEL Training in Koramangala
EXCEL Training in C V Raman nagar
EXCEL Training in Malleshpalaya
EXCEL Training in Kasturinagar
EXCEL Training in Horamavu
EXCEL Training in Mahadevpura
EXCEL Training in Air port road
EXCEL Training in BTM Layout
EXCEL Training in Thippasandra
EXCEL Training in Diary Circle
EXCEL Training in Kaggadasapura
EXCEL Training in Murgesh pallya
EXCEL Training in Pai layout
EXCEL course in Udaya nagar
EXCEL course in Ejipura
EXCEL course in Electronic city
EXCEL course in Madivala
EXCEL course in near me