Location
UAE, Dubai - Office Number 620, Al Attar Business Centre, Beside ibis Hotel, Al Barsha 1 Near Sharaf DG Metro Station, Sheikh Zayed Road, Dubai, UAE
Dates
Dates flexible (12 hours)
Course Type
Professional Training Course
Accreditation
-
Language
English
Price
$408 $218 only

Course Overview

This program will help you to learn about performing calculations, manipulating worksheet data, formatting the content of worksheet, working with charts and sheets, modifying chart options, working with multiple worksheets, setting up and preparing printing information and so much more.

Who should take this course

Basic knowledge of MS Excel

Career options after graduation

Branch Manager , Corporate Managers , Executives

Course content

Pivot Tables & Formatting Sorting & Filtering Creating Pivot table & Analyzing data Sorting a worksheet with filter Refreshing & Changing PivotTable Range Sorting a worksheet without filter Creating sheets from Pivot table Advanced Sorting Calculations & creating dynamic Pivot Types of Filters Table creation Difference between soft filter and regular filter Defining name & Working with tables Creating fields and formatting Creating Sub Totals Creating more than one pivot table on one sheet Sorting data with Multiple Level Sorts Changing Source Advance Filtering on more than 1 Criteria Slicer Extracting Unique Values with Filtering Conditional Formatting Tips of copying Filtered data to New File Formatting data on Conditions Using Charts and Visualization Highlight Duplicate & Unique Values Creating Column, Line & Pie Charts Finding top 5 / 10 Items in the Data Shortcuts of Creating Charts Formatting data using Data Bars & Icons

About Course Provider

Elegant Professional and Management Development is a leading training center in Dubai, U.A.E. We specialize in affordable and effective face-to-face training in variety of courses to meet the needs of the today’s business.

We design and customize courses and programmes for people of different walks and professions like Engineering, IT, Finance, Sales & Marketing and HR & Administration, whether trying to enter into the job market or employees willing to achieve professional development and qualification to secure advancement in their careers and improve their performance level.

Our training is stretching, motivating and tailored to the individual learner. We develop and deliver training courses for organizations across all sectors. All of our courses can be tailored specifically to your team’s needs and delivered at your site as well.

We also run a range of courses for individuals at our training centre enabling delegates to get out of the office so they can network with other learners, build their skills and confidence, and practice in a safe learning environment.