SECRETS OF BUSINESS MATHEMATICS USING EXCEL www.wiseexcel.com Table of Contents INTRODUCTION CHAPTER 1 BASIC STATISTICS CHAPTER 2 EXTRACTING INTEGERS AND FRACTIONS IN MICROSOFT EXCEL CHAPTER 3 CALCULATING PROBABILITIES USING EXCEL CHAPTER 4 CALCULATING PERCENTAGE USING EXCEL CHAPTER 5 CREATING A PAYROLL SPREADSHEET CHAPTER 6 HOW TO MODEL PAYROLL COST IN MS EXCEL CHAPTER 7 HOW TO CALCULATE YIELD USING EXCEL CHAPTER 8 HOW TO CALCULATE DEPRECIATION USING EXCEL CHAPTER 9 HOW TO CREATE INCOME STATEMENTS IN EXCEL CHAPTER 10 ADVANCED MATH FUNCTIONS
INTRODUCTION
Buin mathematics is defined as mthmti utilizd by buin undrtking t record nd vr buin rtin. Buin associations utiliz mthmti in bkking, stock dminitrtin, marketing, dl timting, and budgtr invtigtin. Mthmti commonly utilizd a rt f buin incorporates rudimentary number juggling, basic vribl based mth, ttiti nd rbbilit. Buin dminitrtin huld b ibl ll th more adequately nw and again by utiliztin f further dvld mathematics, for xml, lulu, framework variable based mth nd linr rgrmming. Put essentially, Buin Mth mng Money. Wh n't rfit by hving a urir comprehension f h nd fund? Everybody n! Business mth i for the person wh needs to mltl mrhnd vrthing about individul fund and it i dditinll for th business individul who nd to find out about buin.
You can't tk business without tking math; buin nd mth go n inrbl unit. Some energetic business mth lovers will lt u knw, whthr u don't take m other mth or in th vnt tht you dn't care fr mth, dit vrthing u rquir buin math nd in light f th ft that it manages h, u m vr wll lik it. Everybody nd t vr h in m capacity whih i the thing tht mk buin mth ritil fr vrbd t take. Thi bk i intndd to afford rdr th hn t th mathematical nd rdht titud most ntil to meet the requests f the present business wrld. This bk ln t elucidate mth id utilizing the elements f Microsoft Excel. The bk' rnbl r, nibl rfil and highlight nbl readers to gt dfinit nwr nd linl observe th reasonableness of wht th'r rlizing.
Rdr will figur out how t ace th elements of the Exl while rfining their bnrml state mth iti and different abilities tht will enable them to rvil in the ntmrr work environment. The vr ntibl highlight of a spreadsheet rgrm, fr xml, Exl i that it nbl u t make mathematical frmul and xut iti. El, it in't ubtntill mr thn an xniv tbl hwing ntnt. Yur rdht nditin will turn int a dnmi nd responsive workplace when you utiliz frmul and iti; th naturally refresh whn u hng your infrmtin. The accompanying ught t b considered whil making a spreadsheet: Whih terms are dt/numbr that u will t? What terms r dt/numbr tht you will ascertain frm th infrmtin? Which numbr r constant and r t b utilizd as a rt of an rtmnt f counts? What game ln f the lumn and rw will mk it most straightforward for u nd your target gru t work with the rdht? Formulas and Funtin The ability t perform calculations is one f th ur f uing a rdht litin. Some examples of th t f lultin that n b done r: Totals Subttl Average Standard deviation In Exl,th lultin n be ifid uing ithr a frmul r a funtin.
Frmul r lf-dfind intrutin fr executing calculations.In ntrt, funtin r r-dfind frmul tht r intlld with Excel.In ithr case, ll frmul nd funtin r ntrd in a ll and must bgin with n qul ign =. Entering Frmul Aftr th equal ign, a frmul inlud th ddr f th ll whose values will be manipulated with appropriate rnd ld in between. The rnd r the tndrd rithmti rt Basic Math Functions Frmul Bi Bfr w gt trtd, let's look t hw to u n frmul in Mirft Excel. Whthr u'r wrking with the mth frmul in this book or n thr, th tips will hl u master Excel. 1. Eh Formula in Exl Strt with "=" T t a frmul, lik n n ll in Mirft Excel nd t the equals ign n ur kbrd.
Thi trt a frmul. Evr bi Excel frmul trt with th qul sign, nd thn th formula itlf. Aftr the equals ign, u n ut an incredible vrit f things int th cell. Try typing =4+4 ur very firt frmul, nd r ntr t rturn th result. Exl will output 8, but the frmul is till a peripheral aspect of th rdht. 2.
Frmul r hwn in Exl' Frmul Br Whn u'r ting a formula int a ll, u n the rult f the ll n you press enter. But when you lt a ll, u can see th frmul fr that cell in th frmul bar. Clik n a ll in Exl t hw th frmul in it, such th multilitin formula that vlut to 125. T u th example frm above, th ll will show "8, but when w lik n that ll, th frmul bar will hw that th ll is dding 4 nd 4. 3. Hw t Build a Frmul In th xml bv, w typed a simple dditin formula to dd tw numbr.
But, u dn't have t t numbr; u n l rfrn thr ll. Excel i a grid f ll, with the lumn running left to right; each ignd a letter, whil the rows r numbrd. Eh ll i n intersection f a rw nd a lumn. The cell whr lumn A nd row 3 intersect is lld A3, for example. Exl frmul can be writtn t u th values in multiple cells, such multiling A1 nd B1 t get th vlu in C1, whih is 125. Fr example, we have two cells with simple numbr, like 3 nd 6, nd they are in ll A2 and A3.
When w t a frmul, w n start th frmul with "=" as lw. Then, w n t: =A2+A3 to dd those tw numbr together. It's very mmn t hv a ht with vlu, nd thn a separate ht whr calculations r performed. Keep all f th tips in mind whil working with this bk. For each f th frmul, you n rfrn ll, r dirtl t numerical vlu int the frmul. If u nd t hng a formula tht you've lrd td, dubl lik n th cell.
Yu'll b bl t adjust the vlu in th frmul. Arithmti in Excel Nw we'll vr Exl math frmul nd walk thrugh hw t u thm. Let's trt ff b xlring th bi arithmetic formula. These r th fundtin of math rtin. 1. Add nd Subtrt Additin and ubtrtin are tw ntil mth frmul in Excel.
Whthr u'r dding u ur list of business xn for th mnth r blning ur hkbk digitll, the dditin and ubtrtin operators r incredibly uful. U th tb titled "Add nd Subtract" in th wrkbk fr practice. Add Values Example: =96+192 r, reference vlu in cells with: =A2+A3 Adding values in Exl i typing tw numbr nd a "+" ign, or adding two ll references. Subtract Values Exml: =150-75-20 or, rfrn vlu in ll with: =A3-A2 Subtrt tw vlu in Excel b typing numbr dirtl in a box, rtd with "-" sign, r rfrn tw ll with the "-" sign between thm. 2. Multilitin T multiply values, u the * operator.
U multilitin intd of dding th m item over nd vr. Example: =6*8 r, rfrn vlu in ll with: =A2*A3 Multilitin in Excel u th * symbol btwn tw vlu r ll rfrn. 3. Division Division i hlful whn splitting itm into groups, for example. U th "/" rtr to divid numbr or th vlu in ll in ur spreadsheet.
CHAPTER 1
BASIC STATISTICS
Now tht u knw th basic math operators, lt' mv nt mthing more advanced.
CHAPTER 1
BASIC STATISTICS
Now tht u knw th basic math operators, lt' mv nt mthing more advanced.
Bi ttiti r hlful t rviw a set of dt nd to mk infrmd judgmnt about it. Lt' vr vrl ulr, iml ttiti formulas. 1. Avrg T u an vrg frmul in Exl, n ur frmul with =AVERAGE( nd thn inut ur vlu. Srt h numbr with a comma. =AVERAGE(1,3,5,7,10) Th bt way t calculate n vrg is t input your vlu into separate cells in a single lumn. =AVERAGE(A2:A5) U th =AVERAGE formula t average a lit f vlu rtd b mm, or a t f cells as the bttm xml shows. 2. 2.
Mdin Th mdin f a dt t is the value tht' in th middl. If u tk th numril vlu and rdrd them frm mllt to largest, th median wuld b mk db in the middl f tht lit. =MEDIAN(1,3,5,7,10) This bk rmmnd ting ur vlu into a list f cells, nd thn uing th mdin frmul vr a lit of ll with values td in thm. =MEDIAN(A2:A5) U th =MEDIAN frmul t find th middl value in a lit f vlu when u rt thm with mm, or u th frmul n a lit f ll with vlu in them. 3. Min If u have a t of dt nd want t k ur n the mllt vlu, th MIN formula in Exl is uful.
You n use th MIN frmul with a lit of numbers, rtd b mm, t find th lwt vlu in a set. Thi i vr useful whn working with lrg datasets. =MIN(1,3,5,7,9) You might want t find the minimum vlu in a lit of dt, which i ttll possible with a frmul such : =MIN(A1:E1) U th Exl MIN formula with a list f vlu rtd by commas, r with a rng f cells t monitor the lowest vlu in th set. 4. Max Th MAX formula in Excel is th lr opposite f MIN; it tll u which vlu in a set is th lrgt.
Next page