Microsoft Excel is the tool of choice for most accountants and financial professionals, and possessing advanced Excel skills can make a real difference to your career prospects. However, many bookkeepers and financial officers lack the fundamental Excel skills required to carry out daily tasks efficiently and accurately. These abilities include the use of logical tests and ‘IF’ statements, lookups and pivot tables.
This course has been designed and developed by an accountant and focuses on the Excel skills used daily in the industry. Some of these skills are basic, such as summing with criteria and using logical tests. However, some are advanced, like the use of dynamic arrays. Each of our topics represents a necessary ability for the job and familiarity with some of the newer features of Excel 365 can put you ahead of the curve.
This short training course provides you with a basic knowledge of Excel and covers logical tests and ‘IF’ statements, lookup formulas, summing with criteria, working with tables, pivot tables and dynamic arrays. We use workbooks and exercises to allow you to practice your new skills, grounding your newfound theoretical knowledge in practical demonstrations. Excel is an industry-standard tool for those working in finance, so sign up to add this popular spreadsheet program to your portfolio.
What You Will Learn In This Free Course
- Solve problems and carry out logica...
- Explain and carry out different typ...
- Calculate ‘SUM’ with multiple crite...
- Explain and demonstrate the benefit...
- Solve problems and carry out logical tests and ‘IF’ statements
- Explain and carry out different types of lookups
- Calculate ‘SUM’ with multiple criteria
- Explain and demonstrate the benefits of working with tables
- Analyze data with pivot tables
View All Learning Outcomes View Less All Alison courses are free to enrol study and complete. To successfully complete this certificate course and become an Alison Graduate, you need to achieve 80% or higher in each course assessment. Once you have completed this certificate course, you have the option to acquire an official certificate, which is a great way to share your achievement with the world.
Your Alison certificate is:
- Ideal for sharing with potential employers
- Great for your CV, professional social media profiles and job applications.
- An indication of your commitment to continuously learn, upskill & achieve high results.
- An incentive for you to continue empowering yourself through lifelong learning.
Alison offers 3 types of certificates for completed certificate courses:
- Digital certificate: a downloadable certificate in PDF format immediately available to you when you complete your purchase.
- certificate: a physical version of your officially branded and security-marked certificate
All certificates are available to purchase through the Alison Shop. For more information on purchasing Alison certificate, please visit our FAQs. If you decide not to purchase your Alison certificate, you can still demonstrate your achievement by sharing your Learner Record or Learner Achievement Verification, both of which are accessible from your Account Settings.