close New Updated Classes on DT for final by CA Farooq On CCI Online Coaching   view more

Please Wait ..

Sign-in to your account


Username:
Password:

Remember Me

Forgot your password?

Sign-up now



Join CAclubindia.com and Share your Knowledge. Registered members get a chance to interact at Forum, Ask Query, Comment etc.


Discussion > Info Technology > Excel >

Advanced Excel Using the GkExcel Tool

    Post New Topic
Pages : 1





Employee

[ Scorecard : 103]
Posted On 24 September 2008 at 17:04 Report Abuse

Now Find the Help File on How to use the GkExcel Tool for Working Faster and Smarter.

1. Do BANK Reconciliations and any other Reconciliation in minutes using the GkPlookup & GKRlookup functions

2. Want to Filter Items with color use teh GkBgcolor & GkFGColor Function to Get the Color code and Filter using the Code you have filtered the colored items of your choice

3. Working in BPO Co ? in AP Process ? Don't know What Invoices are available in a Folder Or Want to get the Invoice file Names in Excel Use the Amazing gkFilelist Function by specifying the Path.

4. Fed Up using the Concatenate function ? try out the GkConcate Just One shot its Done

And Lots more....Have Fun

 

 



Attached File : 30 how to use the gk excel tool.doc downloaded 107 times

(Guest)
Posted On 12 November 2008 at 13:22

Is this free? If this is free,how can I download this file.



There are 1 Replies to this message






Related Files








Related Threads


Post your reply for Advanced Excel Using the GkExcel Tool



Your are not logged in . Please login to post replies

Click here to login


Not a member yet ?? Click here to signup

Message







    

  • Use thank button to convey your appreciation.
  • Maintain professionalism while posting and replying to topics.
  • Try to add value with your each post.