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”

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”

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

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%)