Best New Features of Microsoft Project 2013

Posted on Updated on

There are several new features in Microsoft Project 2013. The first noticeable improvements you will observe is the sharp new look. Brighter and more user friendly graphics are just the start of what Microsoft Project 2013 can offer you.

Project Data

Microsoft Project 2013 takes you to a new one-stop center of premade templates, imported information, and Gantt Charts instead of dropping you into a blank file. This new area allows you to get started quickly. You can even open previous projects and or open a new blank project from this area also. The possibilities are endless in the new center.

Better reportsYou can also create better reports than ever before with the new graphics and formatting capabilities offered by Microsoft Project 2013. Long gone are the walls of data previously seen in other versions of Project. They have been replaced by vivid charts and images that tell the story about your project when you personalize them according to the elements needed in the reports. Change the colors or add and remove what is shown. The choice is now yours with Microsoft Project 2013. Read the rest of this entry »

VLOOKUP with a Named Range

Posted on Updated on

In this excel tutorial Rich will demonstrate a simple VLOOKUP example incorporating a named range.

http://www.youtube.com/watch?v=zmW7Sy8VywI

The first step is to create a new spreadsheet and add data similar to the data in our example.

Step 2 is to select the range of cells we are going to perform the VLOOKUP on. A nice keyboard shortcut for that is CTRL+SHIFT+END. That does a nice job of selecting a contiguous range of data.
Next go to the name box which is just above the spreadsheet (see red box below) that currently displays a value of “A2” which is the anchor cell (top left cell) of the data we have selected.

Named Range Box

 

 

 

 

 

 

 

 

 

Click into the name box and call the range “Orderinfo“. You must hit the enter key when you type a name for your range and your name can’t contain any spaces or start with a symbol like a “#” sign or anything similar. Just use plain names and no spaces. One of the things we love about name ranges is that they are globally accessible throughout the workbook without having to reference the sheet name. Read the rest of this entry »

How to Drawing floor plans using Microsoft Visio

Posted on Updated on

Microsoft Visio is an amazing tool to have and it can be pretty simple to work with once you get the hang of it. Unfortunately, you may feel a little confused when you’re starting, so throughout this guide we will show you how to draw floor plans in Microsoft Visio in a simple and concise way, bear with us.

Image

Step One: Microsoft Visio Setup

After you install Microsoft Visio and perform the software’s setup process, you have to setup the file you want to be working on – throughout this tutorial we will assume you want to draw floor plans.

To begin, simply launch the Microsoft Vision executable file and wait for it to finish processing. After you’re all clear, locate the menu button labeled “Template Categories” and make the following selection: “Maps and Floor Plans”. Read the rest of this entry »