MS Project Tip - Import Tasks from Excel

Often, there are multiple people who have to give input on planning a project. You can make the process easier by having each member enter their tasks into Excel, merging the lists, and importing the list into Project.

Step 1 - Enter the task lists into Excel.

• Click the Microsoft Office button and click New.
• In the New Workbook window, click Installed Templates.
• Choose Microsoft Project Task List and then Create.
• Send the task list to the members of your team, and have each member create their tasks. Make sure they enter valid information in each column.
• When you receive the information, combine the sheets and organize the tasks.
• Save the file as an Excel 97-2003 workbook.

Step 2 - Import the Excel task list into MS Project

• Open MS Project.
• Open the project plan.
• On the Standard toolbar, click Open, and open the Excel workbook. (You may have to change the file type to 97-2003).
• The Import Wizard box will pop up.
• In the Data type screen, select Project Excel template and click Next.
• In the Import Mode section, choose one of the following 3 options.
• Import as new project.
• Add tasks to the end of current file.
• Insert the imported tasks somewhere in the Project task list.

MS Project Training - Offered in Atlanta or Online

• Intro to MS Project 2007
• Advanced MS Project 2007
• Subscribe to our weekly email newsletter.
• Ask about our 1-on-1 Internet training in Atlanta and online.
• Check out our group
  MS Software training classes in Atlanta and online.

Excel 2007 Tutorial - Highlighting Duplicate Values

Excel 2007 Tutorial - Highlighting Duplicate Values


If you've worked with Excel 2007 for a little while, you've probably noticed how much easier it is to delete duplicates.

What if you wanted to take a look at the duplicate values before you deleted them?

This is also very easy.


Simply highlight the range of cells you want to check for duplicates.

Click Conditional Formatting on the Home tab.

Click New Rule.

Click the line that reads format only unique or duplicate values.


Make sure duplicateis selected under format all.




Click the Format button to set your formats.

Click OK until you are back on your Excel screen.

That's it!



Excel Classes - Offered in Atlanta or Online

• Excel 2007 Comprehensive - Certification Prep.
• Excel Charts & Graphs
• Excel Formulas & Functions
  
• Subscribe to our weekly email newsletter.
• Ask about our 1-on-1 Internet training in Atlanta and online.
• Check out our group
  MS Software training classes in Atlanta and online.

Internet Explorer Tip - Eek! My Google Toolbar is Providing TMI!

If you use the Google toolbar and Internet Explorer, you've probably noticed that every time you open a new tab, a window pops open showing very large pictures of the sites you visit most often. As you may imagine, having this information showing up on your screen may be a little embarrassing. (Imagine your boss looking over your shoulder).

The steps to get rid of this are not easy to find.

Here they are:

• Click the wrench icon on your Google toolbar.

• Make sure Search is selected.
  
• Make sure the box next to Enable the Google new tab page is unchecked. (While you're at it, you may want to go through the rest of the options and adjust your settings).
  

• Click the Save button.

That's it.

Would you like more Internet Tutorials?

• Subscribe to our weekly email newsletter.
• Subscribe to this blog.
• Ask about our 1-on-1 Internet training in Atlanta and online.
• Check out our group MS Software training classes in Atlanta and online.