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

Home Online Courses Microsoft Excel MS Excel Intermediate Level
Elegant Training Center MS Excel Intermediate Level Elegant Training Center
Get More Info

MS Excel Intermediate Level

Elegant Training Center

Add to wishlist
50% Off for Laimoon Users! Get This Deal
Price: USD 191
USD 382
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.
  • Duration / Course length: Upto 12 Hours
  • Timings: Enquire

    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
    Get More Info

    Enquire about this course

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

    Rate this page