Ms Excel Advance in Nucom institute in Rawalpindi - Rawalpindi

Saturday, 8 September 2018

Item details

City: Rawalpindi, Punjab
Offer type: Offer
Price: Rs 4,500


Contact name Nucom
Phone 03045776226

Item description

Advanced Excel Course - Overview of the Basics of Excel
Customizing common options in Excel
Absolute and relative cells
Protecting and un-protecting worksheets and cells
Advanced Excel Course - Working with Functions
Writing conditional expressions (using IF
Using logical functions (AND, OR, NOT
Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX
VlookUP with Exact Match, Approximate Match
Nested VlookUP with Exact Match
VlookUP with Tables, Dynamic Ranges
Nested VlookUP with Exact Match
Using VLookUP to consolidate Data from Multiple Sheets