Select the Whole Worksheet in Excel

Select the entire worksheet by clicking on the gray square above the row numbers (and to the left of the column letters).

Why would you want to do this?

The most common use is if you want to apply common formatting to every cell.

For example, you may want the sheet to display currency with no decimals, and make all entries blue,
and change a font.

You also may wish to copy the whole sheet to another sheet or workbook without missing anything.

To find out more about Excel Training Perth

MS Project Best Practice Tips

Here are 18 tips that make up “best practices” for using any version of MS Project:

1)    Set the status date when reporting progress (up to the “status date”).

2)    Autolink inserted or moved tasks should be turned Off.

3)    Split In-progress tasks should be turned Off.

4)    No unfinished work to the left of the status date.

5)    No unstarted work to the left of the status date.

6)    No started work to the right of the status date (you did not start tomorrow).

7)    No finished work to the right of the status date (you did not finish tomorrow).
     
8)    No logic on summary tasks (no predecessors, successors).

9)    Detail tasks have predecessors and successors.

10)  Detail tasks have at least one Finish to Start successor.

11)  Resources assigned to detail tasks only, not summaries.

12)  If you claim 100% on a task, it’s predecessors should be 100% complete as
        well, unless there is a Start-to-Start Relationship.

13)  Milestones do not have resources. Do you really need to work with resources in
        the first place as this really complicates things a lot. There are other easier ways
        to allocate task ownership.

14)  Generally a milestone has predecessors OR successor, but not usually both
        (this is optional).

15)  There should never be negative lag on a task. Negative lag predicts the future
        with certainty and that doesn’t exist.

16)  Too much positive lag on a task probably indicates missing tasks, or incomplete
        logic.

17)  Constratint types: You want them to be As Soon As Possible as much as you
        can. Start No Earlier Than, Finis As Late As Possible, and Finish No
        Earlier Than are tollerable. Items like Must Finsh On, Must Start On, Finish
        No Later Than, Start No Later Than are pretty much not a good thing.

18)  Eliminate constraints other than ASAP as much as practical. A task with a
        Start No Earlier Than 15/10/2009 is useless if the schedule logic has it
        starting 01/11/2009.

MS Project 2010

Fast Track Computer Solutions in Perth will be offering MS Project Upgrade Training in 2010.

This version is claimed to be the biggest upgrade in the last 10 years!

Go to this site to read more:

http://www.projectknowledge.net/2009/09/microsoft-project-2010-the-news-is-out.html?utm_source=newsletter&utm_medium=email&utm_campaign=news7_6_sept09

99 Tricks and Traps for MS Project

For those who want to get ahead with Microsoft Office Project we now have available “99 Tricks and Traps for MS Project”.

The “Casual Users Survival Guide” is written by Paul E Harris and cuts straight to the heart of MS Project and is written in an easy to use and read style.

The book quickly gets down to the issues that many people grapple with when trying to use some of the more advanced features of the software.

It is suitable for most people who know the basics of Microsoft Project but want a short guide to give them insight into the less intuitive features of MS Project. Brilliant for basic, intermediate and even to advanced users of MS Project.

To find out how to get your copy click here.

How To Search An Excel Spreadsheet

We all know that we can search in MS Excel by using CTRL + F to display the Find tab of the Find and Replace dialog box and do a search of the entire worksheet.

If you want to place a limit on your search, however, there is another way to do this. Follow the steps below:

Select the range you want to search before you press CTRL + F.

Perhaps you only want to search a specific column in your worksheet.

Selecting that column before displaying the Find tab of the Find and Replace dialog box will perform the search only in that range of cells, ignoring the rest.

To find out more about Excel Training Perth

How to hide the contents of a cell in Excel

Here is another pretty nifty tip that you can use in MS Excel – have you ever had occasion to want to hide the contents of a cell from a reader that is not privy to certain information? Of course you have! Haven’t we all? The good news is that you can and it is pretty easy to do.

Follow the steps below:

1. Select the cell in your spreadsheet.

2. Click on Format | Cells.

3. Click on Category | Custom.

4. Enter three semicolons in the Type box.

5. Click OK.

Those values will not be visible on-screen unless you highlight that cell. If you should highlight that cell, you will still be able to view the values on the formula bar, but not on-screen.

To find out more about Excel Training Perth

How to change the colour of the tabs in Excel

Were you aware that you can color the tabs in your MS Excel spreadsheets? Well you can and it can be pretty helpful too when you are trying to draw a user’s attention to those little tabs at the bottom of your spreadsheet!

Follow the steps below:

1. Right-click the tab.

2. Select Tab Color.

3. Select the color you would like to use.

How to resize a column in Excel

To resize a column:

Move cursor to the edge of the column to resize, on the column letter eg: C. When you see a double pointed arrow, just double click. The column width will increase to fit the longest text in that column.

How to quickly return to the top of an Excel spreadsheet

To return to cell A1 from anywhere on your worksheet, press CTRL key and HOME key together.

To jump to the bottom of a very long column, simply select a cell in the column and double-click the top or bottom edge of the cell.

To return to the top of your data, click the edge of the cell. Clicking the left or right edge of the cell works in the same manner for going across rows.

How to Calculate the time between two dates in Excel

To calculate days between 2 dates:

Enter the dates in separate cells. Then in a blank cell enter a formula to subtract one date from the other. Endure that the cell containing the formula is formatted to number. For example, enter today’s date and your date of birth to see how many days you have been on this planet!

Next Page »