Category: Basics

Quick Excel Tip: Transpose

Did you know that you can easily switch rows and columns of a list of values in an instant by copy-paste using transpose option ?

Named Ranges

Did you know that you can give a name to your ranges or cells in excel? And using these named ranges, while you can work...

Sumif Function

When you need to get sum of a list of vaules depending on one condition, sumif function is here to help.

Enable Excel Developer Tab

Excel developer tab houses some very useful shortcuts. Macro buttons and form controls are just 2 examples of these. But unfortunately developer tab is not...

Excel Form Controls

Excel form controls helps you turn your Excel workbook book into something more. They add interactivity to your workbook. Here is some explanation about form...