Hello again, Steemians !

in steemit •  last month  (edited)


Beige and Blue Illustrative Hello Summer Banner.png
Background Image Source- Canva.com/Location

Greetings!


“ The journey of thousand miles begins with a single step ”
- Lao Tzu

Yes. It’s been a while. First, I’d like to thank @damithudaya for his guidance in helping me restart my journey on Steemit. As well @heriadi for the information provided.


I have been working in the field of finance for over four years. Today, I'd like to write about a skill that has been helping me to succeed in my career.

It’s spreadsheet skill. Many people think that spreadsheets are only important only for those in the finance field. But that’s not the case. They can be used for various tasks across different industires. For example, you can use spreadsheets to monitor student performance in a class or to create a timeline for your projects, and much more. When you hear the word “Spreadsheets” you probably think of MS Excel as many of us first learned it in IT class at school. However, I mostly use Google sheets rather than MS Excel, and I personally prefer it for my work.

I hope you all have some basic knowledge of spreadsheets. If not just Google it. I am sure you will find plenty of resources to learn from. Here is a quick tip to save your time when using Google Sheets.

When adding two numbers together, you might use a separate formula for each cell. For example, if you have 10 rows you’d typically create 10 formulas to add numbers together.

Capture.PNG

But this is where arrays come handy. An array formula will help you to get your expected result with just one formula instead of many.

test.gif

Remember the shortcut key for array formula.

Ctrl + Shift + Enter

It is easy to use the shortcut key instead of always typing it. It also saves time !


So, that’s it for today. Thanks for reading..

I’ll meet you with a new post soon.


username.gif

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!