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 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.
Maybe helpful for a beginner, but this book is not as helpful a reference as Microsoft for an advanced user. Any time I need help, Microsoft has a video on any function. I'm also learning a lot from Excel webinars.
Having had to lookup and manipulate text strings for the past 3 years, I can hardly say there were any surprises in that section of the book, although it did provide a good summary.
Fianncial modelling, forecasting and statistics formulae, however, were a different kettle of fish and I will be sure to revisit if I ever find myself in need of creating analysis on the basis of those.
Wish I'd read this years ago. Would've saved me so much time and so many headaches. Very hand how-to to keep around your desk in case you need a reminder.