Advanced Excel

ADVANCE EXCEL

TRAINING IN BANGLORE

Goecode Technology Training Institute offers Advanced Excel training course for the students and professional to learn more advanced features of Excel.The topics covered in Advanced Excel Training 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 training workshop in Bangalore and training with us would give you an edge over others at office or in interviews.

 

Introduction to Advanced 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 (Multiple if conditions)
    • HLOOKUP,VLOOKUP, INDEX, MATCH, MID, FIND, REPLACE
    • Date Functions(TODAY,WEEKDA,NOW),
    • 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
    • Displaying an Input Message
    • Creating the Error Alert
    • Displaying an Error Alert
    • Creating List
  WORKING WITH PIVOT TABLES
    • Creating Custom Formats
    • Explaining the Grouping Options
    • Adding Formulas to a Pivot Table
    • Changing a Calculation in a Pivot Table
    • Replicating a Pivot Table
    • Counting with a Pivot Table
    • Using Pivot Charts
 AUDITING
    • Displaying all formulas within a worksheet
    • Adding comments
    • Displaying comments
    • Removing comments
    • Editing commen

Embedded system Training Institute in Indiranagar Bangalore|  Training Courses 10-Advanced-Excel-Charts-768x384 Advanced Excel

 

 

Embedded system Training Institute in Indiranagar Bangalore|  Training Courses 47fb6393ef45988beff9b7ac9d25df020531 Advanced Excel

 

 

Embedded system Training Institute in Indiranagar Bangalore|  Training Courses d7a25d23ea0af5a3f6bb6e569618aa40c21209da_original-2-768x410 Advanced Excel

 

 

Embedded system Training Institute in Indiranagar Bangalore|  Training Courses statistics Advanced Excel

About our ADVANCE Excel Training in Bangalore

Our best 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.

Goeocde Technologies , most popular locations
where students / professionals are lining up
to get trained with us.

ADVANCE EXCEL Training in Indiranagar
ADVANCE EXCEL Training in Domlur
ADVANCE EXCEL Training in Jeevan Bima nagar
ADVANCE EXCEL Training in HAL
ADVANCE EXCEL Training in Ulsoor
ADVANCE EXCEL Training in Koramangala
ADVANCE EXCEL Training in C V Raman nagar
ADVANCE EXCEL Training in Malleshpalaya
ADVANCE EXCEL Training in Kasturinagar
ADVANCE EXCEL Training in Horamavu
ADVANCE EXCEL Training in Mahadevpura

ADVANCE EXCEL Training in Air port road
ADVANCE EXCEL Training in BTM Layout
ADVANCE EXCEL Training in Thippasandra
ADVANCE EXCEL Training in Diary Circle
ADVANCE EXCEL Training in Kaggadasapura
ADVANCE EXCEL Training in Murgesh pallya
ADVANCE EXCEL Training in Pai layout
ADVANCE EXCEL Training in Udaya nagar
ADVANCE EXCEL Training in Ejipura
ADVANCE EXCEL Training in Electronic city
ADVANCE EXCEL Training in Silk Board