Lýsing:
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.
Annað
- Höfundur: Ken Bluttman
- Útgáfa:5
- Útgáfudagur: 26-10-2018
- Hægt að prenta út 10 bls.
- Hægt að afrita 2 bls.
- Format:ePub
- ISBN 13: 9781119518266
- Print ISBN: 9781119518259
- ISBN 10: 1119518261
Efnisyfirlit
- Cover
- Introduction
- About This Book
- Foolish Assumptions
- How to Use This Book
- Icons Used in This Book
- Where to Go from Here
- Part 1: Getting Started with Formulas and Functions
- Chapter 1: Tapping Into Formula and Function Fundamentals
- Working with Excel Fundamentals
- Gaining the Upper Hand on Formulas
- Using Functions in Formulas
- Chapter 2: Saving Time with Function Tools
- Getting Familiar with the Insert Function Dialog Box
- Finding the Correct Function
- Entering Functions Using the Insert Function Dialog Box
- Directly Entering Formulas and Functions
- Chapter 3: Saying “Array!” for Formulas and Functions
- Discovering Arrays
- Using Arrays in Formulas
- Working with Functions That Return Arrays
- Chapter 4: Fixing Formula Boo-Boos
- Catching Errors As You Enter Them
- Auditing Formulas
- Watching the Watch Window
- Evaluating and Checking Errors
- Making an Error Behave the Way You Want
- Chapter 1: Tapping Into Formula and Function Fundamentals
- Chapter 5: Calculating Loan Payments and Interest Rates
- Understanding How Excel Handles Money
- Figuring Loan Calculations
- Chapter 6: Appreciating What You’ll Get, Depreciating What You’ve Got
- Looking into the Future
- Depreciating the Finer Things in Life
- Measuring Your Internals
- Chapter 7: Using Basic Math Functions
- Adding It All Together with the SUM Function
- Rounding Out Your Knowledge
- Leaving All Decimals Behind with INT
- Leaving Some Decimals Behind with TRUNC
- Looking for a Sign
- Ignoring Signs
- Chapter 8: Advancing Your Math
- Using PI to Calculate Circumference and Diameter
- Generating and Using Random Numbers
- Ordering Items
- Combining
- Raising Numbers to New Heights
- Multiplying Multiple Numbers
- Using What Remains with the MOD Function
- Summing Things Up
- Getting an Angle on Trigonometry
- Chapter 9: Throwing Statistics a Curve
- Getting Stuck in the Middle with AVERAGE, MEDIAN, and MODE
- Deviating from the Middle
- Analyzing Data with Percentiles and Bins
- Going for the Count
- Chapter 10: Using Significance Tests
- Testing to the T
- Comparing Results with an Estimate
- Chapter 11: Rolling the Dice on Predictions and Probability
- Modeling
- Getting It Straight: Using SLOPE and INTERCEPT to Describe Linear Data
- What’s Ahead: Using FORECAST, TREND, and GROWTH to Make Predictions
- Using NORM.DIST and POISSON.DIST to Determine Probabilities
- Chapter 12: Dressing Up for Date Functions
- Understanding How Excel Handles Dates
- Formatting Dates
- Making a Date with DATE
- Breaking a Date with DAY, MONTH, and YEAR
- Converting a Date from Text
- Finding Out What TODAY Is
- Determining the Day of the Week
- Working with Workdays
- Calculating Time Between Two Dates with the DATEDIF Function
- Chapter 13: Keeping Well-Timed Functions
- Understanding How Excel Handles Time
- Formatting Time
- Keeping TIME
- Converting Text to Time with TIMEVALUE
- Deconstructing Time with HOUR, MINUTE, and SECOND
- Finding the Time NOW
- Calculating Elapsed Time Over Days
- Chapter 14: Using Lookup, Logical, and Reference Functions
- Testing on One Condition
- Choosing the Right Value
- Let’s Be Logical
- Finding Where the Data Is
- Looking It Up
- Chapter 15: Digging Up the Facts
- Getting Informed with the CELL Function
- Getting Information About Excel and Your Computer System
- Finding What IS and What IS Not
- Getting to Know Your Type
- Chapter 16: Writing Home About Text Functions
- Breaking Apart Text
- Putting Text Together with CONCATENATE
- Changing Text
- Comparing, Finding, and Measuring Text
- Chapter 17: Playing Records with Database Functions
- Putting Your Data into a Database Structure
- Working with Database Functions
- Fine-Tuning Criteria with AND and OR
- Adding Only What Matters with DSUM
- Going for the Middle with DAVERAGE
- Counting Only What Matters with DCOUNT
- Finding Highest and Lowest with DMIN and DMAX
- Finding Duplicate Values with DGET
- Being Productive with DPRODUCT
- Chapter 18: Ten Tips for Working with Formulas
- Master Operator Precedence
- Display Formulas
- Fix Formulas
- Use Absolute References
- Turn Calc On/Turn Calc Off
- Use Named Areas
- Use Formula Auditing
- Use Conditional Formatting
- Use Data Validation
- Create Your Own Functions
- Chapter 19: Ten Functions You Really Should Know
- SUM
- AVERAGE
- COUNT
- INT and ROUND
- IF
- NOW and TODAY
- HLOOKUP and VLOOKUP
- ISNUMBER
- MIN and MAX
- SUMIF and COUNTIF
- Chapter 20: Ten Really Cool Functions
- Work with Hexadecimal, Octal, Decimal, and Binary Numbers
- Convert Units of Measurement
- Find the Greatest Common Divisor and the Least Common Multiple
- Easily Generate a Random Number
- Convert to Roman Numerals
- Factor in a Factorial
- Determine Part of a Year with YEARFRAC
- Find the Data TYPE
- Find the LENgth of Your Text
- Just in CASE
UM RAFBÆKUR Á HEIMKAUP.IS
Bókahillan þín er þitt svæði og þar eru bækurnar þínar geymdar. Þú kemst í bókahilluna þína hvar og hvenær sem er í tölvu eða snjalltæki. Einfalt og þægilegt!Rafbók til eignar
Rafbók til eignar þarf að hlaða niður á þau tæki sem þú vilt nota innan eins árs frá því bókin er keypt.
Þú kemst í bækurnar hvar sem er
Þú getur nálgast allar raf(skóla)bækurnar þínar á einu augabragði, hvar og hvenær sem er í bókahillunni þinni. Engin taska, enginn kyndill og ekkert vesen (hvað þá yfirvigt).
Auðvelt að fletta og leita
Þú getur flakkað milli síðna og kafla eins og þér hentar best og farið beint í ákveðna kafla úr efnisyfirlitinu. Í leitinni finnur þú orð, kafla eða síður í einum smelli.
Glósur og yfirstrikanir
Þú getur auðkennt textabrot með mismunandi litum og skrifað glósur að vild í rafbókina. Þú getur jafnvel séð glósur og yfirstrikanir hjá bekkjarsystkinum og kennara ef þeir leyfa það. Allt á einum stað.
Hvað viltu sjá? / Þú ræður hvernig síðan lítur út
Þú lagar síðuna að þínum þörfum. Stækkaðu eða minnkaðu myndir og texta með multi-level zoom til að sjá síðuna eins og þér hentar best í þínu námi.
Fleiri góðir kostir
- Þú getur prentað síður úr bókinni (innan þeirra marka sem útgefandinn setur)
- Möguleiki á tengingu við annað stafrænt og gagnvirkt efni, svo sem myndbönd eða spurningar úr efninu
- Auðvelt að afrita og líma efni/texta fyrir t.d. heimaverkefni eða ritgerðir
- Styður tækni sem hjálpar nemendum með sjón- eða heyrnarskerðingu
- Gerð : 208
- Höfundur : 11055
- Útgáfuár : 2018
- Leyfi : 379