This course provides valuable spreadsheet skills that can take your corporate career to the next level. In this course, we cover important features from logical tests involving ‘IF’ statements to pivot tables and the new dynamic array functions. We teach you the key Excel features used daily in bookkeeping and to give financial presentations.
This Course Includes How To
- 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
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 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.
Complete This Course & Get Your Certificate!
Certify Your Skills
The Certificate certifies the skills you’ve learned
Stand Out From The Crowd
Add your Certification to your resume and stay ahead of the competition
Advance in Your Career
Share your Certification with potential employers to show off your skills and capabilities.