Elegant Training Center Intermediate Excel for administrator and Professional Elegant Training Center
50% off through Laimoon! 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: Flexible

    Course details

    Microsoft Excel Intermediate
     
    1.    Performing Calculations
    1. Naming groups of Data using Named Ranges
    2. Creating Formulas to Calculate Values
    3. Summarizing data meets specific condition
    4. using If function
    5. Formula Auditing
    • Adding a watch Window o Tracing Formula Errors
    o  Tracing Precedents and Dependent cells
    1. 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
    o  Clear Filters
     
    o 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 12 May, 2020

    Eligibility / Requirements

    Basic knowladge of computer and internet

    About Elegant Training Center

    Elegant Professional and Management Development is a leading training center in Al Barsha, Dubai, specialized in affordable and effective face-to-face training programs in variety of courses like Engineering & IT, Finance, Sales & Marketing and HR & Administration.
     
    We design and customize courses and program for people of different walks 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

    See all Elegant Training Center courses

    Enquire about this course

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

    Rate this page