Home

Quickly discover patterns and trends in your data using Excel PivotTable

%3CLINGO-SUB%20id%3D%22lingo-sub-857106%22%20slang%3D%22en-US%22%3EQuickly%20discover%20patterns%20and%20trends%20in%20your%20data%20using%20Excel%20PivotTable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857106%22%20slang%3D%22en-US%22%3E%3CP%3EJoin%20Excel%20MVP%20Bill%20%22Mr.%20Excel%22%20Jelen%20as%20he%20shares%20his%20tips%20%26amp%3B%20tricks%20in%20using%20Excel%20PivotTable%20to%20quickly%20discover%20patterns%20and%20trends%20in%20your%20data.%26nbsp%3B%20Join%20and%20filter%20multiple%20tables%3B%20compare%20lists%20and%20add%20calculations%20like%20rank%2C%20running%20totals%2C%20percent%20of%20total%2C%20etc.%3B%20and%20create%20top-10%20reports%20and%20year-over-year%20analyses%20the%20easy%20way.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESign%20in%20to%20our%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FExcelCommunity%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EExcel%20Community%20%3C%2FA%3Eand%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fexcel-oct-webinar-stream%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ewatch%20this%20webinar%20live%20on%20October%2023%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3EBill%20Jelen%20is%20the%20host%20of%20%3CA%20href%3D%22https%3A%2F%2Fwww.mrexcel.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMrExcel.com%3C%2FA%3E%20and%20the%20author%20of%2060%20books%20about%20Microsoft%20Excel%20including%20Excel%20Gurus%20Gone%20Wild%2C%20Pivot%20Table%20Data%20Crunching%2C%20and%20Excel%202019%20Inside%20Out.%20He%20has%20made%20over%2080%20guest%20appearances%20on%20TV%E2%80%99s%20Call%20for%20Help%20with%20Leo%20Laporte%20and%20was%20voted%20guest%20of%20the%20year%20on%20the%20Computer%20America%20radio%20show.%20He%20writes%20the%20Excel%20column%20for%20Strategic%20Finance%20magazine.%20He%20has%20produced%20over%202%2C200%20episodes%20of%20his%20daily%20video%20podcast%20Learn%20Excel%20from%20MrExcel.%20Before%20founding%20MrExcel.com%20in%201998%2C%20Jelen%20spent%20twelve%20years%20%E2%80%9Cin%20the%20trenches%2C%E2%80%9D%20as%20a%20financial%20analyst%20for%20the%20accounting%2C%20finance%2C%20marketing%2C%20and%20operations%20departments%20of%20a%20publicly%20held%20company.%20The%20website%20answers%20over%2040%2C000%20questions%20a%20year%20%E2%80%93%20for%20free%20%E2%80%93%20for%20readers%20all%20over%20the%20world.%20Bill%20joins%20us%20from%20Merritt%20Island%2C%20Florida.%26nbsp%3B%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-857106%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Excel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
cuong
Microsoft

Join Excel MVP Bill "Mr. Excel" Jelen as he shares his tips & tricks in using Excel PivotTable to quickly discover patterns and trends in your data.  Join and filter multiple tables; compare lists and add calculations like rank, running totals, percent of total, etc.; and create top-10 reports and year-over-year analyses the easy way.

 

Sign in to our Excel Community and watch this webinar live on October 23.

 

Bill Jelen is the host of MrExcel.com and the author of 60 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Excel 2019 Inside Out. He has made over 80 guest appearances on TV’s Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show. He writes the Excel column for Strategic Finance magazine. He has produced over 2,200 episodes of his daily video podcast Learn Excel from MrExcel. Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches,” as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company. The website answers over 40,000 questions a year – for free – for readers all over the world. Bill joins us from Merritt Island, Florida. 

  • Microsoft Excel

Events and related information presented in the Tech Community website are made available solely for general information purposes. Microsoft is not associated with nor endorses any event and does not warrant the accuracy, completeness or usefulness of the information presented or any event. Information is provided by and any questions about an event should be directed to the event organizer.

Register

Hosted By

Microsoft
Event Location

This is an online event

Related Conversations
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Pulling data from one tab to another
krysphares in Excel on
6 Replies
Maps Data for Scotland
Chris Nicol in Excel on
19 Replies
Problems using Pivot tables in Excel 16.25 on Mac
jeromepineau in Excel on
0 Replies