Publish Your Free AD

Advanced Excel training in Dubai - Regular / Weekend Classes Bur Dubai

Computer Classes Karama, Bur Dubai, Dubai, United Arab Emirates
Check with seller  

Description

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 Syllabus
Advanced Functions and Formulas
HLOOKUP, INDEX & MATCH)
Working with Data Ranges
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
Working with the Web and External Data
Working with Macros
info@laurelsinstitute.com or call us : 04 3969124 / 50 5572242


More information

Views 144
Listing id 52483
Post date 10/01/2019 3:44 PM