Microsoft Excel Pivot Tables – Master Excel Pivot Tables!

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

Excel with Microsoft Excel Pivot Tables & Data Analysis - Excel 2010, Excel 2013, Excel 2016, Excel 2019, Office 365

1. FREE EXCEL PIVOT TABLE RESOURCES

1. FREE EXCEL PIVOT TABLE RESOURCES.zip

2. EXCEL PIVOT TABLES

1. Introduction

2. Why Most People Dont Know How To Use Excel Pivot Tables

3. Tabular Format & Excel Tables

4. Creating an Excel Pivot Table

5. Formatting an Excel Pivot Table

6. Summarize Values By

7. Show Values As

8. Grouping

9. Slicers

10. Excel Pivot Charts

11. Creating an Interactive Excel Dashboard with Slicers & Pivot Charts

12. BONUS Pivot Table Tips & Tricks!

13. Course Review

3. BONUS VIDEOS

1.1 Pivot Table Webinar Course - Bonus Video Workbooks.zip

1. DOWNLOADABLE EXCEL WORKBOOKS.html

2. Show the Classic Pivot Table Layout

3. Show various Grand Totals

4. Actual v Plan Variance Report

5. Group two pivot tables independently

6. Sort manually

7. Filter by Text wildcards and

8. Different ways to filter a Slicer

9. Excel formulas & Calculated Fields

10. Data Bars, Color Scales & Icon Sets

11. Create a custom report with GETPIVOTDATA

12. Different pivot table views macro

4. EXCEL BUSINESS CASE STUDIES

1.1 8.16 Actual v Plan with Calculated Fields .xlsx

1.2 Data Source.pdf

1. CASE STUDY #1 Sales Actuals v Plan with Calculated Fields

2.1 9.21 Pivot Table Slicer & Chart Dashboard .xlsx

2.2 Data Source.pdf

2. CASE STUDY #2 Slicer & Pivot Chart Excel DASHBOARD

3.1 14.6 Interactive Balance Sheet Pivot Table .xlsx

3.2 Data Source.pdf

3. CASE STUDY #3 Interactive Balance Sheet Excel Pivot Table

5. QUIZZES & PRACTICE ACTIVITIES!

1. Recognize which button is used to update a Pivot Table.html

2. Recall the way to change a Count Of to a Sum Of.html

3. Identify the steps to showing the values as a Year to Date.html

4. State which command is used to group a PivotTable report by weeks.html

5. Recall the way to connect a Slicers to Pivot Tables.html

6.1 1. SETTING UP YOUR PIVOT TABLES.pdf

6.2 Homework.1.xlsx

6. HOMEWORK CREATE A PIVOT TABLE.html

7.1 2. SUMMARIZE VALUES BY.pdf

7.2 Homework.2.xlsx

7. HOMEWORK SUMMARIZE VALUES BY.html

8.1 3. SHOW VALUES AS.pdf

8.2 Homework.3.xlsx

8. HOMEWORK SHOW VALUES AS.html

9.1 4. GROUPING.pdf

9.2 Homework.4.xlsx

9. HOMEWORK GROUPING.html

10.1 7. SLICERS.pdf

10.2 Homework.7.xlsx

10. HOMEWORK SLICERS.html

11. Create a Pivot Table Dashboard.html

6. BONUS THE MYEXCELONLINE ACADEMY!

1. Thank You & Course Review!

2. Get our other 5 TOP RATED Udemy courses at a HUGE DISCOUNT!.html

3. Microsoft Excel E-Books.html

139,000 تومان

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

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

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

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