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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
