If you are creating a public website with SharePoint online and you want to start marketing that website to customers, you will want to get google and bing to start crawling your site.

To achieve this, you will need do some manipulation of the website with SharePoint Designer, as the web based configuration console will not allow you to either drop a verification file in the correct place, or make any changes to the meta data required for you to register your site with either google or bing’s webmaster tools.

Here are a few simple steps to help you achieve the goal:

  1. Download the html verification file from google or bing
  2. Open your public website with SharePoint Designer
  3. Click on the ‘All Files’ icon in the left pane, under the ‘Site Objects’ pane.
  4. You should be able to drag the google or bing html file straight into the right hand pane, and it will immediately upload this to the server
  5. Once you have done that, you should be able to go back to the google or bing webmaster tools and hit verify.

 

All done.  You should now have your site registered with either google or bing.

Tags: , , , , , ,

You may want to add full access permissions to a mailbox for a specific user or group.

If you have just created a shared mailbox, you will need to assign permissions to an individual or group so that you can access this.

This guide will teach you how to add full access permissions to a mailbox via powershell.

 

Preparation

You need to get the following information before you create the shared mailbox:

Variable Value (example shown)
<shared mailbox alias> sharedmb1
<user or group UPN> user1@domain.com

 

Implementation

Create Shared Mailbox

Add-MailboxPermission <shared mailbox alias> -User <user or group UPN> -AccessRights FullAccess

 

Example:

Add-MailboxPermission sharedmb1 -User user1@domain.com -AccessRights FullAccess

 

Click on the related links below to complete your goal:

Modern Melee can help you with your administration of Office 365 cloud services. Click here for more information
Tags: , , , , ,

There are a number of functions that you need to use PowerShell to do in Office 365.

One of these functions is to create shared mailboxes, as the web gui does not allow you to do this.

 

This guide will teach you how to create a shared mailbox using powershell.

Preparation

You need to get the following information before you create the shared mailbox:

Variable Value (example shown)
<shared mailbox alias> sharedmb1
<shared mailbox display name> Shared Mailbox1
<shared mailbox email> sharedmb1@domain.com

 

Implementation – Simple Method

This is the simplest method to create a shared mailbox.  If you are going to be creating a lot of these, you might be best checking out the best practice method.

Create Shared Mailbox
New-Mailbox -Name "<shared mailbox display name>" -Alias <shared mailbox alias> –Shared

Apply the correct quota settings
Set-Mailbox <shared mailbox alias> -ProhibitSendReceiveQuota 5GB -ProhibitSendQuota 4.75GB -IssueWarningQuota 4.5GB

Example

New-Mailbox -Name "Shared Mailbox1" -Alias sharedmb1 –Shared
Set-Mailbox sharedmb1 -ProhibitSendReceiveQuota 5GB -ProhibitSendQuota 4.75GB -IssueWarningQuota 4.5GB

 

To access these mailboxes you are going to need to assign permissions to your user account. Click on the related links below to complete your goal:

 

 

Modern Melee can help you with your administration of Office 365 cloud services. Click here for more information
Tags: , , ,

There are a number of functions that you need to use PowerShell to do in Office 365.

One of these functions is to grant ‘SendAs’ permissions to mailboxes, as the web gui does not allow you to do this.

This guide will teach you how to grant ‘SendAs’ permissions to a mailbox using powershell.

 

Preparation

You need to get the following information before you create the shared mailbox:

Variable Value (example shown)
<shared mailbox alias> sharedmb1
<user display name requiring sendas permission> Test User1

Implementation

This is the simplest method to create a shared mailbox. If you are going to be creating a lot of these, you might be best checking out the best practice method.

Grant ‘SendAs’ Permissions to a Mailbox

Add-RecipientPermission <shared mailbox alias> -Trustee "<user display name requiring sendas permission>" -AccessRights SendAs

Example

Add-RecipientPermission sharedmb1 -Trustee "Test User1" -AccessRights SendAs

 

To access these mailboxes you are going to need to assign permissions to your user account. Click on the related links below to complete your goal:

 

Modern Melee can help you with your administration of Office 365 cloud services.  Click here for more information.

Given a list of phone numbers, and the need to turn these into international format,  you may need to combine some formulas.

Example:

Original phone number in Cell A2:     2223334444
Desired format:    +1 (222) 333-4444

Excel formula:
=CONCATENATE(“+1 (“,LEFT(A2,3),”) “,MID(A2,4,3),”-“,MID(A2,7,4)))

Tags: , , , ,

If you are looking to clear all formatting on an Excel spreadsheet, then Excel 2007 has just the feature.

Click the ‘Home’ tab in the ribbon, click on the ‘Clear’ icon in the ‘Editing’ section, and select ‘Clear Formats’

image

Nice and simple, and very useful.

Tags: ,

When trying to delete a sheet programmatically in Excel, an alert is displayed asking you to confirm if you want to delete the sheet.

image

To remove this, you can use the following code:

Application.DisplayAlerts = False
Worksheets("Sheet1").Delete
Application.DisplayAlerts = True

The alerts will be switched off for this action and then turned on again.

Tags: , , , , , ,

A common task when analysing data is to highlight values to show the data.

To highlight a row based on the value of one cell you need to use the INDIRECT function in Excel.

This allows you to use conditional formatting to highlight a whole ROW based on the value of one of the cells in the row.  (Useful if you have used a count function to highlight duplicates)

Example:

Lets say you have numbers in column B, and you want to highlight all the rows where the value in the column equals “2”.

You can use the formula below in the conditional formatting rule to create the entry:

=INDIRECT("B" & ROW())=2

image

You can amend how you want to format the values as normal.

Tags: , , ,

After a recent laptop hard drive failure I have been checking out some home backup solutions to backup that valuable data.

After a long search it comes down to 2 contenders; Acronis True Image Home and Nero BackItUp.

Both allow you to backup files and your system, however where Acronis is streets ahead is the recovery software.  True Image Home allows you to create a disk/partition image of your operating system, back this up to a portable hard drive so that in the event of any drive failure, a restore can be achieved with speed.  Acronis gives you the ability to create rescue media to either a CD or even a bootable USB stick, which given the abundance of netbooks without CD drives is streets ahead.

You can use the Excel formula ISNA to remove excel producing ‘#N/A’ results in cells.

This is especially useful when using VLOOKUP functions which seach for values in one column and return values in other columns.

How to use it:

Using ISNA is conjunction with IF, you can create a formula that will replace #N/A when it appears.

=IF(ISNA(“<yourformula>”),””,”<yourformula>”)

for example:

=IF(ISNA(VLOOKUP(A1,B1:B26,1,FALSE)),””,VLOOKUP(A1,B1:B26,1,FALSE))