Elegant Training Center Intermediate Excel for Administrator and Professional Elegant Training Center
50% Off for Laimoon Users! Get This Deal
Price: AED 900
AED 1,800
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.
  • Other Location: Al Barsha - Dubai
  • Duration / Course length: Upto 12 Hours
  • Timings: Flexible

Course details

Microsoft Excel Intermediate:

Course Outline:
 
1.    Performing Calculations

  • Naming groups of Data using Named Ranges
  • Creating Formulas to Calculate Values
  • Summarizing data meets specific condition
  • using If function
  • Formula Auditing
  • Adding a watch Window o Tracing Formula Errors
  • Tracing Precedents and Dependent cells

2.    Changing Workbook Appearance

  • Defining Styles
  • Making Numbers easier to read
  • Transposing data
  • Changing Cell Orientation and Merging Cells
  • Change appearance of data based on its value
  • Focusing on specific data by using filters
  • Inserting Filters
  • Sort A to Z using Filters o Number Filters
  • Clear Filters
  • Advanced Filtering (Criteria Range) o Summarizing worksheets with hidden and filtered rows (subtotal and aggregate functions)
  • Data Validation 

3.    Reordering and Summarizing Data

  • Sort Data
  • Custom Lists
  • Organizing data into levels using subtotals 
  • Creating an outline
  • Lookup Functions

4.    Combining Data from Multiple Sources 

  • Using Excel's Built-in Templates
  • Using workbooks as templates for other workbooks
  • Linking to data in other workbooks
  • Consolidating data
  • Saving workbooks as a workspace
  • Comments in cells and workbooks
    • Viewing Comments in a worksheet
    • Adding and Removing comments
    • Adding comments to a workbook
  • Protection 
  • Password protect a worksheet and workbook
  • Unlock cells and protecting part of a worksheet
  • Track Changes
  • Mark a workbook as final

 

 
 
 
 
 
 

Updated on 30 September, 2024

Eligibility / Requirements

- Basic knowledge of Computer and Internet.

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.