Top 4 Average Formulas in SharePoint

The following are the top four average formulas in SharePoint:

1. Average of two columns: To calculate the average of two columns, use the following formula: =[Column1]+[Column2])/2.
2. Average of multiple columns: To calculate the average of multiple columns, use the following formula: =AVERAGE([Column1], [Column2], [Column3]).
3. Average of selected items: To calculate the average of selected items in a choice column, use the following formula: =AVERAGE([Choices]).
4. Average of a column with errors: To calculate the average of a column with errors, use the following formula: =IF(ISERROR([Column1]/[Column2]), "-", [Column1]/[Column2]).

Top 4 Count Formulas in SharePoint

The following are the top four count formulas in SharePoint:

1. Count: This formula counts the number of cells in a range that contains numbers.
2. Countif: This formula counts the number of cells in a range that meet a certain condition.
3. Sum: This formula adds up the values in a range of cells.
4. Average: This formula calculates the average of the values in a range of cells.

Top 4 External Web parts for SharePoint

The following are the top four external web parts for SharePoint:

1. Planner: Displays tasks and progress from team boards plans.
2. Twitter: Displays individual tweets and full feeds.
3. Office 365 Connectors: Used to embed information from 3rd party services such as Bitbucket, JIRA, and RSS.
4. Kindle Instant Preview: Used to reference an important Kindle book with one-click to preview or buy.

Top 3 Items About SharePoint Online Widths

The following are three key information items on SharePoint Online widths:

1. SharePoint Online uses a responsive grid system based on the Office UI Fabric The basic grid in the SharePoint desktop experiences is a 12-column structure.
2. In a communication site the max width listed as being 1204 px.
3. In a team site the max width is listed as being 1204 px.

Note: these aspects may vary based on your screen size, system and layout of the page.

Top 3 SharePoint Themes

The following are the top three SharePoint themes:

1. Teal: One of the default themes that comes with SharePoint. This theme has a calming effect and is easy on the eyes.
2. Indigo: A custom theme that can be defined using SharePoint’s JSON schema. This theme had a modern look and feel, with a focus on simplicity.
3. Warm Gray: Another default theme that comes with SharePoint. This theme has a professional look and feel, with a focus on readability.

Top 4 Button Aspects in SharePoint Online

The following are the top four button aspects in SharePoint Online:

1. Button web part: This web part lets one easily add a button to a page with a label and link.
2. Quick Links web part: This web part allows one to capture links on the page and allows for several different layouts/customizations.
3. Call to action web part: This web part allows for a button link along with custom text to be utilized. The button the end user clicks can be set and styled as needed.
4. Navigation: This is a navigation option in SharePoint Online that allows for links and menus to be utilized to suit one’s needs.

Top 3 Key SharePoint Online Strategies to Consider

The following are three key SharePoint Online strategies to consider:

1. Focus on user adoption and engagement.

• Make it easy to utilize. A SharePoint site should be intuitive and easy to navigate. It should have clear labeling, logical site structure, and helpful search functionality.
• Promote the value. Let users know how SharePoint can be beneficial. Showcase success stories and highlight how SharePoint can help save time, is productive, and allows one to collaborate more effectively.
• Provide training and support. Offer training sessions and resources to help users learn how to utilize SharePoint effectively. This could include online tutorials, cheat sheets, or in-person workshops.

2. Leverage the power of collaboration.

• Utilize MS Teams and Viva for real-time communication. These tools can help connect colleagues, as well as let them share ideas, and work on projects together in real-time.
• Create collaborative workspaces. Utilize SharePoint sites and libraries to store and share documents, track tasks, and manage projects.
• Encourage knowledge sharing. Utilize wikis, forums, and other tools to capture and share institutional knowledge.

3. Use governance to keep the SharePoint environment organized and secure.

• Develop a clear information architecture. This will help to organize content in a way that makes sense for the users.
• Implement strong security measures. Make sure the SharePoint site is protected from unauthorized access and data breaches.
• Monitor and manage the SharePoint environment. Regularly review the site usage and make changes as needed.