Excel for Accountants
In today’s world, for any accountant, present anywhere in the world, his task revolves around number crunching. To perform his task better, they should definitely be adept enough to work on Excel, so they can perform the required analysis of statements and financial data provided to them to work upon. However even though Excel remains the most powerful tool for accountants to work upon, most accountants have accepted to not receiving any formal training of Excel. Thus, they are compelled to use more time-consuming processes to complete their duties and their responsibilities.
ABOUT THE COURSE
This course designed by SkillAcademee in close guidance with industry experts, contains innumerable Excel tips and techniques that aims to make the accountant’s job easier.
All that is required to excel in the same is the knack to learn and innovate and keep yourself up to date with the changing trends of the industry.
The focus of the course is to improve the output and competence of accountants and Certified Professionals Accountants, by exposing them to numerous higher functions, tools and techniques offered in Excel.
This course is ideal for accountants who desire to learn to use Excel more efficiently and effectively. The perfect candidate for this program are accountants, who lack formal Excel training, regardless of their seniority in the professional world.
- Learn about the most complex Excel functions and their applications
- Learn the best practices used in Excel globally
- Create complete models using Excel that are easy to implement and interpret
- Opportunity to improve the presentation skills by improving the numerical aspect of presentation
- Understand the intrinsic business dynamics by performing and learning to interpret using the ‘what if’ function and performing sensitivity analysis.
Being adept with various aspects of Microsoft Excel (preferably Excel 2007 or 2010) is a prerequisite for this program.
- Lectures 15
- Quizzes 0
- Duration 20 hours
- Skill level All levels
- Language English
- Students 496
- Certificate Yes
- Assessments Self
PART 1: Learning to work with Databases
- Lecture 1.1 Locked
- Lecture 1.2 Locked
- Lecture 1.3 Locked
- Lecture 1.4 Locked
PART 2: Macros and VBA
- Lecture 2.1 Locked
- Lecture 2.2 Locked
- Lecture 2.3 Locked
- Lecture 2.4 Locked
PART 3: Recording of Financial Statements on Excel
- Lecture 3.1 Locked
- Lecture 3.2 Locked
- Lecture 3.3 Locked
PART 4: Building and interpreting scenarios, Models and conducting the ‘what-if’ analysis
- Lecture 4.1 Locked
- Lecture 4.2 Locked
- Lecture 4.3 Locked
- Lecture 4.4 Locked