Creating and Managing Excel Pivot Tables

Опубликовано: 09 Октябрь 2024
на канале: Tom Fragale - Microsoft Certified Trainer - Author
77
0

Creating and Managing Excel Pivot Tables
Many people struggle with how to create Pivot Tables, or maybe they don’t even know what they can do, or maybe they think they are too difficult. I’m going to show you what they, how to use them, and that they are not difficult, and they can give you tremendous results. We will then make Pivot Charts, to graphically show the data. Then, we will add sorts, filters, slicers, and timelines to create a very easy-to-use, but very powerful dashboard that can give you instant results, and allow you to slice and dice your data any which way
To support this channel, please clock the Thanks icon below the video.

Please subscribe to my channel
http://www.youtube.com/user/TomFragal...
For Full versions of these videos, or to join my mailing list:
http://www.pcwebinars.com

Tom Fragale
Microsoft Certified Trainer

Available for Onsite Training, Private Webinars, Consulting, and Custom Software
(215)280-1073
[email protected]

To get the sample file from these videos, send an email to
[email protected]


Top 20 Most popular videos

Create Mailing Labels from Your Excel 2010 data using Mail Merge in Word 2010 Christmas holiday 2016
   • Create Mailing Labels from Your Excel...  
Using Excel Macros and VBA - Complete - Excel VBA 2010 2013 2007 2016 Tutorial Macros & Visual Basic
   • Using Excel Macros and VBA - Complete...  
Using An Excel If Function Formula With Multiple Conditions - Excel 2010 Tutorial Examples 2013 2016
   • Using An Excel If Function Formula Wi...  
How To Compare 2 Sheets Using The Excel Vlookup Function Formula 2007, 2010 , 2013, 2016 Tutorial
   • How To Compare 2 Sheets Using The Exc...  
Excel Pivot Table Tutorial - Create A Monthly, quarterly, Yearly Summary Report Excel 2013 2016 2010
   • Excel Pivot Table Tutorial - Create A...  
Creating a workflow in Sharepoint 2013 - How to create a workflow in Microsoft Sharepoint 2013 2016
   • Creating a workflow in Sharepoint 201...  
How to compare 2 tables in Access - Create a Find Unmatched Query in Access 2007 2010 2013 2016
   • How to compare 2 tables in Access - C...  
Access switchboard manager - creating a main menu in Access 2010 Tutorial Access 2013 2007 2016
   • Access switchboard manager - creating...  
Linking Sheets - Linking Data from Different Excel Sheets and Workbooks - 2010 Tutorial 2013 2016
   • Linking Sheets - Linking Data from Di...  
Installing an odbc driver in Windows 10 - SQL Server ODBC Driver Excel 2013 2016 Microsoft Access
   • Installing an odbc driver in Windows ...  
Installing an odbc driver in Windows 8 and Windows 8.1 and Windows 10 SQL Server ODBC Driver Excel
   • Installing an odbc driver in Windows ...  
How to reset autonumber in Access 2013, Microsoft Access 2010, and Access 2007 Access 2016
   • How to reset autonumber in Access 201...  
How to add a great lookup field to An Access form using the combo box wizard. Access 2016 2013 2010
   • How to add a great lookup field to An...  
How to make an Access query using yes no fields - Access 2010 Tutorial Access 2013 Access 2007 2016
   • How to make an Access query using yes...  
Word Basics - Tutorial for Beginners - Microsoft Word 2010, 2013, 2016 Office 365 Getting Started
   • Word Basics - Word Tutorial for Begin...  
Word - Adding a Picture To Mailing Labels - Create Christmas Holiday Labels Mail Merge 2010 2013
   • Word  Adding a Picture To Mailing Lab...  
How to lock a field on an Access form field protection on a form Microsoft 2007 2010 2013 2016
   • How to lock a field on an Access form...  
How to Use a sharepoint list in Access 2013, Microsoft Access 2010, and Access 2007 Tutorial
   • How to Use a sharepoint list in Acces...  
Excel Pivot Tables, Pivot Charts, Slicers and Dashboards - Complete Excel 2010 2013 2016 Tutorial
   • Excel Pivot Tables, Pivot Charts, Sli...  
How to import a text file into Access - Access 2010 tutorial CSV file Access 2007 Access 2013 2016
   • How to import a text file into Access...  

Most recent videos
Excel 2016 PowerPivot and PowerQuery , Measures and KPI Data Analysis Excel PowerPivot & PowerQuery
   • Excel 2016 PowerPivot and PowerQuery ...  
Excel Database Part 1 - How to Use Excel as a database - Excel 2010, 2013, 2016 tutorial
   • Excel Database Part 1 - How to Use Ex...  
Excel Database Part 2 - How to Use Excel as a database - Excel 2010, 2013, 2016 tutorial
   • Excel Database Part 2 -  How to Use E...  
Installing SQL Server on Windows 10 - How to install SQL Server 2016 Express on Windows 10 Free SQL
   • Installing SQL Server on Windows 10 -...  
Excel For Bankers - How to maximize using Microsoft Excel For Bankers - Excel 2010, Excel 2013,
   • Excel For Bankers - How to maximize u...  
How to Export from an Access Table or Query to SQL Server - Access 2010, Access 2013, Access 2016,
   • How to Export from an Access Table or...  
How to create an ODBC Driver in Windows 10 for SQL Server 2016 - Tutorial
   • How to create an ODBC Driver in Windo...  
Making it so it is required to check out a document in a document library in SharePoint 2016 & 2013
   • Making it so it is required to check ...  
Displaying multiple windows in Windows 10 - How to display multiple windows in Windows 10, Windows 8
   • Displaying multiple windows in Window...  
How to Create Rules in Outlook to automatically handle emails - Outlook Rules tutorial - 2016, 2013
   • How to Create Rules in Outlook to aut...  
#microsoft #excel #microsoftexcel #pivottables #excelpivottables