MS Office - Advanced MS Excel Al Manal Training Center
Price: USD 408
USD 1,020
Instructor led live virtual classroom online. Classes may be individual or in group.
  • Duration: Upto 30 Hours

Course details

Course Curriculum:

  • Outline of Excel Environment
  • Usage of Shortcuts
  • Developments and Scenarios utilizing charts
  • Guidelines and Techniques to improve dashboard designing
  • Overview of VBA
  • Getting Started with PivotTables
  • User Defined Function
  • Error Handling
  • Slicers
  • Using Custom AutoFill Lists
  • DBMS - SQL (VIDEO-BASED)
  • SQL Fundamentals
  • Manage Macros
  • Comprehending RDBMS concept
  • Data Forms
  • Outlining and Grouping Data
  • Special Features for Filtered Lists
  • Splitting Windows
  • Analysis tool pack
  • Building your worksheet interactive by utilizing actions
  • Goal Seek and Data Tables
  • Visual Basic and Macros
  • Identifying Records Using Criteria
Course Overview:

  • You will be capable enough to break the complex applications down into basic steps.
  • Utilizing advanced graphs in minutes and complete the work as a substitute to killing hours to figure out.
  • Students will be able to improve interaction by automating spreadsheets.
  • You can easily answer difficult problems with superpower functions.
  • You will be able to turn raw data into decisions by leveraging PivotTables.

Updated on 20 June, 2021

About Al Manal Training Center

Al Manal Training Institute is one of the finest training institutes now available in Abu Dhabi, UAE. We are presently offering coaching on a range of educational courses! Some of them are: Test Preparations, Healthcare and Medical,, Softskills, Microsoft Courses, Accounting Courses, Language Courses, Management Courses, CAD and Engineering Courses, Designing Courses, etc. We have experts who have tons of expertise in their respective fields and can help you master any course effectively. We also provide individualized training to the students to make them understand each level of training successfully.

Our training batches have limited number of students too because it assists students to resolve their queries then and there which will help them in quick learning of the course. Our training is very intense and at the same time very friendly. We do offer training in such a way that the students get placed and get their dream IT job! Many students choose us because we are offering quality training at affordable price range compared to our competitors, which
has played a key role in our success.

See all Al Manal Training Center courses
Courses you can instantly connect with... Do an online course on Microsoft Certified starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or