Pakaccountants - pakaccountants.com - PakAccountants.com
General Information:
Latest News:
Hiding Gridlines in Excel – Learn the Right Ways 26 Aug 2013 | 12:40 am
One of our facebook community member consulted for Excel help and sent me a sample file. In that I noticed in order to hide gridlines, that are visible by default, were “forced” to disappear by fillin...
Conditional Charts in Excel – Workaround + How To 23 Aug 2013 | 07:04 pm
Last time we learnt how to make simple dial charts. There is so much to be discussed as basics to Excel charting but without little fun and doing out of ordinary is what everyone asks for. So today we...
Create Simple Dial Charts in Excel – How To 22 Aug 2013 | 06:10 pm
Charting or graphing is one of the biggest punch Excel has. Visual presentation of data greatly improves user’s ability to comprehend the information and significantly cuts down the time to take decis...
Excel Dynamic Data Validation Lists – Explained 20 Aug 2013 | 03:57 pm
Data validation lists are one easy way to keep your data error free and other benefit it is that it automates data entry to some extent. For those who are unaware of data validation tool and data vali...
Building a reference to specific Worksheet based on Cell value using Formula 19 Aug 2013 | 03:00 pm
Most of the time businesses are managed using specialized software but when it comes to a final touch in reporting the data is exported to Excel where calculations and everything is done much more eas...
5 Interview Questions I ask every candidate 18 Aug 2013 | 06:40 pm
Hiring the right person is first step to successful organization. Letting the right one in saves you ample in the long run. Filtering down to the right candidate is a difficult process. If it depends ...
10 Signs that You are a born Leader 16 Aug 2013 | 08:58 pm
Many think leaders are not made but are born to be one. To be a leader one don’t need to have super powers. It only takes few traits under the skin. We have listed 10 characteristics that are common i...
Count Specific Weekday or Weekdays within Data range containing Dates 15 Aug 2013 | 11:15 am
Often we have to deal with dates as they form integral part of almost every data set. But what if you want to count specific weekdays within a large range of dates? This is often the case with time sh...
Removing leading Apostrophe (‘) in Excel from Numbers and Text 13 Aug 2013 | 05:54 am
This question is asked by one of the member at our facebook community. He was stuck in common problem. Leading apostrophes. This is often the case if data is extracted from a famous business applicati...
How Excel VLOOKUP Works: How to use it – Explanation with Example 4 Aug 2013 | 02:28 am
While explaining LOOKUPs in my previous post, I explained how in daily life we apply lookup functions in different situations and to understand better I explained the example of mathematical lookup ta...
