وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Excel Pivots & Dashboards (Basic to Super Advance)

سرفصل های دوره

Data Analysis, Summary Reports, Dashboards using Advance Pivots - Super Advance knowledge coming in your way.


1. Introduction to PIVOTS - Let us Begin from Basics
  • 1. A quick demo- What you are going to Learn
  • 2. Introduction to Pivots - Creating Pivots

  • 2. Most important and Used Pivot Features for Data Analysis & Reporting
  • 1. Subtotals, Layouts, Selecting fields to Color - Pivot Features - Deep Dive
  • 2. More Features - Insert Blank Lines, Item Labels, Grand Totals
  • 3. Sorting the Pivot Fields
  • 4. Identify the fields to be Sorted
  • 5. Date Group - Must know feature for dashboards
  • 6.1 PivotFiles.zip
  • 6. GetPivotData function - Not many of us know this. Very Useful

  • 3. Calculate Percentages of one item over others - Hidden Features to be explored
  • 1. Calculate the Contributions on Process level, Sub Levels - Incredible Pivots
  • 2. More Contribution Percentages - Deep dive
  • 3. Calculate Difference between previous and next Fields and much more
  • 4. Ranking - Asc or Dsc order - Hidden Pivot feature

  • 4. Pivot SLICERS - Game Changing factor
  • 1. Slicers in Pivots- Let us take a deep dive into it
  • 2. Sorting in SLICERS
  • 3. Amazing Features of SLICERS - hide or show unwanted Fields
  • 4. Remove Slicer field if no data available - Just loving it
  • 5. Design the way you want - SLICER Colors Customizations - My favourite
  • 6. Report Connection - Linking or de-linking of Slicer with Pivots - Must know

  • 5. Pivot CHARTS - Graphs are possible in Pivots
  • 1. Create Pivot Charts - For Dashboards

  • 6. Make Dashboards now -Finally wait is over & time to implement everything learnt
  • 1. Dashboard Making - Let us Begin
  • 2. Finishing the Dashboard

  • 7. Time to Check your Scorecard by doing these Assignments-Solutions given also
  • 1.1 PivotsSolutions1.xlsx
  • 1.2 PivotsSolutions2.xlsx
  • 1.3 pvt questions.txt
  • 1. Assignment Solutions - Refer to assignment text file for questions
  • 2. Assignment Discussion Continue
  • 3. Assignments Continues
  • 4. Assignments - More questions
  • 5. More exercises - Let us solve more questions
  • 6. Exercises still continues
  • 7. More practice More power in data analytics
  • 8. My other Courses with links.html
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 36587
    حجم: 3793 مگابایت
    مدت زمان: 433 دقیقه
    تاریخ انتشار: 25 اردیبهشت 1403
    دسته بندی محصول
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید