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.

Top 3 SharePoint Online Actions

The following are the top three SharePoint actions:

1. Document Sharing and Co-Authoring: SharePoint Online allows end users to share documents with others and collaborate on them in real-time.
2. Team Sites and Communication Sites: SharePoint Online offers two types of sites that can be used to create a collaborative workspace for teams. These types are a team site and a communication site.
3. Integrated Workflow Automation: SharePoint Online provides a range of tools for automating workflows, including Microsoft Power Automate.

Top 3 SharePoint Online Visions

The following are the top three visions for SharePoint Online:

1. Cloud-Based Flexibility: SharePoint Online is a cloud-based service which provides unparalleled flexibility and accessibility. It allows information access and collaboration from anywhere, anytime with a Internet/Intranet connection.
2. Enhanced Collaboration Tools: SharePoint Online offers powerful features designed to enhance collaboration, streamline workflow, and secure data.
3. Advanced Security Measures: SharePoint Online provides advanced security measures to protect the data.

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.

Top 5 Best Practices for SharePoint Lists

The following are five best practices in regard to SharePoint lists: 

1. Keep the list focused: Keep the list to only one purpose or context and try not to mix information.
2. Use the modern experience: If one can use the modern interface that is best.
3. Plan for large lists. One should plan for building and operating large SharePoint Lists and Libraries well above the item limit threshold.
4. Be aware of the List View Threshold: This is when the number of items or documents is so high that SharePoint displays an error instead of the content.
5. Use proper information architecture: To use SharePoint safely and effectively, use the right security settings and tips for efficient administration.

Top 5 Key Features of SharePoint That You Should Know

The following are five key features of SharePoint that you should know:

1. Flexibility and Safety: SharePoint enables one to create intranet sites that serve as an internal internet for the business.
2. Simplifying and Integrating Business Processes: SharePoint can be utilized to simplify and integrate business processes, making it easy to manage workflows and automate tasks.
3. Content Optimization and Data Management Simplified: SharePoint can make it useful to manage and optimize content, as well as store and manage data.
4. Individualization and Centralization of Management: SharePoint allows for individualization and centralization, making it easy to manage and customize a site.
5. Efficiencies in Cost-cutting and Real-Time Collaboration: SharePoint can help cut costs and improve collaboration by providing real-time access to information and resources.

Top 5 SharePoint Web Part Aspects

The following are the top five SharePoint web part aspects:

1. Personalized full-width news carousel: This web part can display news articles in a full-width carousel based format.
2. Color-coded SharePoint calendar web part: This web part displays a color-coded calendar which can be customized to show events from multiple calendars.
3. Quick Links web part: This web part can display a list of links to frequently accessed pages or documents.
4. SharePoint search for document library web part: This web part allows one to search for documents that are in a document library.
5. Employee directory web part: This web part displays a list of employees in one’s organization.

Top 4 Best Practices for SharePoint 2019

The following are the top four best practices for SharePoint 2019

1. Plan the information architecture: In SharePoint 2019, every site is a site collection and can be associated with a hub. A hub is a flat collection of sites which share navigation, branding, and other elements.
2. Personalize the page banner: Use good text descriptions and use quick links for the most relevant material. Show long text in the form of collapsible sections.
3. Evaluate site performance: Use the site performance feature to evaluate the performance of a SharePoint site.
4. Keep the content up-to-date: Ensure that the content is up-to-date and relevant to the intended audience.