• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • Product ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
Techwalla
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Do Excel Formulas

How to Do Excel Formulas

March 31, 2015
By: Lia Stokes
  • Share
  • Share on Facebook

Formulas are an excellent way to maximize your efficiency when working with Excel. Excel has built-in formulas for finance, basic math, statistics, logical expressions and other information. By using Excel to perform your calculations for you, you can save time, increase accuracy and minimize potential human error on your spreadsheet reports. Customizing your own Excel formula is simple; follow the steps outlined below to use formulas in your Excel worksheets. Once you have mastered these steps, you will be able to access the function options in Excel 2007 and make your own formulas.

Video of the Day

...
Headers and data
...
Headers and data

Fill in your data. Your spreadsheet should be clearly labeled to make the information easy to understand and categorize. Include a header row and/or column for labels.

...
Selct the cell

Choose the cell to hold the formula and select it. Click on the cell in your spreadsheet where you want the calculations for the formula to appear.

...
The Function button

Click the Function (fx) button on the formula bar above your Excel sheet. This will open a dialog box to choose the function you wish to use.

...
Select a function

Select the function you want to use. Excel 2007 provides a list of commonly used functions for you to choose from. Or use the search box at the top to narrow your choices.

...
Function arguments

Enter the function arguments, which are the data used to compute the answer to your formula. You can select cells in your spreadsheet by clicking the button to the right of the text box next to the function argument. If you just need to enter a number, type it into the text box. Excel 2007 provides contextual help for all types of function arguments. Click the "OK" button when you are finished.

...
Function syntax

View your function. The Function bar next to the Function button displays the syntax for your function. This is handy if you decide to type the function directly in the future.

Show Comments

Related Articles

Uses of Logarithms in Computers

Uses of Logarithms in Computers

Around The Home
Productivity
By: Anastasia Zoldak
How to Calculate IRR in Excel

How to Calculate IRR in Excel

Around The Home
Productivity
By: Hunter Taylor
How to Count the Number of Characters in Microsoft Excel

How to Count the Number of Characters in Microsoft Excel

Around The Home
Productivity
By: Aaron Parson
How to Convert Excel Formulas to PDF

How to Convert Excel Formulas to PDF

Around The Home
Productivity
By: Marina Martin
Elements of MS Excel

Elements of MS Excel

Around The Home
Productivity
By: Lisa Bass
How to Add Hours and Minutes in Excel

How to Add Hours and Minutes in Excel

Around The Home
Productivity
By: Aaron Parson
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2018 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.