From the course: Excel for Accountants
Join today to access over 23,100 courses taught by industry experts.
Using Excel for regressions in audit work - Microsoft Excel Tutorial
From the course: Excel for Accountants
Using Excel for regressions in audit work
- [Instructor] One important practical tool for accountants is regression analysis. Now, people often think about regressions as being primarily an academic tool, but the reality is they're often used in accounting work, especially the audit side of the world. Let's take a look at a couple of examples. So we have here a thought leadership piece from Deloitte titled, "Regression and Outliers." And essentially, this is going through and talking about using standard regressions and the issues that comes up with that, and then how we can address those issues so that you can continue to use regressions for doing things like forecasting your sales and then understanding whether or not there are potential audit risks based on what the forecast from the regression said versus what sales actually were reported to be by the audit client. So we see Deloitte using these. Similarly, here's a podcast with Ernst & Young, and we have a couple of senior leaders from E&Y talking about their big…
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.