Advance Excel VBA Training Institute In Marathahalli

• 1.Microsoft Word
  2. Microsoft Excel
  3. Microsoft PowerPoint
  4. Introduction to Ms access
  5. Working with Ms outlook express

   

• 1.Inserting Objects
  2. Inserting different files into Excel (like .doc, .pdf, .txt files)
  3. Hyper linking to different sheets
  4. Providing screen tips in hyper link
  5. Hyperlink to send emails
  6. Inserting symbols
  7. Sending working file to an email

1. Rearranging of Data
   2. Sorting by alphabets, numbers and time

1. Using Auto filter option
   2. Custom Filtering with different options
   3. Advanced Filtering
   4. Find Unique records using advanced filtering
   5. Filter using operators AND/OR
   6. Filter by color

1. Group and ungroup rows and columns
   2. Auto outlining the data
   3. Freezing and Unfreezing

• Use Data Validation in Excel
  2. Using Input Message in Data validation
  3. Using Error Message in Data validation

1. Remove duplicate records in a spread sheet
   2. Customize to remove the duplicate values

• Combining different spreadsheet using data consolidation
  2. Using summary function in data consolidation

1. Use of conditional formatting
   2. Custom formatting

1. Use of format painter
   2. Use of paste special
   3. Strike through a value
   4. Find and Replace

1. Arrange multiple windows to view in one time
   2. Split big sheet into sub sheets for better analysis

1. Hide/ Unhide a tab
   2. Color a tab
   3. Move /Copy the tab to another sheet/workbook

1. V-Lookup
   2. H-Lookup
   3. IF
   4. ISERROR
   5. Index Match
   6. Rows
   7. Columns
   8. Match
   9. Offset
   10. Get Pivot Data
   11. Data and Time functions
   12. Text Functions
   13. Operators
   14. Mathematical functions
   15. Calculation Operations

1. Define a name to a range
   2. Use of name manager
   3. Using formulas in name manager
   4. Editing name range

1.From access
2. From SQL
3. From Web
4. From ODBC

1. Customize Excel view
   2. Developer Option
   3. Trust Centre
   4. Add-Ins
   5. Save directory options
   6. Language Setting
   7. Quick access toolbar