Discover millions of ebooks, audiobooks, and so much more with a free trial

Only $11.99/month after trial. Cancel anytime.

Excel Formulas & Functions For Dummies
Excel Formulas & Functions For Dummies
Excel Formulas & Functions For Dummies
Ebook671 pages5 hours

Excel Formulas & Functions For Dummies

Rating: 0 out of 5 stars

()

Read preview

About this ebook

Put the power of Excel functions to work in your formulas

There are more than 400 built-in functions in Excel 2019, from AGGREGATE to Z.TEST. The question is which ones will make your work easier? How and why should you use a particular function in your formulas? Excel Formulas and Functions For Dummies offers thorough but easy-to-read coverage of powerful Excel functions.

With this book, you’ll learn to apply the power of Excel functions and formulas to make your work and other tasks easier. Compare 15-year vs. 30-year mortgage terms, choose between leasing or buying a car, compute classroom grades, create an amortization table, evaluate investment performance, calculate the real cost of credit card purchases, or forecast college expenses and savings. All of this and more is possible when you master functions and formulas in Excel. Although it covers the latest software version, Excel 2019, the techniques and functions described in this book can be used on any version of Excel. 

  • Step-by-step instruction on Excel's 150 most useful functions
  • Each function is illustrated by helpful, real-world examples
  • 85 specialized functions are described in abbreviated form
  • Includes Excel’s must-know functions

This book is a must-read for beginning to intermediate Excel users who want to find out how to use Excel’s powerful built-in functions.

LanguageEnglish
PublisherWiley
Release dateOct 26, 2018
ISBN9781119518266
Excel Formulas & Functions For Dummies
Author

Ken Bluttman

Ken Bluttman is the author of numerous computer books and articles. He recently wrote O'Reilly's "Access Hacks" as well as "Excel Charts for Dummies". Ken's technical chops include Microsoft Office, XML, VBA, VB.NET, SQL Server, and assorted web technologies.

Related to Excel Formulas & Functions For Dummies

Related ebooks

Enterprise Applications For You

View More

Related articles

Reviews for Excel Formulas & Functions For Dummies

Rating: 0 out of 5 stars
0 ratings

0 ratings0 reviews

What did you think?

Tap to rate

Review must be at least 10 words

    Book preview

    Excel Formulas & Functions For Dummies - Ken Bluttman

    2Hdbook_preview_excerpt.html]vȕxd"PdҭeIjV=O?"P4)13?0/ϥVg%H.ϥJ̟|M5u5IWU͟oG]}2[];k3l<+lMv]Ӭ,,ڢm;< 0( MUO߸*mvЮ&̵ٝˢe]&wtSlZ?vey8qMMG5bCВFٚɚuQ6mE:&y8jΚz?)>%;ج#ݴd"òtźlɪt]e0-,GhK42"o :m{: PW<^mG\,O\MK_MԬ=^2 WҌ _uČ֕Dy~-*b -l3ʖM3 k'seI#ɪ툙/}m ote[Z6:kߖt0 b x^'>Cܸ^uuU]: ,< <-Hƕ#aAw<-vvQw }*߃aj1&4j2Ǭm3&/fA w~C%>IISy1LTf3h' [,IW V쓼38w7Z4+DӼȡHy} +{%y:wYsĸBd1A6!04-BUfّI i ġ]J.f9I9ꎲ UAT$hnWBUQv$Sb Q|0^GL[,H9*7]Q\Aڎ ҫ@T+&,ޣVNEUDÂɑLZ]Ɨ!x90#QH%en㋚%|X #Kl}sZ}V4Yȴ2SJ>%˹#*Vtq(UxWҢKrhǤj5'_VЌY.9 p9!*I>QJ*vxIvhyۮKyo-཮^2W]R&rkrQ #=Wy!)`O$k BEY=U|A"Qmmk2iC+hy%YΕ/f*k_n{qm|+;$wi+,;5,!<x˹[H[;Sge҂dUcQ!T$f*2(;cu-lc[9cu%d&,!@NZaj,{{RϫSQA2(MUwp`#q&MA67 4g)Od$+ JS.mfVMci5LJ͝!:{9-ayy1KVn4XL ;KZDw*"ihF9}U0lQeE1&4;dL*em@^БvkkQcؔȚ%lo/+qDKV[la:7Z sIʑW~h$:-&ѬxdЁF#wJ @xަ]ދ47aۣT5@ \̜GlM7;s!]=lCX-#"X`'phd-ylu]W'ʖ6av5f P9T ̝WTIN|)8!xPC ֖u=,jM؛>j7q !nׇ_ Hɀİa fu6_֭&w>lJ#?x0'װ8gDeB$9:hk a_v84C&6"%!?0NRuN) q][~2S#vA"1"L8 Dh95:K8tfl.EuJ0pȻ3fxUzwۻ(C0mqcZR7SQāB2C7a;c$ Qw&O2催~QDh/D'6øYM !mGT"`v$@/aLiTb,[ H1+vkaF3@W%dBdlBRUp~5¨ÐP^= $鈳w]|&\FLo{E1'&K-"^4{(M-eCSLK~݂5 !UtBFy(oRs=rH0k9D:++A~%`MS7iYAAhJuKN]W4˄FfH񅁌旯^}fŊ !ÑUS>$rn0'1z>rk`t4_RpK Y0{5;>,JB_ZA>y &dˢCwU9i85:u[ QJ O^N^|=ף! dqٴ[{'|犜'O/8"t_JV~5s0`!hx^_ K QwK~Z 70{?rx"ҡע[\-'wE(>Z`Y6kW JXisvy㒇TWRCp˲n[ NcrY#"h@tǶcL#kqNPǥ4%},p r£YIlX:!Ͼed_ bg$GCg$*i6هg©`&4x̬M=Ž^:JtZޙ"`sC# {dxَWI;IfRJ$^f lijADSKr E*kII5?&GzxqF"[qȉq1HV?IK(9M4xsd`F!jHD̼BPE2 2rokVk(0mRAlqk$ߎ e] ~7,̈$kja7Es@e\ʋ BwHK^{0%V1SC1&e[K/o5e H-0`kU#kEG*3`4TqÙ41잨%uBx\pr2(Κ 4H%lS/W%rVPCҙ4q1-Y9V?uKﯕ&1LbZF meMNϱJ@Ts7#^ebk$+K9GZj%C{pӎz53?#5x>R@lb!.J&y6 tQYA[˒ QQ%ɼ/ *3.]uO]cƋAOz w[Xb( 5;q&kD/,JΡaޓLL4VuO|wQ[d:/@36Pì*cWPBtST$''rD8B/rE5b$l>7d&s~0-/Zb[y)B&0G).i迁4&DE%\;l}G@2R%DrTtHnrr4\HŰ4H~(w̃Zhs s39@8<şO**ba Ʉ3V N6`khy"q8iZuFuiX1Aa|,m.|5F4XdL?/ߺn우$) %6~ o!W!BXv‚y# TDHb$;K-iVPF),bIM,Q3 >;afOԉ̇suk} o_\vPFybV=IisZTXuib^j'|@eoh`:qWBܭ# @Dfu磤8IJdcȨ\gΥTh܊4l/@pU3íC`5w!/^JY[F؎<]zF^!<~qJP5b<L$O5&S,-GŨ^me U<2p&E):`y-E`USk 6e@= O5[t}}ʎѮBᷫ0)9"gDl6lkHC*Cn?"6'E{, uvBǾG>x 4WÃu'UJLLdGapKm [U%3W*D9ReZ|+Ú~̈́"Ћob"YގZ1Te(: `ΒF̬_pX{)IcT54{ӂ6X ں! >F"R[K֜cdnyu/:wmM5D?W Id~uA2QQWAc(2r{ k139ayk4 #vqeQw6u, ;hM>'m䘮S@(IC1#Yp~ذ Y6k锩7)p]B]Pf_ k6z$:obN&4V-g(qfJ-" >i7J5A, f >Koq/Sb璕(^-6MؤU'$R6}'ף4HtRT3J򎠎u.ʘ6I: Ʌj7\KI7c 8*=ggYC*;x;,KrqMja[NCǛbܸq\M?R\*l<_ujM0olFhy 8ܣ9x7;KA[YB TkΘS_ >W7 XXlgVh2竜C`O: pkZaO7FUaNGc4L zDG?XކJЇ{=f]'C/fwP7ю5zb(hk%!k1AbR9 z$ fۺ[AW TH7 5R(]2&cQ+SX4^r Wn*IvzfK̲$> y+WXFR耀Ү"g–`w|6^E֋}PF6XQvɉAĴ:繒k&z ܱF )*j}qWfdDԪ"s\2&`:]\C뒋7*c'kF8V>NВ^&L;w|B'h j*g,QBoɌ&8jݹL i໐"7#9 [Q#wVÚ=|!UM<$Wn|*QAX?2սb KT1Gf# lP}5POrţeo L>aCYEab)ou9g4]h/}K "H 6}¢ y6=!WJ+Ӊ6 ڎƊ0h]Wа_i 9no߾ne}Sv*{Ïߜg 2C[8^*Ѕ;MIS/_VəlzmNa k(#|Y܋" "c,!<]y^+-lWKs4crMrph$c Yhi.sW$[9!q|4O .:L>/MdM0Er*R#/D6 2k e(9VXR摥%-s̄#љF"rQX%CQ',wLg.O>ʭ1Pat {M*pQ{Q͝VSCP<;TVp1LN$:;JM#$gJ۷BX}5TGtiW9ZtC23!o|мAgh;C7H;KcQEXh qY蟶3N,ώ[5 Tu"Ymܒ-3 2Ur3<9ɝuP}ۮU# ',aa%s1kݚ_%Al6UDnqM~د<,ޮ׏2H~Owg8&ZVܘ-39Gm;C%)2 s+lq,mѨGçOvw 0JZR*$ze~]cCU,1v]X`ONafy=> /\_eo޽_/?pv?xs~sV?iePv*L-&XR IvG!`8mΤ Mvk;rœ 0KSp}(28 gghkRE2!?Q j,Iھ yAz3`qK>**L&z\g{Y$u \6 i(sX$,.hH2c$mYlYLU8#.Z#QFdg܂7PniH+Sh,vjteǟ\@Yl_am0<$i^ ˤ/D dpWB}8s7E{ >d"s^N l& >rM$$Sz= vqXSYUd ZʊzXTX{4mYr?Zȗ(Tz.HB/Bs2!97mEI/I-R!dҚnL5&E|Z}-:5Mc~~l:$2IV2,:ߤY]DzU;h}%ZqJU K7›,wNɢ7 R'ymt˱үס0H%^L *&vAXGxS}fNXu~%{ߝ?O'ࣸ_K{UͤI(3laz >.FŚIT3hzmB=% F7z=rc2Œ:0[q}Ab0X18yÁS դ~urGdA;iKp.C2l,)Gާ+NrHW6v;]2}G%*&􅬪x1%S2Q2|3(ɡz*c ƞlǑd)頢g1PջzK˜ 1@ R:` >c$c+^ǿoƮ!6u*E+3>yuQk~IYv+m]4ҵ.0bߺ|KICWv2ZءJAs<t-PH }]8mw?O'⻒$l.tuu5cqN^:z_:=~g̗kaD;U gA7pyI:fp zZ =t2`BFE;rZ<\^ ö搔|+dc{$q,8\%iڅ8\E]1<ĩg֦I d'8m 2ғ S8 ,ɓ{+xIKyݶI;M{vnNWy-NkQkZr߼E`J6A/iLO/f[GŌɟ>ފII>)߷u+m]z= v>i)ٴ[O8VH`&h'i׊P n{}5p_mHG"r8Gt.X8fF*ɕSwd.pВwdv$ u+6. M*\ґd{6PjvľwxHxRL.}dw1G.;)boC~sEmgZb8nV{,-ҵn*=B6F)?4zY\~D}*=2`̑Tjpr |\lb Z<;;% )^JQ\.7s[J&Lft7$}ǕsÎ!,6E噙8,_m}.Vw^ZzWȒJJ@w4;vb`:-TPJ9R-'ONѱ#w@D>yJ-`ݶ}2[Eg]jT <߷4rQ@۪q5)HK~RslwKUB&;VUd޳ ɦT)'BkK(.gSB 4;H";=',Y|ǷϒdUN | :=l>=ˮZ8Dێ)};|߸?T
    Enjoying the preview?
    Page 1 of 1