Download Microsoft Excel Functions and Formulas Third Edition by Bernd Held and Theodor Richardson
Contents of Microsoft Excel Functions and Formulas
Chapter 1 Formulas in Excel
Chapter 2 Logical Functi
Chapter 3 Text Functi
Chapter 4 Date and Time Functions
Chapter 3 Text Functi
Chapter 4 Date and Time Functions
Chapter 5 Basic Statistical Functions
Chapter 6 Mathematical Functions
Chapter 7 Basic Financial Functions
Chapter 8 Database Functions
Chapter 9 Lookup and Reference Functions
Chapter 10 Conditional Formatting with Formulas
Chapter 11 Working with Array Formulas
Chapter 12 Special Solutions with Formulas
Chapter 13 User-Defined Functions
Chapter 14 Examples
Preface of Microsoft Excel Functions and Formulas
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
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.
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.
Download Microsoft Excel Functions and Formulas Pdf Book
No comments:
Post a Comment