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:
Convert Text Formatted Numbers to Proper Numbers
Maximizing the use of your Excel toolbars
Improve your efficiency with Excel icons
How to separate the text into two lines in a cell
Remove duplicate records from a list
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.
PRIVACY: We respect your privacy and we hate spam. We will not share your email address with anyone for any reason. You can unsubscribe at any time.
|
