What Are Master Slides and Why Are They Beautiful

While I do not think a PowerPoint presentation is a substitute for learning to speak well, I do think that if you have that presentation down pat, visual aids can help.

For me, Master Slide are like formatting a Word document in Styles. It streamlines the creation process, helps with consistent formatting, and allows the designer to apply universal changes to large presentations both quickly and globally.

What is a Master Slide?

A Master Slide is a series of slides and sub-slides that control the layout and appearance of a PowerPoint presentation. From here you can control themes, colors, fonts, and individual slide layouts.

Master Slides Save Time

Have you ever created a presentation and had a colleague or supervisor praise it to the skies…

… except they didn’t like the font, and thought the color scheme was juuust the wrong shade of fuchsia?

If you have not formatted your presentation using the Master Slide options, but instead have formatted slide by slide, that 80 slide presentation is going to take forever to update!

If you have formatted using Master Slides, you’ll make the corrections on one Master Slide, then have those corrections populate throughout your presentation.

How Do I Use a Master Slide?

Here’s a little secret. All presentations have Master Slides. It’s just that so many of us don’t use them.

To access the slide master:

  1. Activate the View tab.
  2. Click Slide Master.

From here, you will access a Master Slide and various layouts available in your presentation. If you can do it to a slide, you can do it to a Master Slide, so this is where you can get creative. You can apply headers and footers to the slide globally, add a background image to all slides, control the font, color and layout of each slide.

The Right Tool for the Right Job

image

Excel is a powerful program, no doubt.  When you need hard-core data analysis it’s a great tool.  Sadly, this is not how I often see Excel used in my professional life.

I see Excel used as a table creation tool for printed schedules — no calculations being performed at all.  I see Excel being used as a database.   This is forgiveable.  If you know what you’re doing, you can make a decent flat database with Excel. 

But that is exactly the problem.  A well-designed database is one that can be used by someone who does not necessarily know what they’re doing, but can enter data and pull reports easily.  This is where Excel falls down badly.  Hand this tool to someone who does not know what they’re doing, and you’d better be locking down a lot of functions on the user end, or you’re going to wind up with destroyed data.

I encourage people who use Excel for data tracking to look carefully at their data before making a decision about what application to use when doing it.  The two biggest criteria I see are record count and report complexity.

If your data is going to be involving millions of records, you want a database.  Excel will choke.  If you want complex data reporting across several data tables and records, you want a database, not Excel.

If you’re dealing with a few thousand records and need to display that data graphically to explain in a presentation, yeah, Excel is your tool and it works great.

The Top Three Reasons to Use Styles When Formatting a Document

Do you use styles in formatting your MS Word doc?

Do you even know what styles are?

At its simplest, a style is a collection of formatting – font face, font size, font color. And when you hear that, you think, “So what? Why should I go to the trouble of using those presets to format my document when I can think of something so much cooler?”

Styles Help You Write

I’m going to go back about thirty years when I was first learning to write. My fifth-grade teacher, like many in the US, taught us something called a Five-Paragraph Essay. This project takes the student through the writing process by teaching them to create an outline, coming up with supporting points for their topic, and then using that to start writing the actual essay.

When you use styles, you can integrate the outline and the writing process easily. Come up with the main points you want to cover in your document format them as headers, and then, voila! You have a ready-made outline in your navigation pane.

But let’s say that you’re writing something that has some sub-points to make:

Outlining helps to organize thoughts

When you outline, you’re organizing your piece into units of thought that go together logically. Maybe you’re writing an instruction manual, and you want to divide by topic or sub-topic. Maybe you’re writing a speech, and you need to make sure that your points go together into a coherent group. Formatting your points into headings and subheadings means that you can do this on the fly as you’re in the brainstorming stage of your piece.

Outlining makes text flow easier

But using headings and subheadings to outline your document isn’t just for the writer. A document that uses them makes it easier for the reader to follow. If you’ve ever tried to read a wall o’ text explaining something, you’ll agree that formatting documents in headings and subheadings mean that you can digest the material more quickly.

Styles Make Document Structure Automatic

Once you have the outline for your document using styles, the structure of the outline can drive the structure of the document.

Have you ever collaborated on a piece with someone, only to find that your perfectly-paginated and laid out document is now completely messed up because one of your co-authors has added a few paragraphs of material somewhere?

It can be frustrating until you realize you can edit a style that makes this sort of thing unnecessary.

Let’s say that you’re formatting a document so that anything that is a Heading 1 in your work would be analogous to a new chapter in a book. Therefore, it always needs to start on a new page. Sure, sure, you could add a page break before the Heading 1 manually. But why bother when Word can do that for you?

  1. Right-click on the style you wish to change (in this example, Heading 1)
  2. Click on the Format button in the lower-right corner.
  3. Then click on Paragraph.
  4. Click on the Page and Line Breaks tab.
  5. Check Page Break Before.
  6. Click OK on each dialog box until you get to your document again.

Now the wordiest of co-authors can’t mess up pagination!

There are many more features that can be style-driven if you want them to, and I encourage you to explore Using Styles in Word from Microsoft. Styles can control tables of contents, headers and footers and other types of formatting that make the document easily-readable.

Styles are Easy to Change

The biggest reason to use styles, in my opinion, is that they are easy to change. If you’ve ever been in a meeting and had someone hung up on the color or size of text in a document, you’ll understand why styles make this easy.

Debbie and Bill might be at each other’s throats in the design meeting going back and forth on whether or not to use the purple (because it’s a strong color) or the green (because it implies calm and good resource stewardship). And there you are chewing your nails because you know that this 800-page document has fifty headings and subheadings. They could come to an agreement only to have Corey over in Marketing put the kibosh on their choice for an aqua when you’re three-quarters through implementing the green on each heading one by one.

If you’d used styles, all you have to do is edit the styles themselves and the change is global.

I hope you’ll consider using styles for your next MS Word document to see how much easier the writing and formatting goes.

NIFTY TIP Adding or Subtracting Amounts from Different Ranges

Problem: You need to add or subtract amounts from different ranges according to a specific criteria (SUMIF function).

Solution: Insert two SUMIF formulas and combine them into a single formula:

  1. Insert the SUMIF formula to total the amounts based on the criterion 701 into cell E2.
  2. Insert the SUMIF formula to total the amounts based on the criterion 300 into cell E3.
  3. Select cell E2 and copy the formula from the Formula Bar, select the formula and press <ctrl>+C and click the Enter or Cancel symbol in the Formula Bar to exit Edit mode.
  4. Select cell E5 and press <ctrl>+V.
  5. Select cell E3 and copy the formula from the Formula Bar without the equals (=) sign by selecting the formula and pressing <ctrl>+C.
  6. Select cell E5 and enter a minus(-) sign after the formula in the cell, and then press <ctrl>+V.

The combined formula is now:

=SUMIF(A:A,D2,B:B)-SUMIF(A:A,D3,B:B)