+971 56 731 2942 , +971 04 298 9926

MS Excel - Advance Level

Lesson 1: Automating Worksheet Functionality 
• Update Workbook Properties
• Create and Edit a Macro
• Apply Conditional Formatting
• Add Data Validation Criteria

 

Lesson 2: Auditing Worksheets

• Trace Cells
• Troubleshoot Invalid Data and Formula Errors
• Watch and Evaluate Formulas
• Create a Data List Outline

 

Lesson 3: Analyzing Data
• Create Spark lines
• Create Scenarios
• Perform a What-If Analysis
• Perform a Statistical Analysis with the Analysis Tool Pack

 

Lesson 4: Working with Multiple Workbooks 
• Create a Workspace
• Consolidate Data
• Link Cells In Different Workbooks
• Merge Workbooks

 

Lesson 5: Building a PivotTable
• Insert a PivotTable
• Create a PivotTable Based on External Data
• Categorize PivotTable Data
• Customize a PivotTable

 

Lesson 6: Analyzing Data Using Pivot Tables
• Create Custom Calculations in a PivotTable
• Restructure a PivotTable

Lesson 7: Presenting PivotTable Data Visually
• Format a PivotTable
• Present a PivotTable in a Pivot Chart
• Print PivotTables and Pivot Charts

 

Lesson 8: Exporting Excel Data
• Export Excel Data
• Import a Delimited Text File
• Integrate Excel Data with the Web
• Create a Web Query

 

Lesson 9: Examining Data Using Math Functions
• Analyze Sales Data Using Math Functions

 

Lesson 10: Manipulating Data Using Text and Information Functions
• Manipulate Data Using Text Functions
• Validate Data Using Information Functions

 

Lesson 11: Working with Templates and Charts
• Create Advanced Templates
• Create Advanced Charts

 

 

Lesson 12: Managing Data in Workbooks
• Retrieve and Paste Data
• Clean Data in Workbooks

Online Assessment Test

Testimonials

Download Here


download_profile