MS EXCEL ADVANCE IN NUCOM INSTITUTE IN RAWALPINDI IN RAWALPINDI

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 Views: 2