Dear All,
I am new in this group. And I really like the posting that you all have made. It's a very useful group as I am getting new things to learn. Could you please provide with help for the following topics below. I would appreciate if some one can send the material for the following topics. Thanks in advance. Regards, Kamal Gulati - India (New Delhi) +91-9899101928, 9718361928 E-mail: kamalgula...@gmail.com TOPICS Advance MS Excel Formatting Numbers Apply number formats (accounting, currency, and number) Create custom number formats Use conditional formatting Working with Named Ranges Add and delete a named range Use a named range in a formula Use Lookup Functions (Hlookup or Vlookup) Statistical Functions In Excel Working with Toolbars Hide and display toolbars Customize a toolbar Assign a macro to a command button Auditing a Worksheet Work with the Auditing Toolbar Trace errors (find and fix errors) Trace precedents (find cells referred to in a specific formula) Trace dependents (find formulas that refer to a specific cell) Displaying and Formatting Data Apply conditional formats Perform single and multilevel sorts Use grouping and outlines Use data forms Use subtotaling Apply data filters Extract data Query databases Use data validation Using Analysis Tools Use the Microsoft PivotTableR autoformat Use Goal Seek Create Microsoft PivotChartR reports Use data analysis and PivotTable Collaborating with Workgroups Create, edit, and remove a comment Apply and remove worksheet and workbook protection Change workbook properties Apply and remove file passwords Create a shared workbook Recording a Macro in Word and Excel Running and Recording a Macro in Word and Excel Interactive Macros Creating and Using Dialog and Input Boxes Extracting Data From Excel Visual Basic for Applications Programming Introduction to Visual Basic for Applications Running and Recording a Macro Examining Module Design Assigning Macros Absolute and Relative Recording of Macros Assigning Macros to Menus, Buttons, and Toolbars Creating Decision Making Code The If-Then Decision Structure The If-Then-Else and Select Case Decision Structures Using Loop Structures For-Next Structures in VBA Do- Loop and For Each-Next Structures in VBA Macro Management Personal Macro Workbook and Automatic Procedures Visual Basic Programming Data Access Objects, Using ADODC, Crystal Reports Working with Variables and Procedures, Event and Error Handling, More Controls. --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
