Excel VBA Training (Beginner to Advanced Level) - Delhi.. CiteHR
CiteHRCiteHR
 
HOME RISE NEW TEAM →|
Home > Information Section > Events And Announcements

excelmis1 Started The Discussion:

I provide training on Excel VBA which includes Excel formulae and simple VBA programs for beginners; then advanced VBA at the later stages. This is a job oriented training that helps you in getting job in various organisations. This training is done on Saturdays and Sundays. Call-8802579388

excelmis1 -  Member Since: Jun 2011
I provide training on Excel VBA which includes Excel formulae and simple VBA programs for beginners; then advanced VBA at the later stages. This is a job oriented training that helps you in getting job in various organisations. This training is done on Saturdays and Sundays

Call- 8802579388

www.excelonline.webs.com

excelmis1 -  Member Since: Jun 2011
Advanced MS Excel Course Content

Advanced Functions
IF Function & Nested IF Statements
And & Or Functions
Lookup Functions (Horizontal And Vertical Lookup
Index Function
Array Function
Subtotals
Conditional Formatting


3D Ranges

Create & Maintain (Within Worksheets In a Single File & Between External Files)
Consolidate Data (via 3D Ranges & Using The Consolidate Tool)


Pivot Tables
Create Pivot Table
Work With Row/ Column Fields
Data Fields
Customise Table Display


Organising Workbooks
Create Templates
Styles
Protect Ranges & Worksheets


Data
Enter & Select Records Using The Input Form
Sort Data Into Lists
Filter Data - Autofilter, Advanced Filter
DataBase Functions
Validation Rules


Goal Seeking
Solver
Goal Seeking With Charts
What-If




Scenarios
Create Scenarios
Create Summary Report
Merge Scenarios
Protect Scenarios


Macros
Create Macros Record

Relative Referencing
Assign To Toolbars/ Keyboard
Make Available To All New Documents/ Current Document Only


Outlines
Group Row/ Column Data To Create Outline Levels Based On Worksheet Formulae
Display Summary Rows And Summary Styles


Custom Views
Create, Modify, Delete
Include Hidden Rows, Columns, Filter Settings


Report Manager
Create, Modify, Delete
Create Sections (Sheet, View1, Scenario)

Contact : -
Sujeet Kumar
8802579388
www.excelonline.webs.com




 
 
 
 





POSTING RULES OF CONDUCT
  • Do not post anything derogatory about any company or person.
  • Sharing articles from other websites should be done by posting a link to the original article.
  • To discuss sensitive issues create a pseudo/anonymous account.
  • Please avoid repeat posting your company profile - such accounts are removed automatically.
  • Found This Useful? +Vote Up This Via Google.  

    Why Vote? User validation is extremely important for good content to prosper.
    Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.



    3M Users, 100K+ Documents & 450K+ Discussions

    Share »


    Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
    Community Support & Professional Insights. Login or Register.
    Email/Username    
    Password  

    About Us - Advertise - Contact Us - RSS   On Google+  
    All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
    Privacy Policy | Disclaimer | Terms Of Service
    Facebook Page | Follow Us On Twitter | Linkedin Network