Learning Excel is a series of trial and error. Sometimes it succeeds, most of the time it fails. 🙂
Whenever I learn something new, I will test it again and again in order to make sure I understand the usage. However, if there is no real application in my daily work, I will forget it real soon. Then I realize that it’s not about learning a function or a feature; it’s about to link it to our daily work and turn it into real-life application.
To cite an example, when I first encountered OFFSET, I have no idea at all how I will use it…… until I learned about Dynamic Naming. Since then, OFFSET is one of my favorite functions!
Although most functions can be working stand-alone, the power of nesting functions is just awesome… if you know how.
On my previous post, I talk about the one of the usage of F4. On my next post, I will talk about the 2nd usage of it.
I have also been thinking about the coming topics:
1) Tips for selecting objects (do you want to select objects in Excel as if in PowerPoint?)
2) Tips for using Find and Replace effectively (have your thought about to highlight all cells with strikethrough?” )
3) Tips for Copy and Paste (most of the time, I thought I know something but I wasn’t)
4) Tips for Go to Special
4) Your input… pls let me know if you want to discuss any non-VBA topics in Excel. 😛