Hard copy is hard copy.You can read it , experiment it , prepare notes and lot. So why read online samples when you can own a full copy for less than 4$ .Email [email protected]  to buy hard copy of the same. If you think the excel book can be improved please email the author at [email protected]
 

How to find average of a given set of results?
What is the use of Goal seek command?
How do we concatenate in excel?
How can we extract data from the web in to EXCEL continuously?
How can we convert row data in to columns?
How can we implement validation on an EXCEL cell?
You want to split MA12345-890 in to MA12345 and 890?
How do we calculate actual working days excluding Saturdays and Sundays?
How can we implement common size reports using EXCEL?
How can we create multi-dimension reports?
How can we add subtotals in EXCEL?
How can we implement complicated search and calculation on huge data?
How can we format data on certain condition?
You want to password protect your EXCEL file?
How to import files in EXCEL received from third party?
How can we compare text in EXCEL?
How can we capitalize the first letter of a string?
Some useful text manipulation functions in EXCEL
How can we automate a repeatable task in EXCEL?
How can we insert image in EXCEL?
Can you explain VLOOKUP?
How can we create a dropdown in an EXCEL column?
How can we do SUM according to criteria?
How can we extract unique records from a given list?
How can we use an IF condition in EXCEL?
How do we round up and round down financial amounts?
How can we do a Sum and Product ?
How can we change simple numbers in roman numbers?
How can two users work on the same EXCEL sheet at the same time?
How can we send an EXCEL as email attachment in outlook?
How do we find number of occurrences in a given set of data range?
For given set of student marks, we need to find the rank?
How can we calculate compounding interest in excel?
How do we calculate future and present value for series of cash flow?
What are data tables and how can it helps us?
To achieve 61051 INR after 5 yrs at 10% interest rate what should be the yearly investment amount?
How do we calculate number of years for given rate of interest and loan value?
How do we calculate rate of interest?
You have two models of investments you want to know which is the best?
How can we compare a business plan investment with fixed rate returns?
How do we calculate a value of a bond using excel?
How can we calculate Current yield, YTM and YTC for bonds?
You have two stocks how will you decide the investment strategy for the same?
You have three stocks you want to choose two stocks with diversified investment?
How do we calculate straight line depreciation?
What is double declining depreciation?
How do we calculate depreciation using ‘sum of year digit’?
How can we calculate depreciation for a certain time period?
Theory about forecasting
How can we do linear forecasting using EXCEL?
What are the different other ways of linear forecasting using EXCEL?
How can we represent linear regression in a graphical format?
How can we perform multiple regression using EXCEL?
Basic Accounting automation in EXCEL
EXCEL Short cut reference
Second Edition of EXCEL Questions and Answers
Other books written by us