آموزش طراحی جداول و نمودار ها در اکسل Excel 2013 Dashboard Design

<< آموزش تخصصی و کاربردی اکسل با MrExcel

طراحی جدول و نمودار حرفه ای در اکسل 2013 Excel 2013 Dashboard Design

 

کلاس های آنلاین اکسل کاربردی

فروشگاه اینترنتی آفیس پیشنهاد می کند قبل از خرید این محصول "آموزش تخصصی و کاربردی اکسل با MrExcel" را مطالعه و تهیه نمایید.زیرا محصولی کاملتر با هزینه کمتر به دست شما خواهد رسید.

Master the dashboard planning and design process by incorporating feedback from your audience, setting yourself up for success
Import data from your SQL or Access Database, or another spreadsheet, so that you can utilize all the relevant data in your dashboard
Implement PowerPivot as a flexible aggregation point for all your data, creating a bridge between Excel and your data sources
Utilize PivotTables to aggregate, slice, and present data exactly how your audience needs to see it
Deploy PivotCharts to effectively illustrate trends and metrics to your audience
Stylize and enhance your dashboard with conditional formatting and SparkLines to quickly communicate KPIs to your stakeholders
Add interactive features that put your audience in control of the data that they see, allowing them to drill down and focus on what is important to them
Quickly create a sleek and powerful dashboard using the new Power View feature
Explore the publishing options for your dashboard and deploy it using the most effective medium for your audience



Table of Contents
Dashboard Outputs and Inputs 16:39 mins

    Beginning with the End in Mind
    Empowering your Audience
    Connecting to MS Access
    Connecting to MS SQL Server
    Using Data in your Excel Sheet


Working with Pivot Tables 15:47 mins

    Importing Data into PowerPivot
    Adding Data from Excel to PowerPivot
    PowerPivot Relationships and Hierarchy
    Creating Calculated Fields
    Implementing KPIs


Constructing Your Framework 21:47 mins

    Constructing PivotTables (part 1)
    Constructing PivotTables (part 2)
    PivotTable Formatting and Options
    PivotTable Design and Layout
    Adding a Calculated Field and KPI


Stylizing Your Data 19:04 mins

    Creating a PivotChart
    Customizing a PivotChart
    Creating a Combo Chart
    Customizing a Combo Chart
    Creating Text-Highlight Cells


Adding Interactivity 24:45 mins

    Formatting the Dashboard Sheet
    Referencing a PivotTable
    Conditional Formatting
    Implementing Sparklines
    Enhancing Sparklines Using Named Ranges


Utilizing Power Pivot 16:38 mins

    Implementing Slicers
    Customizing Slicers
    Employing Timelines
    Utilizing Hyperlinks


Implementing Power View 15:29 mins

    Creating a Power View
    Adding Drill-Downs in Power View
    Using Filters in Power View
    Implementing Tiles in Power View
    Visualizing Multiples in Power View

Publishing Your Dashboard 22:38 mins

    Cleaning Up & Locking Down
    Backwards Compatibility and SharePoint Distribution
    Sharing on Microsoft SkyDrive
    Publishing on Office 365 SharePoint
    Printing and Exporting to PDF

مشخصات
زبان آموزش انگلیسی
مدت زمان آموزش 2:32
ویرایش 2013
نوع تصویری(Multimedia)
تعداد DVD 1
سطح مقدماتی-متوسط-پیشرفته-حرفه ای
هزینه حمل دارد
اوپن کارت فارسی
فروشگاه اینترنتی محصولات آموزشی آفیس © 2016