Latest Posts
MS-101 Exam Study Guide
Below you’ll find all exam areas and objectives with related documentation to help you prepare for the exam. Most of the references below are summarized in my exam prep book. <h2>Implement modern device services (30-35%)</h2> <a href=””>Implement Mobile Device Management (MDM)</a> <ul><li>plan for MDM<br /><ul><li><a href=”https://docs.microsoft.com/en-us/intune/planning-guide”>Intune deployment planning, design, and implementation guide</a></li><li><a href=”https://docs.microsoft.com/en-us/intune/device-profiles”>Apply features and …
New book! MS-101 Exam Study Guide Announcement
Earlier this year, in January 2019, I wrote an MS-100 and MS-101 exams study guide blog post linking to resources to help people prep for both exams. MS-101 in particular seemed to have less available for it, and I jumped at the opportunity to change that. I’m pleased today to be able to add my …
Continue reading “New book! MS-101 Exam Study Guide Announcement”
Connect a Google Sheet spreadsheet to Power BI as a data source
I recently connected Power BI directly to a spreadsheet in Google’s Excel alternative, Google Sheets. It’s important to connect to data without moving it when we can. The less we have to export/download, save, rename, move, massage, etc. the better. Here’s how we’ll connect to a Google Sheet: Get “no sign-in required”/anonymous share URL from …
Continue reading “Connect a Google Sheet spreadsheet to Power BI as a data source”
How to create a PTO/vacation request form and approval process in SharePoint
I was recently asked to develop a PTO request form that accomplished the following: Allowed users to submit PTO, Remote work, Training, and Other requests Auto-lookup of the employee’s manager Send confirmation to submitter Notify manager and seek approval/rejection with comments If approved, send notification with an iCal link users can save to their calendar, …
Continue reading “How to create a PTO/vacation request form and approval process in SharePoint”
Possible solution: “Sorry, something went wrong. The file is locked for exclusive use by…”
I recently ran into the following error when someone tried to edit a shared Excel file from OneDrive (we’re running SharePoint Server 2016). “Sorry, something went wrong. The file {address} is locked for exclusive use by {name}.” Troubleshooting The user in question, who had it “locked for use,” had the file open in Excel (client, …
Get Involved
Where's Nate
Your Membership
or log in if already a member.