Miscellaneous stuff related to daily works
Thanks again to Chandoo for his superb trick. This is just a replication of his post. Excel has a built-in feature that lets you transpose data with a single click. Just select your original data Press CTRL+C to copy Go to an empty area and open Paste Special (CTRL+ALT+V) Select Transpose. Done! Although this approach works, …
The following excerpt is taken from Chandoo’s blog on time and date functions. It’s just a bookmark post. All credits to him. Staying at present: To have latest star date in a cell, just press CTRL+; (of course, in Excel world, star date is nothing but whatever date your computer shows) To have current time …
Today we are going to discuss about VLOOKUP Function in Excel. Instead of going into the details of the syntax etc., we shall discuss how we use it search a given list of items, from a big pool of data. We will see if the items in the list have any match in the pool, …
Using VLOOKUP() in Excel to locate a list of items in a given pool of data Read More »
While submitting the screens for review, follow this checklist of documents that you need to put there. Let us assume, screens for the SHG course are to be submitted for review. Review sheet: File name convention: Review comments _Name of Module_part_Date(ddmmyyyy) Example: Review comments_SHG_P5_08052013 ——————————————- Storyboard: File name convention: Storyboard_Name of Module_part_date Example: Storyboard_SHG_P5_08052013 —————————————— …