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
Microsoft Excel 2016 New Get and Transform feature

Microsoft Excel 2016 New Get and Transform feature

In my Complete Microsoft Excel Course on Udemy, Excel from Beginner to Advanced, I recorded some instruction on working with Microsoft Excel’s powerful Power Query and PowerPivot Add-Ins. When Excel 2013 was released, Microsoft made some changes and the 2 Add-Ins are no longer available on the home and student releases. In the 2016 release of Excel, Microsoft add the functionality that Power Query offered directly into the software without the additional Add-Ins needed. Micro
Microsoft Excel – How to Move and Copy Worksheets

Microsoft Excel – How to Move and Copy Worksheets

The video below is part of my Complete Microsoft Excel training course on Udemy, Excel with Microsoft Excel from Beginner to Advanced.
How to Create a Microsoft Excel Timeline (Gantt Chart)

How to Create a Microsoft Excel Timeline (Gantt Chart)

I got another excellent question from a student in my Complete Microsoft Excel course. Take a look at the video below on how to create a simple Excel Timeline using a list and an Excel Stacked Bar Chart. Download the Exercise File: ConstructionTimeLine.xlsx
Top Lesser Known Microsoft Word Shortcuts and Tips

Top Lesser Known Microsoft Word Shortcuts and Tips

Microsoft Word is full of shortcuts that will boost your productivity. Below is a quick list of the most common shortcut keys. CTRL + S —– SAVE CTRL + Z —– UNDO CTRL + C —– COPY CTRL + V —– PASTE CTRL + N —– NEW DOCUMENT CTRL + P —– PRINT CTRL + B —– BOLD Almost all of the above shortcuts work not only in Word but in most application, Microsoft and others. Lesser Known Shortcuts and Tips Below are some of the lesser known shortcuts that Microsoft Word has. This shortcuts and
Microsoft Office Specialist Exam (MOS) Information

Microsoft Office Specialist Exam (MOS) Information

The Microsoft Office Specialist exams provide one of the best opportunities to stand out from the average Microsoft Office user. Below are some quick facts about the various Office Exams available through Microsoft Certification program. Short Blurb from the Microsoft Official MOS site. “Demonstrate that you have the skills needed to get the most out of Office by earning a Microsoft Office Specialist (MOS) certification in a specific Office program. Holding a MOS certificatio
{"items":["6023c0d7eb2961001719a1f5","6023c0d7eb2961001719a1f2","6023c0d7eb2961001719a1f4","6023c0d7eb2961001719a1f6","6023c0d7eb2961001719a1f7"],"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}}
 
OfficeNewb
  • Facebook
  • Home

  • Blog

  • Course Files

  • More