Modern Excel webinar: Tips & tricks to help boost your productivity in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1390130%22%20slang%3D%22en-US%22%3EModern%20Excel%20webinar%3A%20Tips%20%26amp%3B%20tricks%20to%20help%20boost%20your%20productivity%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1390130%22%20slang%3D%22en-US%22%3E%3CP%3EJoin%20Excel%20MVP%20%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F5002589%3FfullName%3DWyn%2520Hopkins%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EWyn%20Hopkins%3C%2FA%3E%20as%20he%20demonstrates%20a%20rapid-fire%20round%20of%20shortcuts%2C%20features%20and%20formulas%20that%20will%20speed%20up%20your%20daily%20use%20of%20Excel.%20From%20SWITCH%20to%20Dependent%20Drop%20downs%2C%20Grouping%20to%20Conditional%20Formatting%2C%20clever%20validation%20lists%20and%20even%20a%20few%20XLOOKUP%20tricks%20there%20will%20be%20something%20for%20everyone%20in%20this%20session.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CDIV%20class%3D%22video-embed-center%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%252Fi6iOW43NCY0%253Ffeature%253Doembed%26amp%3Bdisplay_name%3DYouTube%26amp%3Burl%3Dhttps%253A%252F%252Fwww.youtube.com%252Fwatch%253Fv%253Di6iOW43NCY0%26amp%3Bimage%3Dhttps%253A%252F%252Fi.ytimg.com%252Fvi%252Fi6iOW43NCY0%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%20title%3D%22YouTube%20embed%22%20frameborder%3D%220%22%20allow%3D%22autoplay%3B%20fullscreen%22%20allowfullscreen%3D%22true%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%3CP%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3E%3CEM%3EWyn%20is%20a%20director%20at%20the%20Australian%20company%20%3CA%20href%3D%22https%3A%2F%2Faccessanalytic.com.au%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAccess%20Analytic%3C%2FA%3E%20which%20provides%20amazing%20Excel%20and%20Power%20BI%20solutions%20to%20clients.%20He%20started%20his%20career%20as%20a%20Chartered%20Accountant%20with%20PwC%20in%20the%20UK%20and%20then%20began%20to%20develop%20his%20Excel%20skills%20as%20an%20analyst%20at%202%20UK%20Banks%20before%20moving%20to%20Australia%20in%202007.%20Wyn%20is%20a%20trainer%20and%20developer%20utilising%20advanced%20Excel%20and%20Power%20BI%20techniques%20including%20Power%20Query%2C%20Power%20Pivot%2C%20DAX%20and%20VBA%20to%20build%20applications%20that%20help%20companies%20address%20their%20reporting%2C%20automation%20and%20analysis%20needs.%20He%20is%20an%20active%20contributor%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Ftoday%2Fauthor%2Fwynhopkins%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FExcelTechCommunity%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EExcel%20Tech%20Community%3C%2FA%3E%20and%20LinkedIn.%20Wyn%20is%20co-author%20of%20the%20book%20Excel%20Insights%20published%20in%202020%20with%2023%20other%20MVPs%20and%20was%20awarded%20MVP%20status%20by%20Microsoft%20for%20the%203rd%20year%20running%20in%202019.%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1390130%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%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1422008%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20Excel%20webinar%3A%20Tips%20%26amp%3B%20tricks%20to%20help%20boost%20your%20productivity%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1422008%22%20slang%3D%22en-US%22%3E%3CP%3EWhere%20can%20we%20get%20the%20excel%20spreadsheet%3F%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320924%22%20target%3D%22_blank%22%3E%40cuong%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1457680%22%20slang%3D%22en-US%22%3ERE%3A%20Modern%20Excel%20webinar%3A%20Tips%20%26amp%3Bamp%3B%20tricks%20to%20help%20boost%20your%20productivity%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1457680%22%20slang%3D%22en-US%22%3EHi%20everyone%2C%20I%20am%20attempting%20to%20create%20an%20excel%20formula%20that%20will%20compare%20two%20cells%20(column%20A%20and%20B)%20and%20if%20the%20values%20on%20cell%20are%20a%20match%20it%20will%20indicate%20%22Yes%22%20on%20different%20cell%20and%20if%20not%20%22No%22%20on%20column%20C.%20I%20got%20that%20formula%20down%20(IF(B5%3DC5%2C%20%22Yes%22%2C%20%22No%22))%2C%20but%20am%20I%20also%20trying%20to%20include%20a%20third%20formula%20that%20will%20put%20term%20%22Blank%22%20if%20any%20of%20the%20fields%20on%20columns%20A%20and%20B%20of%20respective%20rows%20have%20no%20values.%20Any%20advice%20would%20be%20greatly%20appreciated.%20Many%20thanks.%3C%2FLINGO-BODY%3E
Highlighted
Microsoft

Join Excel MVP Wyn Hopkins as he demonstrates a rapid-fire round of shortcuts, features and formulas that will speed up your daily use of Excel. From SWITCH to Dependent Drop downs, Grouping to Conditional Formatting, clever validation lists and even a few XLOOKUP tricks there will be something for everyone in this session.

 


Wyn is a director at the Australian company Access Analytic which provides amazing Excel and Power BI solutions to clients. He started his career as a Chartered Accountant with PwC in the UK and then began to develop his Excel skills as an analyst at 2 UK Banks before moving to Australia in 2007. Wyn is a trainer and developer utilising advanced Excel and Power BI techniques including Power Query, Power Pivot, DAX and VBA to build applications that help companies address their reporting, automation and analysis needs. He is an active contributor to the Excel Tech Community and LinkedIn. Wyn is co-author of the book Excel Insights published in 2020 with 23 other MVPs and was awarded MVP status by Microsoft for the 3rd year running in 2019.

2 Replies
Highlighted

Where can we get the excel spreadsheet? @cuong 

Highlighted
Hi everyone, I am attempting to create an excel formula that will compare two cells (column A and B) and if the values on cell are a match it will indicate "Yes" on different cell and if not "No" on column C. I got that formula down (IF(B5=C5, "Yes", "No")), but am I also trying to include a third formula that will put term "Blank" if any of the fields on columns A and B of respective rows have no values. Any advice would be greatly appreciated. Many thanks.