Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

2011-07-26 Thread Venkatesh Srinivas
I some how feel he need to know a bit of database basics...


   - Clean and organize the database before working on it...
   - Ensure to know the compatible formula- other features based on version
   and its disadvantages

Regards
Venkatesh
+91 9841969353


On Wed, Jul 27, 2011 at 9:41 AM, XLS S xlst...@gmail.com wrote:

 Hey

 Please find  below link

 http://en.wikipedia.org/wiki/Management_information_system

 On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina 
 lovemekris...@gmail.comwrote:

 Hi Group,

 My Name is krishna, Working as a Data Analyst from the last 3 years. My
 daily work includes working with excel, Creating General Reports, Pdf to
 Excel Conversion, Data Mining and Analyzing data by using Data Tools like,
 Filter, Formulas, Sorting etc..

 But I got a mail from one of my friend, It is an Opening for MIS
 Executive. I just want to know the exact qualification needed for the job. I
 mean, what are the Tools i need to know,

 I know, Many of us are already well settled. So, I just want to know from
 you people,


 Thanking you and Waiting for your reply   - Krrish

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 .


  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 

Regards
Venkatesh KS
Phone: +91 98419 69353

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ vlookup query

2011-07-09 Thread Venkatesh Srinivas
please shoot your query

On Sat, Jul 9, 2011 at 9:43 AM, PRADEEP KUMAR KOKNE 
pradeepkumar...@gmail.com wrote:

 I have a some query regarding the vlookup can somebody help

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 

Regards
Venkatesh KS
Phone: +91 98419 69353

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


$$Excel-Macros$$ Re: Need to track minutes

2009-08-18 Thread venkatesh srinivas
hi dilip!

Please fine enclosed the solve sheet.'




On 8/18/09, Dilip Pandey dilipan...@gmail.com wrote:

 Hi Sachin,

 Attached herewith is the dummy scenario with solution.  Thanks.

 --
 DILIP KUMAR PANDEY
   MBA-HR,B COM(Hons.),BCA
 Mobile: +91 9810929744
 dilipan...@gmail.com
 dilipan...@yahoo.com
 New Delhi - 110062



 On Tue, Aug 18, 2009 at 10:53 AM, Sachin Gohil 
 sachin.go...@hotmail.comwrote:

 Dear All,

 I have to maintain database of alarms received  closed, format is date 
 time, and need to keep track of differences in minutes, please help.

 Thanks.

 --
 Are you an untamed, bizarre or daring explorer? Find out now! Drag n'
 drop http://www.exploremyway.com/



 



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

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Difference in Min - by DILipandey.xls
Description: MS-Excel spreadsheet


$$Excel-Macros$$ Re: column chart

2009-08-18 Thread venkatesh srinivas
Hi Lynn!

Please let me know if the below mentioned file solves our problem




On 8/18/09, Lynn moley_c...@yahoo.com.au wrote:


 i have the following columns
 -  dates
 - no. of boxes packed
 - no. of boxes to be packed.

 how do i do a column chart which compares the no. of boxes packed vs
 to be packed ?

 


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

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



coloumn chart.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


$$Excel-Macros$$ Re: NAMED Range

2009-08-12 Thread venkatesh srinivas
Hi Suresh!

can you please give an example of us to solve the problem might be you can
add a example with your desired result..

Rgds
Venkatesh


On Tue, Aug 11, 2009 at 8:57 PM, suresh k brave.sur...@gmail.com wrote:

 Hi All,

 I have selected A1 to A5 and given some name(In Named Range).

 Now I want to remove it. Anyone know how to do it???

 Regards,
 Suresh

 


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

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



$$Excel-Macros$$ Re: help Needed!

2009-08-12 Thread venkatesh srinivas
Hi Abdul
Can you please provide an example. your file has the folloing fields

Time of Call Recorded
(T1) Tech.Deputed Time
Tech. Arrival Time
Tech. Responding Time
Work Start Time Work Finish Time (T2)
Restoration Time (T2-T1)
Restoration Time In Mins.

can you tell us what should be the final result.. so that the formula can
you given accordingly

Regards
Venkatesh
On Wed, Aug 12, 2009 at 12:53 PM, Abdul Rehman
stevejamesrica...@gmail.comwrote:

  Hi All,

 Can anyone guide me how to input formula in column J(file attached) to
 calculate the value. I am doing tht individually for each row. Would it be
 possible to write a formula for all the rows in one go 

 --
 Warm Regards,
 Abdul Rehman.

 Woods are lovely, dark and deep
 But I have promises to keep,
 And miles, miles and miles to go before I sleep.


 


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

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



$$Excel-Macros$$ Re: URGENT HELP

2009-08-03 Thread venkatesh srinivas
rajesh can you confirm if the number of rows in just 13 or will it cross
more than that...
if its just Jan to Dec.. we can fix it with an simple {if condition.. } or
else we need to find other ideas..

Regards
Venkatesh


On 8/3/09, Rajesh Janardanan rajesh...@gmail.com wrote:


 Dear All,
 Need an urgent help , please refer the attached file , I need a formula
 which will read YTD (B13) as the last cell entered , in the attached file
 B9. If I update the file for september B13 automatically should pick from
 B10.

 Please advise

 Best regards
 Rajesh

 



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

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



$$Excel-Macros$$ Re: URGENT HELP

2009-08-03 Thread venkatesh srinivas
sorry guys.. looks like i am too late...to reply
sorry ...


On 8/3/09, Rajesh Janardanan rajesh...@gmail.com wrote:

  Guys,

 I am waiting for an answer , Please respond

 Best regards
 rajesh


 On Mon, Aug 3, 2009 at 8:01 AM, Rajesh Janardanan rajesh...@gmail.comwrote:


 Dear All,
 Need an urgent help , please refer the attached file , I need a formula
 which will read YTD (B13) as the last cell entered , in the attached file
 B9. If I update the file for september B13 automatically should pick from
 B10.

 Please advise

 Best regards
 Rajesh




 


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

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---