{"id":233,"date":"2014-02-10T16:24:44","date_gmt":"2014-02-10T08:24:44","guid":{"rendered":"http:\/\/excelchamp.net\/?p=233"},"modified":"2023-12-03T21:37:28","modified_gmt":"2023-12-03T13:37:28","slug":"top-10-time-saving-tips-in-using-microsoft-excel","status":"publish","type":"post","link":"https:\/\/www.excelchamp.net\/top-10-time-saving-tips-in-using-microsoft-excel\/","title":{"rendered":"Top 10 Time Saving Tips in Using Microsoft Excel"},"content":{"rendered":"

If you are a data warrior, chances are that you use Excel extensively in your day to day work. Learn to Analyze Data Quickly With Excel<\/a>.<\/p>\n

<\/div>\n

And there are many ways to boost productivity within Excel. Use these nifty tricks and improve productivity.<\/p>\n

1. View All Formulas in Excel With a Single Click<\/a>:<\/strong> I wrote about this trick some time back. It allows you to view all the formula with a single click of Control + ` Key. This acts like a toggle key. This can save a lot of time in finding where are the formulas to edit\/view them.<\/p>\n

2. Clean up Your Data\u00a0 – Identify the Duplicates, and Remove Duplicates:<\/strong> There is no point in having duplicates in your tables. There are multiple ways to do this. You can identify the duplicates<\/a>, and then choose to remove them manually,\u00a0 or you can request Excel to remove the duplicate rows completely<\/a>, automatically.<\/p>\n

3. Colour Alternate Rows and Make it Easier to Read Large Data Sets:<\/strong> Prior to Excel 2007, we used to write formulas to colour alternate rows in Excel. This makes it easier to read the data.<\/p>\n

=MOD(ROW(),2)=0<\/p>\n

This function would tell us if the row is an even row or an odd row, and then we could colour it.<\/p>\n

But since Excel 2007, we can do this in multiple ways. We can convert the data into a table. And in the table options, you can then colour alternate rows or columns as bands.<\/p>\n

And then you can also use the formula above, and use conditional formatting.<\/p>\n

4. Learn The In-Built Functions in Excel:<\/strong> Many people are amazed at the plethora of in-built functions available in Excel. But you must know that they exist, and also know the syntax to make a good use of them.<\/p>\n