FYI: SharePoint Sites and SharePoint Pages

Learn  how Pages make a Sharepoint Site GREAT!

We all love food, so…
Here’s a Cooking analogy:

You’re having friends over for a formal dinner. Not a casual dinner where everyone gathers in the kitchen. No. This time you have told all your guests that they are not allowed in the kitchen for this special night of dining.

In your kitchen, you have all the ingredients to make a fine, wonderful meal for your guests.
Continue reading “FYI: SharePoint Sites and SharePoint Pages”

Power BI – Business Intelligence just got Smarter

Power BI

powerbi

Watch the webinar here: https://youtu.be/nOaeJ9D_9D4

We just conducted the first Power BI webinar at Learn iT! with a full house of on-line attendees. We all had an awesome session of discovery!

Power BI is a great platform of programs designed to put powerful data analytics in the hands of all of us.

The beauty is you don’t need to be a “big data” person to use the tools of Power BI and see the benefits straight away.

All you need is some data, a little training and you can be producing amazing, stunning visuals in no time.

You will produce visuals that allow for better, timely business decisions based on any type of data you can imagine.

Watch for my next post for a link to our next Learn iT! Power BI webinar!!

If you sign up for our next Power BI Bootcamp (Nov 29) before Nov 4 you will get a 55% discount on the price of admission.

Learn more at Learn iT! www.learnit.com

There is a reason it’s called POWER BI.  Come find out for yourself.

Watch the webinar here: https://youtu.be/nOaeJ9D_9D4

VLookup – Let’s Learn Together

Vlookup Microsoft Excel 1

VLookup. V stands for ‘Victory’.  Well, not this time. It actually stands for ‘Vertical’. But, once you learn to use this popular function of Microsoft Excel, you WILL feel victorious.

Use VLookup when you have two sets of data that you would like to turn into one. For instance: You may have a list of invoices of products purchased. You may also have a separate list of products on another Excel sheet. The challenge is to ‘marry’ these two lists, bringing the needed information from both lists into a single, complete list.

I have included a link to a file you can download so you can follow along as you read through this blog lesson. For your reference, the completed file is available for download as well.

Vlookup Microsoft Excel 2

In this example we will use VLookup to bring the Sales Price from the Products list over to the Invoices list Rate column. We will use the Product Name in the Invoices list to ‘look up’ the same Product Name in the Products list.

Vlookup Microsoft Excel 3

Once we find the correct product name, we can ‘index’ over to the Sale Price column and send it back to the Invoices list Rate column. In this case invoice ‘A001’ shows a ‘UPS’ unit was purchased. Take a look at the Products list and notice ‘UPS”, glance over to column 2 and see the price for a UPS is $148. Now we will put the $148 into invoice line A001 under the Rate column.

Vlookup Microsoft Excel 4

To start a VLookup formula, we must first reference the cell we want to “look up”. In this case we will look up cell D2 in the Invoice list and compare it to the first column (column 1)  in the Products list. The ‘vertical’ aspect of VLookup refers to the fact that VLookup will start looking from the top of  column 1 in the Products list and continue looking down (vertically) until it finds a match.

Vlookup Microsoft Excel 5

When a match is found, we then instruct VLookup to ‘index’ over to the column we would like to return to the Invoice list. Since we are looking to find the Sale Price/Rate of the Product, we specify column 2. (If we wanted to return the corresponding Product Category we would specify column 3)

Vlookup Microsoft Excel 6

There is one more part of the VLookup we must consider. VLookup has two modes of operation: True and False. Think of this as a question: “Is this a RANGE lookup?” In other words are we looking for a product name that is similar to “UPS”, or are we looking for “UPS” exactly? We are looking for an EXACT match, not a ‘close enough’ match. So in this example, the answer would be FALSE to the question: “Is this a range lookup?”

Vlookup Microsoft Excel

Carolyn, here is the VLookup formula entered into cell F2 of the Invoices list:

=VLOOKUP(D2,‘Products List’!$A$2:$C$23,2,FALSE)

D2 is the relative cell reference we want to look up

‘Products List’!$A$2:$C$23 is the absolute range where VLookup will find the information on the Products sheet in cells A2:C23

2 refers to the 2nd column in the lookup table. This is the column we want to send back to Invoices when a product match is found

FALSE instructs VLookup to find an exact match, not simply a ‘close’ match

Vlookup Microsoft Excel 7Now that you have the formula entered into cell F2, use the Autofill Handle on the lower right corner of F2 (the active cell) and double click (or drag) to copy the formula to the bottom of the list.

AutoFill

If  you downloaded the exercise file for this lesson, you will notice that I have included a ‘Salesperson List’ sheet for you to practice VLookup. Using what you have learned, try to build a VLookup formula to look up the Country of Sales and bring it to the Invoice sheet.

Here is the formula if you want to check your work:

=VLOOKUP(C2,’Salesperson List’!$A$2:$D$17,3,FALSE)

I have included a link to a file you can download, so you can follow along as you read through this blog lesson. For your reference, the completed file is available for download as well.

Enjoy the sweet taste of Victory.

SharePoint Saturday is Around the Corner

SharePoint Saturday

SharePoint Saturday
SharePoint Saturday
SharePoint Saturday in Sacramento California  November 7th, 2015. 

It’s going to be a great day of learning and networking. Bring your brains and business cards  

Do you want your SharePoint child to grow up to be Mediocre or Spectacular?

Microsoft-SharePoint

Microsoft SharePoint is all about being able to find content quickly and accurately. It is unfortunate that most don’t realize the importance of 2 key elements before they set up and raise their SharePoint child.  Without these 2 key items, SharePoint will be no more than a shared drive with a slow web interface.  Yikes! Nobody wants that.

To avoid this happening to you and your SharePoint baby, keep tuned in this week and next week as I introduce these 2 key elements that can make you proud of your SharePoint implementation.

I’ll be speaking about one of these two important SharePoint tools at SharePoint Saturday in Sacramento on November 7th, 2015.

If you can’t make it to Sacramento, I will make the seminar available for a short time after the event on my website: www.tomvorves.com.

Watch for my posts over the next few weeks to learn more about the event, but more importantly to learn how to take SharePoint Knowledge that I share with you and turn it into Wise SharePoint decisions that will help your SharePoint environment grow into a mature tool for your enterprise.

MetaData

Your quest for power. You want it all, and you want it NOW.

Power

Your quest for power. You want it all, and you want it NOW.

For quick access to everything on the Internet:
Place an always-accessible address bar on your Windows 7 Taskbar.

Follow these steps to realize your full-power-potential:

1 Right mouse click on an empty area of your Taskbar

taskbar

2 Select ‘Properties’

3 Click the ‘Toolbars’ tab and turn on the ‘Address’ option.

Taskbar Properties

 

Feel the Power of the Internet surging through your fingertips. Wow

Enjoy

Have Inbox Clutter? Well, you should think about getting it.

Use Microsoft Clutter to sort low priority messages in Outlook Web App

Read full story from Microsoft hereClutter is a feature designed to move low priority messages out of your Inbox and into their own folder, saving you time when you scan for important messages. Clutter looks at what you’ve done in the past to determine the messages you’re most likely to ignore. It then moves those messages to a folder called Clutter available in the left pane under the Inbox folder . The Clutter folder will be available regardless of how you access your account.

Clutter and junk email are both filtered out before they reach your Inbox. Junk email is evaluated first, and filtered based on the characteristics of the messages themselves, for example the subject or the server it was sent from. Next, Clutter analyzes the remaining messages destined for your Inbox, and filters out the types of messages that you usually ignore or don’t respond to, based on your past behavior.

In this article

Turn Clutter on

  1. Sign in to Outlook Web App. For help, see Sign in to Outlook Web App.
  2. At the top of the page, select Outlook (or Mail). Or, select the App launcher Office 365 app launcher icon, and then select Outlook.Office 365 navigation options
  3. Go to Settings Settings: update your profile, install software and connect it to the cloud > Options > Mail > Automatic processing > Clutter.
  4. Choose Separate items identified as Clutter.
  5. Click Save Save to save your changes, or discard Discard to cancel.Clutter options

Help Clutter learn your preferences faster

It might take Clutter a few days to fully adapt to your preference, as the system records your choices and uses the information to identify similar messages in the future. But you can help Clutter learn your choices faster:

  • If you see a message that was sent to Clutter by mistake, right-click the message and choose Move to inbox.Move to Inbox
  • If you see a low priority email in your Inbox, right-click the message and choose Move to Clutter.Move to Clutter

Note   Moving an email in or out of the Clutter folder, from any of your devices, is enough to give the signal to the Clutter system that an item is Clutter or not. For example, if you move an email to the Clutter folder in Outlook desktop, or the Mail app on your phone, the action gets recorded in the Clutter system on all your mail apps. You don’t have to do this individually in each app.

How Clutter filters messages

Clutter helps you focus on what’s important by automatically filtering out messages you’re not likely to read. Messages from certain people will never be identified as clutter:

  • You
  • Anyone in your management chain
  • Your direct reports

For mail from everyone else, you teach the system what kinds of content interest you by interacting with your mail. No extra work is required. Clutter learns which kinds of messages you frequently read and uses that to determine if a new item is likely clutter or not.

Clutter looks at various aspects of messages to understand what you don’t typically read, for example:

  • The sender
  • Whether you’ve participated in the conversation
  • If you’re the only recipient
  • The importance

As your reading habits change, the Clutter feature learns and adapts.

Turn Clutter off

You can turn Clutter off anytime in Outlook Web App.

  1. Follow the steps at the beginning of this document to sign in to Outlook Web App. Then, go to Settings Settings: update your profile, install software and connect it to the cloud > Options > Mail > Automatic processing > Clutter.
  2. Select Don’t separate items identified as Clutter, and then click SaveSave.

Note   The Clutter folder remains in Outlook after you turn off Clutter feature. If you don’t want the folder listed under your Mailbox, move the emails from Clutter to other folders, as appropriate, and then right-click the Clutter folder and choose Delete Folder.

Applies To: Office 365 End User, Outlook Web App, Office 365 Admin, Office 365 Small Business Admin, Outlook Web App for Office 365, Outlook on the web for Office 365 Business

More Windows Key Tricks

More Windows Key Tricks

windows8Logo

 

 

 

If you have programs pinned to the Windows Taskbar, you can use Windows Key + 1 to launch the first pinned program, Windows Key + 2 to launch the second pinned program, and so on 3, 4, 5…

taskbar

Enjoy

 

Take a closer look

Quickly Zoom In and Zoom Out using your keyboard and mouse

While using a Microsoft Office program, you may need to zoom in to get a closer look, or zoom out to see your work from a birds-eye view. Although using the zoom bar on the lower right corner of any Microsoft Office program is easy, there is an even faster, and more convenient way to zoom in or out.

Microsoft Office zoom bar

If you have a mouse with a roller button (in between the left and right mouse buttons), you are ready to zoom in and out at super-sonic speeds.
Simply hold down the Control Key and then roll that middle knob on your mouse.

Let the zooming begin. Instantly you are looking at your document as close up as you need, or just as quickly zoom out to see the big picture.

This amazingly fast zoom trick works exactly the same in most of Microsoft’s programs: Word, Excel, PowerPoint, Outlook, Visio, and Internet Explorer (as well as in some non-Microsoft programs).

Control + Roll = Fast Zoom In and Zoom Out

Mouse

Enjoy…

If you appreciate a great computer tip now and again, please Like and Share