From the course: Working with Computers and Devices

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Create a basic equation

Create a basic equation

From the course: Working with Computers and Devices

Start my 1-month free trial Buy for my team

Create a basic equation

“

- [Instructor] One of the advantages of working with spreadsheet programs like Excel is that they can quickly perform both simple and complex calculations once you've set them up to do so. Here I have a basic spreadsheet that I've been working on to figure out which of two jobs will give me the higher annual income. I've entered the data for the hourly wage of both jobs, as well as the number of hours that are available each week. Now I could get out a calculator and figure out what my annual income for both jobs would be, but it's worth entering the proper formulas into Excel, so if the terms of the hourly wage or hours per week change, I just have to plug in the new numbers to update my totals. So to add a formula to a cell, first select the cell. I'll select the annual income cell for job A, and then click the formulas tab. Next, I'm going to click the arrow below the autosome button, which gives me a list of common…

Contents