MS EXCEL - Advanced

This course enables you to create and use defined names in a workbook, create advanced formulas and consolidated formulas, use a range of lookup and reference functions, understand and create simple Pivot Table, construct and operate Pivot Tables using some of the more advanced techniques and create recorded macros in Excel.
 

Learning Outcomes

Upon successful completion of this course, trainees will be able to:

  • Create and use defined names in a workbook;

  • Create advanced formulas and consolidated formulas;

  • Use a range of lookup and reference functions;

  • Understand and create simple Pivot-tables;

  • Construct and operate Pivot-tables using some of the more advanced techniques;

  • Create recorded macros in Excel.

Socialize with us
Contact Us 

4A Khaled Ebn El Walid, Sheraton-Heliopolis Cairo Egypt

Copyright ©2019 Nile Academy in Egypt

Privacy  |  Copyright & Disclaimer