Combine multiple excel sheet (Power Query)

refer to this article

Power Query is included with Excel 2016. It has been renamed and is now on the Data tab of the Ribbon in the Get & Transform section. This means there is nothing to install. If you are using Excel 2016, go to the Data tab on the ribbon and press the New Querybutton to create a query and open the Power Queryeditor.

  1. prepare each sheet: create “Table”. Column names shall be identical (it is case sensitive).
  2. create query “From Table”.
  3. merge query and load data to a new sheet
Advertisements
Posted in Uncategorized | Leave a comment

SharePoint online: share document

  • Get Access link:

“View” and “Edit” are difference links: e.g.

https://????.sharepoint.com/sites/????/_layouts/15/guestaccess.aspx?guestaccesstoken=JUcWH5UX……

https://????.sharepoint.com/sites/????/_layouts/15/guestaccess.aspx?guestaccesstoken=pI%2fr5NfgoDa8….

  • How to Share

2017-09-06-0001

 

Posted in Office365, SharePoint online, Uncategorized | Leave a comment

Office 365 (SharePoint online): tenant vs. Domain (DNS) name

  • Excerpt from this Post:

When you create a tenant for your organization, we will then register two different DNS entries by default.  Let’s assume the tenant name we are picking is guyinacube.  The two DNS entries that will be created are the following.

  • guyinacube.onmicrosoft.com
  • guyinacube.sharepoint.com

My tenant name is guyinacube.  The default domain for the Tenant will be guyinacube.onmicrosoft.com.  Any users I add at this point will have a login/email address of user@guyinacube.onmicrosoft.com if I do nothing else.

There is no cost to having a Tenant itself.  The cost comes in with whatever subscriptions you have for your Tenant and the number of licenses you are paying for.  This may be O365 Subscription, SharePoint Online, Exchange, Power BI, etc…

  • Excerpt from this Post:

Why do I have an “onMicrosoft.com” domain?

Office 365 creates a domain for you, like contoso.onmicrosoft.com, when you sign up with the service. The user ID that you create when you sign up includes the domain, like alan@contoso.onmicrosoft.com.

If you want to have your email look like alan@contoso.com: buy the domain or just follow the steps in Add your users and domain to Office 365 if you own it already.

  • You can’t rename the onmicrosoft domain after sign-up. For example, if the initial domain you chose was fourthcoffee.onmicrosoft.com, you can’t change it to be fabrikam.onmicrosoft.com. To use a different onmicrosoft.com domain, you’d have to start a new subscription with Office 365.
  • You can’t rename your team site URL. Your team site URL is based on your onmicrosoft.com domain name, and because of the way SharePoint Online architecture works, unfortunately you can’t rename the team site.
  • You can’t remove your onmicrosoft domain. Office 365 needs to keep it around because it’s used behind the scenes for your subscription. But you don’t have to use the domain yourself after you’ve added a custom domain.

You can keep using the initial onmicrosoft.com domain even after you add your domain. It still works for email and other services, so it’s your choice.

Posted in Office365, SharePoint online | Leave a comment

Write Project Bid Documents

  1. Decide which General Condition (GC) to use (e.g. AIA, EJCDC)
  2. prepare “Supplementary Condition” (SC) that tweak (revise) General Condition
  3. Prepare “Tech Specification”, decide which Divisions to use
  4. Prepare “Special Provision” that tweak Tech Specification,
  5. Prepare “Agreement”,
  6. Prepare “Instruction to Bidders”
Posted in Uncategorized | Leave a comment

SharePoint Team Site vs. OneDrive for Business

This post give an answer:

OneDrive for Business is meant to be your “me” place at the office. Basically, if you’re trying to compare it to your File Shares, it could be thought as the new “Home Folders” for users or the new “My Documents”.

SharePoint Team Site is meant to be the “We” part of the work for you and your team. In this location, the file isn’t owned or associated to one user, but rather the team itself or the Team Site if you will.

Posted in Office365, SharePoint | Tagged | Leave a comment

SharePoint Online: NT Authority\Authenticated Users

This answer comes from this post:

All Users (windows) and All Users (membership) are not valid for use in SharePoint Online?
Yes, in SharePoint Online, we use Everyone or Everyone except external users.

Does Everyone except external users include users who are present in Office 365 but do not have a license?
No. The Everyone except external users group includes the users who have been assigned SharePoint Online licenses. The Everyone group includes internal licensed users or external users from external sharing.
Note: External users are the users outside of your tenant. They may from other Office 365 tenants or just the users with Microsoft accounts.

Posted in Office365, SharePoint | Leave a comment

How to paste code at WordPress blog

  1. Use Notepad++ (32 bit), add plugin Convert2HTML
  2. covert code to html inline CSS,
  3. switch post edit mode to HTML, and paste, like below.
 <Item MenuEntryName="Edit" MenuItemName="Cut"/>
 <Item MenuEntryName="Edit" MenuItemName="Copy"/>
 <Item MenuEntryName="Edit" MenuItemName="Paste"/>
 <Item MenuEntryName="Edit" MenuItemName="Delete"/>
 <Item MenuEntryName="Edit" MenuItemName="Select all"/>
 <Item MenuEntryName="Edit" MenuItemName="Begin/End Select"/>
Posted in Uncategorized | Leave a comment