From Boring to Exciting – Use PowerPoint SmartArt

In an  earlier post, I explained how to convert a Word document to a PowerPoint presentation in one click (ok… few clicks!). Unfortunately, the resulting presentation is guaranteed to put your audience to sleep. The presentation contains only text. And lots of bullets. Everyone in the world knows that …

PowerPoint SmartArt turns boring presentation into exciting Most presentations are boring! Still we contribute to that boredom by creating more boring presentations. If you want to succeed in your presentations, you should strive to be in the 1% image There are thousands of ways to make your presentation less sleep inducing. But one method stands out. Which is quick and easy.

SmartArt.

Convert those boring bullets into interesting and easy-to-understand diagrams.

Boredom to excitement… in few clicks

  1. Right click in your bulleted text and choose Convert to SmartArt.
  2. PowerPoint shows you 20 diagrams to choose from.
  3. Move the mouse cursor over each diagram – it is temporarily drawn … move to next till you find the most suitable diagram to explain your concept.
  4. Remember that most people don’t do this. So you are already in the 5%
  5. But you don’t want to stop there. You want to be exclusive…
  6. So have the courage of clicking on More SmartArt Graphics… (nobody has that courage… so that is your competitive advantage)
  7. Now you will have a big problem

135 diagrams to choose from!

Don’t get disheartened. In a given business context, only one or two of these diagrams are most suited. The real skill is finding the right diagram for your need. Unfortunately, there is no easy way there. You have to put effort.

Homework: Learn 135 diagrams

Spend 30 minutes of your precious life to do this:

  1. Create a new blank presentation
  2. Create a new slide (usually it will be Title and Text type of slide)
  3. Open Insert tab and choose SmartArt
  4. Look at the categories on the left. These will tell you overall categories of diagrams from a business point of view.
  5. Click on each category. Then diagrams of that category are shown.
  6. Now click on each diagram.
  7. On the right side, a bigger version of that diagram is shown. Just imbibe that visually.
  8. Look below… Microsoft has taken the trouble to explain the business context in which the diagram should be used. Read that.
  9. Move to the next diagram.

Spend image minutes of your precious life and see the difference! To stimulate your thought… here are some nice diagrams.

Risk Management

Risk Management SmartArt

Pricing is determined by demand and supply

Supply and Demand SmartArt

Input and Output

image

Colors, Styles, Animation and Effect options

Try all options on the SmartArt Tabs – Design and Formatting to know more about what you can do. Also apply some simple animation and choose Effect options to see interesting ways in which you can control the animation.

How to get full control?

SmartArt is very nice. But you have one limitation. You cannot change one item independent of others, you cannot group items and so on. Don’t worry. Use SmartArt first to create a base diagram quickly. Then click Design tab and Choose Convert to Shapes. Now it is no longer a SmartArt diagram. It becomes a simple diagram with grouped objects and shapes. Now you can ungroup it and control each shape exactly the way you want. Now you get best of both worlds. Quick diagram and full control.

Homework 2

Take any of your existing presentations. Save it as a copy. Look at existing verbose slides and see if you can improve them using appropriate usage of SmartArt

Pending issue

Creating Picture SmartArt is not easy. You insert the SmartArt first and then you have to choose one picture at a time, repeatedly. And as you know, repetition means inefficiency. In the next post we will see how to create SmartArt containing many pictures (of dissimilar sizes) in two simple steps. Another miracle coming up…

9 benefits of using Excel Tables

If I have to teach ONE thing to the world, it would be Excel Tables.

Excel tables

I recently created this video for a Microsoft Webcast.
Excel Tables were introduced in Office 2007.
This video explains the importance of using Excel Tables.

Prevent Wrong Decisions using Excel Tables

Outdated formulas in Excel are a big operational risk

Tables eliminate that risk proactively.

Additional Benefits of Excel Tables

This in itself can become a series. But here is a short description of the benefits

Auto-update of formulas and references

All dependent formulas are auto-updated across sheets. If you have a linked file, the file must be open for the auto-update to work.

Automatic formatting of tabular data

If you have manual formatting applied, the Table formatting cannot override it. To override, right click on the desired format and choose Apply and Clear Formatting option.

Automatic copying of calculated column formulas

Any formula added in new columns in the table is auto-copied across the table. The formula is copied all the way to the end of the table even if the left column has empty cells.

This saves you the trouble of using time consuming DRAG or error prone DOUBLE CLICK for copying formulas.

If you don’t like this behavior then use the SmartTag to UNDO the auto-copy action.

Automatic copying of calculations when more data is added

This is very useful. If more data is added, calculated columns are auto-filled.

To take advantage of this feature, make sure that you add calculated columns at the end of the raw data. This way, when you get more raw data, you can simply paste it at the bottom of the Table.

Automatic display of headings

Headings are shown in place of regular column headings. It also offers Auto-Filter dropdown (2010 onwards). This eliminates the need for Split and Freeze Pane.

Automatic copying of formatting, conditional formatting and validations

All attributes of cells are auto-copied when you add more rows in a Table.

Ability to use Table and Column names in formulas

Ability to integrate with SharePoint and Visio

You can upload an Excel table to a SharePoint site. It automatically creates a list, creates relevant columns, uploads the data to SharePoint and finally creates a one way (SharePoint to Excel) link with the data.

In Visio you can create a visualization based upon a Visio based Pivot Table functionality.

Create a presentation in One Click with Send to PowerPoint

Send to PowerPoint is an amazing feature of Word.  It has been available for many years but nobody noticed it. So Microsoft removed it from the menus in Office 2007. You need to add this menu back into your Word ribbon first.

If you are using Office 2003 or older, just go to File – Send to – Send to PowerPoint.

How to enable Send to PowerPoint feature in Word

  1. Start Word
  2. Right click on the ribbon
  3. Choose Customize Quick Access Toolbar
  4. You will see two lists. From the left side, open the dropdown which is showing
    Popular Commands. Choose All Commands
  5. Click in the list below. This shows all Word commands (buttons). This is a very long list.
  6. Type character s
  7. This will take you to the list of commands starting with character s
  8. Now press Page Down multiple times till you locate the command Send to PowerPoint
  9. Click the Add button then click Ok

Now you will have the Send to PowerPoint button in your Quick Access Toolbar.

Word to PowerPoint in ONE click

Create or open any Word document which is using styles.

image

Click on the Send to PowerPoint button.
The button looks a little different depending upon your version of Office.

Send to PowerPoint

PowerPoint will automatically create a presentation for you. Every item with Heading 1 style becomes a new slide. All other heading levels below it become bullets.

Pictures are not transferred to PowerPoint even if they have Heading style applied.

image

Few more steps…

  1. As soon as this presentation is created, go to Slide Sorter view.
  2. Press CTRL A to select all slides.
  3. From Home tab, click the Reset button.
  4. Now you can apply any other design template and use the presentation OR
  5. Copy the slides into another presentation

image

This step is required to remove the unwanted formatting which was transferred from Word to PowerPoint. If you do not perform this formatting reset operation, applying other design templates will not work properly.

Be stylish – Use Word Styles

Thank you for responding the vote in the previous article on 3 Efficiency Best Practices. In this article, we explore Word Styles in greater detail. Read this even if you are using Word Styles.

word styles

Picture created using Fresh Paint on Surface Pro with finger painting.

Problem: We spend too much time on formatting and too little on the core content.

Solution: Use Word Styles

Styles are just ready to use formatting which is created by graphics experts. There are 9 styles – Heading 1 to Heading 9

While creating a document, you know which of the paragraphs are Headings or Topics or Titles. As soon as you type the paragraph, choose the style.

Word styles

Main topics get H1, sub topics get H2 and so on.

How to select styles quickly

  1. Click the style in the Home tab – Styles drop down (it is called a Gallery).
  2. Or use keyboard shortcuts CTRL ALT 1 for H1 CTRL ALT 2 for H2 and
    CTRL ALT 3 for H3
  3. Or use the shortcut Shift Alt Up arrow to apply Higher styles, Shift Alt Down arrow to apply lower styles

Default styles in Word 2013

This how the default styles look. If you want to change the appearance to match your corporate branding guidelines, Right Click on each style, Choose Modify and change the look and feel.

Default styles in Word 2013

Customized styles affect only the current document by default. If you want all further documents to have the customized styles, choose the following option in the Modify dialog.

Customized styles in Word

Change the look and feel instantly using Themes

Choose Page Layout tab (2007,2010) or Design tab (2013) and open the Themes dropdown. Just move the mouse cursor over each theme and see how the document reformats instantly with different color and font combinations.

If you find some combination which resembles your brand colors, it is the easiest way of customizing document look and feel for corporate branding. Remember to use the same theme in Excel and PowerPoint as well.

What are the benefits of using Word Styles?

The main benefit is that Word knows what are the main and sub-topics in your document. Word uses this information intelligently to provide you with many useful features.

Navigation Pane

Choose View tab – Navigation Pane. Now a Separate window opens on the left side and shows you the document hierarchy. This never gets printed. This is your on-screen navigator.

Navigation Pane in Word

  1. Just click on the item to navigate to that area. No more scrolling and searching.
  2. Reorganize the document (and your thoughts) by just using drag-drop.
    (Amazing! is it not?)
  3. Right click on any heading and you get many useful options. Explore and find out.
    The Show Heading levels option is very useful for reading complex documents. Just show level 1 first and then drill down into the desired area quickly.

image

Sample file for practice

This file contains styles and TOC Download Style Document

Automatic Table of Contents

Now that word knows your topics and it anyway knows the page numbers, it can put these together and create a TOC automatically.

Go to the place in the beginning of the document where you want to create the TOC and Choose References tab and choose Automatic Table of Contents

Automatic table of contents

By default three levels of headings are added to the TOC along with page numbers. You can change the settings from the Custom Table of Contents option.

Remember to update the table before printing because the page numbers are not automatically updated when you edit the document. Right click on the TOC and choose Update Field or click inside the TOC and choose Update Table option.

Choose the second option.

Update table of contents

For very large and complex documents you can choose the first option (which is faster) when you are sure that you have not added any new headings. In most cases using the second option is safer.

Retrofitting styles into non-style documents

You will love Styles once you start using them. But then you will feel very sad that your older documents are not getting all these benefits of styles. But don’t lose heart. Microsoft has thought of that as well.

Open a document which is using manual formatting. You need to find all areas where manual formatting indicates various levels of headings and then apply the correct Heading Style. But this is going to be very time consuming if you want to do it one by one. Repetition means inefficiency.

Solution: Select text with similar formatting

  1. Click in one of the manually formatting heading. Choose Home tab – Select dropdown – Select text with similar formatting

Select text with similar formatting
Don’t worry if it shows (No Data). It works anyway.

  • Now Word finds and selects similar headings. You just have to apply Heading 1 once
  • If you have three levels of headings, you will have to do this thrice. Absolutely worth it because now you get all the benefits of Styles

Next article

Styles have many more benefits. One very useful feature is the ability to convert a Word document to a presentation. I will cover that in the next article.

Top 3 Efficiency Habits: Use Word Styles, Excel Tables and PowerPoint SmartArt

Office has thousands of features. And contrary to popular belief, all of them are useful to everyone under certain circumstances. Learning these things is not complex but time consuming.

My approach is to help you learn these things in a simple and intuitive manner. In future articles I will show you some easy methods of learning Office while you work.

But let us start with three very important things you must know.

No negotiation. No option. Absolutely Mandatory. Trust me on this!

Word Styles, Excel Tables and PowerPoint SmartArt.

I would like to know if you already use these features. Please vote. Just three clicks!

Word Styles

Problem

We spend too much time on formatting and too little on the core content.

Solution: Let Word handle the formatting

Don’t do formatting manually. Word is better than you. That is why it is called a word-processor. Let Word handle the formatting.

Most common formatting is to show titles and subtitles in a document. Word has already created formatting for up to 9 levels of topics (headings). Just use it.

How? By choosing the appropriate style.

Styles are just ready to use formatting which is created by graphics experts. There are 9 styles – Heading 1 to Heading 9

While creating a document, you know which of the paragraphs are Headings or Topics or Titles. As soon as you type the paragraph, choose the style.

word styles, excel tables and powerpoint smartart

Main topics get H1, sub topics get H2 and so on.

How to select styles quickly

  1. Click the style in the Home tab – Styles drop down (it is called a Gallery).
  2. Or use keyboard shortcuts CTRL ALT 1 for H1 CTRL ALT 2 for H2 and
    CTRL ALT 3 for H3
  3. Or use the shortcut Shift Alt Up arrow to apply Higher styles, Shift Alt Down arrow to apply lower styles

Benefits

  1. Automatic table of contents
  2. Live navigation pane
  3. Ability to create PowerPoint presentation automatically
  4. Automatic numbering
  5. Ability to rearrange the document by just drag drop of headings
  6. Expand / Collapse headings to make long documents easier to manage (2013 only)
  7. and many more

We will cover these benefits in the upcoming articles.

Excel Tables

Problem

Excel is a very dangerous piece of software. We use complex Excel files to take critical decisions – personally as well as at organizational level.

All of us know that Excel contains two primary things. Data and Formulas (Charts are visual formulas, Pivot Tables are automated formulas)

When you add a formula Excel calculates the results. Usually we do not cross check the results for every formula. Which is very dangerous.

Why? Because, when you add more data, you must update all the related formulas. Often we forget to do that. Due to this, the formulas may be outdated but you or others may not notice that. If you trust a formula which is showing outdated results, your decisions will be wrong.

Solution? Excel Tables

I will explain it in the upcoming articles. But to cut a long story short, Excel tables automate the process of updating formulas when you add more data.

If there is an outdated result, Excel shows an error marker (Green mark on top left corner). Unfortunately, most people in the world have never bothered to find out the meaning of that poor little green mark. We simply ignore it and take the risk of looking at wrong information.

Excel tables

Benefits

  1. The primary benefit is auto-update of formulas and references
  2. Automatic formatting of tabular data
  3. Automatic copying of calculated column formulas
  4. Automatic copying of calculations when more data is added
  5. Automatic display of headings
  6. Automatic copying of formatting, conditional formatting and validations
  7. Ability to use Table and Column names in formulas
  8. Ability to integrate with SharePoint and Visio

PowerPoint SmartArt

The purpose of PowerPoint is to present your case to the audience to achieve the desired impact. The impact could be sales, training, convincing, debating, explaining, and so on.

Problem

Most presentations are boring and uninteresting. If your audience loses interest in what you are showing or if they cannot understand it clearly, your objective will not be achieved.

There are thousands of ways of making better presentations. But one of them stands out.

Solution: SmartArt

That is called SmartArt. It is a very quick way of converting text (bullets) to appealing and high-impact visuals (diagrams). PowerPoint offers around 130 diagrams – intelligently created to help us depict various type of information (Lists, Processes, Hierarchy, Relationships and so on).

Creating a SmartArt Diagram is very easy. But choosing the right one in the right place does take some amount of practice.

SmartArt

Benefits

  1. Easy to create visually appealing diagrams
  2. Automatic formatting and resizing
  3. Eliminates the need for manual alignment, formatting and animation
  4. Automatic diagram creation from multiple pictures of different sizes

PowerPoint SmartArts

We will cover SmartArt in detail in upcoming articles.

Weekend Activity: Propose with PowerPoint

Speak from your heart. Create this amazing graphic in few minutes and impress your beloved!

The output

image

The text is transparent. So you can put some background animation and it will show through the text.

How to do it?

Watch this 2.5 minute video to find out how easy it is.

It uses a new feature (PowerPoint 2013) where you can use two objects (shapes or text) and subtract one from another.

View this in YouTube with 480 p resolution in full screen mode to see menu selections and actions with greater clarity.

Heart inscribed with text

How to enhance it further?

Add some animated background behind it and the impact is amplified thousand times!

Here is a sample for you to download and learn from.

See what you can achieve in just 109 kb of presentation! Download

propose with Powerpoint

Outlook Tasks: Take an appointment with yourself

Please read the previous article before you read this one.

Remember. Your work is higher priority than work with others want you to do.

Where is your pending work listed?

Usually scattered across multiple locations : Mind, Notepads, Tissue papers, Mobile notes, mails, minutes of meetings, etc.

That is not a good idea because you can’t see all the pending work in one place. If you don’t see something you don’t end up doing it.

Step 1: Create Outlook Tasks

Go back to your core job description or KRAs or organizational commitments sheet – whatever you have signed up for. Take each item from there and break it down into smaller pieces of work and add them to tasks. Using color categories mark them as Core work.

Outlook Tasks

Think of all the other pending tasks and add the to task folder as well.

Anything in this color is additional information and optional reading. You can move to the black area ahead without losing context.

Common mistake: Adding work to Calendar

Calendar and Task are two different things. If you are blocking specific time for whatever reason, put it in the calendar.

Work is different. We decide What to do and When it should be completed (the deadline). However, we don’t specify when exactly it will be done. That is called a TASK.

Calendar is for meetings, events, leave , seminars, off-sites, fieldwork, training programs, etc. Here we block time to say EXACTLY WHEN something is going to happen. If it does not happen, it may be rescheduled but that is not very important.

Step 2: Block YOUR time to do YOUR work

This is a genuine problem. We simply don’t have time to handle all the mails, attend all meetings and handle all tasks. But now that we know that tasks are the priority, we must focus on them.

If others see that your calendar is free, they are bound to send meeting requests. So before that happens, make sure that you block your time for your work.

  1. Open the calendar. Better to be in the Work Week View
  2. Right click on Tasks folder and choose Open in New Window
  3. Make the tasks window smaller so that you can float it above the calendar window and see both
  4. Look a the tasks. Choose which ones are important
  5. Decide which date and time you want to do that work
  6. Drag the task and drop it on that date
  7. Adjust the time based upon your estimate of how long the task will require

Now think what you just did.

Remember, dragging the task to calendar is just a convenience. It DOES NOT mark the task as complete. When you finish the task, you must go and mark it as complete in the task folder.

“I took an appointment with myself to do my own work” = Time Management

Sounds funny. But this is the simplest form of time management.

Homework

Start creating the task list and drag the tasks to calendar to block time. Start it immediately.

Creating tasks is your first task Smile

Next article

In the next article we will understand how you can refine your work in Outlook using custom fields.