Sometimes, we need to know how many specific weekdays between two dates. For example, I have two dates: the start date is 1/1/2014 and the end date is 2/15/2014, now I want to know how many times a Sunday or a Monday or a Tuesday etc occurs in this duration. Maybe this is somewhat difficult […]
Author: Summa Lai
How to Use AirDrop on Your iPhone, iPad, or iPod Touch
Use AirDrop to share and receive photos, documents, and more with other Apple devices that are nearby. Before you begin Make sure that the person you’re sending to is nearby and within Bluetooth and Wi-Fi range. Check that you and the person you’re sending to have Wi-Fi and Bluetooth turned on. If either of you have Personal […]
How to Reserve an IP Address on a NETGEAR Router?
When you specify a reserved IP address for a computer on the LAN, that computer always receives the same IP address each time it accesses the router’s DHCP server. Assign reserved IP addresses to computers or servers that require permanent IP settings. To reserve an IP address: Launch a web browser from a computer or […]
Understand Power BI Workspace Roles: Viewer / Contributor / Member / Admin
In this blog you will understand the difference between Power BI workspace roles. In Power BI new workspace we have four roles and they are- Admin, Member, Contributor & Viewer. Let’s understand all in detail- Admin Create, edit, delete, copy and publish reports and content in a workspace. Publish, Update, or Share App in workspace. […]
How to Make Gmail as a Desktop App
In this two-minute guide, I’ll show you a quick and easy method to create a Gmail desktop app. Unfortunately, Gmail does not have a downloadable desktop app of their own, so we’ll have to do a quick workaround. This guide requires you to use Google Chrome as your main internet browser. We use a Mac in the examples, but […]
Excel VBA – How to Turn Automatic Calculations Off (or On)
Whenever you update a cell, Excel goes through a process to recalculate the workbook. When working directly within Excel you want this to happen 99.9% of the time (the exception being if you are working with an extremely large workbook). However, this can really slow down your VBA code. It’s a good practice to set […]