Excel

Microsoft Excel course and certification in Abu Dhabi.

Excel is a popular tool used for creating spreadsheets, and managing, planning, formatting, organizing, analyzing and reporting the data.

If you want to learn and make the most of this software, you have come to the right place. New Horizons aims to build and enhance your competencies in MS-Excel through its onsite and classroom-based training solutions in Abu Dhabi.

Does not matter, if you are a beginner, intermediate level or an advance user, New Horizons makes sure you will get the best MS Excel training from our highly qualified instructors.

Skills Covered in Courses

Be it an older version (e.g. Excel 2000, Excel 2003 and Excel 2007 ) or the latest, more advanced ones like Excel 2010 and . Our Excel training courses will give you the in-depth knowledge of its functions and upgrade your skills. New Horizons Abu Dhabi can also help you choose the right course as per your needs. We’ve divided our courses in several steps for easy and fast learning. Some of those skills that we cover in our Excel courses are:
  1. Creating & managing worksheets/workbooks
  2. How to delete, insert, fill, drag and drop cells etc
  3. Doing basic math in Excel using functions and formulas
  4. How to lock/freeze panes, modify fonts and format cells
  5. Understanding of cell references, Auto-Fill and Flash-Fill
  6. How to use headers, footers and sort or filter data
  7. Writing what-if equations and recording macros
  8. Visual representation of data in pivot tables and graphs
If you want to learn the complete aspects of MS-Excel, book your training session with us, now.

Microsoft Excel 2016 Level 1

This course aims to provide students with a foundation for Excel knowledge and skills, which they can build upon to eventually become an expert in data manipulation.

Microsoft Excel 2016 Level 2

This course builds upon the knowledge presented in the Microsoft® Office Excel® 2016: Part 1 course and helps start students down the road to creating advanced workbooks & worksheets that can help deepen their understanding.

Microsoft Excel 2016 Level 3

This course builds off the knowledge presented in the Microsoft® Office Excel® 2016: Parts 1 & 2 courses to help you get the most of your Excel experience. This course covers Microsoft Office Specialist exam objectives to help students prep for the exam.

Excel 2016 Programming with VBA

This course builds off the knowledge presented in the Microsoft® Office Excel® 2016: Parts 1, 2 & 3 courses to help you get the most of your Excel experience and you can get maximum out of VBA programming and its usage.

Microsoft Excel 2013 Level 1

In this course, students will use Microsoft® Office Excel® 2013 to create spreadsheets and workbooks that you can use to store, manipulate, and share your data.

Microsoft Excel 2013 Level 2

How to work with large worksheets and advanced formatting techniques. How to create outlines and subtotals. Sort and filter data. Create and format tables. Audit worksheets for errors, protect work-sheets, share and merge and track changes in a workbook.

Microsoft Excel 2013 Level 3

Work with advanced formulas and lookup functions. Advanced data filtering & apply advanced chart formatting. PivotTables & Charts, export/ import data and external databases. Analytical features and create scenarios. Run/record macros. Explore VBA code.

55084 Excel 2013 Self-Service Analytics with No Code for End Users

This course is designed for the end users and analysts that are interested in exploring the new self-service business intelligence tools in Excel and SharePoint Server 2013.

55108 Discovering the Power of Excel 2010-2013 PowerPivot Data Analytic Expressions (DAX)

This course expose students to PowerPivot Data Analytic Expressions (DAX) concepts such as the Data Model and evaluation context, DAX functions, operators, and constants. There is an added module on the Data Model, an introduction to patterns.

Excel 2013: Data Analysis with Pivot Tables

Analyzing data and gaining insight is important. You have experience creating PivotTables but Excel is capable of doing more. In this course, students will learn how to organize data in a way that can be meaningfully presented to others using PivotTables.

Excel 2013: Data Analysis with Power Pivot

In this course, students learn how to organize, manipulate, and report data in the best way possible. This course will provide students with a solid understanding of Power Pivot to maximize their effectiveness when analyzing data.

Excel 2013 - Formulas & Charts

In this course, students will create, edit, and enhance spreadsheet formulas and charts using Microsoft Office Excel 2013.

Microsoft Excel 2010 Level 1

After an introduction to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and save workbooks.

Microsoft Excel 2010 Level 2

Students will learn how to use multiple worksheets and workbooks efficiently, start working with more advanced formatting options including styles, themes, and backgrounds, learn how to create outlines and subtotals, work with tables and add hyperlinks.

Microsoft Excel 2010 Level 3

Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX; will learn about data validation and database functions such as DSUM; will learn how to import and export data, and how to query external data bases.

Microsoft Excel 2010 Level 4

In this course, students will use the advanced features of Microsoft® Office Excel® 2010 to attain proficiency as an Excel power user.

Excel 2010 - Advanced Functions

In this course, students will explore specialized and advanced Excel functions.

Excel 2010 - Charts and Graphs

In this course, students will learn how to create, format and modify charts.

Excel 2010 - Embracing Formulas in Microsoft Excel

Students will learn how to use formulas to better calculate data.

Excel 2010 - Building Your Microsoft Excel Environment

After an introduction to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and save workbooks.

Excel 2010 - Formulas & Charts

In this course, students will create, edit, and enhance spreadsheet formulas and charts using Microsoft Office Excel 2010.

Excel 2010 Transition from Excel 2003

In this course students will use the new and enhanced features in Microsoft Office Excel 2010.

Custom Requests/Older Versions Training

We do provide training for older versions or custom requested outline/courses, please contact our Education Consultant to get more details.

Learn More

Fields marked with an * are required