After successfully conducting many MS Excel & Modeling Workshops this year, we at Kredent Academy, are delighted to offer the next in our series of Workshops on Microsoft Excel on Saturday, 11th June and Sunday, 12th June 2011.

The indicative list of topics that will be covered are below:
1. Introduction to Excel
2. Formula Writing & Fixing Errors
a. Financial : Time Value of Money (PV, FV, nper, rate, PMT) + IRR, NPV
b. Look up : Vlookup, Hlookup
c. Math: Sum, Sumproduct, Absolute, Integer, Rounding, Average, Count, Minimum, Maximum, Absolute
d. Logical : IF, nested if, sumif, Count, CountA, CountBlank, CountIf, iferror and, or,
e. Text: Case, Position, Search and Concatenate, Trim, Right, Left, Concatenate
f. Date & Time: Day and Time, Representation of Date in Excel, Conversion, Today, Day, Today
g. Others: Even, Exact, Exp, Find, Int, IsBlank, Left, Len, Lower, Upper, Proper, Now, Power, Rank, RoundMore...