Posted: 1 month ago


Shortlist Click to Shortlist
+91 72040 91060
+91-80-4209 3564

Send Email Response

  • Course: Career Counseling
  • Locality: RT Nagar
  • You are: Offering professional course

MS-EXCEL Training Module
Advanced Excel
Time: 18 hrs
1. Pivots and Pivot Graphs:
a) Creating of Pivot Table
b) Using Summary function in Pivot Table
c) Pivot Table Calculations
d) Creating own formulas in Pivots
e) Grouping and Ungrouping in Pivot Tables
f) Creating Pivot Graph
g) Custom Filter on Pivot Table
h) Formatting Pivot table (Removing old data, grand total, subtotal …etc.)

2. Working on Objects:
a) Inserting Objects
b) Inserting different files into Excel (like .doc, .pdf, .txt files)
c) Hyper linking to different sheets
d) Providing screen tips in hyper link
e) Hyperlink to send emails
f) Inserting symbols
g) Sending working file to an email

3. Data Management in Excel:
a. Rearranging of Data
b. Sorting by alphabets, numbers and time
Filtering Data:
a. Using Auto filter option
b. Custom Filtering with different options
c. Advanced Filtering
d. Find Unique records using advanced filtering
e. Filter using operators AND/OR
f. Filter by color
Grouping and Outlining Data
a. Group and ungroup rows and columns
b. Auto outlining the data
Freezing and Unfreezing
Data Validation:
a. Use Data Validation in Excel
b. Using Input Message in Data validation
c. Using error message in Data Validation
Removing duplicate records:
a. Remove duplicate records in a spread sheet
b. Customize to remove the duplicate values
Split Texts:
a. Split texts to different columns
b. Remove special character from a string and split the string
Data Consolidation:
a. Combining different spreadsheet using data consolidation
b. Using summary function in data consolidation
Conditional Formatting:
a. Use of conditional formatting
b. Custom formatting
Copy Data:
a. Use of format painter
b. Use of paste special
c. Strike through a value
d. Find and Replace
View Multiple Files:
a. Arrange multiple windows to view in one time.
b. Split big sheet into sub sheets for better analysis
Working on Tab:
a. Hide/ Unhide a tab
b. Color a tab
c. Move /Copy the tab to another sheet/workbook

4. Advanced Functions:
a. V-Lookup
b. H-Lookup
c. IF
Index Match
f. Rows
g. Columns
h. Match
i. Offset
j. Get Pivot Data
k. Date and Time Functions
l. Text Functions
m. Operators
n. Mathematical functions
o. Calculation options

Name Manager:
a. Define a name to a range
b. Use of name manager
c. Using formulas in name manager
d. Editing name range

5. Data Connection from External Data:
a. From access
b. From SQL
c. From Web
d. From ODBC

6. Customize your Excel view:
a. Customize Excel view
b. Developer Option
c. Trust Centre
d. Add-Ins
e. Save directory options
f. Language Setting
g. Quick access toolbar

7. Security options in excel:
a. Protecting the worksheet
b. Protecting the workbooks
c. Sharing the workbook
d. Allow users to edit ranges

EXCEL MACRO- VBA Programming
Time: 20 hrs
1. Introduction to VBA:
a. What is VBA Programming?
b. Benefits of using Macro.
c. Recording Macro.
d. Running of Macro using an Object.
e. Editing Macro.

2. Basic Programming Concept:
a. Overview of different programming language
b. Operators
c. Decision making and looping
d. Functions

3. How VBA work with Excel:
a. Working in Visual Basic Editor
b. Introducing the Excel Object Model
c. VBA Sub and Function Procedures

4. Use VBA programming concept in Macro:
a. Essential VBA Language elements
b. Working with Range objects
c. Using VBA and worksheet functions
d. Controlling program flow and making decisions; IF, If Else, Else If, Do While, Do Until Loop, Select Case
e. Automatic Procedures and Events
f. Error Handling Techniques

5. External Connectivity
a. Connecting to share point
b. Connecting to SAP
c. Connecting to web portals
d. Connecting to data base.

6. Communicating with your Users:
a. Simple Dialog Boxes
b. User Form Basics
c. Designing User Form
d. Using User Form Controls
e. User Form Tricks and Techniques
f. Accessing the Macro through User Form
g. Linking one Form to another Form
h. Progress Indicator.

7. Putting it All Together:
a. Creating worksheet functions and calling functions
b. Creating Excel Add-Ins

8. Completing the Project:
a. Creating User Manuals
b. VBA Security Option
c. Delivering the project

RIA Institute of Technologie
#10/23, 2nd Floor, 5th main road, Ganga Nagar
R T Nagar, Bangalore-560032
Land mark: Near L.G Showroom
Phone No:+91 9945601060/7204091060

See more ads by this user
Mark as Spam
Safety tips for buyers / sellers
Use      keys to browse Next/Prev ads
Similar classified ads which may interest you :
Get similar ads More details
Course - Others | Locality - AMCO Colony
Posted: 7 hours ago   |   Professional courses - Bangalore
Course - Others | Locality - Yelahanka
Posted: 7 hours ago   |   Professional courses - Bangalore
Course - Others | Locality - SR Nagar
Posted: 17 hours ago   |   Professional courses - Bangalore
Course - Teaching | Locality - Ashok Nagar
Posted: 17 hours ago   |   Professional courses - Bangalore
Course - Teaching | Locality - Basaveshwaranagar
Posted: 17 hours ago   |   Professional courses - Bangalore
Course - Teaching | Locality - Akshayanagar
Posted: 17 hours ago   |   Professional courses - Bangalore
Course - Teaching | Locality - Attikoppe
Posted: 17 hours ago   |   Professional courses - Bangalore
Course - Career Counseling | Locality - Jayanagar
Posted: 22 hours ago   |   Professional courses - Bangalore
Course - Others | Locality - Kamaraj Road
Posted: 22 hours ago   |   Professional courses - Bangalore
Course - Management | Locality - Aga Abbas Ali Road
Posted: 22 hours ago   |   Professional courses - Bangalore
Promote your business on
(Premium packages / Banners / Leads)
Mail us at