Rapid Creation and Renaming of SharePoint Lists SharePoint, be it Office 365 or On-Premise, allows rapid creation of lists. Within few clicks, you have a nice container for documents or structure data. Occasionally, you need to rename those lists at a later time. Good news;… Read More »How to Rename SharePoint Lists
Interactive Data Visualization In this Information Age, more data is being generated than ever. Analytics can’t seem to keep up with the inflow. Excel and Microsoft SQL Server Reporting Services (SSRS) have long dominated both spectrum of Microsoft business intelligence stack. Power BI is a newer suite of… Read More »Power BI – Cloud Business Intelligence Tool
Redmond’s Answer to Trello? You must have heard of Trello, the popular card-based project management software. Atlassian just snatched Trello up for $425 million few days ago! What is the buzz behind these task management tools? For years, Microsoft Project has been the de-facto way to manage group… Read More »Microsoft Planner: New Project Management Tool in Office 365
What Are Multi-Choice Columns? If you have been using Office 365 or SharePoint as a data management tool or business application platform, you most likely have come across checkbox columns (aka multi-choice columns). Creating a list with multi-choice columns is effortless. As is the data entry.… Read More »How to Analyze SharePoint List Data in Python
Excel Makes Data Analytics Accessible Office 365 and SharePoint are awesome for working with structured data. All the data is at your finger tips. You just need a web browser to view and edit to your heart’s content. There are times you may need to tap… Read More »How to Export SharePoint Data to Excel
Office 365 Cloud Storage Microsoft OneDrive has always been a great option for sharing within internal teams. However, the external sharing tends to feel a little less intuitive. That has traditionally led to users opting for other file sharing platforms (e.g. Box, Dropbox, Google Drive,… Read More »How to Share Files in Microsoft OneDrive
Target Audience: Office 365 Administrators Distribution Groups, (aka email aliases or distribution lists) conserve keystrokes and improve accuracy. Say you work at ACME Company and regularly communicate with Jane at Northwind Trading Company. Instead of typing “[email protected]; [email protected]; [email protected]” in every single email correspondence, you would simply… Read More »Office 365 Tips – How to Create Email Distribution Groups
SharePoint Server Topology Primer The first step to deploying SharePoint is to determine an appropriate server topology. This decisions is largely is dictated by the number of SharePoint users. For this blog post, let’s assume that an on-premise server farm is designed for a medium… Read More »How to Select SharePoint Server Architecture for Medium Sized Business
Target Audience: Office 365/SharePoint Users Good news: SharePoint lists and libraries can contain a huge number of items. Bad news: Finding the right items requires more efforts. SharePoint, by default, displays every list item alphabetically. Clicking on column headings allows you to sort and filter items,… Read More »Office 365 Tips: How to Sort, Filter, and Group in List Views
Editing Multiple Records Simultaneously Typically when users add an item to a SharePoint list, they would have to do so one at a time. This is incredibly tedious; a quicker method is Quick Edit. Quick Edit (or Datasheet view in older versions of SharePoint) turns the list… Read More »How to Edit SharePoint List using Quick Edit