Excel Formulas Functions
Excel Formulas Functions is aa practical guide to mastering Excel Formulas and Functions efficiently. It covers essential mathematical, statistical, and logical functions with real-world examples for data analysis and automation. Perfect for beginners and professionals to boost productivity.
Contents at a Glance Introduction
Contents at a Glance Introduction
Part 1: Getting Started with Excel Formulas and Functions .
CHAPTER 1: Tapping Into Formula and Function Fundamentals
CHAPTER 2: Saving Time with Function Tools
CHAPTER 3: Saying “Array!” for Formulas and Functions
CHAPTER 4: Fixing Formula Boo-Boos.
Part 2: Doing the Math
CHAPTER 5: Calculating Loan Payments and Interest R
CHAPTER 6: Appreciating What You’ll Get, Depreciating What You’ve.
CHAPTER 7: Using Basic Math Functions
CHAPTER 8: Advancing Your Math
Part 3: Solving with Statistics .
CHAPTER 9: Throwing Statistics a Curve .
CHAPTER 10: Using Significance Tests
CHAPTER 11: Rolling the Dice on Predictions and Probability
Part 4: Dancing with Data
CHAPTER 12: Dressing Up for Date Functions
CHAPTER 13: Keeping Well-Timed Functions
CHAPTER 14: Using Lookup, Logical, and Reference Functions
CHAPTER 15:Digging Up the Facts
CHAPTER 16: Writing Home about Text Functions
CHAPTER 17: Playing Records with Database Functions
Part 5: The Part of Tens
CHAPTER 18: Ten Tips for Working with Formulas
CHAPTER 19: Ten Ways to Get Fancy with Excel
CHAPTER 20: Ten Really Cool Functions