In this hands-on workshop series, you will learn how to create informative data representation using advanced functions of Excel such as VLOOKUP, INDEX, and MATCH. Financial functions such as PMT, FV, and NPV are explored. Text manipulation functions such as FIND, SEARCH, MID, LEFT, RIGHT, PROPER, TRIM, and RIGHT are explained. The use and advantage of Excel’s “Pivot Table: will be discussed and practiced in details. The locking, and unlocking of the whole or part of the spreadsheet will be demonstrated. The users will also learn how to create and use Macros to become efficient in using data.