From the course: Excel 2019 Essential Training
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Using simple formulas
- [Instructor] For many Excel users writing formulas is one of the most common things they do. Many times formulas are straight forward, simple, easy to use. But, they start with a different concept than what you might be familiar with. In this worksheet here called Formulas, and were in the workbook 03 Creating Formulas and Functions. We're about to put in a formula in cell B4. We want to subtract the two entries there. Now, in once sense we could be saying, we want the cell B4 to be equal to whatever's in B2 minus whatever's in B3. Now, you don't always think it out that way, but you might think, well do we have to type that all in? B4 is equal to? Well, we're at cell B4 so that's implied. Excel formulas begin with the equal sign. Now, I could type in 120 minus 100 and get an answer. but nearly always in Excel, when we refer to numerical information, if it's in the worksheet, we refer to it by cell location. And what we really like to say is, whatever's in B2, so we can do this in…
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.