FOLLOW

  • Facebook

CONTACT

kyle.pew@officenewb.com

ADDRESS

Pleasant Grove, UT

©2017 by Office Newb

Recent Posts

LIVE QA ON MICROSOFT EXCEL - June 24th, 2020

LIVE QA ON MICROSOFT EXCEL - June 24th, 2020

LIVE QA ON MICROSOFT EXCEL

LIVE QA ON MICROSOFT EXCEL

Microsoft Excel Power Query Cleaning Nested Data with Conditional Columns and Fill Command

Microsoft Excel Power Query Cleaning Nested Data with Conditional Columns and Fill Command

{"items":["6023c0d7ee3d2e0017a440bb","6023c0d7ee3d2e0017a440ba","6023c0d7ee3d2e0017a440b7"],"styles":{"galleryType":"Columns","groupSize":1,"showArrows":true,"cubeImages":true,"cubeType":"max","cubeRatio":1.7777777777777777,"isVertical":true,"gallerySize":30,"collageAmount":0,"collageDensity":0,"groupTypes":"1","oneRow":false,"imageMargin":5,"galleryMargin":0,"scatter":0,"rotatingScatter":"","chooseBestGroup":true,"smartCrop":false,"hasThumbnails":false,"enableScroll":true,"isGrid":true,"isSlider":false,"isColumns":false,"isSlideshow":false,"cropOnlyFill":false,"fixedColumns":0,"enableInfiniteScroll":true,"isRTL":false,"minItemSize":50,"rotatingGroupTypes":"","rotatingCropRatios":"","columnWidths":"","gallerySliderImageRatio":1.7777777777777777,"numberOfImagesPerRow":3,"numberOfImagesPerCol":1,"groupsPerStrip":0,"borderRadius":0,"boxShadow":0,"gridStyle":0,"mobilePanorama":false,"placeGroupsLtr":true,"viewMode":"preview","thumbnailSpacings":4,"galleryThumbnailsAlignment":"bottom","isMasonry":false,"isAutoSlideshow":false,"slideshowLoop":false,"autoSlideshowInterval":4,"bottomInfoHeight":0,"titlePlacement":["SHOW_ON_THE_RIGHT","SHOW_BELOW"],"galleryTextAlign":"center","scrollSnap":false,"itemClick":"nothing","fullscreen":true,"videoPlay":"hover","scrollAnimation":"NO_EFFECT","slideAnimation":"SCROLL","scrollDirection":0,"scrollDuration":400,"overlayAnimation":"FADE_IN","arrowsPosition":0,"arrowsSize":23,"watermarkOpacity":40,"watermarkSize":40,"useWatermark":true,"watermarkDock":{"top":"auto","left":"auto","right":0,"bottom":0,"transform":"translate3d(0,0,0)"},"loadMoreAmount":"all","defaultShowInfoExpand":1,"allowLinkExpand":true,"expandInfoPosition":0,"allowFullscreenExpand":true,"fullscreenLoop":false,"galleryAlignExpand":"left","addToCartBorderWidth":1,"addToCartButtonText":"","slideshowInfoSize":200,"playButtonForAutoSlideShow":false,"allowSlideshowCounter":false,"hoveringBehaviour":"NEVER_SHOW","thumbnailSize":120,"magicLayoutSeed":1,"imageHoverAnimation":"NO_EFFECT","imagePlacementAnimation":"NO_EFFECT","calculateTextBoxWidthMode":"PERCENT","textBoxHeight":26,"textBoxWidth":200,"textBoxWidthPercent":65,"textImageSpace":10,"textBoxBorderRadius":0,"textBoxBorderWidth":0,"loadMoreButtonText":"","loadMoreButtonBorderWidth":1,"loadMoreButtonBorderRadius":0,"imageInfoType":"ATTACHED_BACKGROUND","itemBorderWidth":0,"itemBorderRadius":0,"itemEnableShadow":false,"itemShadowBlur":20,"itemShadowDirection":135,"itemShadowSize":10,"imageLoadingMode":"BLUR","expandAnimation":"NO_EFFECT","imageQuality":90,"usmToggle":false,"usm_a":0,"usm_r":0,"usm_t":0,"videoSound":false,"videoSpeed":"1","videoLoop":true,"jsonStyleParams":"","gallerySizeType":"px","gallerySizePx":1000,"allowTitle":true,"allowContextMenu":true,"textsHorizontalPadding":-30,"itemBorderColor":{"themeName":"color_12","value":"rgba(200,200,200,0)"},"showVideoPlayButton":true,"galleryLayout":2,"calculateTextBoxHeightMode":"MANUAL","targetItemSize":1000,"selectedLayout":"2|bottom|1|max|true|0|true","layoutsVersion":2,"selectedLayoutV2":2,"isSlideshowFont":true,"externalInfoHeight":26,"externalInfoWidth":0.65},"container":{"width":300,"galleryWidth":305,"galleryHeight":0,"scrollBase":0,"height":null}}

Archive

  • June 2020
  • April 2020
  • March 2020
  • September 2019
  • August 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • June 2018
  • May 2018
  • December 2017
  • October 2017
  • September 2017
  • August 2017

Tags

  • Contest
  • Excel
  • Excel Functions
  • Excel MAC
  • Microsoft Excel
  • Microsoft Office
  • Microsoft Word
  • MOS
  • New Course
  • New Features
  • Pivot Column
  • Power Query
  • PowerP
  • PowerPoint
  • SharePoint
  • Udemy
  • VBA
  • Web Scraping
  • Windows Task Scheduler
  • Word
LIVE QA ON MICROSOFT EXCEL - June 24th, 2020

LIVE QA ON MICROSOFT EXCEL - June 24th, 2020

Join us for a live Q&A on Microsoft Excel, Wednesday June 24th at 10:00 AM Mountain Time US. I've asked those that will be attending to p...
LIVE QA ON MICROSOFT EXCEL

LIVE QA ON MICROSOFT EXCEL

Join us for a live Q&A on Microsoft Excel, Monday June 1st at 11:00 AM Mountain Time US. I've asked those that will be attending to post ...
Microsoft Excel Power Query Cleaning Nested Data with Conditional Columns and Fill Command

Microsoft Excel Power Query Cleaning Nested Data with Conditional Columns and Fill Command

Excel Power Query makes transforming and cleaning up data a breeze. By using Conditional Columns and Excel Power Query Fill Command you'l...
Excel LOOKUP Functions

Excel LOOKUP Functions

I recently recorded a handful of videos for my Complete Microsoft Excel course and thought I would share these videos. I've placed them i...
Microsoft Excel Power Query Pivot Column

Microsoft Excel Power Query Pivot Column

I recently got a question about cleaning up a list of addresses in order to make it useable for a mail merge. The original data looks som...
Top Time Saving Excel Techniques in Microsoft Excels Power Query

Top Time Saving Excel Techniques in Microsoft Excels Power Query

Experience true Excel power by using Microsoft Excels Power Query (GET AND TRANSFORM - Excel 2016+) feature. In this video I will introdu...
Microsoft Excel Running Total with SUM and SUMIF Functions

Microsoft Excel Running Total with SUM and SUMIF Functions

(Watch the video for a demonstration) The Microsoft Excel function, SUM, is the most used function in all of Excel. We typically use the ...
Microsoft Announces a New XLOOKUP Function for Excel

Microsoft Announces a New XLOOKUP Function for Excel

Microsoft announced a brand new function for Microsoft Excel called the XLOOKUP(). This function provides an enhanced method of looking u...
Microsoft Excel Combine Worksheets with Power Query

Microsoft Excel Combine Worksheets with Power Query

Microsoft Excel's Power Query makes it easy to combine multiple Excel tables, from different worksheets, into one master list. You can th...
Become a Microsoft Office Specialist (MOS)

Become a Microsoft Office Specialist (MOS)

It's time for another contest! Participating in this contest could help you on the path to becoming a Microsoft Office Specialist, certif...
{"items":["6023c0d7ee3d2e0017a440bb","6023c0d7ee3d2e0017a440ba","6023c0d7ee3d2e0017a440b7","6023c0d7ee3d2e0017a440b9","6023c0d7ee3d2e0017a440bf","6023c0d7ee3d2e0017a440b8","6023c0d76336df00172a91e5","6023c0d76336df00172a91e4","6023c0d76336df00172a91e0","6023c0d76336df00172a91e9"],"styles":{"galleryType":"Columns","groupSize":1,"showArrows":true,"cubeImages":true,"cubeType":"max","cubeRatio":1.7777777777777777,"isVertical":true,"gallerySize":30,"collageAmount":0,"collageDensity":0,"groupTypes":"1","oneRow":false,"imageMargin":32,"galleryMargin":0,"scatter":0,"rotatingScatter":"","chooseBestGroup":true,"smartCrop":false,"hasThumbnails":false,"enableScroll":true,"isGrid":true,"isSlider":false,"isColumns":false,"isSlideshow":false,"cropOnlyFill":false,"fixedColumns":0,"enableInfiniteScroll":true,"isRTL":false,"minItemSize":50,"rotatingGroupTypes":"","rotatingCropRatios":"","columnWidths":"","gallerySliderImageRatio":1.7777777777777777,"numberOfImagesPerRow":3,"numberOfImagesPerCol":1,"groupsPerStrip":0,"borderRadius":0,"boxShadow":0,"gridStyle":0,"mobilePanorama":false,"placeGroupsLtr":true,"viewMode":"preview","thumbnailSpacings":4,"galleryThumbnailsAlignment":"bottom","isMasonry":false,"isAutoSlideshow":false,"slideshowLoop":false,"autoSlideshowInterval":4,"bottomInfoHeight":0,"titlePlacement":"SHOW_BELOW","galleryTextAlign":"center","scrollSnap":false,"itemClick":"nothing","fullscreen":true,"videoPlay":"hover","scrollAnimation":"NO_EFFECT","slideAnimation":"SCROLL","scrollDirection":0,"scrollDuration":400,"overlayAnimation":"FADE_IN","arrowsPosition":0,"arrowsSize":23,"watermarkOpacity":40,"watermarkSize":40,"useWatermark":true,"watermarkDock":{"top":"auto","left":"auto","right":0,"bottom":0,"transform":"translate3d(0,0,0)"},"loadMoreAmount":"all","defaultShowInfoExpand":1,"allowLinkExpand":true,"expandInfoPosition":0,"allowFullscreenExpand":true,"fullscreenLoop":false,"galleryAlignExpand":"left","addToCartBorderWidth":1,"addToCartButtonText":"","slideshowInfoSize":200,"playButtonForAutoSlideShow":false,"allowSlideshowCounter":false,"hoveringBehaviour":"NEVER_SHOW","thumbnailSize":120,"magicLayoutSeed":1,"imageHoverAnimation":"NO_EFFECT","imagePlacementAnimation":"NO_EFFECT","calculateTextBoxWidthMode":"PERCENT","textBoxHeight":240,"textBoxWidth":200,"textBoxWidthPercent":50,"textImageSpace":10,"textBoxBorderRadius":0,"textBoxBorderWidth":0,"loadMoreButtonText":"","loadMoreButtonBorderWidth":1,"loadMoreButtonBorderRadius":0,"imageInfoType":"ATTACHED_BACKGROUND","itemBorderWidth":0,"itemBorderRadius":0,"itemEnableShadow":false,"itemShadowBlur":20,"itemShadowDirection":135,"itemShadowSize":10,"imageLoadingMode":"BLUR","expandAnimation":"NO_EFFECT","imageQuality":90,"usmToggle":false,"usm_a":0,"usm_r":0,"usm_t":0,"videoSound":false,"videoSpeed":"1","videoLoop":true,"jsonStyleParams":"","gallerySizeType":"px","gallerySizePx":1000,"allowTitle":true,"allowContextMenu":true,"textsHorizontalPadding":-30,"itemBorderColor":{"themeName":"color_15","value":"rgba(36,36,36,1)"},"showVideoPlayButton":true,"galleryLayout":2,"calculateTextBoxHeightMode":"MANUAL","textsVerticalPadding":-15,"targetItemSize":1000,"selectedLayout":"2|bottom|1|max|true|0|true","layoutsVersion":2,"selectedLayoutV2":2,"isSlideshowFont":true,"externalInfoHeight":240,"externalInfoWidth":0},"container":{"width":560,"galleryWidth":592,"galleryHeight":0,"scrollBase":0,"height":null}}
1
2
 
OfficeNewb
  • Facebook
  • Home

  • Blog

  • Course Files

  • More