Excel 2013 - Level 3 هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

Work with advanced formulas and lookup functions. Advanced data filtering & apply advanced chart formatting. PivotTables & Charts, export/ import data and external databases. Analytical features and create scenarios. Run/record macros. Explore VBA code.

Course Outline

1 - Advanced functions and formulas

• Logical functions
• Conditional functions
• Financial functions
• Text functions
• Date functions
• Array formulas

2 - Lookups and data tables

• Using lookup functions
• Using MATCH and INDEX
• Creating data tables

3 - Advanced data management

• Validating cell entries
• Advanced filtering

4 - Advanced charting

• Chart formatting options
• Combination charts
• Graphical objects

5 - PivotTables and Pivot Charts

• Working with PivotTables
• Rearranging PivotTables
• Formatting PivotTables
• PivotCharts

6 - Exporting and importing data

• Exporting and importing text files
• Getting external data

7 - Analytical tools

• Goal Seek
• Scenarios

8 - Macros and Visual Basic

• Running and recording a macro
• Working with VBA code

Target Audience: This course is intended for students who want to further build on the acquired skills from Level 1 and Level 2 Excel 2013 classes.