Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,148,854 members, 7,802,738 topics. Date: Friday, 19 April 2024 at 08:24 PM |
Nairaland Forum / Nairaland / General / Education / EXCEL Skills Every Accountant Need To Know (part 2) (181 Views)
EXCEL Skills Every Accountant Need To Know / EXCEL Skills Every Accountant Need To Know / 8 Skills Every Nigerian Student Needs To Survive In Campus (2) (3) (4)
(1) (Reply)
EXCEL Skills Every Accountant Need To Know (part 2) by starryadmin: 2:01pm On Nov 24, 2021 |
Before I mention the Excel skills that every accountant needs, let me share feedback from part 1 of this article. https://starrygoldacademy.com/successtips/excel-skills-every-accountant-need-to-know/ “I have been a Chartered Accountant for over 3 years, something unbelievable happened in my office recently, there was a vacancy for the post of Chief Accountant. A colleague, Mr. Orioye, and I were top contenders for the job. The company hired an outsourcing firm to conduct the interview for Mr. Orioye and I. The panel started with an Oral interview, then proceed to the use of SAGE 50, Project Management, and Excel. I actually know how to use all these packages but not really very proficient in the use of Excel. After the interview, we were informed that Orioye got the job for the position of Chief Accountant. Later I found out that he was extremely proficient in the use of Excel. I felt the company was unfair with the interview, after all I have spent more years in the company than Mr Orioye. I don’t want to call this my fate, but I want to see it as an act of negligence because I have the practical Video tutorial on Advance excel but didn’t use it. After reading your last article, I just feel like to share my own bitter experience just to save other Charted Accountant from such mistake” So let’s continue on the EXCEL skills every Accountant need to know • PIVOT TABLES Excel for accountants can be challenging, particularly when you’re dealing with huge spreadsheets with many sheets. Pivot tables can help you to make sense of huge sets of data by organizing and summarising selected rows and columns of data to obtain a report on the data you’re interested in. • PIVOT TABLE DIALOGUE BOX IN EXCEL If you’ve ever felt overwhelmed looking at row upon row of numbers, wondering where to even begin, pivot tables are a quick way of getting some much-needed clarity. Pivot tables are invaluable for extracting important information from large data sets. • EXCEL EVALUATE FORMULA FEATURE There’s nothing worse than copying a formula to multiple cells, only to discover it doesn’t work or do what you want it to. Instead, test your formulae by going to Formula and then Evaluate Formula, or by using the shortcut Alt + M + V (Cmd + M + V on Mac). • USEFUL EXCEL MACROS FOR ACCOUNTANTS Macros are a way of automating repetitive tasks, making it a great excel shortcut for accountants. Although they can seem a little intimidating at first, with some practice you’ll master this skill in no time at all. You’ll need to be able to recognize which tasks are suitable for automation and have a good grasp of formulae to be able to make the most of macros. • AUDITING FORMULAS You no longer have to be a calculus whiz to get the most out of Excel formulas. The Formula Auditing toolbar gives you quick and dirty access to an error checking function that works especially well on large and complicated worksheets. Even if you are working with a smaller worksheet, you can still make the process of creating and auditing your formulas speed along much more quickly. Need to upgrade your Excel skill? Get practical Advance EXCEL videos training NOW. Click here to chat with our Admin on Telegram https:///starrygoldacademy OR Call Starry Gold Academy on 08023428420, 07086810335 to get all Practical EXCEL Video Training NOW Our Offline Video Tutorials: ICAN, ATS, CITN, CIS, IFRS, JAMB, WAEC, GCE, NECO, Junior WAEC, SAGE 50, SAGE Evolution, Excel (Basic & Advance), QuickBooks, and others. Starry Gold Academy Number 1 tuition center with the highest exam pass rate at ONE SITTING. http://starrygoldacademy.com 1 Like |
(1) (Reply)
Sumec Firman Educational Ideology / ETH Zurich Excellence Scholarship 2022 For Masters Studies / Master Abroad
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 10 |