Spell Checking and Proofing in Excel – Ten things to learn how it works
Although Excel is a spreadsheet but one of things it has borrowed from in-family word processor (Word) is Spell check feature. Excel uses the same kind of framework to find spelling mistakes in the...
Automating Data Entry using Data Validation in Excel
This is mainly a data entry tutorial and can be used in other scenarios as well. But as sales and price data is easily understood so I am using the same. Let me know...
Multi level or Multi column sort in Excel – How To
Before in Excel tips we learnt about Custom Lists feature in Excel and how to use it to sort and have custom autofill series. In our example we sorted the sales data using our...
Absolute or Static structured references in Excel table – How to
Just a quick note on how to do absolute referencing if you are using structured references in Excel tables. For the ones who are not familiar with structured references and tables, your tutorial is...
Understanding Custom Views in Excel
Excel is all about flexibility. With all the built in features there is just endless possibilities the way you can use this marvelous application software. But Excel extends the flexibility even further through custom...
Calculate number of Workdays in Excel using formula
Few days back I scribbled about calculating days between two dates and there I discussed DAYS360 formula method and one other common sense method to find out the number of days between two dates....
How to sort Rows horizontally left to right instead of Columns vertically top to...
Sorting is one of the many good things excel offers. And it does make our job a lot easier once the data is arranged in particular order. However there is one limitation to the...
How to convert numbers into words in Excel – VERY QUICK TIP
I have been working on a small piece and I came across one requirement that in letters to customers in addition to amounts reported in numbers it must also include amounts receivable in words....
How to make a basic Tax calculator in Excel
Business and Taxation go hand in hand. However, taxation calculations are most of the time tedious and if you need to make a small change you might have to punch millions of calculator keys...
Calculating number of days between two dates – Excel Function Vs Common Sense
Business and every aspect of our life is about time and we have to compute days most often. To handle this Excel does provide a solution for in shape of a dedicated formula DAYS360()....