Thursday, December 21, 2023

3 Tips for Using SharePoint Online for Scrum

The following are three tips for using SharePoint Online for Scrum:

  1. Create a site collection to hold one Scrum site per project. In the site include all the documents, schedules team member and list based information.
  2. Use task prioritization techniques such as MoSCoW, Kano model, etc. to prioritize tasks in the product backlog. Posted Excel documents or simple information from lists can be used for backlog tasks and show proper status and priority.
  3. Leverage SharePoint’s metrics tracking and automated testing features. Use the document libraries and lists to add all of the proper stories for the project to the site. Information needed for a story such as points, estimated time, developer, tester, story tasks, test cases, etc. For metrics, use web parts such as the chart webpart for burn-down charts, velocity, points per iteration, etc.

Wednesday, December 20, 2023

3 Examples of Calculated Columns in SharePoint

The following are three examples of calculated columns in SharePoint:

  1. Conditional formulas: These formulas can be utilized to evaluate a condition and return a value based on the result. For example, one can use the IF function to check if a value in one column is greater than another column and return a specific value if the condition is true. One can also use the AND and OR functions to evaluate multiple conditions.
  2. Date and time formulas: These formulas can be utilized to calculate the difference between two dates or times, extract specific parts of a date or time, or perform other operations. For example, one can use the DATEDIF function to calculate the number of days between two dates.
  3. Mathematical formulas: These formulas can be utilized to perform mathematical operations on values in other columns. For example, one can use the SUM function to add up the values in two or more columns, or use the ROUND function to round a number to a specific number of decimal places.

Tuesday, December 19, 2023

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])
  3. DATEDIF formula: This formula is utilized to calculate the difference between two dates in days, months, or years. Example: =DATEDIF([Column1], [Column2], "d")

Sunday, December 17, 2023

Top 3 Ways to Access SharePoint

The following are the top 3 ways to access SharePoint:

  1. SharePoint Site: One can access documents via the web interface by going directly to a SharePoint site.
  2. Microsoft Teams: One can access via a collaboration method via Microsoft Teams. One can access the document library via the Files Tab in a MS Team channel.
  3. Windows Explorer (via OneDrive sync): One can access documents just by synchronizing them to/from a computer via OneDrive sync. This will allow one to access your documents in a very familiar interface (via Windows Explorer).

Saturday, December 16, 2023

6 SharePoint Tips and Tricks for Using Web parts

The following are six tips and tricks related to using SharePoint web parts:


1. Use a variety of web parts to create visually appealing and informative pages.


2. Customize web parts to match branding and style.


3. Use web parts to display dynamic data.


4. Use web parts to create interactive pages.


5. Use web parts to embed content from other sources.


6. Use third-party web parts to extend SharePoint's functionality.

Thursday, December 14, 2023

5 Benefits of Using SharePoint

The following are five benefits of using SharePoint:

  • Collaboration: SharePoint provides a variety of tools for collaboration, such as lists, libraries, and calendars. These aspects make it easy for teams to work together on projects and share information.
  • Document management: SharePoint provides a central location to store and manage documents. These aspects make it easy for users to find the documents they need and to keep track of changes.
  • Workflow automation: SharePoint can be used to automate workflows, such as approval processes and document routing. These aspects can help to save time and improve efficiency.
  • Scalability: SharePoint is a scalable platform that can be used to support organizations of all sizes.
  • Security: SharePoint provides a variety of security features to protect data. These aspects make it a good choice for organizations that need to protect their sensitive information.

Wednesday, December 13, 2023

Brief List of 6 Key Features in SharePoint On-Premise Over the Years

The following are six key features that have been added to SharePoint on-premise over the years:

  • 2003: SharePoint 2003 introduced support for wikis, blogs, and web content management.
  • 2007: SharePoint 2007 introduced support for enterprise social networking, document libraries, and workflows.
  • 2010: SharePoint 2010 introduced support for mobile devices, cloud storage, and business intelligence.
  • 2013: SharePoint 2013 introduced support for hybrid deployments, social features, and search.
  • 2016: SharePoint 2016 introduced support for Office 365 integration, hybrid deployments, and security features.
  • 2019: SharePoint 2019 introduced support for modern UI, artificial intelligence, and compliance.