####
__Contents of ____Microsoft Excel Functions and Formulas __

__Contents of__

Chapter 3 Text Functi

Chapter 4 Date and Time Functions

####
__Preface of ____Microsoft Excel Functions and Formulas __

__Preface of__

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

in stallations, 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.

## No comments:

## Post a Comment