Connecting Technology and Business.

The Wikipedia in Word

​Creating a research paper or citing the text in a document to its original source has become easy. Now you can search the Wikipedia from your favourite MS Word application. There is a Wikipedia app that can help you search for info from the Online encyclopedia when you are working on a Word document.

Just open the app and it displays in a pane to right of the document for easy view and reading. Now click a word or sentence in your document. The app immediately searches the Wikipedia for this search term. It has sections, images infobox and references tabs for easy navigation. Additional quick links that are related to the search term are also presented at the bottom of the main content.

When you mark a portion of the text or point to a picture in the pane, it presents a + sign that helps quick insertions of the content with a citation as to where this info is picked from. A complete summary of the search item from the Wikipedia's page content is displayed in the infobox. The references tab gives a lot of links to various pages in the net that relates to the search term.

Change Your Profile Picture in Office 365

​In the Lync main window, click your picture.

In My Picture options, under My picture, click Edit or Remove Picture.

Note: If the Edit or Remove Picture button is unavailable (grayed out) mke sure:

  • The Hide my picture option, above Edit or Remove Picture, is not selected.
  • You have the Office 365 service upgrade.

Important:   If you have the service upgrade and Show my picture is selected but the button is grayed out, the option to change your picture has been disabled at your company.

  1. On the Office 365 sign-in page that opens, type your Office 365 user name and/or password as needed, and click Sign in.
  2. Click Browse, and go the picture you want to use. Any size and resolution is fine.
  3. Click the file, and then click Save.

You can use Outlook Web App offline!

Offline access lets you use Outlook Web App on your laptop or desktop computer when you're not connected to the Internet. After you've enabled offline access, Outlook Web App will work in an offline mode as needed depending on your network connection. When you're online, Outlook Web App will automatically update the offline information. To use offline access, you need at least Internet Explorer 10, Safari 5, or Chrome 24.

What can I do when I'm offline?

Most tasks that you can do online are available when you're offline. Tasks you can do while offline include but aren't limited to:

  1. Reading and responding to messages.
  2. Sending new messages.
  3. Viewing and editing your calendar.
  4. Responding to meeting requests.
  5. Viewing and editing your contacts.

If you try to do something that's not available offline, you will either see an error message, or what you did will change back. Anything that you do while offline will be uploaded to the server when you reconnect to a network.

1. To turn on offline access, select Settings at the top of the Outlook Web App window and select Offline settings.

2. Select Turn on offline access.

3. Select OK. Outlook Web App will walk you through the steps to set up and use offline access.

On some browsers, you may see a message warning you that the website is requesting space on your disk. For the best offline experience, accept the request for space.

Warning    You should not turn on offline access on a computer that you share with others.

  • Offline access may not make all of your email and calendar information available offline. Some of the available features and limitations are:
    • The last few days of messages. Supported folders include Inbox, Drafts, and any folders viewed within the last few days, up to 20 folders. If you've viewed more than 20 folders in the last few days, the most recent 18 plus Inbox and Drafts will be available.
    • In each folder that's available offline, you will see three days of content, or 150 items, whichever is larger.
    • Attachments aren't available when offline.
    • The previous month and future year of your calendar.
    • A limited set of upcoming calendar reminders. If you're offline for a long period of time, calendar reminders will stop working until you go online and Outlook Web App can download current information.
    • Only your primary Calendar will be available offline.
    • All the items in your Contacts folder, plus any people that you email often and any that you've emailed recently.
    • Offline access doesn't include archived folders, Team folders, tasks, or Favorites.
    • You can't search for or sort items in your mailbox when offline, and the built-in filters won't work when you're offline.
  • You have to enable offline access on each computer that you want to be able to use Outlook Web App on when not connected to a network.
  • Offline access for Outlook Web App is designed for portable computers such as laptops and notebooks. It can't be enabled in browsers on smaller devices, such as tablets and smartphones.
  • Your web browser determines where on your computer the offline information is stored and how much space it can use. If your offline information won't fit in the space that's been set aside, you may be prompted to increase it. If the space can't be increased, less of your information will be available when you're offline.

What's new in Outlook Web App

If you've been using Outlook Web App for a while, you may notice some recent changes. Outlook Web App has been upgraded with new features and new ways to manage your mailbox.

 Note:    Some of the features described here may not be available for your account.

New features for Your account

  • Navigation has moved to an upper corner. Use the links in the upper corner to switch to different types of information.
  • Jump to your personal information with one click. Click your name in the upper corner, and then click Change to update your information. If instant messaging is enabled, you can also change your status here.
  • Connect to your LinkedIn or Facebook accounts. Click Settings > Options > Account > Connected accounts to add a connection to your LinkedIn or Facebook accounts.
  • Offline access through the latest web browsers.

New features in mail

  • One-click access to filter messages. You can select all, unread, to me, and flagged with a single click.
  • Apps for Outlook. These apps add features to your mail. For example, if there's a street address in a message, an app for Outlook will add a tab with a map and directions to that address.
  • Inline compose. In addition to reading your mail in the reading pane, you can now compose replies and forwards in the reading pane. You still have the option to open your response in a new window.
  • Drag and drop to add an attachment. In some browsers, you'll be able to add an attachment to a message by dragging it from the desktop to the message form.
  • Find drafts quickly. You don't have to go to your drafts folder or open a conversation to find your drafts. Conversations that you have started a new message in will be clearly marked in the list view.
  • Refine search results with a click. You can quickly refine your search results by selecting an option to change the folders included in the search and the time period searched.

New features in calendar

  • Merged calendars views. When you add an additional calendar to your calendar view, the added calendar will be merged with yours to make it easier to find scheduling overlaps. Each calendar will have its own color, which you can change. If you're using the day view of your calendar, you can split the calendars into separate columns.
  • Click for details. Click any item in your calendar to see a quick view of the details. In addition to a snapshot of the information, you'll find controls to edit items that you own or respond to meeting invitations. Double-click an item to open it in a view that shows all details.
  • More useful month view. The month view now includes an agenda for the current day, and the grid will show as many items as possible based on your screen size plus a number indicating the number of items not displayed for each day.

New features in people

  • Linked contacts. Outlook Web App will look for similar entries in your Contacts folder and will link them together in a single contact card. You can manually link or unlink entries.
  • Adding LinkedIn or Facebook. You can connect to your LinkedIn and Facebook accounts through options. Connecting to LinkedIn and Facebook automatically adds your contacts in those accounts to your Outlook Web App contacts. See Connected accounts to learn more.
  • Your personal contacts folder and your organization's address lists are all available from Contacts.

Organize yourselves - plan your time using Calendars

Creating Appointments in O365 Calendar

Click +New event or double-click the calendar to open a new calendar item form.

Calendar - appointment.png 

  1. Enter a short description of the event.
  2. Add a location if you want.
  3. Select the starting date and time.
  4. Select the duration. Select All day for an all-day event. All-day events appear at the top of the calendar.
  5. Use Show as to choose how you want the time to appear on your calendar.
  6. Change or turn off the reminder.
  7. If you have more than one calendar, choose which calendar to save it to.
  8. Set a repeating pattern if you want this event to repeat.
  9. Mark it as Private if you don't want anyone you've shared your calendar with to see the details.
  10. Use the Notes area to add any other information you want.
  11. Click Save to save your changes or Discard to cancel. 

Create a meeting

A meeting is a calendar event that you send to other people. You create a meeting the same way you do an appointment, but you invite attendees and may add a resource such as a conference room.

After you've selected +New Event, you follow most of the same steps. To turn a calendar item into an invitation, start by entering the names of people you want to invite in the Attendees field.

Calendar - Meeting.png 

  1. You can type names directly in the Attendees field to add them.
  2. Enter a location, or select Add a room to see a list of available conference rooms from your organization's address book. Select Scheduling Assistant to show the calendars of attendees. You can also add or remove attendees and automatically schedule resources such as conference rooms.
  3. To see the availability of attendees and conference rooms, select Scheduling Assistant. When you're done, click OK to save your changes or Discard to cancel. Either will take you back to the event form where you can make any other changes you want before sending.
  4. If online meetings are enabled for your account, you can add an online meeting link by selecting Online meeting.
  5. By default, Request responses is turned on, but you can turn it off if you don't want to know who has accepted or declined the invitation. If you leave request responses on, you'll receive a message as each attendee accepts or declines your invitation.
  6. Click Send to save your changes and send the invitation to the attendees or Discard to cancel.

Work together with Office Documents in OneDrive

Office Online

With Office Online it's easy to work with others because you can send links to documents instead of sending file attachments. That saves on e-mail storage and prevents you from having to reconcile multiple versions of the same document.

To send a link, click Share at the top of the Office Online program window, either while you're viewing:

Editing Excel Online.png 

Or editing your document:

Editing Online 2.png 

When your friends click the link you send, the document opens in their browser.

Editing Online 3.png 

To edit, they click the command for editing in the Office Online program (If you send an email link, they'll need to sign in first).

Editing Online 4.png 

Work with others in Word Online

When you are editing a document in Word Online you might see notification that others are working in the document too. There is no special co-authoring mode and no command to begin working together on a document. You edit in Word Online as you normally would, and if others are also editing the document, Word Online alerts you to their presence, and shows you the paragraph they're working on.

Editing Word Online.png 

People can be working in Word Online, Word 2010 or later, or Word for Mac 2011.

Work with others in Excel Online

If you make your workbook available for others to edit, your friends can work on the workbook at the same time as you. This works well for workbooks where you are collecting information from a group of people, such as a list of information or a group project. No more e-mailing a list around.

While you are editing the workbook, Excel Online shows you where others are also working on the workbook.

Editing Excel Online 1.png 

  • Everyone works in Excel Online; if someone opens the workbook in the Excel desktop application, the workbook can't be edited in Excel Online until it's closed again in desktop Excel.
  • Because Excel Online automatically saves everyone's changes, the Undo and Redo commands might not work the way you expect.
  • Also, when one person changes the sort order or filters data, the view changes for everyone who is editing the workbook. So, be mindful of sorting and filtering while others are in the workbook.

Work with others in PowerPoint Online

Team presentations and school projects: you can work on them together in PowerPoint Online. When more than one person is editing a presentation at the same time, you see their names in top of the PowerPoint Online window:

Editing PowerPoint Online.png 

You and your colleagues will see each other's changes immediately, and PowerPoint Online saves the presentation automatically.

People can be working in PowerPoint Online, PowerPoint 2010 or later, or PowerPoint for Mac 2011. However, for best results we recommend that everyone be working in either PowerPoint Online (where changes are saved automatically) or the PowerPoint desktop applications (where everyone saves the presentation periodically).

Work with others in OneNote Online

If you make your notebook available for other people to edit, your friends can work on the notebook at the same time as you. This works well for notebooks where you are collecting information from a group of people, such as a brainstorming session or a group project. The notebook functions like a wiki where everyone contributes. You can see who did what, and you can revert a page back to a previous version if necessary.

Editing OneNote Online.png 

If you or other people have OneNote 2010 or later, you can work in the OneNote desktop and mobile applications while other people are working on the same notebook in OneNote Online. You can share the notebook in OneDrive, just like Excel, Word, and PowerPoint documents, but you can also share the notebook in OneNote 2010 or later.

  • Click the File tab, and on the Info tab, click Invite people to this notebook, under the name of the notebook.

- Inputs from Help pages of Office

Find What You Want Quickly using AQS in Outlook Web Apps

Searching for content in your mails is sometimes a challenging task - more so when you use only Outlook Web Apps to access your mails. But, you can use Advanced Query Search, or AQS, to refine your searches in Outlook Web Apps. To use AQS, type a keyword followed by a colon, and then what to search for in the search box. For example, to find any message with a subject that contains "tomorrow", enter subject: tomorrow in the search box. 

AQS keywordDescription
FromSearches the From field.
ToSearches the To field.
CcSearches the Cc field.
BccSearches the Bcc field.
ParticipantsSearches the To, Cc, and Bcc fields.
SubjectSearches the subject.
Body or ContentSearches the message body.
SentSearches the date sent. You can search for a specific date or a range of dates separated by two dots (..). You can also search for relative dates: Today, tomorrow, yesterday, this week, next month, last week, past month. You can search for the day of the week or month of the year.
ReceivedSearches for the date received. You can use the same search terms as for Sent.
CategorySearches the Category field.
AttachmentSearches for the specified attachment by title. For example, attachment:letter.doc will find any message with an attachment named letter.doc.

Use has:flag to find items that are flagged.

Use has:attachment to find items that have one or more attachments.


When you use AQS, you can search on multiple search terms. When you enter multiple search terms, you can search on any, all, or an exact phrase. 

  • Subject: product plan will find any message with "product" or "plan" in the subject.
  • Subject: (product plan) will find any message with both "product" and "plan" in the subject.
  • Subject: "product plan" will find any message with the phrase "product plan" in the subject.

Outlook.com - Recent Improvements

​When it comes to getting organized, Outlook.com has users covered. Microsoft has released  Advanced Rules and three other features, all to help users keep their inbox in top shape and make it even easier to see the email that matters to them.

The average person has 184 emails in their inbox, and receives 28 emails each day according to a recent survey. This can be a lot to handle, so helping users get to the email they care about is one of the top priorities. Outlook.com already has a number of features to help users do this. For example, Sweep - one of the most popular features, helps users quickly delete multiple unwanted emails.

The following new features, build on MS's commitment to give the inbox new and better ways to do the heavy lifting and help users save time.

Advanced Rules

With Advanced Rules, users now have more control over how their emails are sorted, filed or bumped to the top of their inbox. Users can create multi-condition and multi-action rules and set their inbox to organize itself automatically. Advanced rules allow users to combine their existing rules together and customize them to suit them. Microsoft has included a number of optional conditions that are unique to Outlook.com, including time constraints, email tallying, checking read/unread state of emails, and checking if the sender is a contact the users know.

Here's an example of an Advanced Rule:

If an unread email is older than 3 days and is from one of your contacts, mark it as important and flag it.

This rule brings any emails you might have missed, from real people you know, to the top of your inbox.

Outlook advance rules.jpg 


Billions of emails in Outlook.com are moved from one folder to another every week. Occasionally, the user will drop an email into the wrong folder or hit Delete by accident. Now it's even easier to undo mistakes in range of commands—delete, categorize, flag, mark as junk, or move—for one email or a whole group. Just clicking the undo button, or typing Ctrl+Z, will bring them right back.

Outlook undo.jpg 

In-line reply

Outlook.com customers use the Reply button almost 8 million times a day. With in-line reply, users can directly respond to an email thread without launching a new view. In-line reply can help users save time, and track their conversations more easily.

Outlook inline reply.jpg 

More personal messaging

Earlier, starting a chat session with friends wasn't as easy to find as it could be, so Microsoft has made several improvements to the experience:

  • Find recent conversations and other contacts a user can chat with in the bottom left of the inbox. One click will launch the user straight into a conversation with them.
  • If the users is chatting with a friend on one service, but want to continue the talk on another service, now they can switch over from right inside the chat session.

Outlook personal messaging.jpg 

- Microsoft Outlook Blog Team

Dependent Dropdown list in Excel

​Supposing I have a table of four columns that indicate four types of foodstuff: fruit, food, meat and drink and below them are the specific food name. See the following screenshot:


Now I need to create one drop down list that contains the foodstuff, such as fruit, food, meat and drink and the second dropdown would have the specific food name. If I select food, the second drop down will show rice, noodle, bread and cake.

To do this, please apply the following steps:

1. First, I need to create some range names for these columns and the first categories row.

(1.) Create a range name for the categories, the first row, select the A1:D1, and type the range name Foodstuff into the Name Box, then press Enter key.


(2.) Then you need to name the range for each of the columns as above step as shown below:

DDL3.png2. Now I can create the first drop down list, please select a blank cell or a column that you want to apply this drop down list, and then click Data > Data Validation > Data Validation, see screenshot:


3. In the Data Validation dialog box, click Settings tab, choose List from the Allow drop down list, and input this formula =Foodstuff into the Source box. See screenshot:


Note: You need type in the formula what you named your categories.

4. Click OK and my first drop down list have been created, then select the cell and drag the fill handle to the cell that you want to apply this option.


5. Then I can create the second drop down list, select one blank cell, and click Data > Data Validation > Data Validation again, in the Data Validation dialog box, click Settings tab, choose List from the Allow drop down list, and input this formula =indirect(F1) into the Source box, see screenshot:


Note: F1 indicates the cell location for the first drop down list I have created, you can change it as your need.

6. Then click OK, and drag the cell content downwards, and the dependent drop down list have been created successfully. See screenshot:


And then if I choose one type of the foodstuff, the corresponding cell will only display its specific food name.


1. The drop-down arrow is visible only when the cell is active.

2. You can continue going deeper as you like, if you want to create the third drop down list, just use the second dropdown as the Source of the third dropdown.


Office Web Apps is Office Online - Now With New Features Added

New features allow user to move as seamlessly as possible between Office Online and the desktop.

Excel Online

In Excel Online, users can now insert new comments as well as edit and delete existing comments.

Power users will appreciate that Excel Online now has improved support for files that contain VBA. One can now open and edit VBA-enabled spreadsheets without removing (or corrupting) the VBA contained in the file.

The "Tell Me" feature allows the user to ask Excel how to do something, and presents the relevant commands in a simple drop-down list so one can perform their action right away.

Word Online

Reviewing and providing feedback on documents is a key requirement for users of Office Online. The ability to add and view comments in the View mode was already available. And this is being extended to editing mode, so one can make comments and changes at the same time as others.

Those using Word Online for the creation of research papers and reports can now simply add footnotes and endnotes inline with the text.

Word Online is now smarter when it comes to list making, too. For example, when one is making a list, if they are directly below an existing numbered list and if they start typing, their next line automatically becomes part of the list—just like in desktop Word.

PowerPoint Online

A re-engineered text editor shows a high fidelity view of slides at the time of creation so that the layout of the slides looks more like the final result.

Some performance and video playback optimizations have been made by speeding up advancement of slides in the editor and by adding the ability to play back embedded YouTube videos.

OneNote Online

A One click printing has been added for easy printing of pages.

Multi-column section or page navigation has been added, so that users can maximize reading and editing space regardless of what device or browser they using.