Excel Topics Preview

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. 😛


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in General. Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.