FREE Excel Invoice Template V1.0 with Customer and Product list - Unlocked + Download ready!
Everyone loves getting paid but to get paid one needs to send invoice and to make an invoice that is not only effective from a business perspective but also help you get invoicing done efficiently is not that easy as it is quite hectic that you have type in all the products, their prices, then […]
Format content using Find & Replace feature in Excel - Quick Tip
Find and Replace feature can help us in number of ways but one of its hidden abilities is to format the content specified content as well. For example here is the list of students in which names are repeating in random order. You want the name PakAccountants to be formatted in red color and bold […]
Formatting Dates in Excel the better way using Custom Number Formatting - How To
Time is of prime importance and having dates in your data is most of the time essential bit of whole. However, making the dates look the way we want is often cumbersome in spreadsheets as sometimes it changes, flips on its own or it doesn’t work the way want it to. This definitely frustrates many […]
ABC Analysis using Conditional Formatting in Excel
ABC analysis is an inventory management technique in which stock is classified in usually three categories on the basis of their importance. Such classification help management to concentrate their efforts on such products that are more important in terms of revenue they are generating, cost or any other measure entity is using to judge importance. […]
Top 10 Excel Tutorials for the month of September 2014 on PakAccountants.com
Another EXCELlent month ended and things were quite wild in September as many new tutorials were written and new tips and tricks are shared. We will continue to accelerate at the same pace. But here are the Top 10 Most Read Excel pages on our website in the month of September 5 Ways to Transpose […]
How to LOOKUP using ONLY Conditional Formatting in Excel
Few days back we learnt how to do 2-way lookup i.e. looking up the value against two criteria. You can learn it in detail here: How to do 2 Way Lookup in Excel – One value to lookup with two criteria using Intersect Operator In the tutorial mentioned before the value was fetched in a separate cell […]
![Copy Paste Row Height in Excel [Quick Tip]](../../../../wp-content/uploads/2013/04/1-minute-excel-tutorial-150x150.png)
Copy Paste Row Height in Excel [Quick Tip]
In Excel we have the ability to easily copy and paste the column width using paste special and the beauty of this trick is that you simply have to copy the column having a desired width and go the column of which you want to adjust the width and hit Alt+ Ctrl+V > from the […]
Create Data Validation lists from Unsorted data with duplicates in Excel [How To]
Today I finally decided to make an Excel dashboard on debtors aging analysis. The main reasons to do this dashboard were that: I thought now enough knowledge has been delivered to my cult followers that they will understand the ins and outs of making this dashboard; and that majority of computational work was already done in the […]
How to do 2 Way Lookup in Excel - One value to lookup with two criteria using Intersect Operator
I can safely assume that almost everyone knows about LOOKUP formulas or precisely VLOOKUP. That is probably because sights and sounds of Excel don’t go without shouts and screams of lookup formulas. Learning Excel and not learning lookup formulas is like learning Japanese and not learning how to use chop sticks! So if you are […]
Excel Linked Objects - Making Excel Reports that Spread the Word
Excel is good at so many things and we love it. However, when it comes to reports and presentations we rely on other applications in the office suite like Microsoft Word and Powerpoint. There is no real problem in pasting the data tables and charts in word documents or powerpoint slides until the data in Excel changes […]