The “New item” menu in modern SharePoint document libraries now allows adding templates

I happily stumbled across an update to modern document libraries I hadn’t noticed before. The modern document library “new item” menu now includes an option to “Edit New Menu” which pulls up this pane in-context:

iexplore_2018-11-02_10-54-47.png

And also includes the ability to upload a new template directly from the menu, rather than through content type settings.

2018-11-02_11-01-17.gif

Any new templates added via this method will use the default content type for that library, but provides a way to have multiple templates for a single content type.

Change a SharePoint site collection top-level site URL

Changing a SharePoint site collection name is easy enough (Site Settings –> “Title, description, and logo”), but changing the URL for a top-level site is a bit more involved than just changing a subsite URL. Note that this post applies to on-premise/server environments only.

Continue reading “Change a SharePoint site collection top-level site URL”

Change a SharePoint subsite name and URL

Sometimes “Marketing” becomes “Communication” or you’ve changed a site URL naming convention so that instead of “sharepoint.mycompany.com/marketing” you’ll be shortening all department sites to something like “sharepoint.mycompany.com/mark”. Follow these steps to change the name and URL for a SharePoint subsite.

Note: If you’re trying to change the URL for a top-level site (site collection level), you’ll need to change the URL as an administrator using PowerShell.

Continue reading “Change a SharePoint subsite name and URL”

How to give SharePoint link lists a professional look out-of-the-box using the icon library

In the modern SharePoint experience, you can clean up ordinary link lists with very little effort, thanks to SharePoint’s icon library.

chrome_2018-10-23_15-30-53

Whether you need a Teams icon (teams), dog (fangbody), tooth (teeth) or football (football), you can search for icons and use those for adding visual cues and iconography to your sites. Here’s how you can implement this on your page(s):

Continue reading “How to give SharePoint link lists a professional look out-of-the-box using the icon library”

Speaking at SharePoint Saturday Cincinnati this Saturday | Oct 27, 2018

chrome_2018-09-09_11-33-13.png

I’ll be speaking this Saturday at SPS Cinci (#SPSCinci2018). I’ll be presenting my brand new, magical session on content management, archiving and retention for the third time this year. Don’t miss it!

SharePoint wizardry for content management, archiving & retention

Are your muggles muddying up your servers and site storage with duplicate files, pictures from a 2008 staff party and files named “April” in folders called “Jane’s stuff”? Learn how to most effectively destroy the 8th horcrux using out-of-the-box functionality in SharePoint brewed with bits of governance, content strategy and just a little help from SharePoint Designer to help automate processes. It’s just like magic!

Hope to see you there!

Snipping Tool is being replaced with Snip & Sketch, previewed in latest Windows update

I typically use Snipping Tool or ShareX for my screen capture needs, and saw today after updating Windows that Snipping Tool is soon to be “Snip & Sketch”.

Continue reading “Snipping Tool is being replaced with Snip & Sketch, previewed in latest Windows update”

Speaking at SharePoint Saturday Baltimore this Saturday | Oct 20, 2018

chrome_2018-09-24_21-45-49.png

I’ll be speaking this Saturday at SPS Baltimore (#SPSBMORE). I’ll be presenting my brand new, magical session on content management, archiving and retention for the second time this year. Don’t miss it!

SharePoint wizardry for content management, archiving & retention

Are your muggles muddying up your servers and site storage with duplicate files, pictures from a 2008 staff party and files named “April” in folders called “Jane’s stuff”? Learn how to most effectively destroy the 8th horcrux using out-of-the-box functionality in SharePoint brewed with bits of governance, content strategy and just a little help from SharePoint Designer to help automate processes. It’s just like magic!

Hope to see you there!

Quick tip: Prevent #DIV/0! and #VALUE! errors in Excel files

Recently I was helping a client visualize their excel data using Power BI and ran across an error in Power BI when it couldn’t deal with “#DIV/0!” as a cell value in Excel:

“DataFormat.Error: Invalid cell value ‘#DIV/0!’.” 

You get this error in excel whenever you have a calculated formula that is trying to divide by zero or a blank cell. Similarly, you get “DataFormat.Error: Invalid cell value ‘#VALUE!'” typically when your data formats don’t match – like there’s a word in a number-formatted column.

It’s a simple fix: just modify your Excel formula to be wrapped in =IFERROR((YourFormula),0) so that if your formula attempts to divide a value by zero, it returns a value of zero instead of an error code.

=IFERROR(Your_Formula, Value_If_Error)

2018-10-10_09-12-39.gif

Speaking at SharePoint Saturday Kansas City this Saturday | Oct 13, 2018

chrome_2018-09-09_11-24-06.png

My local SharePoint Saturday, SPS Kansas City, is coming up THIS WEEKEND (#SPSKC). I’ll be speaking about one of my favorite topics – building a modern intranet:

Building the Intranet of the Future: Using SharePoint to Empower Collaboration

Automation, organization, incredible search capabilities and user interactivity; all things your organization can have in choosing to build an intranet with SharePoint. We’ll discuss avoiding File Dump 2.0 by exploring best practices in internal communications and collaboration via intranets. We’ll also cover rethinking forms and minimizing busy work by utilizing automation capabilities via workflow and designing intuitive navigation.

Hope to see you there!

MCSA: Office 365 Study Guide for Exams 70-346 & 70-347

Note: The MCSA: O365 Certification and exams 70-346 & 70-347 are being retired March 31, 2019. Learn more about what to expect here.


Having just passed both 70-346 and 70-347, I know how hard it can be to find helpful and relevant resources to help you prepare for the exams. I’ve compiled resources below I used to help me prepare and I hope they help you with your own studying. I’ve included nothing more or less than I used myself. The most important piece for me was the Lynda.com courses – I wouldn’t have passed without them. Good luck!

Required Exams

(check links for most recent requirements)

Books

Videos

Courses

Lynda.com

(free access for card-holders at many libraries, or free trial month for new users)

edX

Courses are free on edX. Just create an account.

Pluralsight

Get a 10-day free trial

Prep Tips from Nate

70-346 Skills Measured

70-347 Skills Measured

These are taken directly from the exam info pages. Clicking a link will take you to the respective section of the page to see specific sub-topics covered under each skill section. I’ve also included the “Preparation resources” provided by Microsoft under each respective section:
Provision Office 365 (15–20%)Plan and implement networking and security in Office 365 (15–20%)

Manage cloud identities (15–20%)

Implement and Manage Identities by Using Azure AD Connect (15–20%)

Implement and manage federated identities for single sign-on (SSO) (15–20%)

Monitor and troubleshoot Office 365 availability and usage (15–20%)

Manage clients and end-user devices (20–25%)

Provision SharePoint Online site collections (20–25%)

Configure Exchange Online and Skype for Business Online for end users (20–25%)

Plan for Exchange Online and Skype for Business Online (20–25%)

Configure and secure Office 365 services (20–25%)