By Starry Gold
“I used to work with a government parastatal as an accountant,
but now it is a whole new experience because I work with a private company and
we deal with a lot of data. The workload was becoming too much
so I was thinking maybe I should quit the job. But I noticed that other
coworkers are finding the job so. I approach my immediate Boss for advice,
so he advise me to go and master the use of Excel.
If not because my in-law was the one who connected me to the new job,
maybe they would have sacked me.
Please Starry Gold , share my story with other Chartered Accountants
so that they can learn from my story.
I master how to use Excel and my work hour has been
reduced drastically, so I have enough extra time for me at work.”
Excel is an incredibly powerful tool for accountants,
and it is a key skill that any budding accountant should try to become familiar with.
If you’re a newly qualified accountant,
an accountancy student or are a business owner who wants a better handle
on their finances, here are some of our top Excel tips for accounting and finance professionals.
WHAT ARE THE EXCEL SKILLS EVERY ACCOUNTANT NEEDS TO KNOW?
• VLOOKUP and HLOOKUP
VLOOKUP and HLOOKUP are two of the most useful Excel functions or accountants and finance professionals. These functions let you search a table of data and give all the appropriate information for an individual set of data based on only one part of it.
For example, if you have details about clients stored in an Excel sheet, you’ll be able to find all of their information in the data by just using one identifier, such as surname or client number.
• REDUCE MISTAKES WITH 0’S
Have you ever found yourself counting the zeroes when encountered with a figure in billions and millions? We certainly have! Don’t worry, Excel function is got your back.
• PASTE OPTIONS THAT COULD PREVENT ERRORS
This is a useful excel skill that everyone needs to know! Have you ever hit ‘paste’ and been left with a sheet full of errors? Try Paste > Special instead! You’ll be able to transpose data, copy data validation and more with paste options.
Let me stop here for now, there are still other functions.
Practicing all these Excel function is the best, you can get sample video training here …..
I will continue in my next article.
WANT PRACTICAL TRAINING OF EXCEL FUNCTIONS?
Call Starry Gold Academy on 08023428420, 07086810335, 08123189141
Or chat with admin on Telegram,
click here to chat https://t.me/starrygoldacademy to get all Practical EXCEL Video Training NOW
P.S: Most time we don’t determine what the labour market demand of us as professionals, but decide to fit in by updating our skill or do nothing and become outdated…… This choice is yours, ACT NOW.
