MARC details
| 000 -LEADER |
|---|
| fixed length control field |
08802nam a22002057a 4500 |
| 005 - DATE AND TIME OF LATEST TRANSACTION |
|---|
| control field |
20220214172358.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
|---|
| fixed length control field |
220214b ||||| |||| 00| 0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
9789390466733 |
| 082 ## - DEWEY DECIMAL CLASSIFICATION NUMBER |
|---|
| Classification number |
005.54 |
| Item number |
BLU |
| 100 ## - MAIN ENTRY--PERSONAL NAME |
|---|
| Personal name |
Bluttman, Ken |
| 245 ## - TITLE STATEMENT |
|---|
| Title |
Microsoft excel formulas and functions for dummies |
| 250 ## - EDITION STATEMENT |
|---|
| Edition statement |
5th |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) |
|---|
| Name of publisher, distributor, etc. |
Wiley India Pvt. Ltd. |
| Place of publication, distribution, etc. |
New Delhi |
| Date of publication, distribution, etc. |
2021 |
| 300 ## - PHYSICAL DESCRIPTION |
|---|
| Extent |
xiii, 383 p. |
| 365 ## - TRADE PRICE |
|---|
| Price type code |
INR |
| Price amount |
799.00 |
| 504 ## - BIBLIOGRAPHY, ETC. NOTE |
|---|
| Bibliography, etc. note |
Introduction<br/><br/>About This Book <br/><br/>Foolish Assumptions <br/><br/>How to Use This Book <br/><br/>Icons Used in This Book <br/><br/>Where to Go from Here <br/><br/> <br/><br/>Part 1: Getting Started with Formulas and Functions<br/><br/>Chapter 1: Tapping Into Formula and Function Fundamentals<br/><br/>Working with Excel Fundamentals <br/>Understanding workbooks and worksheets<br/>Introducing the Formulas Tab<br/>Working with rows, column, cells, ranges, and tables<br/>Formatting your data<br/>Getting help<br/>Gaining the Upper Hand on Formulas<br/>Entering your first formula<br/>Understanding references<br/>Copying formulas with the fill handle<br/>Assembling formulas the right way<br/>Using Functions in Formulas<br/>Looking at what goes into a function<br/>Arguing with a function<br/>Nesting functions<br/> <br/><br/>Chapter 2: Saving Time with Function Tools<br/><br/>Getting Familiar with the Insert Function Dialog Box<br/>Finding the Correct Function<br/>Entering Functions Using the Insert Function Dialog Box<br/>Selecting a function that takes no arguments<br/>Selecting a function that uses arguments<br/>Entering cells, ranges, named areas, and tables as function arguments<br/>Getting help in the Insert Function dialog box<br/>Using the Function Arguments dialog box to edit functions<br/>Directly Entering Formulas and Functions<br/>Entering formulas and functions in the Formula Bar<br/>Entering formulas and functions directly in worksheet cells<br/> <br/><br/>Chapter 3: Saying "Array!" for Formulas and Functions<br/><br/>Discovering Arrays<br/>Using Arrays in Formulas<br/>Working with Functions That Return Arrays<br/> <br/><br/>Chapter 4: Fixing Formula Boo-Boos<br/><br/>Catching Errors As You Enter Them<br/>Getting parentheses to match<br/>Avoiding circular references<br/>Mending broken links<br/>Using the Formula Error Checker<br/>Auditing Formulas<br/>Watching the Watch Window<br/>Evaluating and Checking Errors<br/>Making an Error Behave the Way You Want<br/> <br/><br/>Part 2: Doing the Math<br/><br/>Chapter 5: Calculating Loan Payments and Interest Rates<br/><br/>Understanding How Excel Handles Money<br/>Going with the cash flow<br/>Formatting for currency<br/>Choosing separators<br/>Figuring Loan Calculations<br/>Calculating the payment amount<br/>Calculating interest payments<br/>Calculating payments toward principal<br/>Calculating the number of payments<br/>Calculating the number of payments with PDURATION<br/>Calculating the interest rate<br/>Calculating the principal<br/> <br/><br/>Chapter 6: Appreciating What You'll Get, Depreciating What You've Got<br/><br/>Looking into the Future<br/>Depreciating the Finer Things in Life<br/>Calculating straight-line depreciation<br/>Creating an accelerated depreciation schedule<br/>Creating an even faster accelerated depreciation schedule<br/>Calculating a midyear depreciation schedule<br/>Measuring Your Internals<br/> <br/><br/>Chapter 7: Using Basic Math Functions<br/><br/>Adding It All Together with the SUM Function<br/>Rounding Out Your Knowledge<br/>Just plain old rounding<br/>Rounding in one direction<br/>Leaving All Decimals Behind with INT<br/>Leaving Some Decimals Behind with TRUNC<br/>Looking for a Sign<br/>Ignoring Signs<br/> <br/><br/>Chapter 8: Advancing Your Math<br/><br/>Using PI to Calculate Circumference and Diameter<br/>Generating and Using Random Numbers<br/>The all-purpose RAND function<br/>Precise randomness with RANDBETWEEN<br/>Ordering Items<br/>Combining<br/>Raising Numbers to New Heights<br/>Multiplying Multiple Numbers<br/>Using What Remains with the MOD Function<br/>Summing Things Up<br/>Using SUBTOTAL<br/>Using SUMPRODUCT<br/>Using SUMIF and SUMIFS<br/>Getting an Angle on Trigonometry<br/>Three basic trigonometry functions<br/>Degrees and radians<br/> <br/><br/>Part 3: Solving with Statistics<br/><br/>Chapter 9: Throwing Statistics a Curve<br/><br/>Getting Stuck in the Middle with AVERAGE, MEDIAN, and MODE<br/>Deviating from the Middle<br/>Measuring variance<br/>Analyzing deviations<br/>Looking for normal distribution<br/>Skewing from the norm<br/>Comparing data sets<br/>Analyzing Data with Percentiles and Bins<br/>QUARTILE.INC and QUARTILE.EXC<br/>PERCENTILE.INC and PERCENTILE.EXC<br/>RANK<br/>PERCENTRANK<br/>FREQUENCY<br/>MIN and MAX<br/>LARGE and SMALL<br/>Going for the Count<br/>COUNT and COUNTA<br/>COUNTIF<br/> <br/><br/>Chapter 10: Using Significance Tests<br/><br/>Testing to the T<br/>Comparing Results with an Estimate<br/> <br/><br/>Chapter 11: Rolling the Dice on Predictions and Probability<br/><br/>Modeling<br/>Linear model<br/>Exponential model<br/>Getting It Straight: Using SLOPE and INTERCEPT to Describe Linear Data<br/>What's Ahead: Using FORECAST, TREND, and GROWTH to Make Predictions<br/>FORECAST<br/>TREND<br/>GROWTH<br/>Using NORM.DIST and POISSON.DIST to Determine Probabilities<br/>NORM.DIST<br/>POISSON.DIST<br/> <br/><br/>Part 4: Dancing with Data<br/><br/>Chapter 12: Dressing Up for Date Functions<br/><br/>Understanding How Excel Handles Dates<br/>Formatting Dates<br/>Making a Date with DATE<br/>Breaking a Date with DAY, MONTH, and YEAR<br/>Isolating the day<br/>Isolating the month<br/>Isolating the year<br/>Converting a Date from Text<br/>Finding Out What TODAY Is<br/>Counting the days until your birthday<br/>Counting your age in days<br/>Determining the Day of the Week<br/>Working with Workdays<br/>Determining workdays in a range of dates<br/>Workdays in the future<br/>Calculating Time Between Two Dates with the DATEDIF Function<br/> <br/><br/>Chapter 13: Keeping Well-Timed Functions<br/><br/>Understanding How Excel Handles Time<br/>Formatting Time<br/>Keeping TIME<br/>Converting Text to Time with TIMEVALUE<br/>Deconstructing Time with HOUR, MINUTE, and SECOND<br/>Isolating the hour<br/>Isolating the minute<br/>Isolating the second<br/>Finding the Time NOW<br/>Calculating Elapsed Time Over Days<br/> <br/><br/>Chapter 14: Using Lookup, Logical, and Reference Functions<br/><br/>Testing on One Condition<br/>Choosing the Right Value<br/>Let's Be Logical<br/>NOT<br/>AND and OR<br/>XOR<br/>Finding Where the Data Is<br/>ADDRESS<br/>ROW, ROWS, COLUMN, and COLUMNS<br/>OFFSET<br/>Looking It Up<br/>HLOOKUP and VLOOKUP<br/>MATCH and INDEX<br/>FORMULATEXT<br/>NUMBERVALUE<br/> <br/><br/>Chapter 15: Digging Up the Facts<br/><br/>Getting Informed with the CELL Function<br/>Getting Information About Excel and Your Computer System<br/>Finding What IS and What IS Not<br/>ISERR, ISNA, and ISERROR<br/>ISBLANK, ISNONTEXT, ISTEXT, and ISNUMBER<br/>Getting to Know Your Type<br/> <br/><br/>Chapter 16: Writing Home About Text Functions<br/><br/>Breaking Apart Text<br/>Bearing to the LEFT<br/>Swinging to the RIGHT<br/>Staying in the MIDdle<br/>Finding the long of it with LEN<br/>Putting Text Together with CONCATENATE<br/>Changing Text<br/>Making money<br/>Turning numbers into text<br/>Repeating text<br/>Swapping text<br/>Giving text a trim<br/>Making a case<br/>Comparing, Finding, and Measuring Text<br/>Going for perfection with EXACT<br/>Finding and searching<br/> <br/><br/>Chapter 17: Playing Records with Database Functions<br/><br/>Putting Your Data into a Database Structure<br/>Working with Database Functions<br/>Establishing your database<br/>Establishing the criteria area<br/>Fine-Tuning Criteria with AND and OR<br/>Adding Only What Matters with DSUM<br/>Going for the Middle with DAVERAGE<br/>Counting Only What Matters with DCOUNT<br/>Finding Highest and Lowest with DMIN and DMAX<br/>Finding Duplicate Values with DGET<br/>Being Productive with DPRODUCT<br/> <br/><br/>Part 5: The Part of Tens<br/><br/>Chapter 18: Ten Tips for Working with Formulas<br/><br/>Master Operator Precedence<br/>Display Formulas<br/>Fix Formulas<br/>Use Absolute References<br/>Turn Calc On/Turn Calc Off<br/>Use Named Areas<br/>Use Formula Auditing<br/>Use Conditional Formatting<br/>Use Data Validation<br/>Create Your Own Functions<br/> <br/><br/>Chapter 19: Ten Functions You Really Should Know<br/><br/>SUM<br/>AVERAGE<br/>COUNT<br/>INT and ROUND<br/>INT<br/>ROUND<br/>IF<br/>NOW and TODAY<br/>HLOOKUP and VLOOKUP<br/>ISNUMBER<br/>MIN and MAX<br/>SUMIF and COUNTIF<br/> <br/><br/>Chapter 20: Ten Really Cool Functions<br/><br/>Work with Hexadecimal, Octal, Decimal, and Binary Numbers<br/>Convert Units of Measurement<br/>Find the Greatest Common Divisor and the Least Common Multiple<br/>Easily Generate a Random Number<br/>Convert to Roman Numerals<br/>Factor in a Factorial<br/>Determine Part of a Year with YEARFRAC<br/>Find the Data TYPE<br/>Find the LENgth of Your Text<br/> |
| 520 ## - SUMMARY, ETC. |
|---|
| Summary, etc. |
Description<br/>There are more than 400 built-in functions in Excel X, from AGGREGATE to Z.TEST. The question is which ones will make my work easier? How and why should I use a particular function in my formulas? Excel Formulas and Functions For Dummies, 5th Edition is a thorough but easy-to-read coverage of powerful Excel functions. This book gives detailed step-by-step instruction on Excel's 150 most useful functions. The use of each function will be illustrated by helpful, real-world examples showing how a function is used within a formula. Another 85 specialized functions will be described in abbreviated form. |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name as entry element |
Microsoft Excel (Computer file) |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) |
|---|
| Source of classification or shelving scheme |
Dewey Decimal Classification |
| Koha item type |
Book |