1 Create your own Sorting Criteria in Excel

Data Sorting is one of the most frequently used features in Excel. Some common examples include sorting alphabetically, by value (largest to smallest or smallest to largest), by day of the week (Mon, Tue, Wed..), or by month names (Jan, Feb..). While these are some inbuilt sorting criteria, you can create new criteria according to your […]

Continue reading >>

7 How to Get the Excel Developer Tab Show Up in the Ribbon

You can insert a lot of interactive controls in an Excel worksheet using the Excel developer tab. These interactive controls (such as a check box, radio button, combo box, scroll bars) are quite useful when you are creating interactive workbooks or excel dashboards. But there is a possibility that you may not have the Developer tab […]

Continue reading >>