Hi Tariq, All this topic would be available in a Excel Programming book, YOu can download excel programming book from the website esnips.com, in search box write the Excel programming you will find many books. download the excel vba programmer refrence or Sybex mastering excel programming.
regards idrees On Wed, Jan 7, 2009 at 6:05 PM, Tariq Kamal <tariq.kamal....@gmail.com>wrote: > Some of the topic you can find on the site www.gate2quality.com > > I will be updating the site with more stuff in coming days. > > > > On Wed, Jan 7, 2009 at 10:17 AM, Kamal Gulati <kgul...@amity.edu> wrote: > >> *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. >> >> * * >> >> >> >> >> >> >> >> >> >> >> > > > -- > http://www.gate2quality.com > http://www.rideahead.blogspot.com > > > > -- Mohd Idrees A lucky guy. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
