X

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

Home UAE Courses Microsoft Excel Advanced Excel Training Course
Advanced Excel Training Course AMCC Institute
See all similar courses Start a new search

Advanced Excel Training Course

AMCC Institute

Add to wishlist
Price: AED 1,200
  • Location: Deira - Dubai
  • Duration: 20 Hours
  • Timings: Part Time, Flexible

Course details

Advanced MS Excel Training:

This course contains Practical Work involving Practical Hands-on, Lab Assignments, and Real World Case Studies. This practical work can be done at your own pace. AMC Institute provides the best Excel training services you ever had !!

What we provide:
  • Real-time Project oriented training
  • Experienced and Certified Trainer
  • Customized training materials
  • Recorded videos of complete training sessions
  • Certificate of Completion approved by Ministry of Education
Course Outline:
  • Workbooks (File) & Worksheet Handling
    • Excel Limitation
    • Excel Shortcut use and benefits
    • Excel Setting and Custom List Creation
    • Excel Template and File Location System
    • Advanced Paste Special
    • Calculation with Paste Special
    • Link Data range as Picture Link
  • Advanced Formatting for Reports and Dashboard
    • Formatting Tricks
    • Date & Time Format
    • Advanced Custom Formatting (Number Format using Code)
    • Conditional Formatting
    • Advanced Conditional Formatting using Formulas
    • File, Sheets or Cells Protection Method
  • Data Handle and Data Analysis
    • Data Fill and Selection Method
    • Advanced Sorting and Filter
    • Data Summarization with Pivot Table
    • Calculation with Pivot table
    • External Data Pivot Table
    • Timeline and Slicer in Pivot Table
    • Power Pivot in Excel 2016
  • Calculation (more than 200 Formulas)
    • Formula basics for Advance Level Formulas
    • Logical Formulas (IF, and, Or, IfError Formulas)
    • Nested If Formulas ( Multi Condition in If,and,or )
    • Text and Advanced Text Formulas
    • Date and Time Calculation using Data Time Formulas
    • Ref# Formulas and VLookup
    • Lookup Method(VLookup,HLookup,Match,Index,Offset)
    • Advanced VLookup and VLookup Listing
    • Math & trigno. Formulas
    • Data Summarization Formulas
    • Averageif,Averageifs,Countif,Countifs,Large,Small
    • Database and list management Formulas
    • Information Formulas
    • Financial Formulas
  • Advanced Formulas
    • Advanced Array Formulas
    • Complicated Large Formulas Creation
    • Advanced Naming Method with Formulas
    • Report Automation with Formulas
  • Dashboard Report Automation
    • Chart Creation
    • Chart Tricks
    • Dynamic Chart with Offset Formulas
    • Dashboard Example
Why we are different:

We provide classroom training (face-to-face) with theory and practicals. Training material & recorded sessions of classroom videos for practice and free revision of course any time in our any future batch makes us different from other institutes. Updated on 02 July, 2019

Job titles this course is suitable for

This program is best suited for people who use Microsoft Excel in their day-to-day work , and know the basics fairly well , knowledge of the basics of Excel , including how to create , edit , format , and print worksheets that include charts , sorting and filtering data , but would like to extend their knowledge of the more advanced functions of Excel to become more productive and make the most of Excel.The course is designed for professionals would want to learn more complex formulas , troubleshoot and customize Excel application , Automate Excel Files and Create Dashboards how sort and filter more specific data , import and export data sets , analyze data using the rich features provided in Excel. It will impart the necessary skills to create macros.

Job roles this course is suitable for:

Assistant Front Office Manager , Office Manager , Instrutor de Excel

Course Location

Show map Location Deira - Dubai

About AMCC Institute

We are committed to excellence and total creativity, providing an atmosphere of cooperative learning methodologies that are inter personal,inter active and rich with application relevant to everyday workplace situations. We raise corporate teams beyond the mundane, to higher planes of awareness, alertness, and communication through a multi modal approach, involving trust building, co-operative interaction and dividua leadership skill development.

See all AMCC Institute courses
Ask Laimoon
View more similar courses
See all current Secretary and Administration jobs in UAE
Courses you can instantly connect with... Do an online course on Microsoft Excel starting now. See all courses
See all similar courses

Is this the right course for you?

Didn't find what you were looking for ?

Try searching for it!
or
Browse Microsoft Excel Courses in the UAE Courses

Not sure which courses to take? LET US GUIDE YOU