Home Page Icon
Home Page
Table of Contents for
Title Page
Close
Title Page
by Paul McFedries
Microsoft Excel 2019 Formulas and Functions, First Edition
Cover Page
Title Page
Copyright Page
Dedication Page
Contents at a Glance
Contents
Acknowledgments
About the author
Introduction
What’s in the book
This book’s special features
About the companion content
Support and feedback
Part I: Mastering Excel formulas
Chapter 1 Building basic formulas
Understanding formula basics
Understanding operator precedence
Controlling worksheet calculation
Copying and moving formulas
Displaying worksheet formulas
Converting a formula to a value
Working with range names in formulas
Working with links in formulas
Chapter 2 Creating advanced formulas
Working with arrays
Using iteration and circular references
Consolidating multisheet data
Applying data-validation rules to cells
Using dialog box controls on a worksheet
Chapter 3 Troubleshooting formulas
Understanding Excel’s error values
Fixing other formula errors
Handling formula errors with IFERROR()
Using the formula error checker
Auditing a worksheet
Part II: Harnessing the power of functions
Chapter 4 Understanding functions
About Excel’s functions
The structure of a function
Typing a function into a formula
Using the Insert Function feature
Loading the Analysis ToolPak
Chapter 5 Working with text functions
Excel’s text functions
Working with characters and codes
Converting text
Formatting text
Manipulating text
Searching for substrings
Substituting one substring for another
Chapter 6 Working with logical and information functions
Adding intelligence with logical functions
Getting data with information functions
Chapter 7 Working with lookup functions
Taking a look at Excel’s lookup functions
Understanding lookup tables
The CHOOSE() function
Looking up values in tables
Chapter 8 Working with date and time functions
How Excel deals with dates and times
Using Excel’s time functions
Chapter 9 Working with math functions
Excel’s math and trig functions
Understanding Excel’s rounding functions
Summing values
The MOD() function
Generating random numbers
Part III: Building business formulas
Chapter 10 Implementing basic business formulas
Pricing formulas
Financial formulas
Inventory formulas
Liquidity formulas
Chapter 11 Building descriptive statistical formulas
Understanding descriptive statistics
Counting items
Calculating averages
Calculating extreme values
Working with rank and percentile
Calculating measures of variation
Working with frequency distributions
Chapter 12 Building inferential statistical formulas
Understanding inferential statistics
Sampling data
Determining whether two variables are related
Working with probability distributions
Determining confidence intervals
Hypothesis testing
Chapter 13 Applying regression to track trends and make forecasts
Choosing a regression method
Using simple regression on linear data
Using simple regression on nonlinear data
Using multiple regression analysis
Chapter 14 Building loan formulas
Understanding the time value of money
Calculating a loan payment
Building a loan amortization schedule
Calculating the term of a loan
Calculating the interest rate required for a loan
Calculating how much you can borrow
Chapter 15 Working with investment formulas
Working with interest rates
Calculating the future value
Working toward an investment goal
Chapter 16 Building discount formulas
Calculating the present value
Discounting cash flows
Calculating the payback period
Calculating the internal rate of return
Part IV: Building business models
Chapter 17 Analyzing data with tables
Sorting a table
Filtering table data
Referencing tables in formulas
Excel’s table functions
Chapter 18 Analyzing data with PivotTables
Working with PivotTable subtotals
Changing the value field summary calculation
Creating custom PivotTable calculations
Using PivotTable results in a worksheet formula
Chapter 19 Using Excel’s business modeling tools
Using what-if analysis
Working with Goal Seek
Working with scenarios
Chapter 20 Solving complex problems with Solver
Some background on Solver
Loading Solver
Using Solver
Adding constraints
Saving a solution as a scenario
Setting other Solver options
Making sense of Solver’s messages
Displaying Solver’s reports
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Cover Page
Next
Next Chapter
Copyright Page
Microsoft Excel 2019 Formulas and Functions
Paul McFedries
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset