*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 PivotTable(R) autoformat Use Goal Seek Create Microsoft PivotChart(R) 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. * * -- ================= - k...@m@l' g...@ti' - ================= Ph: +91 9899101928, 9718361928 --------------------------------------------------------- "Don't compare yourself with anyone in this world. If you do so, you are insulting yourself." --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
