• 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

Embed Fonts in PowerPoint File

If you are sharing a PowerPoint presentation with others, you may decide to embed fonts in the PowerPoint file. This will ensure that others can use those fonts, even if they are not installed on their machine.

If you have used a custom font that another user does not have, it will be replaced by the default font on their machine. The presentation will then have an inconsistent look to it.

Be aware that embedding fonts in a PowerPoint file will increase its file size. However this is typically a small price to pay for a consistent and reliable presentation.

To embed fonts in PowerPoint presentations;

[Read more…] about Embed Fonts in PowerPoint File

Format Mail Merge Fields from Excel

When performing a mail merge from Excel to Word, your mail merge fields tend to lose their Excel formatting. This is especially common with date, time and currency fields. In this tutorial, learn how to format mail merge fields in Microsoft Word.

The tutorial will look at how you can correctly format date, time and currency mail merge fields from Excel. Once the formatting is applied to the mail merge document it will be remembered for future use.

Take the image below for instance (click to see enlarged view). Notice the formatting of the date, time and currency fields in Excel, and then the result in Word after inserting the mail merge fields.

Format mail merge fields to stop them losing their Excel format
[Read more…] about Format Mail Merge Fields from Excel

Create a Looping PowerPoint Introduction

This blog post looks at how you can create a looping PowerPoint introduction. This is when a few select slides are set to loop continuously before the main presentation begins.

It provides something for the audience to watch whilst they are gathering in the room. It can be a useful technique for creating a buzz, and setting the expectations for what is to follow.

To do this we will need to create two custom shows. One for the looping introduction, and another containing the main body of the presentation. We will then need to link the two shows so that the presenter can easily exit the loop and begin the presentation when needed.

[Read more…] about Create a Looping PowerPoint Introduction

5 MS Project Settings You Need to Know

Microsoft Project has many settings that control the behaviour of the application, and of your projects.

These settings can be accessed by clicking the File tab on the Ribbon and then Options. There are many useful options in here, but this blog post focuses on 5 MS Project settings you need to know.

Calculate Multiple Critical Paths in  a Project

Although a project can only have one true critical path (the tasks that directly affect the finish date of the project). You may wish to view the critical path for each independent series of tasks.

This can be done to view the critical path for each subproject for a large master project, or maybe you have different independent series of tasks that are performed by different departments or regions in the project.

The Calculate multiple critical paths checkbox is found at the bottom of the Advanced category in the Options window.

Watch this video on using multiple critical paths in MS Project.

Display multiple critical paths in MS Project
[Read more…] about 5 MS Project Settings You Need to Know

MS Project: Display Multiple Fields Next to Task Bars in Gantt Chart

In Microsoft Project you can display different project information next to the task bars in a Gantt Chart. This ensures that you can see the information you need to see about a task without having to keep looking over to the table.

You can display the information in different positions in relation to the bars such as to the left, right, above, below or in the middle. However, Project only allows one piece of information per position.

Resource names shown to the right of task bars

This can limit the feature somewhat so we will look at how to add multiple fields next to the task bars in a Gantt Chart.

Create a Concatenated Field

[Read more…] about MS Project: Display Multiple Fields Next to Task Bars in Gantt Chart
  • « Go to Previous Page
  • Page 1
  • Page 2
  • Page 3
  • Page 4
  • 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 ·