Blog

Licensing Office 365 E5



December 1st marked two extraordinary launches: a brand new Office 365 plan called E5 and Microsoft becoming a Telco.

We described the key new features and capabilities in an earlier post and we’re going to concentrate on the licensing concepts in this blog post.

Some of the new features will be included via updates to the E1 and E3 plans.  Most of the new features will be included in the E5 plan with the exception of PSTN Calling which will be an add-on subscription.  All of the new features will be available as standalone subscriptions which will suit customers that don’t require all of the E5 functionality but do want one of two of the new capabilities.

This does mean that Office 365 E4 plan follows E2 in being discontinued.  E4 will remain on the pricelist until the end of Microsoft’s financial year, June 30th, 2016.  Customers on E4 will be able to renew it as E4 prior to that date but should look to transition into E5 or into E3 with the Cloud PBX add-on.  If customers want to maintain E4 functionality after June 30th, they can transition to the E3 plan and add the new Skype for Business Plus user subscription licence (USL) that was released on the 1st December.

Microsoft Office 365 Plan Features

Table 1: Office 365 E1, E3 and E5 plans with new or enhanced features highlighted in orange

 

How can customers licence Office 356 E5?

Office 365 E5 is available as a:

  • Full User Subscription Licence (USL) for new users
  • Step-up licence for existing Office 365 E3 and E4 customers
  • From SA USL for customers who currently own licences for and have active Software Assurance (SA) on Office and a Client Access licence (CAL) Suite
  • Add-on licence for customers who already subscribe to the Enterprise Cloud Suite (ECS)

At launch, what you’ll see on the price list is Office 365 Enterprise E5 without PSTN Conferencing.  Office 365 E5 and Cloud PBX is available worldwide, however the PSTN conferencing feature is only available in fifteen countries from the 1st December.  Lucky UK; we’re one of those fifteen.  The remaining 191 countries (bonus points if you can name them all; I had to source from the United Nations) cannot enjoy PSTN conferencing yet so it‘s unfair to sell them full E5.

Where PSTN Conferencing is available, customers will purchase Office 365 Enterprise E5 without PSTN Conferencing and Office 365 Skype for Business PSTN Conferencing
Where PSTN Conferencing is not available, customers will purchase Office 365 Enterprise E5 without PSTN Conferencing
At some point in the future, we’ll announce a single Office 365 E5 licence on the pricelist which is likely to be priced the same as the combination of E5 w/out PSTN Conferencing and the Skype for Business PSTN Conferencing licences.

 

What channels are the new plans available through?

Being a telco brings tax and regulatory responsibilities.  Microsoft needs to sell these PSTN features in the right way so whilst the Office 365 Enterprise E5 without PSTN Conferencing SKU is available worldwide and through all licensing channels, currently Office 365 Skype for Business PSTN Conferencing is only available through direct channels: the Microsoft Online Subscription Program (MOSP) and direct Enterprise Agreements.

 

How can customers licence the new features as standalone subscriptions?

Table 2 lists the new standalone licences along with the relevant pre-requisite.

Office 365 E5 Standalones

 

Table 2: Office 365 E1, E3 and E5 plans with new or enhanced features highlighted in orange

 

How can customers licence the PSTN Calling Plans?

These are not available as of December in the UK.  In fact they are only available in the US but the UK should be able to enjoy this in the first half of 2016.

There are two PSTN Calling Plans: Domestic and International.  Domestic will have a set price per user/per month for 3,000 minutes of national calls.  The International Plan will include the domestic quota and add 600 minutes of international calls.  These quotas will be allocated to the organisation as a whole, rather than each user so a customer with 10 USLs for the International PSTN Calling Plan will have 30,000 national minutes and 6,000 international minutes.

 

What do the PSTN features include?

At launch, PSTN Conferencing includes the ability to advertise a national, non-freephone number (e.g. 0118 for Reading, 020 for London, etc.).  The person dialling into the conference will pay for the call charges.  Customers can also dial-out to a phone using a national phone number in order to bring someone into the Skype conference.

In 2016, there will be a consumption billing model, similar to Azure consumption billing, where customers can maintain a balance of monetary credit.  This can then be used to advertise Freephone numbers to conferences and dial-out to international phone numbers to bring people into the conference.  The call charges will be met using the consumption balance.

The same goes for the PSTN Calling plans.  If a customer exceeds their quota of minutes, or a customer subscribing to the Domestic plan wants to make international calls, the charges will be drawn from their consumption balance.

E5 and the PSTN features mark a very exciting chapter in Microsoft’s online capabilities.  Keep a close eye out for the release of UK PSTN Calling plans and the consumption billing in 2016.  We’ll continue to keep you up to date with blog posts.

 


Office 365 E5 Plan



We should be used to Microsoft announcing new capabilities and investments in Office 365 but December 1st marked two extraordinary launches.

Firstly, a brand new Office 365 plan called E5.  This joins the current enterprise plan line up of E1, E3 and E4 and becomes Microsoft’s new ‘hero’ plan.  We’ll cover what it contains in a moment.

The second extraordinary launch is Microsoft is becoming a telecommunications provider (or simply telco in modern syntax).  Microsoft has extraordinary capacity in its global data network and is putting it to good use by offering PSTN conferencing and PSTN calling plans for Skype for Business.

Before you worry that Microsoft will start making adverts starring Maureen Lipman about ‘ologies, these PSTN capabilities are aimed squarely at organisations rather than consumers at this point.

What do I need to know from the December launch?

The key new features and capabilities are below.  There’s a post on Microsoft’s Volume Licensing site covering how to licence Office 365 E5 and the standalone features.

 

Microsoft Office 365 Plan Features

 

PSTN Conferencing

PSTN Conferencing (Public Switch Telephone Network) offers audio conferencing within Skype for Business web conferences.  If people can’t connect to a conference over the internet, it’s nice to give them a phone number so they can dial-in and listen to the audio.  Currently you need to set up an account with one of the audio conferencing providers in the Office 365 Marketplace, or have on-premises Mediation Servers and PSTN gateways.

Dial-in conferencing allows meeting attendees to dial into Skype meetings through a local phone number and in the near-future, a Freephone number (when consumption billing is released for Office 365).

Dial-out conferencing enables presenters in the web conference to add others to the meeting by dialling their phone number.  It also allows attendees to join the audio portion of the meeting by asking Skype for Business to call them on a specified phone number.

Cloud PBX

PBX stands for private branch exchange and is the internal phone system an organisation uses.  Cloud PBX can offload that requirement entirely to the cloud, or connect cloud PBX to an on-premises PBX in hybrid configurations.

It includes all the features you’d expect including calling by name & number from Softphones, IP Phones and mobile devices, Call History & Redial, Call Hold/Retrieve, Transfer, Forwarding, Call Waiting, Simultaneous Ring, Team Calling, and so on.

Like the rest of Office 365, updates are delivered over the cloud so customers can avoid the headache of upgrading their on-premises PBX.  A notable update in the pipeline will be PBX features for call centres.

Cloud PBX can be connected to the PSTN through two different capabilities.  First, a customer can purchase a PSTN calling service add-on to Office 365, available initially in the US only.  Alternatively, a customer can use Skype for Business software on-premises to provide PSTN connectivity.

PSTN Calling

Which brings us nicely onto PSTN Calling.  This is an add-on to Cloud PBX that provides national and international calling services directly from Office 365.  Instead of a customer contracting with a traditional telco and using an on-premises IP-PBX, they can purchase the Cloud PBX from Microsoft and add on PSTN Calling for a complete enterprise telephony experience for end-users.

So Microsoft is becoming a regulated carrier in each geography that this will be available.  Customers can get new phone numbers for users or have phone numbers ported to the PSTN Calling service.  Number provisioning will be done directly through the Office 365 admin portal or of course, via PowerShell.

Power BI Pro

Power BI Pro is a business analytics service that enables information workers to visualize and analyse data with greater speed, efficiency and understanding.  Users are connected to live data through dashboards, interactive reports and visualizations that bring data to life and make it meaningful to their role.  And don’t underestimate the live data here; this could come from Internet of Things (IoT) devices, wearables for example and be up to the second.  Power BI provides a Power BI Desktop tool and Power BI mobile apps for iOS, Android and Windows.  Excel also has Power BI enhancements such as being able to merge and use queries from multiple data sources, including public sources like Twitter alongside corporate data.

Delve Analytics

You may have heard or perhaps used Delve.  Delve allows an individual to see and search the documents and sites that are important to people connected to you.  It surfaces knowledge according to what and who you’re working with.

Delve Analytics on the other hand, allows managers to discover how their team or organisation works.  It provides insights into important business problems like organization collaboration, who’s talking to whom, siloed team detection, identification of most connected employees, types of meetings taking place across the organization and work-life balance; which teams are consistently working beyond their shifts.  Individuals can gain a fresh perspective about the way they work including time management, network analysis and influence and reach indicators.

Both Delve and Delve Analytics use Office Graph and sophisticated machine learning to map the relationships between people, content and activity that occurs across Office 365.

Customer Lockbox

One of the common cloud topics is that organisations want to have full control over their content stored in cloud services.  Office 365 has evolved so nearly all service operations performed by Microsoft are fully automated and any human interaction is highly controlled and kept away from customer content.  Only in very rare cases does a Microsoft engineer have any reason to access customer content.  Microsoft employees do not have automatic access to service operations.  All access is obtained through a rigorous access control technology called Lockbox.  An extension to this is Customer Lockbox and if an organisation has Customer Lockbox, they have the keys to that engineer access.  The customer is notified when their content needs to be accessed by service administrators and the have total control to approve or deny such access.  They can set up Just-In-Time access to specific scopes of data and all access control activities are logged and audited.  So access currently goes through a secure workflow process but Lockbox makes the customer part of that process.

Customer Lockbox will be available for Exchange Online first and for SharePoint Online in Q1 of 2016.

Advanced Threat Protection

Advanced threat protection has been available for a few months now.  It combats unknown & sophisticated threats in email.  Let’s say you get an email with a short link, a Bit.ly link for example.  When you first receive the email, the link is fine and directs you to the Sugababes fan club site as expected.  However, sometime in the future that shortlink redirects you to a malware site and before you know it you’ve downloaded a One Direction virus.  Safe Links provide time-of-click protection against such malicious URLs by wrapping external links in special URLs that check the destination link for threats before opening them.  There’s also Safe Attachments which opens email attachments sandboxed virtual environments to detect malicious behaviour.  And Click Trace keeps a record of every user who has clicked on a URL for additional protection so if you do need to take remedial action, it’s easier to know exactly where.

Equivio Analytics for eDiscovery

Back in January, Microsoft acquired Equivio, a provider of machine learning technologies for eDiscovery and information governance.  If an organisation goes through a law suit, it’s extremely expensive and time consuming.  Data on a given topic needs to be found and collected and once it’s harvested, typically lawyers are paid lots of money to go through that data and determine relevance.  Equivio simplifies the eDiscovery process by using machine learning, tagging and predictive coding to identify relevant email and documents and reduce the amount of data that’s returned.
All of these new capabilities form part of Office 365 E5 and with the exception of the PSTN Calling plans are available as standalones licences.

In the next blog post, we’ll go deeper into the PSTN features and what they include.


Action Items in Outlook



In the Office 365 Exchange Admin Centre there are several default apps that can be turned on in Outlook by your administrator such as Action Items, Bing Maps, Suggested Meetings or Unsubscribe. These apps can help to streamline your daily workflow and save you time.

All emails received into your inbox will be scanned. If Outlook notices anything that needs to be ‘actioned’ it will flag these items to you in the form of buttons above the reading pane.

In the following example, Outlook has picked up and flagged an address and an item that needs to be actioned.

ActionItems4

Click on Bing Maps to see the exact location of the address.

ActionItems5

Click on Action Items to see what items need to be actioned. In this example, Outlook has picked up that the sender has asked me to download a form from the files library. It has flagged this with a suggested action of adding it into my tasks lists for follow-up.

ActionItems6

So next time you receive an email, take a glance at the bar above the reading pane for Bing Maps, Action Items, Suggested Meetings etc. These can be really helpful and time saving little apps!


Quiet people have the loudest minds



How do good trainers run great training sessions that are inspiring for different types of attendee?

As far back as I can remember I have been made to feel somewhat guilty about my introverted personality. I was that child that preferred spending the summer holidays inside reading a book, drawing or making a fabulous princess palace out of old cardboard boxes and toilet rolls. Most of my friends would be outside on their bikes or up the hills playing games but for me, it was never as appealing. I think my parents found this somewhat unusual and I was always gently encouraged to go outside and play. Sometimes I did, but all the time longing to get back inside doing something creative on my own.

As an only child I grew up enjoying solitude and seeking out activities that I could do on my own or with one other trusted person. I always felt different to others. I didn’t really understand when I was younger why I didn’t enjoy being around lots of people or partaking in social activities. I felt weird. I felt that there was something wrong with me. If this rings true for you, then you are not weird, you are an introvert.

Introvertcat2

So what is the difference between an introvert and an extrovert? It relates to where you gain your energy. It was the famous Swiss psychiatrist Carl Jung that popularised this definition. Extroverts feel energised and most alive being around people and feeding off others whereas introverts get their energy from within themselves. An introvert needs solitude like most people need oxygen.

As an introvert I can tell you that if I have to spend a number of hours in a social situation, particularly with people I do not know I feel totally drained at the end of the day. My batteries are flat. I find that people tend to drain the energy out of me and I usually cannot wait to get back home and recharge. Now that makes me sound completely anti-social and a bit of a people hater. I am not. I do enjoy the company of others but it does tire me out. And this is the problem that introverts encounter on a daily basis.

All of our institutions, be it schools or the workplace are setup to cater to extroverts. The gregarious qualities of an extrovert are prized more highly than the contemplative qualities of an introvert in today’s society. It’s easy to understand why this is but let’s look at a scenario.

Richard and Daisy are both going for a job interview. They both have excellent skills and qualifications on paper. Richard walks into the interview and confidently speaks about his achievements. He oozes charisma. He has fabulous anecdotes. He’s social, gregarious, a go-getter and real man of action! Daisy follows him. She has a quiet confidence, she pauses in deep thought before each answer. She has amazing, well thought out and creative ideas but seems shy and reserved. She indicates that she works best on solo projects as this is how her creativity flourishes. As an employer, who would you hire? I am guessing probably Richard. Why? He fits the mould of the modern office environment. However, sometimes the quiet people have the loudest minds.

introvertvsextrovert

Introverts make up 1/3 of the population and in general this personality type is misunderstood. Introverts are not shy. Introverts do not lack confidence. This is the most common misconception. Type Introverts into a Word document and hit Shift+F7 to see what I mean.

I am an introvert and I do a very extroverted job. I am a trainer, which means I stand in front of large groups of people and speak. If I lacked confidence or was shy, I would find it very difficult to do the job I do. That’s not to say that I do not find my job challenging. Being in the spotlight is not something that comes naturally to me. I’ve had to work at it. A lot of trainers I know are extroverts. They are comfortable running a training session with very little preparation and to a certain extent ‘winging it’. I’m not accusing them of running bad sessions or not caring as much, they are just more able to absorb the unexpected and run with it.

That’s not me. I plan, I research, I think about all the things that could go wrong in advance and try to counter them, I prepare, I practice, all so that my time ‘in the spotlight’ runs smoothly. It is this that enables me as an introvert to do an extroverts job. It’s my process that enables me to feel comfortable. It is very frustrating for an introvert when someone tries to change your process or doesn’t understand your need for meticulous planning.

This leads us into talking a little bit about training sessions and how, as a trainer, you can execute an interactive training session that is conducive for both introverts and extroverts.

Let’s briefly go back to talking about schools. Schools these days are setup in a way that caters to extroverts. Students sit on large round tables, facing each other and are encouraged to partake in countless group activities. The idea being to encourage interaction, learn how to work in a team and share ideas. I am not saying this is a bad thing. Young people do need to learn these skills. But what about the introverted child in that classroom? The child that is uncomfortable working in large groups. The child who prefers to reflect on a subject quietly before sharing his or her idea. The child that is often labelled as anti-social or difficult. Forcing introverts to work like extroverts is counter-productive and only serves to alienate that child from the group.

This is similar in an adult learning environment. Most trainers use a technique at the start of training sessions to ascertain the different learning styles and personality types of their students. It’s called an ‘Ice Breaker’ and usually involves some kind of activity or exercise. I use Ice Breakers to sort out the introverts from the extroverts. Many trainers I have met are very focused on the interactive element of training sessions. Group activities, high energy exercises, getting the students to voice their opinions, ask questions etc. I agree that these are important parts of training in order to keep participants engaged and interested. However, I would encourage all trainers to think about the introverted participants who are sitting there dreading the next group exercise or next question that puts them on the spot. Often, the fear of what is coming distracts them from their learning.

Susan Cain did an amazing Ted Talk on the ‘Power of introverts’ and I think this quote is very true. ‘Stop the madness for constant group work!!’ Think about alternative methods that will allow extroverts and introverts to flourish equally. Instead of large, boisterous group activities, pepper your sessions with solo exercises or brain training activities. Instead of large group work, stick to partner work. If you need to do an exercise in a large group, make it a more relaxed ‘Café style’ workshop where you start a discussion with the group during a coffee break. This is immediately more relaxed and informal. Students can participate as much or as little as they like with no pressure. Try not to fire questions at a student that appears to be quiet and not interacting as much. They are probably listening intently and processing.

Introverts hold so much power that is overlooked. They tend to be more effective than their extroverted counterparts, statistically more intelligent and oddly better leaders as they don’t dominate others and are more inclined to let individual ideas flourish. Introverts are creative. They are imaginative. They are deep thinkers. They are invaluable to this world. Where would we be without the likes of Einstein, Ghandi, Abraham Lincoln, Rosa Parkes or Bill Gates? All introverts who changed the world.

Employers are slowly starting to understand this concept. Our workplaces are changing and becoming more flexible. Employers are introducing different ways of working and home working is on the rise. There is a mini revolution going on at the moment confirmed by the amount of blogs and articles popping up all over the web on this subject. Let’s embrace everyone, introverts, extroverts and all those that are in between and recognise the supreme benefit of letting individuals work within their natural personality type.

And whatever personality type you are, you’re more than welcome on our courses.

 

 


Living on the Edge



Microsoft Edge, that is.

As it’s Guy Fawkes Night this week and everyone is getting excited at the prospect of sparklers, amazing fireworks and toasting marshmallows on an open fire, we thought we would dedicate this week’s blog post to something new and exciting in the world of Microsoft!

If you are one of the many millions of people that have upgraded to Windows 10, you will probably be aware of Microsoft Edge already. If not then carry on reading and start living on the edge!

What is Microsoft Edge?

Microsoft Edge is your new browser for Windows 10. It’s a new way to surf the web! Microsoft Edge gives you new ways to find stuff, read and write. It’s the browser for doing stuff!

Click the Screenshot of logo tile icon to open Edge.

Searching from the address bar

No need to go to a website to search for pictures of cute kittens or funny memes, just type what you are searching for into the address bar and Edge will give you search suggestions, your browsing history and instant results right on the spot.

Edge1

The Hub: Everything in one place

Think of the Hub as the place where Microsoft Edge keeps the things you collect on the web. Select Hub to view your favourites, reading list, browsing history, and current downloads.

Edge2

Looking for your favourites? In the Hub, choose Favourites and then select Import favourites.

Read without distractions

Turn on reading view to bring articles front and centre

Edge4

NOTE: If the reading view icon is greyed out it means that the web page is not available in read mode.

Save articles to read later by adding them to your reading list. Click the star icon and select Reading List and Add.

Edge5

Write on the web

Add your own personal touch to web pages with Web Note.

Use the Pen, Highlighter or Type Tools to add your own ideas.

Edge6
Edge7

Save your notes to share with a friend or co-worker.

Edge8

Get answers from Cortana

When you stumble across a topic on the web you’d like to know more about, Cortana is your ready and able, all-knowing guru. Highlight a word or phrase, press and hold (or right-click) it, then Ask Cortana to find out all about it.

Edge9

Happy browsing and have a safe and enjoyable Guy Fawkes Night!

happy-guy-fawkes-night-the-bum-gun

 


Conditional Formatting in Outlook



Conditional Formatting in Outlook is a really useful tool that allows you to customise how different messages appear in your inbox message list based on criteria that you set.

By default, conditional formatting makes unread messages appear in bold but you can add your own customisations also. For example, you may want messages that are just sent to you and no one else appear larger in your message list, or you may want message that are sent to you from your manager to appear in a different colour so they stand out. Both of these things can be done by applying conditional formatting.

Setting up Conditional Formatting

From your inbox:

  • Click on the View tab
  • In the Current View group, click View Settings
  • Click Conditional Formatting
  • Click Add to create a conditional formatting rule

Let’s look at an example. I want to create a formatting rule for mail that is sent only to me. I have named by rule ‘Only Me’.

Cond_Form1
  • Click Condition
  • Put a tick in the ‘When I Am’ box and specify ‘the only person on to To line’
Cond_Form2
  • Click OK
  • Click Font

Select how you wish these messages to appear. As these are important I have changed the font style, made it purple and bigger so they really stand out.

  • Click OK
Cond_Form3

When I switch back to my inbox, I can now see the conditional formatting has been applied to my message list.

Cond_Form4

Another example would be setting conditional formatting for mails that come in from a specific person.

To do this, repeat the above steps but when you click Condition, enter the name of the person in the From field. Click OK and then set the formatting options through Font.

Cond_Form5

There are lots of options within conditional formatting so its worth taking a look at trying out different options to make your important mails really stand out from the others.

 


Using VLOOKUP to extract data



Vlookup

As its Halloween this weekend we thought we would dedicate this week’s blog post to something that people find particularly scary! Something that sends chills down your spine! OK, I am being a little dramatic but it is fair to say that when it comes to Excel, Formulas are the thing that tend to strike fear into the heart of most.

Fortunately, formulas have never been easier or more human in Excel which means you don’t have to be a mathematical genius to understand them. Today we are going to take a look at ‘Using VLOOKUP to extract data’, a really common and useful formula which will help you cross-reference spreadsheets and save a lot of time.

Using VLOOKUP to extract data

VLOOKUP is a great time saving formula.

Let’s set the scene…

In this spreadsheet, I have a table (Table 1) that lists Items in column C and their associated unique Item Number or ID in column A. When a customer orders an item, I log the Item Number and the Customer Name in a separate spreadsheet (Table 2). However, the Item Name is not listed. I am going to use VLOOKUP to quickly and easily reference the Item ID and pull back the Item Name.

vlookup8

STEP ONE: Name your lookup range

This step is optional. You do not have to name your lookup range but I find that this is the best way of ensuring that your data pulls through correctly and it means that you don’t have to mess around making cell references absolute (fixed).

  • Highlight the lookup table (the table that contains the data you are pulling through, in this case Table 1)
  • Click in the Name box and type a name for your table i.e. PRODUCTS.
  • Press Enter
vlookup5

NOTE: It is worth noting that table name cannot have spaces. If I wanted to name it ‘PRODUCT KEY’ I would need to use the format ‘PRODUCTKEY’ or ‘PRODUCT_KEY’.

STEP TWO – Create the VLOOKUP Formula (the scary part)

  • Click in the cell where you want the value to appear (C12)
  • Click on the Formulas ribbon
  • Click Insert Function
vlookup7
  • Enter the criteria into the fields

Lookup_value – The lookup value is the information that you want to reference. It is normally a piece of information that is in both tables. Excel needs a reference point and in this example we are using the Item ID.

  • Click the cell that contains the first Item ID (A12)

Table_array – The table array is the table Excel is referencing. Excel needs to know which table to find the Item ID. This is where naming your table in Step 1 comes in useful.

  • Press F3

Any named tables will appear in a list. Select the table ‘PRODUCT’. If you did not name your table, you would need to highlight the cells instead.

Col_index_num – This is the column in the lookup table that contains the data you want to pull through. In our example, we need the ITEM NAME. This information is contained in Column 3.

  • Enter ‘3’

Range_lookup – This field can be left blank or will contain the value ‘TRUE’ or ‘FALSE’. Which one you use depends on how your table is sorted and the data you want to pull through. If you have your tables sorted in Ascending order, you can leave this field blank or use TRUE. TRUE also searches for an exact match.  In our example, my data is not sorted and so I need to enter FALSE. In my experience, most data that you are dealing with is not sorted nice and neatly and so FALSE is the more common value to go in here.

  • Enter FALSE
vlookup3
  • Click OK

If the formula has been added correctly, you should now see the item name in cell C12. Excel has essentially looked in the lookup table for the Item ID and then pulled through the corresponding Item Name.

Once you have used the helpful dialogue box a few times and you are comfortable with the format, you can just type the formula into the cell. E.g. =VLOOKUP(C12,PRODUCTS,3,FALSE)

vlookup6

You could repeat the above steps to complete the rest of the table but that can be quite tedious especially if you are dealing with a lot of data. To quickly copy the formula down, you can use the AutoFill handle in the bottom right-hand corner.

  • Drag the handle down OR double-click on the handle
vlookup9

TIP: If you get an unexpected result when using the auto-fill handle, such as the wrong data being pulled through or the same Item Name repeated, it is worth checking that you do not have your Auto-fill settings set to manual.

  • Click the Formulas ribbon
  • Click Calculation Options
  • Set to Automatic

So as you can see, Excel formulas do not have to be a scary prospect.

happy-halloween

Outlook Search Folders



Do you forever find yourself running the same search over and over again in Outlook? Maybe you frequently have to search for emails from your manager that contain attachments?

Outlook has a really useful search feature that you can use to find your emails but wouldn’t you rather be able to find what you are looking for in one click? Creating Outlook Search Folders for your frequently searched for email items is a great way to cut down on the amount of time you spend searching for emails.

  • Click the Folder tab
  • Click New Search Folder
Search Folder

You can choose to select the items you would like to search for from the default list presented, i.e. if I want to create a search for all emails from my manager, I would select ‘Mail from and to specific people’ and then select my managers name by clicking ‘Choose‘.

search folder 2

However, if you would like to create a folder that searches using multiple criteria you will need to create a Custom Search.

  • Scroll down in the list and select Create a Custom Search Folder
  • Click Choose
  • Add a name for your search folder
  • Click Criteria
name

You can select criteria for your search from any of the three tabs. In this example, I want a search folder that quickly searches for all emails from David that contain attachments.

options 1

options 2

  • Click OK

A new folder will be created under Search Folders in your folder list. Click on the folder to run the search.

save folder

I think you will agree it is worth taking the time to setup some search folders in your Outlook as it will greatly reduce the amount of time you spend searching for emails.


Cut and paste with Microsoft Spike



Did you know you can cut and paste with Microsoft Spike? Probably not! Word has a hidden feature that most people do not know about to collect text on the clipboard from multiple locations and then paste it in to your document all in one go! Most Word users are familiar with using the clipboard to copy and paste text, but Spike works in a slightly different way.

  • Highlight the paragraph of text you would like to cut
  • Press CTRL+F3
  • Select the next paragraph of text you would like to cut
  • Press CTRL+F3
spike

Continue cutting text from your document in this way. The paragraphs do not need to be next to each other, you can cut from anywhere in the document to move them to the clipboard.

Once you have finished cutting, you can paste all of the paragraphs in the order that you cut them into another part of the document,

  • Press CTRL+SHIFT+F3, OR
  • Type spike and press F3

This clever piece of functionality utilises the Quick Parts feature in the background and is a useful trick to remember next time you are formatting a long document.


The Dynamic Duo – Cortana and Microsoft Edge



Using Cortana within Microsoft Edge

There are many great partnerships in life; Bert and Ernie, Batman and Robin, Yin and Yang and of course the humble Cheese and Pickle sandwich.

Dynamic Duos

Introducing the Dynamic Duo –  Cortana and Microsoft Edge. These two separate applications seamlessly interact to provide you the consumer with a much more fluid and full browsing experience.

Lets back track a little. If you are reading and this and thinking ‘What in the world is Cortana?‘, then you are not alone.

Cortana is your clever new personal assistant! Cortana will help you find things on your PC, manage your calendar, track packages, find files, chat with you, and tell jokes. Yes, I said tell jokes. That was not a typo. The more you use Cortana, the more personalized your experience will be.

Now if you are anything like me, the words ‘Microsoft’ and ‘Assistant’ may conjure up this image in your mind…

Remember this guy?

paperclip

Ah, Mr Clippy. Everyone’s favourite letter writing obsessed friend. The good news is, Cortana is very different to previous Microsoft Assistant tools and it can be utilised very effectively from within Microsoft Edge.

Turn on Cortana

  • Before you can use Cortana in Microsoft Edge you need to turn it on in System Settings.
  • Click the Windows button in the bottom left-hand corner OR press the Windows logo key on your keyboard
  • Start typing ‘Cortana’ to search
  • Select ‘Cortana & Search settings’
cortana1
  • Use the slider to turn Cortana on
cortana2

 

Once Cortana has been turned in, you can now ‘Ask Cortana’ questions directly from your we pages as you are browsing.

Ask Cortana when browsing the web

For example, I was looking at the BBC News website this morning and I was reading an article on the Falkland Islands. I was curious as to where the Falkland Islands were located so I utilised Cortana within my Edge browser.

  • Highlight the word you would like to search
  • Right-click and select ‘Ask Cortana’
cortana3

Cortana will load information related to your search in a pane on the left-hand side of the screen.

NOTE: You must ensure you turn Cortana on within settings in order for ‘Ask Cortana’ to show in the menu when you right-click.