In Part 2 of this 4 part series, you will learn the essential knowledge that every accounting and finance professional should understand to work effectively and productively in Excel.
Different excel formulas and functions (Lookup, Logical, Statistical, Text, Math, and Information) can be used together to solve challenging tasks that accounting and finance professionals perform frequently. Add Excel’s new Dynamic Arrays available in Microsoft 365 and new capabilities – that professionals have never had before – are now available.
After completing this course, you will be able to:
Microsoft Excel is a ubiquitous tool in accounting and finance, and developing your Excel and data analysis skills is a simple way to keep your skills relevant in the data driven world we now live in. This course is Part 2 of the 4-part series of how accounting and finance professionals can accelerate their Excel skills and more effectively perform data analysis with Excel.
There are an overwhelming number of functions available in Excel, and being aware of the most frequently used functions for accounting and finance professionals and how to apply them will greatly enhance Excel effectiveness.
You will learn how to
All accounting and finance professionals, whether a new professional getting started or a seasoned professional looking to stay current and build on existing Excel capabilities and use in the profession, will benefit from this course.
Experience using functions and formulas in Excel is helpful.