Advanced Excel Training / classes in Dubai

Who is this course for?
This course is intended to end users who want to develop their skills, so they can use advanced techniques to Analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros.

Course Objectives
At the end of this course you will be able to:
• Work with advanced lookup and reference functions
• Create macros to automate common tasks
• Use advanced techniques to Analyse data
• Create PivotTables and Pivot Charts
• Work with data validation tools
• Import and export data
Course Syllabus
The Microsoft Excel Advanced course is split into the following modules:
Advanced Functions and Formulas
• Formulas with Multiple Operators
• Inserting and Editing a Function
• Auto Calculate and Manual Calculation
• Cell and Range Names
• Displaying and Tracing Formulas
• Understanding Formula Errors
• Using Financial Functions (PMT & FV)
• Using Logical Functions (IF, NESTED IFs, AND &OR)
• Using Lookup & Reference Functions (VLOOKUP, HLOOKUP, INDEX & MATCH)
• Using Text Functions (CONCATENATE, UPPER, LOWER, PROPER, LEFT, RIGHT & MID)
• Using Date and Time Functions (TODAY, NOW & DATEIF)
Working with Data Ranges
• Creating a Custom AutoFill List
• Applying Conditional Formatting
• Creating and Managing Conditional Formatting Rules
• Sorting by a Custom List
• Filtering Data
• Creating a Custom AutoFilter
• Using an Advanced Filter
• Using Data Validation
Organizing and Analyzing Data
• Creating Scenarios
• Creating a Scenario Summary Report
• Working with Data Tables
• Using Goal Seek
• Using Solver
• Using Flash Fill
• Using Text to Columns
• Grouping and Outlining Data
• Using Subtotal
• Consolidating Data by Position or Category
• Consolidating Data Using Formulas
• Sharing a Workbook
• Track changes
• Comparing and Merging Workbooks
Working with PivotTables
• Creating a PivotTable
• Specifying PivotTable Data
• Using Multiple PivotTable Fields
• Changing a PivotTable’s Calculation
• Filtering and Sorting a PivotTable
• Working with PivotTable Layout
• Grouping PivotTable Items
• Updating a PivotTable
• Formatting a PivotTable
• Creating a PivotChart
• Using Slicers
• Sharing Slicers Between PivotTables
• Creating Relationships between Tables
Working with the Web and External Data
• Inserting a Hyperlink
• Importing Data from a Text File and an n Access Database
• Importing Data from Web
• Working with Existing Data Connections
Working with Macros
• Recording a Macro
• Playing and Deleting a Macro
• Adding a Macro to the Quick Access Toolbar


Why laurels training institute?
1) Expert & Certified Trainers.
2) Practical Approach.
3) Case study-based approach to individuals.
4) Individual desktops for hands-on experience.
5) Study materials.
6) Live examples for hands on practice and experience.
7) Assignments.
8) Real-world examples.
9) Sample sheets, exercise files and quizzes.
10) KHADA approved certification training.

OTHER COURSES: 
Microsoft office | Advanced Excel | Tally ERP | Quickbook | Peachtree | Graphic Designing | Web Designing | Hardware & Networking | MCSA | MCSE | CCNA | CCNP | AutoCAD 
We design all our programs to meet our client’s challenges by gaining an in-depth understanding of an organization’s culture.
Contact us for more information mail us: or call us : 04 3969124 / 50 5572242

Course Syllabus
The Microsoft Excel Advanced course is split into the following modules:
Advanced Functions and Formulas
• Formulas with Multiple Operators
• Inserting and Editing a Function
• Auto Calculate and Manual Calculation
• Cell and Range Names
• Displaying and Tracing Formulas
• Understanding Formula Errors
• Using Financial Functions (PMT & FV)
• Using Logical Functions (IF, NESTED IFs, AND &OR)
• Using Lookup & Reference Functions (VLOOKUP, HLOOKUP, INDEX & MATCH)
• Using Text Functions (CONCATENATE, UPPER, LOWER, PROPER, LEFT, RIGHT & MID)
• Using Date and Time Functions (TODAY, NOW & DATEIF)
Working with Data Ranges
• Creating a Custom AutoFill List
• Applying Conditional Formatting
• Creating and Managing Conditional Formatting Rules
• Sorting by a Custom List
• Filtering Data
• Creating a Custom AutoFilter
• Using an Advanced Filter
• Using Data Validation
Organizing and Analyzing Data
• Creating Scenarios
• Creating a Scenario Summary Report
• Working with Data Tables
• Using Goal Seek
• Using Solver
• Using Flash Fill
• Using Text to Columns
• Grouping and Outlining Data
• Using Subtotal
• Consolidating Data by Position or Category
• Consolidating Data Using Formulas
• Sharing a Workbook
• Track changes
• Comparing and Merging Workbooks
Working with PivotTables
• Creating a PivotTable
• Specifying PivotTable Data
• Using Multiple PivotTable Fields
• Changing a PivotTable’s Calculation
• Filtering and Sorting a PivotTable
• Working with PivotTable Layout
• Grouping PivotTable Items
• Updating a PivotTable
• Formatting a PivotTable
• Creating a PivotChart
• Using Slicers
• Sharing Slicers Between PivotTables
• Creating Relationships between Tables
Working with the Web and External Data
• Inserting a Hyperlink
• Importing Data from a Text File and an n Access Database
• Importing Data from Web
• Working with Existing Data Connections
Working with Macros
• Recording a Macro
• Playing and Deleting a Macro
• Adding a Macro to the Quick Access Toolbar


Why laurels training institute?
1) Expert & Certified Trainers.
2) Practical Approach.
3) Case study-based approach to individuals.
4) Individual desktops for hands-on experience.
5) Study materials.
6) Live examples for hands on practice and experience.
7) Assignments.
8) Real-world examples.
9) Sample sheets, exercise files and quizzes.
10) KHADA approved certification training.

OTHER COURSES: 
Microsoft office | Advanced Excel | Tally ERP | Quickbook | Peachtree | Graphic Designing | Web Designing | Hardware & Networking | MCSA | MCSE | CCNA | CCNP | AutoCAD 
We design all our programs to meet our client’s challenges by gaining an in-depth understanding of an organization’s culture.
Contact us for more information mail us: or call us : [email protected]  04 3969124 / 50 5572242

Total Hours:

20