- Duration / Course length: Upto 12 Hours
- Timings: Enquire
Course details
Microsoft Excel is one of the most powerful tools to manage data and streamline your work. From managers to business owners and scientists, professionals across industries use Excel to analyze and visualize data. While many of us use Excel daily, mastering it through Excel courses can help you work more efficiently. Intermediate level skills in Microsoft Excel allows you to turn complex numbers into compelling data visualizations, leading to better business decisions. Whether you’re new to Excel or not our Excel online courses in Dubai provide the advanced training you need to unlock its full potential.
Course Outline:
1.Tables and Formatting:
- 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
- Subtotal
2. Fields and Fomatting:
- 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
3.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
4. Charts:
- Chanting Chart type
- Clearing & Managing rules adding Target Line in chart
- Analyzing only total rows method of pasting chart into PowerPoint
- Summarizing a data based on single attribute
- Creating two axis chart & advance charting
- Adding data based on two attributes Creating Drop Downs in cell
- Advanced Formatting & Customization Sharing Workbook
- Go To Options Inserting object, Hyperlinking
- Sheet Protection, No Right/Left Click, no copy Formulas and Functions
5. Hiding Formulas Statistical:
- Count/CountA/CountIF/CountIFs/CountBlank
- Protecting Parts of a Worksheet Trim & Concatenate, Sum, SumIF & SumIFs
- Change Case: Upper, Lower & Proper
- Logical: If/IF's, Using AND & OR in IF Condition
- Lookup: Advance & Multiple Vlookup & Hlookup
Eligibility / Requirements
Basic knowledge of MS Excel
Job roles this course is suitable for:
Branch Manager , Corporate Managers , Executives , Excel TrainersAbout Elegant Training Center
Elegant Professional and Management Development Training stands as a distinguished training center in Al Barsha1, Dubai, UAE setting the standard for excellence in face-to-face training programs. As a KHDA-approved and Autodesk Authorized center, we pride ourselves on offering affordable, effective, and industry-recognized courses across diverse fields, including Engineering & IT, Finance, Sales & Marketing, and HR & Administration.
As a KHDA-approved center, our dedication to quality education is recognized by the regulatory authority, assuring you of our commitment to delivering courses that meet the highest standards.
Moreover, being an Autodesk Authorized center in Dubai underscores our expertise in providing cutting-edge training in engineering and technology.
Enquire about this course
You may add more courses here,
your list will be saved.
