Regional Educational Institute Microsoft Office Excel (Advanced) 2016 Regional Educational Institute
Price: AED 1,000
  • Timings: Part Time, Flexible

Course details



This course covers how to work more efficiently using "Advanced" Techniques with workbooks and worksheets, enhance the appearance of data and worksheets, perform analysis using functions and use the sorting and filtering features to manage and analyse ;Our Excel Advanced training program digs deeper into the advanced features and functions of this powerful spreadsheet software. In this course, you will learn ADVANCED and In-Depth features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and many more such as LOOKUP Functions, Pivot Tables, Charts, Create & Record Macros, ;

This advanced Excel video course is not for beginners and you should have a firm grasp of the basics before taking this Advanced Excel training course. By the conclusion of this program you will have mastered the advanced features and functions of this software.
Upon successful completion of this course, students will be able to:
  • Use the fill operations available to fill a data series
  • Understand and use formula cell referencing to create more complex formulas
  • Use a range of logical functions
  • Apply conditional formatting to ranges in a worksheet
  • Create and use labels in a workbook
  • Work with various elements of a worksheet
  • Use a range of techniques to work with worksheets
  • Use a range of find and replace techniques
  • Apply a variety of page setup techniques
  • Sort data in a list in a worksheet
  • Filter data in a table
  • Create effective charts in Microsoft Excel
  • Use a range of techniques to enhance charts
  • Apply formatting techniques to text on charts
  • Data Analysis & Pivot Tables
  • V-Lookup & H-Lookup
  • Auditing
  • Proofing
  • Reviewing 

Eligibility / Requirements

Candidates should have already completed Excel basic level training or have the basic knowledge in using the Excel software such as knowing how to create and save an excel workbook, enter simple formulas, print and chart data.

Course Location

About Regional Educational Institute

Regional Educational Institute (REI) has been at the forefront of education by delivering quality training courses in UAE since 1995, establishing itself as one of the premier training institutes in Abu Dhabi.Our training center in Abu Dhabi has developed numerous programs that have helped a significant amount of individuals uplift their careers not only in the functions they carried out but also in remunerations and future growth prospects. We strive to equip you with the skills and knowledge to better your career options, while also developing your other skillsets through cross functional training programs. Similarly, our corporate training courses in Abu Dhabi have helped many organizations in the region achieve better productivity and higher customer satisfaction levels.

We have numerous certified training programs on board – some of which includes Business Soft Skills, Leadership & Management, Sales & Marketing, Service Excellence, Language Development and IT training courses in Abu Dhabi. Our customers include some of the most prestigious organizations in the country, which include Government and Semi Government Agencies, Banking and Financial Institutions, Oil & Gas Companies, Hospital Groups, Large Corporations, Telecom Service Providers, Technology and Service Providers, System Integrators and many Small and Medium Enterprises.

Everything around us is rapidly changing – Be it technology, work environment, economic conditions, geographies, even thought processes. New paradigms are defined every day wherein keeping up is not only difficult but sometimes impossible. We employ a carefully calculated methodology that allows us to design training courses in Abu Dhabi that target specific skill areas needed by the candidates. Before we provide a training course in Abu Dhabi, we analyse a candidate’s training needs and create an effective educational program that includes training resources specifically chosen to equip the candidate.

At REI we not only focus on enhancing your current career options but also prepare you to stay ahead of the curve with our cross functional training programs. Approved and certified by the Abu Dhabi Centre for Technical and Vocational Education and Training, our training institute in Abu Dhabi offers certified courses and accreditations.

Our Team REI consists of industry professionals with a collective experience of more than 50 years of local and international experience. The core team consists of domain experts in Management, Finance, Learning & Development, Information Technology and Sales & Marketing.

See all Regional Educational Institute courses

Enquire about this course

You may add more courses here,
your list will be saved.

Rate our content