✔ VBA Excel Specialist®: Tips - Microsoft Project 2010 - Quick Reference Card Pack

| Blog Office VBA | Blog Excel | Blog Access |

100.000 VISITAS

Às vezes queremos usar algum recurso do Office e simplesmente temos um branco e não conseguimos nos lembrar onde aquele funcionalidade está.

Há muitas décadas já existem os Cartões de Referência Rápida (Quick Reference Card). E são uma mão na roda tanto para nos ajudar a fixar onde determinada funcionalidade fica, quanto para lembrarmos quando estamos com muita pressa.

Neste post estou listando diversos QRCs (Quick Reference Card), espero que gostem, usem e indiquem este post para outros.

Microsoft Project 2010 Quick Reference Card Pack

Neste caso estou disponibilizando um pacote de referências rápidas. Muitos projetos são implementado utilizando-se o Microsoft Project 2010. Este aplicativo não faz parte da suíte MS Office, mas certamente será uma boa contribuição para aqueles que o utilizam extensivamente.

Este pacote é composto por:

Microsoft Project 2010 Quick Reference Card: Interface Elements and Keyboard Shortcuts

Microsoft Project 2010 Quick Reference Card: Task Ribbon

Microsoft Project 2010 Quick Reference Card: Resource Ribbon

Microsoft Project 2010 Quick Reference Card: Project Ribbon

Microsoft Project 2010 Quick Reference Card: View Ribbon

Microsoft Project 2010 Quick Reference Card: Assignment Variables and the Assignment Equation

Microsoft Project 2010 Quick Reference Card: Task Types

Nessas referências encontrarão:

Main interface elements shown:

Ribbon Tabs

Ribbon Menu

Quick Access Toolbar

Customize Quick Access Toolbar

Title Bar

Window Minimize

Window Maximize

Exit Application: AVOID

Close Schedule: AVOID

Minimize Ribbon

Help

Restore Window

Timeline View

Timeline Vertical Scrollbar

Timeline Horizontal Scrollbar

Horizontal Window Split Bar

View Bar

Task Table

Select All

Task Row Headers

Column Headers

Task Table Horizontal Scrollbar

Vertical View Split Bar

Gantt Chart

Gantt Chart Timescale

Gantt Chart Horizontal Scrollbar

Gantt Chart Vertical Scrollbar

Cell Mode

New Tasks Selector

Status Bar

View Shortcuts

Zoom Slider

Keyboard shortcuts shown:

[F1]: Help

[F2]: Enable direct data entry in cell

[F3]: Clear any applied filters

[F5] or [Ctrl]+[G]: Open 'Go To' dialog

[F6]: Toggle between split window panes

[F7]: Open 'Spelling' dialog

[F8]: Turn on / off Extend Selection mode

[F9]: Force calculation

[F11] or [Alt]+[F1]: Create new blank project

[F12] or [Alt]+[F2]: Open 'Save As' dialog

[Alt]+[F3]: Open 'Field Settings' dialog

[Alt]+[F4]: Close project schedule

[Alt]+[F5]: Go to next overallocation

[Alt]+[F8]: Open 'Macros' dialog

[Alt]+[F10]: Open 'Assign Resources' dialog

[Shift]+[F2]: Open 'Task Information' dialog

[Shift]+[F3]: Remove all groupings

[Shift]+[F5] or [Ctrl]+[F]: Open 'Find' dialog

[Shift]+[F6]: Activate split bar

[Shift]+[F10]: Show Ribbon keyboard shortcuts

[Shift]+[F11]: Open project in new window

[Ctrl]+[F2]: Link selected tasks

[Ctrl]+[Shift]+[F2]: Unlink selected tasks

[Ctrl]+[F9]: Turn on / off auto-calculation

[Ctrl]+[Shift]+[M]: Manually schedule task

[Ctrl]+[Shift]+[A]: Auto schedule task

[Ctrl]+[H]: Open 'Replace' dialog

[Ctrl]+[N]: Create new blank project

[Ctrl]+[O]: Open 'Open' dialog

[Ctrl]+[P]: Display 'Print' page

[Ctrl]+[S]: Save project

[Insert]: Insert new task

[Delete]: Delete cell contents or line

[Alt]+[Shift]+[Right Arrow]: Indent task

[Alt]+[Shift]+[Left Arrow]: Outdent task

[Ctrl]+[/]: Zoom in

[Ctrl]+[*]: Zoom out

[Alt]+[Left Arrow]: Scroll timescale left

[Alt]+[Right Arrow]: Scroll timescale right

[Alt]+[Page Up]: Scroll timescale left 1 page

[Alt]+[Page Down]: Scroll timescale right 1 page

[Alt]+[Home]: Scroll timescale to project start

[Alt]+[End]: Scroll timescale to project finish

[Ctrl]+[Shift]+[F5]: Scroll to task on Gantt Chart

[Alt]+[Shift]+[-]: Hide subtasks

[Alt]+[Shift]+[+]: Show subtasks

[Alt]+[Shift]+[*]: Show all subtasks

Task Ribbon commands shown:

View Ribbon Group: Gantt Chart

Clipboard Ribbon Group: Paste

Clipboard Ribbon Group: Cut

Clipboard Ribbon Group: Copy

Clipboard Ribbon Group: Format Painter

Font Ribbon Group: Font

Font Ribbon Group: Font Size

Font Ribbon Group: Bold

Font Ribbon Group: Italic

Font Ribbon Group: Underline

Font Ribbon Group: Background Color

Font Ribbon Group: Font Color

Schedule Ribbon Group: % Complete

Schedule Ribbon Group: Mark on Track

Schedule Ribbon Group: Respect Links

Schedule Ribbon Group: Outdent Task

Schedule Ribbon Group: Indent Task

Schedule Ribbon Group: Split Task

Schedule Ribbon Group: Link Tasks

Schedule Ribbon Group: Unlink Tasks

Schedule Ribbon Group: Activate / Inactivate Selected Tasks

Tasks Ribbon Group: Manually Schedule

Tasks Ribbon Group: Auto Schedule

Tasks Ribbon Group: Inspect

Tasks Ribbon Group: Move Task

Tasks Ribbon Group: Schedule Mode

Insert Ribbon Group: Insert Task

Insert Ribbon Group: Insert Summary Task

Insert Ribbon Group: Insert Milestone

Insert Ribbon Group: Manage Deliverables and Dependencies

Properties Ribbon Group: Task Information

Properties Ribbon Group: Task Notes

Properties Ribbon Group: Display Task Details

Properties Ribbon Group: Add Task to Timeline

Editing Ribbon Group: Scroll to Task

Editing Ribbon Group: Find

Editing Ribbon Group: Clear

Editing Ribbon Group: Fill

Resource Ribbon commands shown:

View Ribbon Group: Team Planner

Assignments Ribbon Group: Assign Resources

Assignments Ribbon Group: Resource Pool

Assignments Ribbon Group: Substitute Resources

Insert Ribbon Group: Add Resources

Properties Ribbon Group: Resource Information

Properties Ribbon Group: Resource Notes

Properties Ribbon Group: Display Resource Details

Level Ribbon Group: Level Selection

Level Ribbon Group: Level Resource

Level Ribbon Group: Level All

Level Ribbon Group: Leveling Options

Level Ribbon Group: Clear Leveling

Level Ribbon Group: Go To Next Overallocation

Project Ribbon commands shown:

Insert Ribbon Group: Insert Subproject

Properties Ribbon Group: Project Information

Properties Ribbon Group: Custom Fields

Properties Ribbon Group: Links Between Projects

Properties Ribbon Group: WBS

Properties Ribbon Group: Change Working Time

Schedule Ribbon Group: Calculate Project

Schedule Ribbon Group: Set Baseline

Schedule Ribbon Group: Move Project

Status Ribbon Group: Status Date

Status Ribbon Group: Update Project

Status Ribbon Group: Synchronize to Protected Actuals

Reports Ribbon Group: Visual Reports

Reports Ribbon Group: Reports

Reports Ribbon Group: Compare Projects

Proofing Ribbon Group: Spelling

View Ribbon commands shown:

Task Views Ribbon Group: Gantt Chart

Task Views Ribbon Group: Task Usage

Task Views Ribbon Group: Network Diagram

Task Views Ribbon Group: Calendar

Task Views Ribbon Group: Other Views

Resource Views Ribbon Group: Team Planner

Resource Views Ribbon Group: Resource Usage

Resource Views Ribbon Group: Resource Sheet

Resource Views Ribbon Group: Other Views

Data Ribbon Group: Sort

Data Ribbon Group: Show Outline

Data Ribbon Group: Tables

Data Ribbon Group: Highlight

Data Ribbon Group: Filter

Data Ribbon Group: Group By

Zoom Ribbon Group: Timescale

Zoom Ribbon Group: Zoom

Zoom Ribbon Group: Zoom Entire Project

Zoom Ribbon Group: Zoom Selected Tasks

Split View Ribbon Group: Timeline View

Split View Ribbon Group: Timeline Views

Split View Ribbon Group: Details View

Split View Ribbon Group: Detail Views

Window Ribbon Group: New Window

Window Ribbon Group: Switch Windows

Window Ribbon Group: Arrange All

Window Ribbon Group: Hide Window

Macros Ribbon Group: View Macros

Resource Assignment Variables shown:

Work: The number of hours of real work effort spent performing a task.

Duration: The amount of working time between the start date and the finish date of a task.

Assignment Units: The percentage of a resource's typical workday spent performing a task.

The formula that controls the relationship between these three assignment variables in the Microsoft Project scheduling engine.

Task Type Details shown:

Fixed Work: A task for which Microsoft Project attempts to hold the work effort fixed.

Fixed Duration: A task for which Microsoft Project attempts to hold the duration fixed.

Fixed Units: A task for which Microsoft Project attempts to hold the assignment units fixed.

Detailed explanations of each type of task and examples of situations in which you should use each Task Type.