Microsoft 365 Excel Formulas & Functions For Dummies
Kaup valmöguleikar
Turn Excel into an unstoppable data-and number-crunching machine Microsoft Excel is the Swiss Army knife of apps. With over 470 built-in functions and countless custom formulas, the program can help make you the smartest guy or gal in any room. And now that it's been supercharged with Copilot--Microsoft's AI-powered helper--it's even easier to produce accurate and useful results anywhere, anytime.
Best of all, it doesn't take an advanced degree in mathematics or data science to take full advantage of Excel's functionality. Just grab a copy of this latest edition of Excel Formulas & Functions For Dummies and get a flying start on the Excel functions and formulas that power up your data superpowers. With this book, you'll: Learn to create and use hundreds of formulas and functions, correct common mistakes, and make calculations Discover how to analyze data and calculate statistics, and even work with dates and times Use the ever-evolving, AI-powered Copilot to expand Excel's functionality and make it easier to use Get ready to transform your copy of Excel at home or at work into an unstoppable toolkit equipped for almost any occasion.
Nánar um bókina
- Wiley Professional Development (P&T)
- 9781394295579
- 9781394295517
- ePub
- 7
- Ken Bluttman
- English
- 2025-03-10
- 100
- 10
- 2
Kaflar
- Cover
- Title Page
- Copyright
- Introduction
- About This Book
- Foolish Assumptions
- Icons Used in This Book
- Beyond the Book
- Where to Go from Here
- Part 1: Getting Started with Excel 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
- Changing the Shape of Arrays
- 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
- Part 2: Doing the Math
- 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
- Creating a Sequence
- Raising Numbers to New Heights
- Multiplying Multiple Numbers
- Using What Remains with the MOD Function
- Summing Things Up
- Getting an Angle on Trigonometry
- Asking Copilot For Help
- Part 3: Solving with Statistics
- 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: 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
- Part 4: Dancing with Data
- Chapter 11: 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
- Chapter 12: Keeping Well-Timed Functions
- Understanding How Excel Handles Time
- Formatting Time
- Deconstructing Time with HOUR, MINUTE, and SECOND
- Finding the Time NOW
- Chapter 13: 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 14: 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 15: Writing Home about Text Functions
- Breaking Apart Text
- Putting Text Together
- Changing Text
- Comparing, Finding, and Measuring Text
- Part 5: The Part of Tens
- Chapter 16: 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 17: Ten Ways to Get Fancy with Excel
- Calculating Data from Multiple Sheets
- Getting Data from the Internet
- Determining the Needed Number
- Removing Duplicates
- Getting to the Last Row of Your Data
- Freezing Panes
- Splitting a Worksheet
- Filling Cells
- Adding Notes to Cells
- Getting More Information about a Workbook or Worksheet
- Chapter 18: 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
- Index
- About the Author
- Connect with Dummies
- End User License Agreement