• 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

Create a Photo Album in PowerPoint

The photo album feature of PowerPoint makes it easy to create a presentation displaying photos of an event or topic that can be shared with friends and family, or saved for your own memories.

PowerPoint makes it easy to create a photo album allowing you to change the album layout, theme or picture order at any time.

[Read more…] about Create a Photo Album in PowerPoint

Change the Default File Location for Saving Documents

By default, Word 2007 stores your documents in the My Documents folder. However, you may want to save your documents in a different folder.

You may want to save your documents on a server so that they are accessible by all members of your office easily. It make sense to choose a location where everybody will know where to look for the files.

To change the default file location when saving documents in Word 2007;

[Read more…] about Change the Default File Location for Saving Documents

Dynamic Grid in Visio 2010

Visio 2010 makes it even easier to create drawings, and one of the main reasons for this is the improvements to the Dynamic Grid.

The Dynamic Grid assists you with the sizing, aligning and spacing of shapes in relation to one another. It is an extremely useful tool, and one that takes arranging shapes to another level of simplicity.

The dynamic grid was introduced with Visio 2007 and then enhanced further in the 2010 version. As you size or move a shape on the page, arrows and lines will appear to assist you with the shapes alignment and spacing.

The image below shows its use in Visio 2007. The dotted lines indicating that the rectangle shape being moved is centrally aligned with the two other shapes on the page.

Dynamic grid in Visio 2007

The image below shows the dynamic grid in Visio 2010. The lines are red and solid making them clearer. And in addition it also informs you that the three shapes are equally distributed.

Distribution shown in Visio 2010

These examples are simple, but they do illustrate its power. Gone are the over reliance on the align and distribute commands in Visio. They are still available for use, but are rarely required.

The image below shows a more complex use of the dynamic grid. A position shape is being moved on an organisation chart. Arrows and lines appear to assist me with aligning and spacing it with the other position shapes.

Organisation chart on the dynamic grid

The dynamic grid is turned on by default in most drawings. It does depend on the template being used though. For example, it is not turned on by default in the organisation chart template. To turn it on:

[Read more…] about Dynamic Grid in Visio 2010

Use Filters to Analyse Project Data

Microsoft Project has two ways of filtering its’ tables. There is the AutoFilter, similar to what you would see in Excel, and there is the in-built filters.

Filtering allows you to perform some simple analysis of your project data. It can be used to find which tasks begin this week, which tasks have slipped, or the most expensive tasks.

[Read more…] about Use Filters to Analyse Project Data

How to Trim a Video in PowerPoint 2010

The ability to insert video into presentations has always been an incredibly useful feature of Microsoft PowerPoint. PowerPoint 2010 now handles more video formats than ever before including MP4 and Flash movies.

You can even embed online videos from sites such as YouTube, MetaCafe and Daily Motion into your presentations in PowerPoint 2010. All you need is the embed code available from the video publisher.

The improvements to using video in PowerPoint 2010 do not stop there though. One brilliant new addition to the wealth of new video editing features is the ability to trim a video.

Trimming a video enables you to use a specific section of a video. You can cut off time at the start and end of a video. And it really could not be easier to do.

Trim a Video in PowerPoint 2010

  1. Select the video in the presentation that you want to trim
  2. Click the Playback tab on the Ribbon
  3. Click the Trim Video button in the Editing group
  4. The Trim Video window appears. The filename and video duration are shown at the top.
  5. To trim the video you can either click and drag the required marker at the beginning or end of the video timeline, or enter a time in the Start Time or End Time boxes
  6. Click Ok

When the video is now played it will start and end at the times specified.

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 6
  • Page 7
  • Page 8
  • Page 9
  • Page 10
  • 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 ·