Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification
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
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
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
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
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!
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
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
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 -~--~~~~--~~--~--~---