-
Amit and
mohammed are now friends June 15, 2012 12:23 am -
Amit changed their profile picture May 2, 2012 10:42 am
-
Amit uploaded the file: If Function to
Microsoft ExceL- Tips, Tricks & Techniques..!!! May 2, 2012 10:30 amWhat Does It Do?
This function tests a condition.
If the condition is met it is considered to be TRUE.
If the condition is not met it is considered as FALSE.
Depending upon the result, one of two actions will be carried out. -
Amit uploaded the file: If Function to
Microsoft ExceL- Tips, Tricks & Techniques..!!! May 2, 2012 10:27 amWhat Does It Do?
This function tests a condition.
If the condition is met it is considered to be TRUE.
If the condition is not met it is considered as FALSE.
Depending upon the result, one of two actions will be carried out. -
Amit posted an update in the group
Microsoft ExceL- Tips, Tricks & Techniques..!!! April 23, 2012 12:11 pmIt’s one of our member’s birthday today…………….Isha Oswal ! Happy Birthday Isha..!!!
Have a great day ahead…Enjoy!!!! -
Amit uploaded the file: Transpose Function to
Microsoft ExceL- Tips, Tricks & Techniques..!!! April 12, 2012 1:41 pmWhat Does It Do ?
This function copies data from a range, and places in it in a new range, turning it so that the data originally in columns is now in rows, and the data originally in rows is in columns. -
Amit started the forum topic LC Process- 9 Quick steps to understand the process in the group
Everything Commercial April 11, 2012 9:33 pmBelow are 9 quick steps to understand the LC process.
Participants in LC Process
1 Buyer
2 Issuing Bank
3 Advising Bank
4 Seller (Beneficiary)9 Steps in the Letter of Credit Process
[…]
-
Amit uploaded the file: Clean Function to
Microsoft ExceL- Tips, Tricks & Techniques..!!! March 7, 2012 3:22 pmWhat Does It Do?
This function removes any nonprintable characters from text.
These nonprinting characters are often found in data which has been imported
from other systems such as database imports from mainframes.Also, when a table ic copied and pasted from pdf files or OCR’d documents from Microsoft One Note
-
Amit uploaded the file: Roman Numbers to
Microsoft ExceL- Tips, Tricks & Techniques..!!! March 2, 2012 11:48 amWhat Does It Do ?
This function produces a number shown as Roman numerals in various formats. -
Amit posted a new activity comment February 22, 2012 4:18 pm
In reply to: Amit uploaded the file: Split Forename and Surname………… to Microsoft ExceL- Tips, Tricks & Techniques..!!! The given formula’s are useful when you have one cell containing text which needs to be split up. One of […] Viewyou are welcome Isha…
-
Amit uploaded the file: Split Forename and Surname………… to
Microsoft ExceL- Tips, Tricks & Techniques..!!! February 22, 2012 12:11 amThe given formula’s are useful when you have one cell containing text which needs
to be split up.
One of the most common examples of this is when a persons Forename and Surname
are entered in full into a cell.The formula use various text functions to accomplish the task.
Each of the techniques uses the space between the names to identify…[Read more]-
Interesting………..
That’s really useful for people like me who need to maintain a database of employee information etc…
Let me practice & implement it now.
Thanks Amit
-
you are welcome Isha…
-
-
nice…….
-
-
Amit posted a new activity comment February 17, 2012 9:45 am
In reply to: Amit uploaded the file: [Quick Tip] – Use Text Format to Preserve Leading Zeros in Excel to Microsoft ExceL- Tips, Tricks & Techniques..!!! Here is a quick tip to add awesome to your Thursday……… View
Pleasure -
Amit uploaded the file: [Quick Tip] – Use Text Format to Preserve Leading Zeros in Excel to
Microsoft ExceL- Tips, Tricks & Techniques..!!! February 16, 2012 12:40 amHere is a quick tip to add awesome to your Thursday………
-
Always had a problem if I had to key in number like Invoice numbers etc which have a few leading zeros. That customer number format never struck me. Thank you Amit.
-
Pleasure
-
-
-
Amit posted a new activity comment February 15, 2012 4:39 pm
In reply to: Isha-Oswal posted an update It’s one of our member’s birthday today…………….Amit Rajput ! Happy Birthday Amit!!! ViewThanks Isha….
-
Amit and
MUHAMMAD are now friends February 13, 2012 6:52 pm -
Amit posted an update in the group
Microsoft ExceL- Tips, Tricks & Techniques..!!! February 11, 2012 7:54 pmDay- 8
Do not go overboard
Formatting your workbook is much like garnishing your food. No amount of plating & garnishing is going to make your food taste good. I personally spend 80% of time making the spreadsheet and 20% of time formatting it. By learning how to use various formatting features in Excel & relying on productive ideas like…[Read more]
-
Amit and
Gourab are now friends February 11, 2012 9:57 am -
Amit posted an update in the group
Laughing Tiger February 10, 2012 7:16 pmThe Ten Commandments Of Employment
If it rings, put it on hold.
If it clunks, call the repairman.
If it whistles, ignore it.
If it’s a friend, stop work and chat.
If it’s the boss, look busy.
If it talks, take notes.
If it’s handwritten, type it.
if it’s typed, copy it.
If it’s copied, file it.
If it’s Friday, forget it! -
Amit uploaded the file: Day 7 – Tip 7 to
Microsoft ExceL- Tips, Tricks & Techniques..!!! February 10, 2012 5:19 pmLets see something about formatting options for print…
-
Amit posted a new activity comment February 9, 2012 12:38 pm
In reply to: Akshata uploaded the file: Some Rules & Tips to Cut your Tax…. to Tax Planning Guide Tax-Saving Avenues , Reimbursements, Other Expenditure, Loan Disbursement ViewThanks..
- Load More
Loading ...
Thank you Amit….