Useful tips for everyday
How do I add a page to navigation in SharePoint? You can also add a page to the menu from the Site Pages list. Select…
What do you call folder structure? A directory structure/system/tree is simply a layout of directories on your computer. Taking a big step back, the early…
How to loop through all sub sites in a site collection? This script will loop through all of the sub sites, including sub sites of…
How do I allow certain users to edit an Excel file? Allow certain users to edit selected cells without password Go to the Review tab…
When do I get an anonymous login prompt? If the default home page, say default.aspx page is not published & approved, users get a login…
How do you email a previous due invoice? Dear [Name], Further to my previous correspondence, I am contacting you regarding late payment for invoice [Invoice…
How to add calculated column to list in SharePoint? SharePoint Online: Add Calculated Column to List using PowerShell Browse to your SharePoint Online site and…
How do you add seconds in Excel? Notes: If you want to add one minute to cell, use this formula:=A2+1/1440, if you want to add…
How does SharePoint integrate PowerApps with a list? Select Add data > Connectors > SharePoint. Under Connect to a SharePoint site, select an entry in…
How do I calculate the difference between two sets of data in Excel? How to Find the Percentage of Difference Between Values in Excel You…