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

<< آنالیز های آماری در اکسل Statistical Analysis Using Excel آموزش طراحی جداول و نمودار ها در اکسل Excel 2013 Dashboard Design >>
آموزش تخصصی و کاربردی اکسل با MrExcel
نویسنده و تهیه کننده MR Excel-Bill Jelen
امتیاز جایزه: 0
قیمت: 0 تومان

برای داشتن مجموعه یکپارچه با کمترین هزینه پرداختی فروشگاه اینترنتی آفیس، کلیه آموزش ها را به صورت کامل با کمترین قیمت ممکن در اختیار علاقه مندان قرار می دهد.

در حال حاضر این مجموعه شامل:

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

آموزش تخصصی PivotTables, PowerPivot, Power View, GeoFlow با MrExcel

آنالیز های آماری در اکسل Statistical Analysis Using Excel

آموزش تصویری اکسل 2007 توسط MR Excel

آموزش برنامه نویسی اکسل توسط MR Excel Macros&VBA

Pragmatic Self-Service BI with PowerPivot for Excel-Pluralsight
This course will start from scratch, and take you through intermediate PowerPivot concepts pragmatically. You’ll soon be assembling data from diverse sources into models that deliver business intelligence upon demand.
Use PowerPivot for Excel to deliver self-service business intelligence! This course will start from scratch, and take you through intermediate PowerPivot concepts pragmatically. You’ll soon be assembling data from diverse sources into models that deliver business intelligence upon demand. Throughout the rapid but practical exercises, you will gain exposure to accessing and relating data, and to employing the Data Analysis Expressions (DAX) language, to construct and share PowerPivot applications that support analysis and reporting throughout the enterprise

Introduction to Microsoft Business Intelligence End-user Tools-Pluralsight
Are you confused by the fact, that there is not one End-User Tool for BI, but there are many from Microsoft? In spite of the fact that Microsoft decided in 2009 not to build further reporting-tools (but to consolidate the actual portfolio instead) a whole bunch of tools are available and are leading to some confusion through the users: Excel, PowerPivot, Report Builder & Report Designer (Reporting Services), Dashboard Designer (PerformancePoint Services) and Power View. You will take a lap around all of these tools and you will learn when to use which. In this demo-heavy course, the very same report will be built with each of these tools so you can see the strengths and weaknesses of each of them with your own eyes. After finishing the modules, you will be armed with the knowledge to decide which of the tools fits your end-users the best

VBA Fundamentals-Pluralsight
This course will help developers of any level get the most out of the Visual Basic for Applications (VBA) environment. Starting with the development environment and working through various aspects of the language, you will learn the tools and techniques needed to build custom solutions for WeiRuan-->WeiRuan Office

PowerPivot for Microsoft Excel 2010-Pluralsight

Learn how to use Microsoft PowerPivot to do self service Business Intelligence. This course will guide you through importing data, working with it, then creating pivot tables and charts all in Excel 2010

Excel 2013 Dashboard Design

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

Power Excel 2013 with MrExcel LiveLessons

 


Power Excel 2010 with MrExcel LiveLessons

 


Excel An Analytics Superhub

 


Predictive Excel

 

 

کلیه آموزش هایی که توسط MrExcel صورت بگیرد به مجموعه افزوده خواهد شد

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