Excel Formulas & Functions For Dummies
By Ken Bluttman
product.options_with_values.size == 1: 1
product.available == false: false
block.settings.unavailable_variants == 'hide': show
target.option1: New
product.option1:
product.options_with_values: [{"name":"Condition","position":1,"values":["New"]}]
product group: 10
product type: Book
is_new_or_remainder_or_default_title? true
has_only_one_condition_option? true
New RRP:
In-stock. Unavailable. Learn more.
In-stock. Aims to ship within 2 - 8 business days. Learn more.
In-stock. Aims to ship within 1 business day. Learn more.
Unlock the power of Excel with a step-by-step roadmap to its formulas and functions There's a Swiss Army knife in your digital toolbox that can multiply your productivity and make you the smartest guy or gal in almost any room. It's called Microsoft Excel.
If you're like most people, you've barely scratched the surface of what this powerful tool's hundreds of built-in functions can do. But with a little help from Excel Formulas & Functions For Dummies, you'll soon be organizing, analyzing, and interpreting data like a pro.
For those who don't know the difference between a spreadsheet and a bedsheet, the book gets you up to speed with formula and function basics first. But you can also skip ahead to the fancy stuff and learn about working with probabilities, significance tests, and lookup functions.
This easy-to-use Excel formulas and functions survival guide shows you how to:
Work with financial functions like PMT, PPMT, NPER, RATE, and PV
Calculate mean, median, mode, standard deviation, and many more statistical functions
Troubleshoot formulas for common errors and validate your data to avoid mistakes
Work with dates, times, logic operators, conditions, and basic and advanced mathematical functions
You don't need a degree in data science or advanced mathematics to take advantage of the full functionality and flexibility of Microsoft Excel. Let Excel Formulas & Functions For Dummies show you how to transform this unassuming program into the most useful tool in your toolbox.
- ISBN:
- 9781119839118
- Format:
- Paperback / softback
- Pages:
- 416
- Published:
- Publisher:
- John Wiley & Sons Inc
- Imprint:
- For Dummies
- Weight:
- 567 g