3 Commonly Utilized SharePoint Formulas

The following are three commonly used SharePoint formulas:

1. IF formula: This formula is utilized to check whether a condition is met or not. It returns one value if the condition is true and another value if the condition is false. Example: =IF([Column1]>[Column2], "Yes", "No")
2. SUM formula: This formula is utilized to add up the values in a column. Example: =SUM([Column1], [Column2], [Column3])
3. DATEDIF formula: This formula is utilized to calculate the difference between two dates in days, months, or years. Example: =DATEDIF([Column1], [Column2], "d").

Top 5 Items to Help Improve SharePoint Performance

The following are five items to help improve SharePoint performance:

1. Client-side processing and data requests: The SharePoint modern experience utilizes client-side processing and the Microsoft 365 CDN to improve performance.
2. Optimizing network connectivity: Network optimizations from the Microsoft infrastructure use the tuning Network Interface Card (NIC). Coupled with custom drivers these take advantage of the Microsoft Global Network, and assessing network connectivity in the Microsoft 365 admin center.
3. Avoiding common mistakes: Mistakes such as iterating through SPList items, requesting too much data from the content database, memory leaks with SPSite and SPWeb, and using index columns that do not necessarily improve performance.
4. Storage improvements: These include upload, download, and content interaction.
5. Performance monitoring tools: Using performance monitoring tools such as Dynatrace, which offers unique reports based on problems in the environment, assists in troubleshooting problems affecting various SharePoint servers, databases, and the network, and provides proactive alerts to notify admins about any bottlenecks.

Top 5 Keyboard Shortcuts for the SharePoint Online Modern Experience

The following are the top five keyboard shortcuts for the SharePoint Online modern experience:

1. Tab key: Navigate the screen.
2. Shift+F10 or Windows Menu key: Display the context menu for the selected item.
3. Alt+S: Use search.
4. Ctrl+C: Copy text.
5. Ctrl+X: Cut text.

Top 5 Ways to Embed Content in SharePoint

The following are the top five ways to embed content in SharePoint:

1. Embed web part: One can use the Embed web part to display content on a SharePoint page from sites that allow embedding.
2. Content Embed web part: This web part allows one to embed content from a variety of sources, including Microsoft Stream, Microsoft Forms, etc.
3. Connected Web Parts: This feature allows one to connect web parts together to create a more dynamic and interactive experience.
4. SharePoint Embedded: This feature allows one to embed SharePoint content in other applications, such as Microsoft Loop and Microsoft Designer.
5. Add content to a SharePoint space with the Embed web part: This web part allows one to display content in SharePoint from websites that allow embedding.

Top 5 Tricks for SharePoint Spacers

The following are the top five tricks to help with SharePoint spacers:

1. Full-Width Section: To add a full-width section to a page, click the + sign and select Full-Width Section.
2. 4th Column: One can add a 4th column to a page by clicking the + sign and selecting Vertical Section.
3. Link Pages: One can link pages on a SharePoint site using double brackets. Example format would be [Cool page of info].
4. Spacer Web Part: One can add vertical space to a page using the Spacer web part.
5. Use Sections Generously: Adding sections on a page with different color shades based backgrounds can create a visually appealing page based display.

Top 5 SharePoint Math Functions

The following are the top five SharePoint mathematical functions to use in calculated columns, functions and views:

1. SUM: Used to sum all the numbers in a column.
2. AVERAGE: Used to calculate the average of all the numbers in a column.
3. MAX: Used to return the highest value in a column.
4. MIN: Used to return to the lowest value in a column.
5. COUNT: Used to count the number of items in a column.

Top 5 Tips to Make Visually and Interesting SharePoint Pages

The following are five tips to make visually and interesting SharePoint pages:

1. Edit images for a visual experience: Use images to create a better user experience by guiding people to the content they’re looking for. Tie an image to a bold headline by using the correct text formatting and web parts with images.
2. Plan to use more horizontal space: Use horizontal space to create a more modern and visually appealing design.
3. Use different link styles: Use different link styles to make your SharePoint pages more visually interesting.
4. Add sections to break up pages: Use sections to break up pages into smaller, more manageable aspects.
5. Go further with collapsible sections: Use collapsible sections to create more dynamic and interactive pages.