In the modern SharePoint experience, you can clean up ordinary link lists with very little effort, thanks to SharePoint’s icon library.
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):
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”.
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!’.”
Excel error #DIV/0!
Power BI error when trying to read that excel file: “DataFormat.Error: Invalid cell value ‘#DIV/O!’.”
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.
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!
Be willing to learn and memorize some fundamental PowerShell for O365 apps. Both exams require knowing some cmdlets and structure. These are all useful and covered in the exams (from docs.microsoft.com):
Whenever a user or administrator has options (licenses, migration methods, deactivating certain features, adding different roles/permissions, etc.) learn each of them and when they’re applicable
There are sometimes multiple correct solutions, but it’s a matter of understanding which have the least amount of administrative overhead or are most appropriate in different environments under different requirements (for example, if you’re not allowed to connect to the internet, how would you migrate exchange to O365?)
I failed and regretted not buying the “replay” option. I didn’t make that mistake twice. When you schedule your exam, I’d highlyrecommend doing so with a replay option so you get an included retake at a lower price than two exams individually. You could, alternatively, purchase a practice exam which should also give you a good idea of what to expect.
Get to know allthe admin centers (Skype, Teams, StaffHub, SharePoint, etc.), their settings and how they allow or disallow external access
Use the exam pages to guide your studying, particularly in areas you’re uncomfortable with:
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: