Convert Numbers to Words/Text in Excel WITHOUT pasting macros again! – NUMWORD Excel Addin
https://www.youtube.com/watch?v=huozBRRIq1c
This has been long overdue and I am happy that an Excel add-in that helps convert numbers to words or text is finally here. Just install this add-in and you can easily convert numbers...
Working on Multiple Excel Worksheets – 3 Tricks to know!
Intro - Working across multiple worksheets at once!
Excel's workbook can be divided in several worksheets and by design its quite efficient as worksheets can act and work as independent unit and still easily interact in...
Format Dates as Yearly Quarters in Excel – How To
For reporting purposes sometimes its elegant to show dates as quarters of the year instead of months. It helps managing clutter in a large set of data. As much as I wish there was...
Add or Combine text in cells using Excel CONCATENATE – How To
There are two ways to combine text in Excel:
Use CONCATENATE function; or better yet
use "&" connector which is a shortcut of using CONCATENATE facility
The result from both are same but second one is easier,...
Enable or Disable Excel Data Labels at the click of a button – How...
Data labels in Excel charts can help users to get the information right at that spot without referring to any other source of information. In some situations however, same data labels can get in...
Making a Slope Chart or Bump Chart in Excel – How To
Excel has many different styles of charts and graphs inbuilt and one can make them with a single click. A great convenience to have. But for charts and graphs convenience is required, merited and...
Split numbers into integer and decimal parts in Excel – Quick Tip
Excel is all about numbers and we often end up with decimal numbers. Situations can arise when we want to split or separate the integer part from fractional (decimal) part.
This can be achieved in...
5 powerful Excel functions you are not using
When it comes to usability and application of Excel, it is almost as true as if it is an acknowledged fact. There is almost no profession in management of which Excel can't help on...
Making dynamic Chart of Accounts, Journal + Ledgers in Excel – How To
Excel is one of the favourite tools for accountants and for everyone else who has anything to do with accounting information. It is a tool of choice when it comes to data extraction and...
Pivot data using Power Query to show text values – Data Restructuring using Excel...
The ones who make reports on daily basis using Excel can understand how important the data is and how equally important data structure is. With data structure I meant the way data is arranged...