From the course: Excel for Accountants
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Basics of accounting industry - Microsoft Excel Tutorial
From the course: Excel for Accountants
Basics of accounting industry
- [Instructor] Let's talk about two of the most important formulas you need to know when doing accounting work in Excel. This is going to help prepare you for actually using Excel in accounting work as we get started on it. These are the IF formula and the VLOOKUP formula. In particular, when we talk about the IF formula this is really a conditional if, we're essentially testing whether or not a condition is true and then returning results based on that. So for example, when we're using an IF formula, we'll have three major parts to it: The condition that we want to test, what we do if the formula is true or if the condition is true, and what we do if that condition is false. As you see over here on the right-hand side, we might, for instance, be interested in looking at whether or not a particular sale occurred in a particular year. So we would look at whether or not the sale occurred in 2018 or 2019. If it occurred in 2018, we could spit out the sale amount. If the sale did not…
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.