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 تومان

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

خرید دانلودی فوری

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

تولید کننده: Udemy