Tips and Tricks

This section of advanced Excel - Tips and tricks - is not about knowing more excel functions, formulas or features. It is about gaining an in-depth knowledge of the excel features provided. It is also about applying the Microsoft ® excel formulas in a creative way and improve your efficiency in using Excel. It will make Microsoft ® Excel work harder for you without using macro programming / VBA.

In this section, we will not use any technical terms such as Excel charts, Excel pivot table, etc. We will use questions such as this:

Excel Challenge 1

Here is the file for Excel Tips and Tricks Challenge 1 which contains 4,000 records of company name, sales amount and quantity sold. Find out how fast you can copy the average selling price formula (given in cell D2) to all the 4,000 rows.

Can you copy the formula down faster than me? At best, you can be on par with me. Don’t believe me? Try it out and see how long you take. I will let you know how fast I did it once you took the test.

Knowing this tip alone will boost your speed by leaps and bounds, especially if you are always working with a large data list.

Just use your first name and primary email below to get the answer - then click the “I want the Tip” button.