Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Forecasting and Modeling
      • Alteryx
        • Introduction to Alteryx
      • Power BI
        • Power BI – Beyond the Basics
        • Power BI
      • Qlik Sense
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop
      • Python
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Sign Up
Home > Microsoft Excel > The Basics of Formulas and Functions in Excel 2010

The Basics of Formulas and Functions in Excel 2010

Formulas are primarily mathematical equations that can perform calculations. In Excel, a formula always begins with an equal sign (=).

Facebook Linkedin Twitter

Excel calculates each formula from left to right, according to a specific order for each operator in the formula. For multiple operators, Excel evaluates several operators in a defined order when you combine them in a single formula.

1. Negation (as in -1)
2. Percent (%)
3. Exponentiation (^)
4. Multiplication and Division (* and /)
5. Addition and Subtraction (+ and –)

For example, =5+2*2 returns 9, while =5*2+2 returns 12.

Since multiplication comes before addition in the order, the formula =5+2*2 returns 9 because 2*2 is multiplied first before it is added to 5. The product of 2*2 is 4; therefore 5+4=9.

In the second formula, =5*2+2 returns 12 because 5*2 is multiplied first before it is added to 2. The product of 5*2, which is 10, is then added to 2 resulting to 12.

Users can control the order of evaluation by using brackets. Values within brackets are evaluated first by Excel. In the case of multiple brackets, they are evaluated by Excel working from left to right. For example:

=(5+2)*2 returns 14 because 5+2 = 7, therefore 7*2 = 14.
=5*(2+2) returns 20 because 2+2=4, therefore 5*4=20.


MS Office 2010 training tutorial course

One powerful feature of Excel is that it allows us to substitute Cell References in formulas. So if we assume that A1 contains a 5, then = (A1+2)*2 returns 14. Excel also lets us name Cells and uses the name in formulas. If we assume A1 contains a 5 and is named Start, then =Start*(2+2) returns 20. To do this:

1. Type the value 5 in cell A1 and the name Start in B1.
2. Select the cells containing the value and the name.
3. On the Formulas tab, click Create Names from Selection.

4. In this case, since the name is to the right of the value, we are going to create names from values in the Right column. Click OK.
5. Select a cell where you would want the answer to appear; let’s choose C1. In the formula bar, type the formula =Start*(2+2). Press Enter. Notice we get the answer of 20 because the name Start now has the value of 5.

Functions are predefined formulas that perform calculations by using specific values in a particular order, or structure. These specific values are called arguments.

Function Structure always begins with an equal sign (=), followed by the function name, an opening parenthesis, the arguments for the function separated by commas, and a closing parenthesis. Remember that for every opening parenthesis, there should be a closing parenthesis for the structure to be in balance.

Excel holds an extensive library of functions that can be used to perform simple or complex calculations. This capability makes it easier to use functions correctly. You can find the list of the available functions on the Formulas tab where they are listed by category.

Another method of locating a function is by using the Insert Function dialog box. You can access it by clicking on the Insert Function button found on the Formulas tab of the Ribbon.

If you already know which functions you need to use in your formula, you may also directly type them in where necessary other than using the Ribbon or Insert function dialog box to look for the function.


Excel 2010 training tutorials
Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

30 day vertical banner

Most Popular Posts

  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15
  • How to Create Charts and Graphs in Microsoft Excel 2016

START LEARNING The Basics of Formulas and Functions in Excel 2010 ON SIMONSEZIT.COM

START MY MEMBERSHIP

Similar Posts

What’s New in Windows 11 – Recorded Webinar

Reconciling Credit Card and Making Payments in QuickBooks 2019

How to Make a Flowchart in PowerPoint? 2 Easy Methods

How to Setup and Track Sales Tax in QuickBooks 2018

How to Update Your Company Information In QuickBooks 2019

How to Setup Payroll Items in QuickBooks 2018

Course Categories

  • Web Development
  • QuickBooks
  • Microsoft
  • Adobe
  • Data Analysis

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebook
© 2022 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)