• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About
Home / Archives for Office

Eyedropper Tool in PowerPoint – Fantastic Feature

The eyedropper tool in PowerPoint is a fantastic tool. The eyedropper tool allows you to match colours between objects on your slides. This could mean copying a colour from a picture and applying it to text on your slide.

This tool makes it easier to create fantastic looking cohesive presentations. Matching the colours of your fonts, images and other objects has never been so easy.

Using the Eyedropper Tool in PowerPoint

The example below shows the title slide in Slide Master View. Using the eyedropper tool, we will copy the colour used for the text in the NST logo, and apply it to the slide title text currently in black.

[Read more…] about Eyedropper Tool in PowerPoint – Fantastic Feature

Adding Resources in MS Project

Microsoft Project provides many features for the management of resources in a project. It can warn you when a resource is over utilised, list available resources, apply overtime hours, calculate costs and more.

First though you need to define the resources for your project.

[Read more…] about Adding Resources in MS Project

Create a Fire Evacuation Plan in Visio

It is essential to have a fire evacuation plan. As a trainer I am regularly visiting different offices and other locations. On arrival I need to make myself aware of the emergency evacuation procedures and pass this information onto my delegates.

These diagrams should be kept simple so that it provides clarity at a time when people are not thinking clearly. Too many that I see provide cute but unnecessary detail.

You can create a fire evacuation plan in Visio. Visio provides emergency response shapes that can be added to a floor plan. This diagram can then be printed and displayed in the required areas of a building.

[Read more…] about Create a Fire Evacuation Plan in Visio

Format Footnotes in a Word Document

Footnotes are text displayed at the bottom of a page used mainly for references or comments. When footnotes are added to a document in Word they appear in the default font and size. For Word 2010 this is the Times New Roman font and size 10.

The footnote text and reference can be formatted to be consistent with the documents body text or to improve clarity. The footnote separator can also be changed or removed if no longer desired.

[Read more…] about Format Footnotes in a Word Document

Working with Constraints and Deadlines

A constraint is a restriction on the start or finish date of a task in the project. Setting constraints is useful when external factors affect the start or finish date of a project. For example, vital supplies are not available to begin work on a task until the 10th September.

Every task in a project has a constraint applied to it already – the default As Soon As Possible constraint is applied when scheduling from the project start date, and the As Late As Possible constraint is used when scheduling from the project finish date.

These constraints are often not considered true constraints. They indicate that the task follows the working calendar, duration and task dependencies.

[Read more…] about Working with Constraints and Deadlines
  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 3
  • Page 4
  • Page 5
  • Page 6
  • Page 7
  • Interim pages omitted …
  • Page 12
  • Go to Next Page »

Primary Sidebar

Recent Posts

  • Excel SWITCH Function – Nested IF Function Alternative
  • Sum Formulas Only in Excel
  • How to Calculate Age in Excel
  • Custom Sort in Excel
  • Case Sensitive Lookup with XLOOKUP in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

LinkedIn Twitter YouTube

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Blog
  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2009 Computergaga · All Rights Reserved ·