BOOK & EBOOK: EXERCISE OF EXCEL AT AMAZON.COM

 

You can now get exercise of excel book and e-book on the Amazon.com platform.

Currently the Exercise of Excel consists of 202 numbers:

• All questions are in the form of practice questions

(insert the excel formula into the table column).

• There are no theory or multiple choice questions.

 How to get a Book or E-book Exercise of excel on amazon.com:

1. Go to the site: https://www.amazon.com/

2. In the search engine select: book

3. Enter keywords: Exercise of excel

4.Choose whether you want to buy the e-book or the backpaper (book) version

5. Follow the next guide on your monitor screen

Video tutorial on how to purchase Exercise of Excel book / ebook on Amazon.com:

The following is a list of contents or material in the book / e-book exercise of excel:

CHAPTER I

1. Functions: IF, LEFT, MID, RIGHT, AND, OR

(31 numbers)

2. Functions: HLOOKUP, VLOOKUP, INDEX, MATCH            

(27 numbers)

3. Functions: COUNT, COUNTIF, COUNTIFS, SUM, SUMIF, SUMIFS                                                                                         

(11 numbers)

4. Functions: DATE, DAY, MONTH, YEAR

(11 numbers)

5. Financial Functions: RATE, Per, PMT, PV, FV, IPMT, PPMT                                                                                             

(23 numbers)

6. Depreciation Function: SLN, SYD, DB, DDB, VDB

(14 numbers)

7. PIVOT TABLES and CHART

(3 numbers)

 

CHAPTER II

1. Financial Functions: CUMIPMT, CUMPRINC                     

(4 numbers)

2. Financial Function: FVSCHEDULE

(3 numbers)

3. Functions: ROUND, ROUNDUP, ROUNDDOWN

(2 numbers)

4. Functions: PRODUCT and SUMPRODUCT 

(4 numbers)

 

CHAPTER III

1. Function: CHOOSE

(4 numbers)

2. Combined IF with H/VLOOKUP

( 6 numbers)

3. Function: ISPMT

(3 numbers)

4. Text Functions

(4 numbers)

5. Financial Mathematics: FIXED INTEREST RATES, FLOATING RATES, SINGLE INTEREST AND COMPOUND INTEREST

(16 numbers)

 

CHAPTER IV

1. Functions: DATEDIF, DAY, DAYS, DAYS360, EDATE, and EOMONTH

(4 numbers)

2. Functions: AMORLINC and AMORDEGRC

(4 numbers)

3. Functions: WORKDAY and NETWORKDAYS

(4 numbers)

4. Functions: AVERAGE, AVERAGEIF, AVERAGEIFS, and AVERAGEA

(5 numbers)

5. WEAKNESS OF VLOOKUP FORMULA

(4 NUMBER)

 

CHAPTER V

1. Function: IFERROR

(2 NUMBER)

2. MAKE DIAGONAL LINES ON THE TABLE

(4 NUMBER)

3. SMALL & LARGE Functions

(4 NUMBER)

4. Functions: WEEKDAY & WEEKNUM

(3 NUMBERS)

5. Function: CONVERT

(2 NUMBER)