[Assignment for Advance Excel]

 

Microsoft Excel 2007.

Assignment no. 1 (Excel Formatting).

Assignment 1-B- Alignment.

Assignment 1-C Number & Style.

Assignment No. 1-D Styles.

Assignment No. 1-E (Cells).

Assignment No.1 E-Editing.

Assignment No. 2(Insert).

Assignment No.3 (Page layout).

Assignment No.4 (Formulas).

Assignment No.5 (Logical , statistical, math & trigonometry function).

Assignment No.6 (sum if, count if functions).

Assignment No. 7 (convert, vlookup, hlookup).

Assignment No.8 (PMT, PPMT, PV, FV, RATE, NPER function).

Assignment No. 9(Formula auditing and calculation).

Assignment No.10 (External data sort and filter).

Assignment No.11 (Data validation).

Assignment No.12 (what if analysis).

Assignment No.13 (Paste Special).

Assignment No.14 (Protection, sharing, track changes).

Assignment No.15 (data form and macro).

​for more details send your reply on my mail id pankajushinde@gmail.com