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
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.
How to enroll?
Provide us with your contact details, course provider will get back to you.