Elegant Training Center MS Excel Intermediate Level Elegant Training Center
50% Off for Laimoon Users! Get This Deal
Price: AED 700
AED 1,403
100% Money Back Guarantee
No questions asked refund With a goal of giving you a worry-free and secure enrollment experience, We offer a 24 hour money-back guarantee. Just send us a refund request via email within 24 hours after first class and we will refund 100% of your payment, no questions asked!
Instructor led live virtual classroom online. Classes may be individual or in group.

Course details

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

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

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
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 Updated on 05 March, 2024

Eligibility / Requirements

Basic knowledge of MS Excel

Job roles this course is suitable for:

Branch Manager , Corporate Managers , Executives

About 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. See all Elegant Training Center courses

Enquire about this course

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

Rate this page