## Description

Excel is the well-known standard spreadsheet application that allows you to easily perform calculations and recalculations of data by using numerous built-in functions and formulas. Although you may be familiar with simple functions such as SUM, this is just one of the many Excel functions and formulas that can help you simplify the process of entering calculations. Because there are so many other useful and versatile functions and formulas inside Excel that most users haven’t discovered yet, this book was written to help readers uncover and use its wide range of tools.

For each function or formula, we started with a simple task that can be solved with Excel in an efficient way. We added tips and tricks and additional features as well to provide deeper knowledge and orientation. After you have stepped through all the lessons, you will have a great toolbox to assist you with your projects and make many everyday workbook tasks much easier.

The content of the book is as follows:

Chapter 1 describes practical tasks that can be solved by using formulas.

In Chapter 2 you learn the usage of logical functions that are often used in combination with other functions.

Chapter 3 shows how text functions are used. You will often need these functions when working with text in tables or if the text needs to be changed or adapted, especially when it is imported into Excel from other applications.

In Chapter 4 you learn about the date and time functions in Excel. Times and dates are automatically converted inside Excel to the number format, which makes it easier to perform calculations.

With Chapter 5 you delve into the secrets of working with statistics in Excel.

Chapter 6 describes the most commonly used functions for mathematics and trigonometry, along with easy-to-follow tasks. The most common function here is the SUM function, with which you may already be familiar. However, you may be surprised about the additional possibilities shown.

If you want to learn more about functions for financial mathematics, take a look at Chapter 7. Here you will find examples of how to calculate depreciation of an asset and how long it takes to pay back a loan using different interest rates.

With Chapter 8 you get into the secrets of database functions. There are a variety of functions explained that can be used for evaluation of data, especially when using different criteria.

Chapter 9 is about lookup and reference functions inside Excel. With these functions you can address data in various ranges and look up values in a reference.

Chapter 10 goes into the secrets of conditional formatting. This feature has been available since Excel 97, but there are still some tips and tricks for enhancing the built-in features—just take a look at the possibilities.

Chapter 11 provides an introduction to array formulas. With these you learn how to perform multiple calculations and then return either a single result or multiple results. This special feature is similar to other formulas, except you press Ctrl+Shift+Enter after entering the formula.

Chapter 12 shows special solutions with formulas, such as creating a function to color all cells containing formulas inside an Excel spreadsheet.

Chapter 13 goes even deeper into user-defined functions with examples that use Visual Basic for Applications inside Excel. This chapter will show you how to solve problems even when Excel cannot calculate an answer.

With Chapter 14 we present some examples of tasks that combine several functions shown in the previous chapters. Use these to get more experience. Read the description of the task first and try to determine the functions that are needed to get the desired result. Compare your solution to the one shown beneath the task.

Appendix A provides an overview of the current versions of Excel. This includes Excel 2013 for Windows, the primary version used for the images and examples in the text. The interface for Excel 2011 for Macintosh is also covered; the appearance of this version is different, but it is capable of performing the same calculations. The Excel Web App available as part of the Microsoft SkyDrive is also demonstrated in this appendix; it has limited functionality compared to the complete installations, but it still has a significant capacity for performing calculations.

Have fun reading the book and in the continuous usage of the functions and formulas you will discover here.