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

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

Students will build upon the foundational Microsoft® Office Excel® 2013 knowledge and skills already acquired and learn to create advanced workbooks and worksheets, including advanced formulas, tables, PivotTables, PivotCharts and data filtering.

Course Outline

1 - Customizing the Excel Environment

• Configure Excel Options 
• Customize the Ribbon and the Quick Access Toolbar 
• Enable Excel Add-Ins

2 - Creating Advanced Formulas

• Use Range Names in Formulas
• Use Specialized Functions 
• Use Array Formulas

3 - Analyzing Data with Functions and Conditional Formatting

• Analyze Data by Using Text and Logical Functions 
• Apply Advanced Conditional Formatting

4 - Organizing and Analyzing Datasets and Tables

• Create and Modify Tables
• Sort Data
• Filter Data
• Use SUBTOTAL and Database Functions

5 - Visualizing Data with Basic Charts

• Create Charts 
• Modify and Format Charts

6 - Analyzing Data with PivotTables, Slicers, and PivotCharts

• Create a PivotTable 
• Analyze PivotTable Data 
• Present Data with PivotCharts 
• Filter Data by Using Slicers

Target Audience: This course is designed for students who already have foundational knowledge and skills in Excel 2013 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Related Certifications:

• Microsoft Office Specialist (MOS): Excel 2013
• Microsoft Office Specialist (MOS): Excel 2013 Expert
• Microsoft Office Specialist (MOS): Excel 2013 Expert
• Microsoft Office Specialist on Microsoft Office 2013

Related Exams:

• Microsoft Office Specialist for Excel 2013
• Excel 2013 Expert Part One
• Excel 2013 Expert Part Two