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

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

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

Lesson

Lesson 1: Customizing the Excel Environment

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

Lesson 2: Creating Advanced Formulas

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

Lesson 3: Analyzing Data with Functions and Conditional Formatting

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

Lesson 4: Organizing and Analyzing Datasets and Tables

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

Lesson 5: Visualizing Data with Basic Charts

• Create Charts 
• Modify and Format Charts 

Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts

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