TOP TEN TIPS: EXCEL FOR ACCOUNTANTS (INTERMEDIATE)
The Excel for Accountants (Intermediate) course is a short course consisting of 10 video-led modules. The course is primarily aimed at accounting professionals. It aims to teach ten important topics that will assist finance staff with daily Excel tasks.
Excel is an incredibly powerful tool for accountants, and it is a key skill that any accountant or accountancy professional should try to become familiar with. For financial insight and analysis, crunching numbers and compiling non-numerical data, Excel continues to be the tool of choice throughout the accounting and finance field.
Improving your Excel skills is a great accounting career move. With a large range of functionality it’s easy to get overwhelmed, particularly when you are just starting out. Master the basics of Excel and build a solid foundation in which to build further skills.
WHO'S IT FOR?
PC or Mac with a full version of Microsoft Excel (any version from 2003 to 2013 or Microsoft 365).
Not a requirement but a benefit to have some work-related projects to which you can readily apply what you learn.
Accounting professionals and finance staff who are looking to build on their existing Excel skills
Incorporate logical operators into formulas
Create a Loan Amortization table using the PMT function
MPerform more complex lookups using INDEX and MATCH
Automate common tasks using Macros
ABOUT THE AUTHOR
Deborah Ashby is an IT Trainer and has been in the IT Industry for 22 years during which time she has provided a wide range of training services to professionals of all levels. Deborah has worked across various sectors such as the travel, property investment and legal. Her expertise lies in all the main Microsoft applications and she's been running hands-on classroom training sessions, webinars, seminars and workshops for 10 years. She is able to take complex subjects and communicate them clearly and concisely and sometimes even 'make technology fun' for a wide range of mixed ability learners.
Deborah holds a MOS (Microsoft Office Specialist) Master Certification and five TAP (Trainer Assessment Program) Certifications. She is COLF Certified and a Member of the British Institute of Learning and Development.
"Learning and development had not been created as a continuous activity. Training was often one off interventions with the impact difficult to measure. Filtered has helped us change that in a short period of time. The cultural change it has driven in terms of reinforcing an expectation of continuous learning at all levels is the biggest achievement to me."
"We partnered with Filtered because we liked the idea of learners being able to tailor resources based on their knowledge gaps. The quality of reporting data provided allowed us to calculate an ROI of £1.80 for every £1 invested in a licence."