Thanks guys,

 

Really nice attachment..

 

Raj

 

 

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of M, Madhu : Barclays Finance
Sent: Sunday, January 25, 2009 10:56 AM
To: johnplaye...@gmail.com; excel-macros@googlegroups.com;
kamalgula...@gmail.com
Cc: madhukar.madh...@gmail.com
Subject: FW: $$Excel-Macros$$ Re: Help (Excell Formula with example)

 

Hi,

 

Above attachment file in rar format,

In my office rar software is not their, pls send my in zip format 

Pls help me 

 

 

 

 

Thanking You,

   Madhu

  Bangalore HUB

Cell : 91-9743130534

 

  _____  

From: madhu [mailto:indiabul...@gmail.com] 
Sent: 24 January 2009 19:27
To: M, Madhu : Barclays Finance
Subject: Fwd: $$Excel-Macros$$ Re: Help (Excell Formula with example)

 



---------- Forwarded message ----------
From: Mudassar Ramzan <johnplaye...@gmail.com>
Date: Jan 23, 2009 8:29 PM
Subject: $$Excel-Macros$$ Re: Help (Excell Formula with example)
To: excel-macros@googlegroups.com

Take  a look at attached file maybe helpful for you.

 

 

Thanks & regards,

 

|| Mudassar Ramzan | MIS Officer - MIS/IT | WorldCall Telecom Ltd |
061-814-3999| 0321-732-55277 | 0300-7315277 ||

 

----- Original Message ----- 

From: Rabindra Thapa <mailto:rabinthapa2...@gmail.com>  

To: excel-macros@googlegroups.com 

Sent: Friday, January 23, 2009 5:51 PM

Subject: $$Excel-Macros$$ Re: Help


 

thanks a lots.

 

 

could u have other document regarding excel formula using with example. i
can get some idea and apply on my daily task of excel sheet.

 

 

hope that i will get kind co-operation for your end.

 

 

once again thank you.

 

R.thapa

 

On Thu, Jan 22, 2009 at 6:11 PM, Mudassar Ramzan <johnplaye...@gmail.com>
wrote:

Take  a look at attached file maybe helpful for you.

 

 

 

         

 

----- Original Message ----- 

From: Kamal Gulati <mailto:kamalgula...@gmail.com>  

To: excel-macros@googlegroups.com 

Sent: Thursday, January 08, 2009 3:43 PM

Subject: $$Excel-Macros$$ Help


 

 

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.

 

 

 

 

 




-- 
=================
- 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."

  _____  


No virus found in this incoming message.
Checked by AVG - http://www.avg.com <http://www.avg.com/>  
Version: 8.0.176 / Virus Database: 270.10.5/1883 - Release Date: 1/8/2009
6:05 PM

 

 


 

 

  _____  


No virus found in this incoming message.
Checked by AVG - http://www.avg.com <http://www.avg.com/>  
Version: 8.0.176 / Virus Database: 270.10.12/1911 - Release Date: 1/23/2009
7:28 AM

 








This e-mail and any attachments are confidential and intended solely for the
addressee and may also be privileged or exempt from disclosure under
applicable law. If you are not the addressee, or have received this e-mail
in error, please notify the sender immediately, delete it from your system
and do not copy, disclose or otherwise act upon any part of this e-mail or
its attachments.

Internet communications are not guaranteed to be secure or virus-free.
The Barclays Group does not accept responsibility for any loss arising from
unauthorised access to, or interference with, any Internet communications by
any third party, or from the transmission of any viruses. Replies to this
e-mail may be monitored by the Barclays Group for operational or business
reasons.

Any opinion or other information in this e-mail or its attachments that does
not relate to the business of the Barclays Group is personal to the sender
and is not given or endorsed by the Barclays Group.

Barclays Bank PLC.Registered in England and Wales (registered no. 1026167).
Registered Office: 1 Churchill Place, London, E14 5HP, United Kingdom.

Barclays Bank PLC is authorised and regulated by the Financial Services
Authority.

 


--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---

Reply via email to