MS Office - Advanced MS Excel Al Mihad Training Centre

Course Details:
Some of the things that you learn in the course include:
·         An Overview of the Excel.
·         Using Templates and Workbooks
·         Advanced Formulas and Functions in Excel
·         Multiple Sorting & Advanced Filter Functions
·         Common Text and Numeric Functions
·         Working with Cells, Sheets and Workbooks
·         Working with Conditions
·         Naming Cell Ranges and Miscellaneous Functions
·         Lookup Functions: (Lookup, Vlookup, Hlookup)
·         Tips and Tricks for Advanced Visualizations In
·         Waterfall Chart in Excel.
·         Data Management Features
·         Protecting a Worksheet and Setting Permissions
·         Data Management and Analysis Tools in excel
·         Working with Dates and Times
·         Highlight Rows Based on a Cell Value in Excel
·         Forecast with scenarios using what-if analysis
·         Creating Formulas for Financial Applications
·         Loan calculation in Excel
·         Getting Data from Other Programs
·         Automating Activities by Using Macros
·         Build Interactive Excel Dashboards
·         Implementation of Power Pivot
·         Advanced Reports and Data Visualizations Using power pivot and power view.
Objectives of Advanced Excel training course:
·         Work with valid function in Excel
·         Utilize a range of data validation practices
·         Comprehend and build PivotTables
·         Build and employ definite names in a workbook
·         Import and export of data from and into Excel
·         Execute a range of logical tasks using PowerPivot
·         Create recorded macros in Excel
 
 

This course is no longer available.

MS Office - Advanced MS Excel Al Mihad Training Centre
Price: AED 750
Instructor led live virtual classroom online. Classes may be individual or in group.
  • Location: Sharjah
  • Duration: Upto 35 Hours

    Course details

    Course Details:
    Some of the things that you learn in the course include:
    ·         An Overview of the Excel.
    ·         Using Templates and Workbooks
    ·         Advanced Formulas and Functions in Excel
    ·         Multiple Sorting & Advanced Filter Functions
    ·         Common Text and Numeric Functions
    ·         Working with Cells, Sheets and Workbooks
    ·         Working with Conditions
    ·         Naming Cell Ranges and Miscellaneous Functions
    ·         Lookup Functions: (Lookup, Vlookup, Hlookup)
    ·         Tips and Tricks for Advanced Visualizations In
    ·         Waterfall Chart in Excel.
    ·         Data Management Features
    ·         Protecting a Worksheet and Setting Permissions
    ·         Data Management and Analysis Tools in excel
    ·         Working with Dates and Times
    ·         Highlight Rows Based on a Cell Value in Excel
    ·         Forecast with scenarios using what-if analysis
    ·         Creating Formulas for Financial Applications
    ·         Loan calculation in Excel
    ·         Getting Data from Other Programs
    ·         Automating Activities by Using Macros
    ·         Build Interactive Excel Dashboards
    ·         Implementation of Power Pivot
    ·         Advanced Reports and Data Visualizations Using power pivot and power view.
    Objectives of Advanced Excel training course:
    ·         Work with valid function in Excel
    ·         Utilize a range of data validation practices
    ·         Comprehend and build PivotTables
    ·         Build and employ definite names in a workbook
    ·         Import and export of data from and into Excel
    ·         Execute a range of logical tasks using PowerPivot
    ·         Create recorded macros in Excel
     
      Updated on 05 April, 2023

    Eligibility / Requirements

    Knowledge on operating system and understand basic language.

    Job roles this course is suitable for:

    adminstrator , it adminstrator , data entry

    About Al Mihad Training Centre

    Al Mihad is a leading training company offering professional and corporate training in MENA for the last 17 years. Having its focus on financial training, AMT is rapidly growing in trainings areas related to Strategy & Innovation, Human Resource, Sales & Marketing, Customer Relationship Management, Supply Chain Management, Financial Modelling & Excel, customized banking programs and in-house trainings program related to CMA, CIA, CIMA, Diploma & Certificate in IFRS for corporate clients.

    See all Al Mihad Training Centre courses
    Courses you can instantly connect with... Do an online course on Office Management starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or