۳۱ فروردين ۹۷ ، ۱۱:۰۰
سرفصل مطالبی که در اکسل 2013 باید بدانیم
سرفصل مطالبی که در اکسل 2013 باید بدانیم:
Introduction
o Self-Service Business Intelligence
o What is PowerPivot
o What is a PivotTable
o First Steps with PowerPivot
o Example with PowerPivot
PowerPivot Concepts
o Formatting Numbers
o Understanding Calculated Columns
o Using Lookup Tables
o Understanding Calculated Fields
o Handling Many Tables
o Refreshing Data
o Using Slicers
Loading Data
o Understanding Data Connections
o Loading Tables from SQL Server
o Loading from Access
o Using Linked Tables
o Loading from Excel Workbooks
o Loading from Text Files
Power View
o Creating a Power View Report
o Inserting New Views in Power View
o Type of Charts & Maps
o Applying Filters to Power View Reports
o Creating Tiles
Shaping Reports
o Defining KPIs
o Creating Hierarchies
o Properties for Power View Reports
o Named Sets in Excel
o Drill-through with PowerPivot
Introduction to DAX
o Calculation Foundations
o Calculated Columns Examples
o Calculated Fields Examples
o Choosing Between Calculated Columns and Calculated Fields
o Common DAX Functions Examples
DAX Patterns
o Banding in PowerPivot
o New and Returning Customers
o Many-to-Many Relationships
o Merge Values from Different Tables
