Workshop on Microsoft Project Professional 2010 – 2 Days (March 23-24)

Posted on | March 15, 2013 | No Comments

2 Days Workshop on Microsoft Project Professional 2010 (March 23/24)

 About the Workshop

This workshop will help project managers to effectively use MS Project in their respective domains. It will facilitate them to explore its various functions to make it easier to plan and manage project schedule and resources

Topics Covered

• Introduction to Project Management Concepts
• Creating Project Plan
• Exploring Views
• Creating Task List / Mile Stones
• Linking Tasks
• Setting up Resources
• Entering Cost Information
• Assigning Resources to Task
• Gantt Chart View
• Formatting and Printing Project Plan
• Tracking Progress
• Fine Tuning Tasks & Resources
• Task Constraints
• Projects Critical Path
• Recurring Tasks
• Leveling Resources
• Organizing and Formatting Project Details
• Customizing Fields / Tables / Views
• Sharing Project Information
• Creating Base Lines
• Rescheduling Projects
• Calculating Variances
• Creating Reports
• Consolidating / Sharing Projects & Resources
• Introduction to Macros
• Customizing Toolbar

Target Audience

This course is designed for a person who has a good understanding of project management concepts, and also responsible for creating and modifying project plans, and who needs a tool to manage those project plans.

Project Managers, Team Leaders, PMO and , Software Engineers, Architects, etc.

Pre-requisites

Basic understanding of MS Office and Project Management Fundamentals

What you need to bring

Laptop with MS Project 2010 Installed

Key Takeaways

• Identify the basic features and components of the Microsoft Project environment.
• create a new project plan and input project information.
• manage tasks by organizing tasks and setting task relationships.
• manage resources for a project.
• finalize a project plan.
• exchange project plan data with other applications.
• update a project plan.
• manage project costs.
• report project data visually

Venue:

Vijatiya Training Solutions,
988, P.H. Road,
Arumbakkam,
Chennai – 600 106
Landmark: Next to Mega Mart Arumbakkam

For Bookings Contact: +91 9791128890

Compress Excel Workbooks/Reduce File Size

Posted on | March 21, 2011 | No Comments

It is a question these days if Excel workbook file size could be limited so that it doesn’t increase in MBs.  Most of the users just care about feeding in data/copy pasting them/formatting them. But none really cares to remove unwanted cells/default formatting in every sheet which causes the file size to increase.

Following list of bullets could help you reduce your file size. Try them.

  1. Delete unwanted empty sheets created
  2. Delete unwanted cells in the sheet which might have got validations/formatting/formulae either dragged or copied to other adjacent cells/next sheet.  Best way is to ensure your table alone and hold CTRL+SHIFT+Right Arrow to delete unwanted columns to the right and CTRL+SHIFT+Down Arrow to delete unwanted rows below
  3. Say suppose you have created unwanted macros in the sheet, you may delete and send them (in case of mailing/attaching files) and store all the macros in Personal Macro Workbook (PERSONAL.XLS) in case of storing all your code
  4. Make sure there are no hidden worksheets that you may not want to send.  This could also increase file size, as it in memory even if not loaded.
  5. Just in case there are cropped images, make sure you delete the unwanted cropped areas of the image.  Option under FORMAT PICTURE->ADJUST GROUP->COMPRESS PICTURES->Delete Cropped areas of pictures.  As, cropping doesn’t alter/reduce the file size to the cropped area of the image
  6. Ensure that there are no PASTE SPECIAL as BMP type of images on any sheet. While pasting it from another application like Word, or PPT, try  taking them as Object (Document Object/Worksheet Object etc) or in rare cases as Windows Enhanced Meta File
  7. Save the file in the right version. If you are using 2007, make sure you save the file as xlsx and not in older version unless and until you are sending the file to one who has 2003 to open it.  It increases the file size.
  8. Break unwanted links to files/sheets or the non-working links

Hope this helps.

Multi-book desktop shortcut – Open Workbooks Simultaneously

Posted on | March 21, 2011 | 1 Comment

Say, if you are preparing annual report say, AR.xlsx and there are four quarterly report files named Q1, Q2, Q3 and Q4 that you need to open and work with all these five files simultaneously.

To do so, try to open them once from their individual locations one by one wherever they are saved.  Then, click View->Window->Arrange All-> and choose TILED to make sure that all the five files are opened in the same window. (If not, then close another instant of Excel application and try opening the same file inside your first application window).

Now, just by clicking “Save Workspace” in the same View->Window group, you will be prompted to save the group of files as a Workspace with the extension .xlw (w stands for workspace).

You can now attempt closing all the files and open the workspace file (from wherever you saved it). That is it! It just opens all five files in no time and in the same way as you arranged them before saving workspace.  Since it is like a desktop shortcut, the workspaces do not take a copy/paste of the file to occupy more space but just the file name and path for reference.

Help about MS Office Help Window

Posted on | October 26, 2010 | No Comments

Source: http://office2010.microsoft.com/en-us/project-help/keyboard-shortcuts-for-project-2010-HP010352377.aspx

MS Project 2010 – Keyboard Shortcuts

Posted on | October 26, 2010 | 2 Comments

MS Project 2010 Shortcut Keys

INDEX

  1. Navigate Views and Windows
  2. Use a Timescale
  3. Outline a Project
  4. Select and Edit in a Dialog Box
  5. Select and Edit in the Entry Bar
  6. Select and Edit in a Sheet View
    • Edit in a view
    • Move in a view
    • Move in the side pane
    • Select in a view
  7. Use the Network Diagram View

 

Navigate Views and Windows

Action Shortcut
Activate the Control menu. ALT+SPACEBAR
Activate the entry bar to edit text in a field. F2
Activate the menu bar. F10 or ALT
Activate the project control menu. ALT+HYPHEN
Activate the split bar. SHIFT+F6
Close the program window. ALT+F4
Display all filtered tasks or all filtered resources. F3
Display the Field Settings dialog box. ALT+F3
Open a new window. SHIFT+F11
Reduce a selection to a single field. SHIFT+BACKSPACE
Reset sort order to ID order and turn off grouping. SHIFT+F3
Select a drawing object. F6
Display task information. SHIFT+F2
Display resource information. SHIFT+F2
Display assignment information. SHIFT+F2
Turn on or off the Add To Selection mode. SHIFT+F8
Turn on or off Auto Calculate. CTRL+F9
Turn on or off the Extend Selection mode. F8
Move left, right, up, or down to view different pages in the Print Preview window. ALT+Arrow keys

 

Use a Timescale

Action Shortcut
Move the timescale left one page. ALT+PAGE UP
Move the timescale right one page. ALT+PAGE DOWN
Move the timescale to beginning of the project. ALT+HOME
Move the timescale to end of the project. ALT+END
Scroll the timescale left. ALT+LEFT ARROW
Scroll the timescale right. ALT+RIGHT ARROW
Show smaller time units. CTRL+ / (slash on the numeric keypad)
Show larger time units. CTRL+* (asterisk on the numeric keypad)

 

Outline a Project

Action Shortcut
Hide subtasks. ALT+SHIFT+HYPHEN or ALT+SHIFT+MINUS SIGN (minus sign on the numeric keypad)
Indent the selected task. ALT+SHIFT+RIGHT ARROW
Show subtasks. ALT+SHIFT+ = or ALT+SHIFT+PLUS SIGN (plus sign on the numeric keypad)
Show all tasks. ALT+SHIFT+* (asterisk on the numeric keypad)
Outdent the selected task. ALT+SHIFT+LEFT ARROW

 

Select and Edit in a Dialog Box

Action Shortcut
Move between fields at the bottom of a form. Arrow keys
Move into tables at the bottom of a form. ALT+1 (left) or ALT+2 (right)
Move to the next task or resource. ENTER
Move to the previous task or resource. SHIFT+ENTER

 

Select and Edit in the Entry Bar

Action Shortcut
Accept an entry. ENTER
Cancel an entry. ESC
Delete one character to the left. BACKSPACE
Delete one character to the right. DELETE
Delete one word to the right. CTRL+DELETE
Extend the selection to the end of the text. SHIFT+END
Extend the selection to the start of the text. SHIFT+HOME
Turn on or off Overtype mode. INSERT

 

Select and Edit in a Sheet View

Edit in a view

Action Shortcut
Cancel an entry. ESC
Clear or reset the selected field. CTRL+DELETE
Copy the selected data. CTRL+C
Cut the selected data. CTRL+X
Delete the selected data. DELETE
Delete row that has a selected cell. CTRL+MINUS SIGN (on the numeric keypad)
Fill down. CTRL+D
Display the Find dialog box. CTRL+F or SHIFT+F5
In the Find dialog box, continue to the next instance of the search results. SHIFT+F4
Use the Go To command (Edit menu). F5
Link tasks. CTRL+F2
Paste the copied or cut data. CTRL+V
Reduce the selection to one field. SHIFT+BACKSPACE
Undo the last action. CTRL+Z
Unlink tasks. CTRL+SHIFT+F2
Set the task to manually schedule CTRL+SHIFT+M
Set the task to auto schedule CTRL+SHIFT+A

Move in a view

Action Shortcut
Move to the beginning of a project (timescale). ALT+HOME
Move to the end of a project (timescale). ALT+END
Move the timescale left. ALT+LEFT ARROW
Move the timescale right. ALT+RIGHT ARROW
Move to the first field in a row. HOME or CTRL+LEFT ARROW
Move to the first row. CTRL+UP ARROW
Move to the first field of the first row. CTRL+HOME
Move to the last field in a row. END or CTRL+RIGHT ARROW
Move to the last field of the last row. CTRL+END
Move to the last row. CTRL+DOWN ARROW

Move in the side pane

Action Shortcut
Move focus between the side pane and the view on the right side. CTRL+TAB or CTRL+SHIFT+TAB
Select different controls in the side pane if focus is in the side pane. TAB
Select or clear check boxes and option buttons if focus is in the side pane. SPACEBAR

Select in a view

Action Shortcut
Extend the selection down one page. SHIFT+PAGE DOWN
Extend the selection up one page. SHIFT+PAGE UP
Extend the selection down one row. SHIFT+DOWN ARROW
Extend the selection up one row. SHIFT+UP ARROW
Extend the selection to the first field in a row. SHIFT+HOME
Extend the selection to the last field in a row. SHIFT+END
Extend the selection to the start of the information. CTRL+SHIFT+HOME
Extend the selection to the end of the information. CTRL+SHIFT+END
Extend the selection to the first row. CTRL+SHIFT+UP ARROW
Extend the selection to the last row. CTRL+SHIFT+DOWN ARROW
Extend the selection to the first field of the first row. CTRL+SHIFT+HOME
Extend the selection to the last field of the last row. CTRL+SHIFT+END
Select all rows and columns. CTRL+SHIFT+SPACEBAR
Select a column. CTRL+SPACEBAR
Select a row. SHIFT+SPACEBAR
Move within a selection down one field. ENTER
Move within a selection up one field. SHIFT+ENTER
Move within a selection right one field. TAB
Move within a selection left one field. SHIFT+TAB

 

Use the Network Diagram View

Action Shortcut
Move to a different Network Diagram box. Arrow keys
Add Network Diagram boxes to the selection. SHIFT+Arrow keys
Move a Network Diagram box. Note   Manual positioning must be set first. Select the box you want to move. On the Format tab, click Layout in the Format group. Click Allow manual box positioning. CTRL+Arrow keys
Move to the top Network Diagram box in the view or project. CTRL+HOME or SHIFT+CTRL+HOME
Move to the lowest Network Diagram box in the project. CTRL+END or SHIFT+CTRL+END
Move to the leftmost Network Diagram box in the project. HOME or SHIFT+HOME
Move to the rightmost Network Diagram box in the project. END or SHIFT+END
Move up one window height. PAGE UP or SHIFT+PAGE UP
Move down one window height. PAGE DOWN or SHIFT+PAGE DOWN
Move left one window width. CTRL+PAGE UP or SHIFT+CTRL+PAGE UP
Move right one window width. CTRL+PAGE DOWN or SHIFT+CTRL+PAGE DOWN
Select the next field in the Network Diagram box. ENTER or TAB
Select the previous field in the Network Diagram box. SHIFT+ENTER

Source: http://office2010.microsoft.com/en-us/project-help/keyboard-shortcuts-for-project-2010-HP010352377.aspx

Access – Query Definitions

Posted on | October 6, 2010 | 1 Comment

Query Definitions
<> <> “Expired”
<= <=100
Between Between 1000 and 5000
Like “S*” Starts with S
Not Like “S*” Does not start with S
IsNull Empty
And Like “P*” and Not Like “*I”
Or “Km” or “Mts” or “Cm”
In In (“Km”,”Mts”,”Cm”)
Date function Between Date () and Date()+30
[] Parameter Query,  Example [Enter your name]

Access – Input Mask

Posted on | October 6, 2010 | No Comments

Definition of Input Mask
0 Can hold only a digit in that place –
Cannot be skipped
9 Can hold only a digit.  Can be skipped
# Can hold either Digit, + or – sign or space.
If skipped converted to spaces
L Can hold letter only.  Cannot be skipped
? Can hold letter.  Can be skipped
A Can hold either letter or digit cannot be skipped
a Can hold either letter or digit.  Can be skipped
& Can hold any character or space.  Cannot be skipped
C Can hold any character or space.  Can be skipped
< Causes character to the right to be converted to
lower case. Cannot place 0, 9 or # after this
> Causes character to the right to be converted to
upper case. Cannot place 0, 9 or # after this
\ Causes the character that follows to be displayed as
the literal character (eg: \A is displayed as just A)

Powerful Keys of PowerPoint Show

Posted on | October 6, 2010 | No Comments

HINT: Press F1 during a slide show to see this list of controls.

Action Control/Shortcut
Advance to the next slide Left click, Spacebar, N, right or down arrows, Enter, or Page Down
Return to the previous slide Backspace, P, left or up arrows, or Page Up
Go to a slide Type the slide number and Enter
Black or unblack the screen B or .
White or unwhite the screen W or ,
Show or hide the arrow pointer A or  =
End slide show Esc, Ctrl + Pause
Erase drawing on-screen E
Go to next slide, if it’s hidden H
Rehearse with new timings T
Rehearse with original timings O
Rehearse with mouse-click advance M
Return to the first slide 1 + Enter or Hold down both mouse buttons for 2 seconds
Change pointer to pen Ctrl + P
Show or hide ink markup Ctrl + M
Change pen to pointer Ctrl + A
Hide pointer and button Ctrl + H
Hide pointer and navigation button always after fifteen seconds of inactivity Ctrl + U
Show pop up menu or previous slide Right mouse click
Go to the first or next hyperlink on a slide Tab
Go to the last or previous link
hyperlink on a slide
Shift + Tab
Perform the “mouse click ” behavior of the selected link Enter while a hyperlink is selected

Fun with Excel Charts – India Map

Posted on | September 30, 2010 | 1 Comment

The below India map has been created using Excel Chart.

India Map Using Excel Chart

Fun with Excel Charts – Designs

Posted on | September 30, 2010 | 3 Comments

Can you try these in Excel Charts?

keep looking »