Modern Excel webinar: Discover patterns & trends using PivotTable, Excel MVP Bill "Mr. Excel" Jelen

%3CLINGO-SUB%20id%3D%22lingo-sub-959708%22%20slang%3D%22en-US%22%3EModern%20Excel%20webinar%3A%20Discover%20patterns%20%26amp%3B%20trends%20using%20PivotTable%2C%20Excel%20MVP%20Bill%20%22Mr.%20Excel%22%20Jelen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-959708%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22lia-quilt-row%20lia-quilt-row-main%22%3E%0A%3CDIV%20class%3D%22lia-quilt-column%20lia-quilt-column-18%20lia-quilt-column-left%20lia-quilt-column-main-left%22%3E%0A%3CDIV%20class%3D%22lia-quilt-column-alley%20lia-quilt-column-alley-left%22%3E%0A%3CDIV%20id%3D%22bodyDisplay%22%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%0A%3CDIV%20class%3D%22lia-message-body-content%22%3E%0A%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%3E%3C%2FP%3E%3CDIV%20class%3D%22video-embed-left%20video-embed%22%3E%3CIFRAME%20class%3D%22embedly-embed%22%20src%3D%22https%3A%2F%2Fcdn.embedly.com%2Fwidgets%2Fmedia.html%3Fsrc%3Dhttps%253A%252F%252Fwww.youtube.com%252Fembed%252FLY883VM7_Ro%253Fstart%253D53%2526feature%253Doembed%2526start%253D53%26amp%3Burl%3Dhttps%253A%252F%252Fwww.youtube.com%252Fwatch%253Fv%253DLY883VM7_Ro%26amp%3Bimage%3Dhttps%253A%252F%252Fi.ytimg.com%252Fvi%252FLY883VM7_Ro%252Fhqdefault.jpg%26amp%3Bkey%3Db0d40caa4f094c68be7c29880b16f56e%26amp%3Btype%3Dtext%252Fhtml%26amp%3Bschema%3Dyoutube%22%20width%3D%22600%22%20height%3D%22337%22%20scrolling%3D%22no%22%20frameborder%3D%220%22%20allow%3D%22autoplay%3B%20fullscreen%22%20allowfullscreen%3D%22true%22%20title%3D%22Video%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%3CP%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%20style%3D%22font-family%3A%20inherit%3B%22%3EBill%20Jelen%20is%20the%20host%20of%26nbsp%3B%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMrExcel.com%3C%2FA%3E%26nbsp%3Band%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%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EClick%20%3CSTRONG%3ELikes%3C%2FSTRONG%3E%20below%20and%20give%20us%20feedback%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECuong%3C%2FP%3E%0A%3CP%3EMicrosoft%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3CDIV%20class%3D%22lia-quilt-row%20lia-quilt-row-quickreply%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-959708%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EShow%20and%20Tell%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20and%20Tricks%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETutorial%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1014368%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20Excel%20webinar%3A%20Discover%20patterns%20%26amp%3B%20trends%20using%20PivotTable%2C%20Excel%20MVP%20Bill%20%22Mr.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1014368%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20his%20books.%20but%20I%20still%20need%20help%20with%20if%20statements%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1014373%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20Excel%20webinar%3A%20Discover%20patterns%20%26amp%3B%20trends%20using%20PivotTable%2C%20Excel%20MVP%20Bill%20%22Mr.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1014373%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F460629%22%20target%3D%22_blank%22%3E%40wjallen14%3C%2FA%3E%26nbsp%3B%2C%20if%20you%20have%20concrete%20question%20you%20may%20ask%20it%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%3C%2FA%3E%2C%20most%20probably%20someone%20will%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1014455%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20Excel%20webinar%3A%20Discover%20patterns%20%26amp%3B%20trends%20using%20PivotTable%2C%20Excel%20MVP%20Bill%20%22Mr.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1014455%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sergei%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20wanting%20to%20use%20an%20IF%20formula%20in%20a%20spreadsheet%20to%20delete%20a%20line%20if%20the%20value%20in%20a%20cell%20is%20zero.%20Can%20this%20be%20done%20and%20if%20so%20how%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1014472%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20Excel%20webinar%3A%20Discover%20patterns%20%26amp%3B%20trends%20using%20PivotTable%2C%20Excel%20MVP%20Bill%20%22Mr.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1014472%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F460700%22%20target%3D%22_blank%22%3E%40JohnD1505%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfraid%20that's%20only%20with%20VBA%20programming.%20With%20formulas%20you%20may%20only%20to%20change%20the%20value%20of%20the%20cell(s)%2C%20but%20not%20delete%20them.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHowever%2C%20you%20may%20apply%20filter%2C%20select%20only%20rows%20with%20blank%20cells%20and%20manually%20remove%20rows.%20Clean%20filter%20then.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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.

 

 

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. 

 

Click Likes below and give us feedback

 

Cuong

Microsoft

 

 
4 Replies
Highlighted

I have his books. but I still need help with if statements

 

Highlighted

@wjallen14 , if you have concrete question you may ask it here https://techcommunity.microsoft.com/t5/Excel/bd-p/ExcelGeneral, most probably someone will help.

Highlighted

Hi Sergei 

I am wanting to use an IF formula in a spreadsheet to delete a line if the value in a cell is zero. Can this be done and if so how?

Highlighted

@JohnD1505 

Afraid that's only with VBA programming. With formulas you may only to change the value of the cell(s), but not delete them.

 

However, you may apply filter, select only rows with blank cells and manually remove rows. Clean filter then.