Advanced Excel

Home / Advanced Excel

Advanced Excel Training in Bangalore

LEARN ADVANCED EXCEL FROM RIA INSTITUTE OF TECHNOLOGY

Advanced Excel Training in Bangalore helps you to learn all the tricks and functions within Microsoft excel. It is now used in almost all business applications and considered as one of the essential skill that recruiters look for in Job placement interview. Use of excel has drastically increased day to day activities as this can be used in multiple ways to collect, sort, modify the existing data. Learning Advanced excels helps you to make complicated task easier.

ADVANCED EXCEL TRAINING INSTITUTES IN BANGALORE
Learn Advanced Excel from experts at RIA Institute of Technology. Know how to effectively use IF Statements, learn to calculate the mean within a group of numbers using SUMIF and AverageIF functions. The Advanced Excel Training at RIA institute is designed to help you understand all the function and teach you how to put them into action. All the trainings are scenario based to help you learn better.

BEST ADVANCED EXCEL COURSE IN BANGALORE
Course content by best Advanced Excel Training Institute in Bangalore is carefully crafted to match the industry requirements. 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. Our expert instructors will highlight the Key topics from Advanced Excel Training based on the questions that can be possible asked by the interviewer during the job selection process; this provides confidence to the students while facing job interviews.

RIA Institute provides Class room trainings, online training, Weekend classed and Fast track course for Advanced Excel Training in Bangalore. Students have the option to select the course timings according to their convenience. Once the Advanced Excel Training course timings are fixed with the instructor, students are required to complete the course in the same schedule. Our schedule for Advanced Excel Training in Bangalore is very flexible as we provide training in weekdays in morning and evening for students who cannot attend Advanced Excel Training in Bangalore during weekends due to their work schedule.

Related Courses

SAS

WE COVER THE FOLLOWING TOPICS IN ADVANCED EXCEL TRAINING

ADVANCED EXCEL TRAINING COURSE CONTENT
Time: 20 hrs
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

Microsoft Excel VBA
Duration- 20 hrs1 Introduction to VBA
WHAT IS VBA?
INTRODUCTION TO ANOTHER LANGUAGES
VBA: AN EVENT DRIVEN PROGRAMMING
VBA: AN OBJECT BASED PROGRAMMING
ADVANTAGES AND DISADVANTAGES OF VBA
OBJECTS, PROCEDURES AND PROPERTIES
2 VBA IDE
OPENING THE EXCEL VBA IDE
MENU BAR
TOOLBAR
PROJECT WINDOW
CODE WINDOW
IMMEDIATE WINDOW
CUSTOMIZING THE VBE
3Getting Started With Macro
RECORDING THE MACRO
EXAMINING THE MACRO
SAVING WORKBOOKS THAT CONTAIN MACROS
4 Fundamentals of VBA Language
VARIABLE & CONSTANTS
KEYWORDS
DATA TYPES
PROCEDURES: SUB AND FUNCTION
ARGUMENTS
LOCAL VS GLOBAL VARIABLE DECLARATION
PROCEDURES: PUBLIC OR PRIVATE
COMMENTS
5 Control Flow & Loops Statements
RELATIONAL AND LOGICAL OPERATORS
IF….THEN
IF….THEN….ELSE
IF….THEN….ELSEIF….ELSE
SELECT CASE ( WITH TO AND WITH IS)
DO WHILE….LOOP
DOLOOP….WHILE
DO UNTIL….LOOP
DOLOOP….UNTIL
FOR….NEXT
FOR EACH….NEXT
WHILE….WEND
THE EXIT STATEMENT
6 Using VBA and Worksheet Functions
VB FUNCTIONS
EXCEL FUNCTIONS
THE WORKBOOKS COLLECTION
THE SHEETS COLLECTION
ACTIVATE AND SELECT
RANGE PROPERTY
CELLS PROPERTY
OffSET PROPERTY
RESIZE PROPERTY
CURRENTREGION PROPERTY
COLUMNS AND ROWS PROPERTIES
REFERENCING RANGES IN OTHER SHEETS
USING THE UNION AND INTERSECT METHODS
USING THE ISEMPTY FUNCTION
USING THE AREAS COLLECTION
TRANSFERRING VALUES BETWEEN ARRAYS AND RANGES
7 Working with Dialog Boxes and Form Objects
USING LABELS
USING TEXT BOXES
USING THE COMMAND BUTTON CONTROL
USING LIST BOXES
USING COMBO BOXES
USING CHECK BOXES
USING RADIO BUTTONS
USING TOGGLE BUTTONS
USING FRAMES
USING MESSAGE BOXES
TAKING INPUT USING INPUT BOXES
TABSTRIP
USING A SCROLLBAR AS A SLIDER TO SELECT VALUES
ADDING HELP TIPS TO CONTROLS
TAB ORDER
COLOURING THE ACTIVE CONTROL
TRANSPARENT FORMS
WORKING WITH MENUS AND TOOLBARS
CREATING MENUS AND TOOLBARS
8 Handling Errors
TYPES OF ERRORS IN VBA
USING THE ON ERROR GOTO STATEMENT
USING THE RESUME STATEMENT
WORKING WITH THE ERR OBJECT
9 The Excel Object Model
INTRODUCING CLASSES AND OBJECTS
THE OBJECT HIERARCHY
COLLECTIONS
REFERRING TO OBJECTS
NAVIGATING THROUGH THE HIERARCHY
OBJECT PROPERTIES AND METHODS
EVENTS
USING THE WITH…END WITH STATEMENT
10 Arrays
DECLARING ARRAYS
SPECIFYING LIMITS
ARRAY FUNCTION
TWO DIMENSIONAL ARRAYS
MULTI DIMENSIONAL ARRAYS
DYNAMIC ARRAYS
11 The Application Object
GLOBALS
THE ACTIVE PROPERTIES
DISPLAY ALERTS
SCREEN UPDATING
EVALUATE
STATUSBAR
SEND KEYS
ONTIME & ON KEY
12 Data Lists
SORTING A RANGE
CREATING A TABLE
SORTING A TABLE
AUTOFILTER
ADVANCED EXCEL TRAINER PROFILE
Best Advanced Excel Trainers in Bangalore
10 years of relavant work experience in Advanced Excel Training
Real time Traning on Advanced Excel Projects
45 hrs of Job Oriented Training in Bangalore
Successfully Trained more than 1000+ Professionals
OUR ADVANCED EXCEL TRAINING CENTERS IN BANGALORE
Best Advanced Excel Training in Marathalalli
Near Marathahalli Bridge
Best Advanced Excel Training in RT Nagar
Near LG Showroom
JOB ORIENTED ADVANCED EXCEL TRAINING IN BANGALORE
1000s of Students are already working in Top MNC
Placement oriented course curriculum
Interview Tips and preparation

Advanced Excel Training Batch size in Bangalore
10 Seats maximum per batch

Advanced Excel Training in Bangalore on Weekends
10 Seats maximum per batch

Fast Track Advanced Excel Training Options
5 Seats maximum per batch

Advanced Excel Training Cost
Best in class fee structure with quality training

JOIN TODAY







CONTACT US

MARATHAHALLI BRANCH :

# 3/76, Shiva Building, Outer Ring Road,
Marathahalli, Bangalore - 560 037. 
 Opp Kala Mandir 
 +91 97394 31060

RT NAGAR BRANCH :

# 10/23, 2nd Floor, 5th Main Road, 
Ganga Nagar, Bangalore - 560 032. 
 Near LG Showroom

CONNECT WITH US

CONNECT WITH US

Note - We do not provide any SAP software or SAP copyrighted training materials while imparting courses and are
not affiliated with SAP.

RIA Institute of Technology © 2017 | All Rights Reserved