MS Office - Advanced MS Excel Al Mihad Training Centre
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.
- 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.
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 coursesOffice Management Related Questions
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Excel Spreadsheet Diploma The Teachers TrainingAED 46Duration: Upto 2 Hours
- Business Administration Level 2 Course CentralAED 83
AED 514Duration: Upto 1 Hour