From the course: Excel for Accountants
Join today to access over 23,100 courses taught by industry experts.
KPIs and Excel - Microsoft Excel Tutorial
From the course: Excel for Accountants
KPIs and Excel
- [Instructor] We've talked a lot about a variety of different tools that are being used by accountants in a variety of different software packages, from QuickBooks to Excel. But what we haven't talked as much about is some of the controllership aspects of working as an accountant. Let's take a look at an example of how we can use accounting tools in Excel to analyze financial statements and understand business performance. I'm in the 05_01 begin Excel file. Now what we have here is a simple set of financial statements for an income statement, a balance sheet, and a statement of cash flows for a business. And we've got this on a five year historical basis as well as projections for the next five years. But what we might want to do is go through and start with identify some what we refer to as KPIs or key performance indicators. Now, KPIs generally fall into a few different categories. We have strategic KPIs that could be used by high level management to understand how the firm is…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.