excel 2007 formulas training basic math in excel 2016 introduction 1 of 4 you math 6 you use formulas to perform mathematical functions on cells there are two basic ways of writing formulas available ranged syntax or simple syntax fred pryor seminars excel formula syntax figure 3 autosum in excel training basic math in excel 2016 using functions 2 of 4 image titled use summation formulas in microsoft excel step 3 excel formulas sum1 screenshot of excel 2016 how to work with math equations in microsoft excel 2010 microsoft office wonderhowto excel functions tab absolute references calculating percent of totals excel formulas basic math microsoft excel the average function image titled type formulas in microsoft excel step 13 2 1 formulas how to use the formulas tab in excel for ipad image titled use summation formulas in microsoft excel step 5 microsoft excel formulas and functions cheat sheet match function in excel image titled use summation formulas in microsoft excel step 1 excel formulas excel math and formula basics perform simple linear regression in excel 2010 you image titled type formulas in microsoft excel step 2 excel graphing math functions it s all in the formula basic statistics functions excel excel simple amortization sheet arithmetic sequence definition image titled type formulas in microsoft excel step 1 copy formula excel function image titled type formulas in microsoft excel step 4 finding square roots cube roots and nth roots in excel using exponents microsoft excel lesson 2 compound interest calculator absolute referencing fill down you mind map sumif countif averageif