Okebiz Video Search



Title:Master Excel Pivot Tables in ONLY 1 HOUR!
Duration:01:04:15
Viewed:701,346
Published:09-06-2015
Source:Youtube

In this Pivot Table Excel tutorial you will learn how to use & create a Pivot Table in Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365 - for Beginners or Advanced users. DOWNLOAD THE FREE PRACTICE WORKBOOKS FROM THIS TRAINING: 👉https://www.myexcelonline.com/107-158...

You will learn how to create an Excel Pivot Table, Slicers, Pivot Charts & Excel Dashboards in ONLY 1 HOUR!

I am using Excel 2010 in this tutorial but you can also apply what I teach in Excel 2013 , Excel 2016, Excel 2019 and Excel Mac versions 2011 and 2016 (as well as the latest Office 365 version).

In no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to build stunning Excel Dashboards and get noticed by top management & prospective employers.

DOWNLOAD THE FREE PRACTICE WORKBOOKS FROM THIS TRAINING: 👉https://www.myexcelonline.com/107-158...

You can jump to the following sections within this Excel Pivot Table tutorial by clicking on the time links below:

0:00:00 - INTRODUCTION
2:40 CREATE AN EXCEL PIVOT TABLE
3:14 Tabular format
4:13 No gaps in the data
4:48 Use Excel Tables
7:55 Create a Pivot Table

13:50 FORMAT AN EXCEL PIVOT TABLE
15:29 Refresh a Pivot Table upon data change
16:21 Number formatting
17:04 Pivot Table design

18:00 SUMMARIZE VALUES BY: COUNT & AVERAGE
18:20 Summarize by Count
18:35 Summarize by Average

20:30 SHOW VALUES AS CALCULATIONS
22:00 Show Values As: Running Total In (Year To Date)
24:55 Show Values As: Difference From Previous Month

28:10 GROUPING AN EXCEL PIVOT TABLE
28:30 Grouping Numbers
30:40 Grouping Dates
33:40 Group by Text

35:10 INSERT AN EXCEL SLICER

39:25 INSERT AN EXCEL PIVOT CHART

41:50 CREATE AN INTERACTIVE EXCEL DASHBOARD

46:00 BONUS PIVOT TABLE TIPS
46:27 Value for empty cells
46:54 Auto fit column widths on update
48:05 Option to Refresh data
49:00 What's due next month
49:56 Top 10
52:17 Expand Report filter to new worksheets

------------

👨‍🏫 MyExcelOnline Academy Online Excel Courses 👇
1,000 Microsoft Excel video training tutorials & support covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE...
Join Now ► https://www.myexcelonline.com/107-42....

📚 Download Our Free 101 Excel Tips & Tricks E-Book: https://www.myexcelonline.com/101-exc...

💻 [Free Excel Masterclass] Advance Your Excel Level Within 30 Days: https://www.myexcelonline.com/107-125...

🔥 OUR BEST EXCEL RESOURCES 🔥
Get All Our Excel E-Books: https://go.myexcelonline.com/101-exce...
101 Most Popular Formulas Paperback on Amazon: https://www.amazon.com/dp/1700300911
101 Ready To Use Macros Paperback on Amazon: https://www.amazon.com/dp/1700729675
101 Best Excel Tips & Tricks Paperback on Amazon: https://www.amazon.com/Best-Excel-Tip...

👷 Excel Consulting Services: https://www.myexcelonline.com/microso...

💻 Looking for more Microsoft Excel tutorials for beginner videos? Check out this playlist: https://www.youtube.com/channel/UCMaV...
------------

Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!

If you enjoyed the video, please give a thumbs up, comment, share.

Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)

Cheers,

JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP
https://www.myexcelonline.com/

❤️ Let’s connect on social ❤️
LinkedIn: https://linkedin.com/in/johnmichaloudis
Instagram: https://www.instagram.com/myexcelonline/
Pinterest: https://www.pinterest.com/myexcelonli...
Facebook: https://www.facebook.com/groups/myexc...
Twitter: https://twitter.com/myexcelonline

#MyExcelOnline

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
Advanced Pivot Tables Tutorial in Excel - 2.5 Hour Pivot Table Excel Course Advanced Pivot Tables Tutorial in Excel - 2.5 H...
43:53 | 115,611
Master the MOST POPULAR Excel Formulas and Functions Master the MOST POPULAR Excel Formulas and Func...
22:50 | 145,043
Free Microsoft Excel Online Course Training | Microsoft Excel Tutorial for Beginners Free Microsoft Excel Online Course Training | M...
37:59 | 523,444
Excel for Accountants: PivotTables, Power Query, IF, SUMIFS, VLOOKUP, Flash Fill, Charts…CWU Seminar Excel for Accountants: PivotTables, Power Query...
22:28 | 240,370
Excel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards Excel for Accounting: Formulas, VLOOKUP & INDEX...
44:10 | 632,313
How to build Interactive Excel Dashboards that Update with ONE CLICK! How to build Interactive Excel Dashboards that ...
52:26 | 624,559
Excel 2016 - Demystifying Pivot Tables Excel 2016 - Demystifying Pivot Tables
24:47 | 88,019
PivotTables & Slicers Made Easy! 4 Amazing Examples for WAAT Accounting Seminar August 26, 2016 PivotTables & Slicers Made Easy! 4 Amazing Exam...
35:38 | 281,765

shopee ads

coinpayu