Advanced Excel
Best Advanced Excel Training in Bangalore
Training methodology used for conducting Advanced Excel Training in Marathahalli course includes ease of understanding Advanced Excel concepts, latest examples in Advanced Excel classes and real time practical exposure. This ensures that students opting for Advanced Excel training in Marathahalli, Bangalore get value for money. Our Advanced Excel course content is structured to cover all concepts under Advanced Excel Training.
Advantages of Studying Advanced Excel with Us
- Advanced Excel Hands on experience
- Project support on Advanced Excel
- Real time exposure on latest Advanced Excel modules
- Advanced Training methodologies
- Lab facilities and guidance
Advanced Excel Trainers at RIA Institute
- 8+ Years of experience on Advanced Excel Projects
- Has worked on multiple real-time Advanced Excel scenarios
- Worked as Top Advanced Excel Consultant in MNC’s across the globe
- Trained over 100 students over the years
- Certified Advanced Excel industry professional
- Strong Knowledge of Advanced Excel Theory and Practical’s
Advanced Excel Training Facilities
Coaching facilities for Advanced Excel Training in Marathahalli, Bangalore are best suited for Freshers as well as experienced professionals who are actively looking for upgrading skills in Advanced Excel. From Advanced Excel training consultation to Advanced Excel course completion we offer complete support to students. Regular reviews are conducted to ensure that Advanced Excel Training is being conducted in a structured manner and the students are able to understand all the Advanced Excel Training concepts.
Advanced Excel Training Batch Timings
We offer flexible batch timings for Advanced Excel Training in Bangalore. Students can choose to join our weekday batches for Advanced Excel course and IT professionals looking for Advanced Excel Training to advance in their career can join our Weekend classes based on their convenience. We also offer Fast Track Training for students who want to complete Advanced Excel course in detail in a short span.
Advanced Excel Course Content
Our Advanced Excel Course content is structured to cover all the modules within Advanced Excel. From basic to advance, we give Advanced Excel training in Bangalore in a manner that is easy to understand.
Below is the detailed course content for Advanced Excel Training
1 Pivots and Pivot Graphs:
- Creating of Pivot Table
- Using Summary function in Pivot Table
- Pivot Table Calculations
- Creating own formulas in Pivots
- Grouping and Ungrouping in Pivot Tables
- Creating Pivot Graph
- Custom Filter on Pivot Table
- Formatting Pivot table (Removing old data, grand total, subtotal …etc.)
2 Working on Objects:
- Inserting Objects
- Inserting different files into Excel (like .doc, .pdf, .txt files)
- Hyper linking to different sheets
- Providing screen tips in hyper link
- Hyperlink to send emails
- Inserting symbols
- Sending working file to an email
3 Data Management in Excel – Sorting:
- Rearranging of Data
- Sorting by alphabets, numbers and time
Filtering Data:
- Using Auto filter option
- Custom Filtering with different options
- Advanced Filtering
- Find Unique records using advanced filtering
- Filter using operators AND/OR
- Filter by color
Grouping and Outlining Data
- Group and ungroup rows and columns
- Auto outlining the data
- Freezing and Unfreezing
Data Validation:
- Use Data Validation in Excel
- Using Input Message in Data validation
- Using error message in Data Validation
Removing duplicate records:
- Remove duplicate records in a spread sheet
- Customize to remove the duplicate values
Split Texts:
- Split texts to different columns
- Remove special character from a string and split the string
Data Consolidation:
- Combining different spreadsheet using data consolidation
- Using summary function in data consolidation
Conditional Formatting:
- Use of conditional formatting
- Custom formatting
Copy Data:
- Use of format painter
- Use of paste special
- Strike through a value
- Find and Replace
View Multiple Files:
- Arrange multiple windows to view in one time
- Split big sheet into sub sheets for better analysis
Working on Tab:
- Hide/ Unhide a tab
- Color a tab
- Move /Copy the tab to another sheet/workbook
4 Advanced Functions:
- V-Lookup
- H-Lookup
- IF
- ISERROR
- Index Match
- Rows
- Columns
- Match
- Offset
- Get Pivot Data
- Date and Time Functions
- Text Functions
- Operators
- Mathematical functions
- Calculation options
Name Manager:
- Define a name to a range
- Use of name manager
- Using formulas in name manager
- Editing name range
5 Data Connection from External Data:
- From access
- From SQL
- From Web
- From ODBC
6 Customize your Excel view:
- Customize Excel view
- Developer Option
- Trust Centre
- Add-Ins
- Save directory options
- Language Setting
- Quick access toolbar
7 Security options in excel:
- Protecting the worksheet
- Protecting the workbooks
- Sharing the workbook
- Allow users to edit ranges
Best Advanced Excel Training institute in Bangalore
- Trained over 2000 students
- Over a Decade of experience in Training industry
- Experienced and Certified trainers
- Practical and Theory training
- Flexible Batch timings
Quick Enquiry
Certified Trainers
Full Support
Best Value for Money
Best Training
MARATHAHALLI BRANCH :
( Ramanjaneya Layout )
# 3/76, Shiva Building,
Outer Ring Road, Marathahalli,
Bangalore - 560 037.
Opp Kala Mandir
+91 98860 01060 | 81230 21060
+91 080 2540 0478 | 6530 1060
MARATHAHALLI BRANCH :
( Hemanth Nagar )
#24, 3rd floor outer ring road
Above Born Babies, Next to Kala Mandir, Marathahalli 560037
Next to Kala Mandir
+91 80506 01060
+91 080 4851 4803
MARATHAHALLI BRANCH :
( Ashwath Nagar )
#61, basement 3rd Cross, Aswath Nagar, kalamandir Service Road, Marathahalli Post, Bangalore- 560037
Below City Union bank
+91 95135 01060
+91 080 4371 9316
( Ganga Nagar )
# 10/23, 2nd Floor,
5th Main Road, Ganga Nagar,
Bangalore - 560 032.
Near LG Showroom
+91 99456 01060 | 72040 91060
+91 080 4209 3564
For General Queries Mail to - info@riainstitute.in , enquiry@riainstitute.in | For Job Related Queries Mail to - jobs@riainstitute.in
RIA Institute of Technology © 2016 | All Rights Reserved .