217 Practical Exercises to
Master Excel Formulas
Many books and applications
explain Excel formulas in theory—covering beginner to advanced levels. However,
to truly master Microsoft Excel, theory is not enough. You need hands-on
practice.
Why choose this workbook?
- 100% Practical: Every single exercise requires you to enter formulas directly into table columns.
- No Multiple Choice: Forget theoretical or multiple-choice questions; this is about real-world application.
- Linked Resources: For your reference, these exercises are based on extensive tutorials available on the author's blog:
https://mujiyamianto.blogspot.com
Master Excel by doing, not just reading.
You can now get COLLECTION of EXCEL EXERCISES (English Version) on the Amazon.com platform.
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 exercises)
2. Functions:
HLOOKUP, VLOOKUP, INDEX, MATCH
(27 exercises)
3. Functions:
COUNT, COUNTIF, COUNTIFS, SUM, SUMIF, SUMIFS
(11 exercises)
4. Functions:
DATE, DAY, MONTH, YEAR
(11 exercises)
5. Financial
Functions: RATE, Per, PMT, PV, FV, IPMT, PPMT
(23 exercises)
6. Depreciation
Function: SLN, SYD, DB, DDB, VDB
(14 exercises)
7. PIVOT TABLES
and CHART
(3 exercises)
CHAPTER II
1. Financial Functions: CUMIPMT, CUMPRINC
(4 exercises)
2. Financial Function: FVSCHEDULE
(3 exercises)
3. Functions: ROUND, ROUNDUP, ROUNDDOWN
(2 exercises)
4. Functions: PRODUCT and SUMPRODUCT
(4 exercises)
CHAPTER III
1. Function: CHOOSE
(4 exercises)
2. Combined IF with H/VLOOKUP
( 6 exercises)
3. Function: ISPMT
(3 exercises)
4. Text Functions
(4 exercises)
5. Financial Mathematics: FIXED INTEREST RATES,
FLOATING RATES, SINGLE INTEREST AND COMPOUND INTEREST
(16 exercises)
CHAPTER IV
1. Functions:
DATEDIF, DAY, DAYS, DAYS360, EDATE, and EOMONTH
(4 exercises)
2. Functions: AMORLINC and AMORDEGRC
(4 exercises)
3. Functions: WORKDAY and NETWORKDAYS
(4 exercises)
4. Functions: AVERAGE, AVERAGEIF, AVERAGEIFS, and AVERAGEA
(5 exercises)
5. WEAKNESS OF VLOOKUP FORMULA
(4 exercises)
CHAPTER V
1. Function: IFERROR
(2exercises)
2. MAKE DIAGONAL LINES ON THE TABLE
(4 exercises)
3. SMALL & LARGE Functions
(4 exercises)
4. Functions: WEEKDAY & WEEKNUM
(3 exercises)
5. Function: CONVERT
(2 exercises)
6. Function: XLOOKUP
(10 exercises)
CHAPTER VI
1. Function: VALUE
(5 exercises)