SharePoint Site Permissions
SharePoint’s permissions define access and level of control a user or group has over a SharePoint component. SharePoint Permissions can be managed by a site level group or individual. Following are the pre-defined permissions offered by SharePoint. They are listed from the lowest level of access and control to...
What is Microsoft SharePoint 365
Microsoft SharePoint is a collaboration platform. A cloud drive allows you to share documents only. SharePoint allows you to share documents and collaborate. In SharePoint, you can create sites, use Notepad, integrate with teams, share files, and much more. Microsoft 365 is a cloud-based office solution. Unlike its predecessors,...
How to pull in data from Federal Reserve Economic Data (FRED) to Excel
United States Federal Reserve collects massive quantities of economic data. The organization distributes some of its data for free online. This post shows how to import FRED’s data into Excel. Step 1: Install FREDs Add-In. Go to https://fred.stlouisfed.org/fred-addin/. Click on the checkbox next to I agree to terms of...
How to add and remove Excel Add-Ins
Add-Ins are used to add functionality Excel such as pulling stock prices from a website, getting live weather, or connect with Jira. In short, Add-Ins are to Excel what apps are to an iPhone. To add an Excel Add-In, click on Insert > Get Add-Ins. The choose the Add-In...
How to create custom fields in Microsoft Project
This post shows how to create custom fields in Microsoft Project. To create custom fields, go to Project > Custom Fields. Then choose the type you want and add the fields. Following are detailed step-by-step instructions. Create a blank Microsoft Project document by starting Microsoft Project and clicking on...
How to add statutory holidays in Microsoft Project
This post shows how to add statutory holidays in Microsoft Project. To add a statutory holiday, go to Project > Change Working Time. Go to Exceptions tab and add the holidays. Following are detailed step by step instructions. Click on Project > Change Working Time. See Figure below: Ensure...
Principles of Web Design
Conceiving user-friendly and easy to navigate websites is not rocket science. It does not require state-of-the-art multimillion dollar technologies. Most websites don’t fail because of technology but at their conception. I would love to write a long list of website design and development blunders, and back them up with...
How to Create and Attach an EBS Volume to an EC2 instance
This post shows how to create and attach Amazon Web Services (AWS) Elastic Block Storage (EBS) to Elastic Cloud Compute (EC2). Steps to create and attach EBS volume to EC2 instance: Login into AWS Create Volume Attach Volume ID to EC2 instance Connect to your instance using SSH Mount...
How to setup and configure an EC2 instance
This post show how to configure an Amazon Web Services (AWS) Elastic Compute Cloud (EC2) instance. Steps to setup and configure an EC2 instance: Login to AWS console Choose region Launch EC2 wizard Select AMI Select instance type Configure network Configure storage Configure key pairs Launch and connect Following...
How to show single or multiple pages on a Microsoft Word screen
By default, when you have a large screen open or when you zoom out enough, Microsoft Word would show multiple pages on your screen. Sometimes, you want multiple pages on a screen but sometimes you don’t. The option that controls this feature is in the View Ribbon. To show...
Installing Python and Jupyter on Windows 10
This article will show you the easiest, non-technical way to install Python and Jupyter on Windows 10. The simplest way to install Python, Jupyter, other great python tools, simply download and install anaconda. Following are detailed steps: Go to anaconda.com Go to Products > Individual Edition Scroll all the...
Working with equations in Microsoft Word
The equation tool in Microsoft Word can be used to create complex equations. This article would show you how to get started. Using built-in equations: Click on Insert and then the arrow underneath the Equation icon. You should see the following: These are built-in equations. To use them, click...