Currently viewing the tag: "powerpoint"

Excel is an incredibly useful and powerful tool. To greatly extends its functionality, all we need is just some VBA programming. Below, we have 3 such examples of useful tools built in Excel.

Gantt Chart Generator
This tool allows you to automatically create and format extensive project plans in Gantt Chart format.

Org Chart Generator
This tools allows you to dynamically create very detailed, complex organization charts using in Excel.

Automatic Copy/Paste for Microsoft PowerPoint
This tool allows you to automatically update hundreds of Microsoft PowerPoint slides, charts and tables from Excel in minutes. This tool is incredibly useful for managing large PowerPoint presentations that require frequent updates and formatting changes.

For more examples of sophisticated Excel tools and spreadsheets, have a look here:

I’ve always felt the easiest way to learn VBA programming for Excel is by testing and experimenting with the code of others.  The three Excel documents above are great ones to start with.

Tagged with:
 

Flevy.com just introduced its free PowerPoint Plugin, Flevy Tools.  Flevy Tools provides a set of diagramming tools for PowerPoint.  With just a few clicks, you can create and customize the following types of commonly used consulting diagrams:

  • Approach Diagrams
  • Step Box Diagrams
  • Gantt Charts
  • Harvey Ball Diagrams

The plugin is available in 2 versions: 1) MS PowerPoint 2003  and 2) MS PowerPoint 2007 and later.  You can download the plugin here:

Flevy.com is the marketplace for premium business documents.  Need a document in a hurry?  Browse their marketplace and download what you need to expedite and strengthen your work.  Have documents you’ve created?  List them on the marketplace to start earning passive income for yourself or your company.

Tagged with:
 

Here is a compilation of the free PowerPoint documents we’ve made available through the course of 2011.

Holiday Gift PowerPoint Toolkit
http://learnppt.com/downloads/holiday-gift/
Here is a collection of 20+ PowerPoint diagrams, templates, and charts, originally created as a holiday gift to LearnPPT’s newsletter subscribers.

Process Optimization Presentation
http://learnppt.com/downloads/process-optimization/
This is a process optimization presentation.  It is the accompanying download for this PowerPoint tutorial:
http://powerpointing-templates.com/2011/10/slide-from-scratch-process-optimization-presentation/

Business Strategy Update Presentation
http://learnppt.com/downloads/strategy-update/
This is a presentation showing a business strategy update.  It is the accompanying download for this PowerPoint tutorial:
http://powerpointing-templates.com/2011/09/business-strategy-update-presentation/

Agenda and Transition Slide Template
http://learnppt.com/downloads/agenda-contents/
This is a simple, clean, table-based template used for creating the agenda slide and transition slides.

Cone Diagrams
http://learnppt.com/downloads/cone_diagrams/
This is a set of cone diagrams.  Creating a cone diagram yourself is simple, as illustrated by the accompanying tutorial:
http://powerpointing-templates.com/2011/06/powerpointing-how-to-create-a-cone-diagram/

Decision Tree Template
http://learnppt.com/downloads/decision-tree-powerpoint-template/
This is a fancy looking decision tree diagram/template.  It was created originally for a client slide that was scrapped.  You can modify it to include additional decision points and outcomes.

Diamond Diagram
http://learnppt.com/downloads/diamonds/
This is a set of diamond diagrams of various segments.  It is created using the built-in Radar charts, as illustrated in the accompanying tutorial:
http://powerpointing-templates.com/2011/02/powerpointing-how-to-create-a-diamond-diagram/

Want to add more free PowerPoints to your collection?  Check out our free PowerPoint downloads of 2010 (26 in all last year):
http://powerpointing-templates.com/2010/12/free-powerpoint-downloads-of-2010/

Thanks for reading our blog!

Questions, thoughts, concerns?  Go to my site (learnppt.com) and shoot me an email.

For pre-made PowerPoint diagrams used in business presentations and other powerpointing needs, browse our library here: learnppt.com/powerpoint/.  These diagrams were professionally designed by management consultants. Give your presentations the look and feel of a final product made by McKinsey, BCG, Bain, Booz Allen, Deloitte, or any of the top consulting firms.

One of the easiest diagrams to create is the Cone Diagram. In fact, it’s just the piecing together of 2 shapes: a triangle (for the body) and a circle (for the opening).  Just see below.

To enhance the look of the circular opening, I like to change the background color fill of the circle using a linear gradient.

Similar to the PowerPoint funnel diagram, a cone diagram is a great tool to illustrate a downselection or filtering down process.   Likewise, you can also easily build upon the cone diagram to show added layers and direction of flow.  See the examples below.

You can download all the cone diagrams shown in this PowerPoint tutorial here (http://learnppt.com/downloads/cone_diagrams/).  Enjoy.

You can also download a free PowerPoint plugin called Flevy Tools that creates commonly used consulting diagrams: http://flevy.com/powerpoint-plugin.  Flevy Tools allows you to dynamically generate Gantt Charts, Harvey Ball diagrams, approach diagrams, and other diagrams.  For the time being, it’s a completely free download.

Questions, thoughts, concerns?  Go to my site (learnppt.com) and shoot me an email.

For pre-made PowerPoint templates used in business presentations, browse our library here: learnppt.com/powerpoint/.  These diagrams were professionally designed by management consultants. Give your presentations the look and feel of a final product made by McKinsey, BCG, Bain, Booz Allen, Deloitte, or any of the top consulting firms.

http://powerpointing-templates.com/2010/07/how-to-create-a-funnel-diagram-in-powerpoint/

Through this Sunday, learnPPT is having a promo for the Cost Reduction Toolkit.  This detailed document identifies over 45+ cost cutting initiatives across the Value Chain.  For each initiative, examples are provided, along with projected potential savings.

The Cost Management opportunities are broken down into the areas of:

  • Enterprise-wide - These opportunities are cross-functional, meaning they can affect multiple functions within an organization.  The impact is largely to SG&A costs.
  • Asset Management - These opportunities target the improvement of fixed assets efficiency and decreasing net working capital.  The impact is largely capital efficiency.
  • Function-specific - Opportunities in this category are specific to primary and support functional activities.  These are operational and transactional in nature.

This toolkit also explains the levers and challenges to profitability, as well as the formula identifying cost reduction opportunities.

Here’s a partial preview of the PowerPoint presentation.

Questions, thoughts, concerns?  Go to my site (learnppt.com) and shoot me an email.

For pre-made PowerPoint diagrams used in business presentations and other powerpointing needs, browse our library here: learnppt.com/powerpoint/.  These diagrams were professionally designed by management consultants. Give your presentations the look and feel of a final product made by McKinsey, BCG, Bain, Booz Allen, Deloitte, or any of the top consulting firms.

For a current consulting engagement, we prepared a presentation for the management team to brainstorm various growth strategy options.   To facilitate this discussion, we created a decision tree diagram outlining the key decision points and the most viable options pivoting from each decision point.

I wanted to make this diagram especially intuitive.  So, I embedded an image of a tree with deep roots (that I found off Google Image) as backdrop to the slide.  See below.

To create this backdrop/watermark effect, I used a very simple technique.  After finding an appropriate image, I merely copied it into the slide and placed it behind a large white rectangle.  I then set the transparency of the white rectangle to 20% (under the ‘Format AutoShape’ properties window).  The transparent white box grayed out the image into the background.

If you would like to use this decision tree diagram in your business presentation, I’ve made it available for download here: Decision Tree PowerPoint template.  I realize I make a lot of one-time throw-away slides.  Might as well make them available for download on this site, right? :)

By the way, you can download a free PowerPoint plugin called Flevy Tools that creates commonly used consulting diagrams here: http://flevy.com/powerpoint-plugin.  Flevy Tools allows you to dynamically generate Gantt Charts, Harvey Ball diagrams, approach diagrams, and other diagrams.  For the time being, it’s a completely free download.

Questions, thoughts, concerns?  Go to my site (learnppt.com) and shoot me an email.

For pre-made PowerPoint diagrams used in business presentations and other powerpointing needs, browse our library here: learnppt.com/powerpoint/.  These diagrams were professionally designed by management consultants. Give your presentations the look and feel of a final product made by McKinsey, BCG, Bain, Booz Allen, Deloitte, or any of the top consulting firms.

A diamond diagram or a segment diagram is a very useful and flexible diagram.  You can use them to illustrate anything that has multiple contributing components.  The powerpointing technique taught in this tutorial is a great one to have in your growing PowerPoint diagramming skill set.

Here are some examples of situations that can be intuitively portrayed using diamond diagrams:

  • Multi-departmental collaboration – Product X’s product launch requires input from Product Development, Marketing, Sales, and Partners
  • Multi-pronged sales strategy – Product X’s go-to-market strategy includes Selling to China, Moving from SMB to Enterprise, Cross-selling with Product Y, Attacking the Financial Vertical, and Attacking the Healthcare Vertical
  • A product’s value proposition – Product X’s value proposition includes Water Conservation, Energy Savings, Durability, Compact Size, and Time Savings.

Now, there’s an incredibly easy way to create a Diamond Diagram in PowerPoint!

First, create a chart in PowerPoint and change the ‘Chart Type’ to ‘Radar Chart.’


Next, modify the chart values.  First, only leave 2 rows of data.  Then, create as many columns as you would like segments.  In our example, we will create a diamond with 5 segments.  For the first row, set all the values to 1.  For the second, set all the values to 2.  UPDATE – The screenshot below is from PowerPoint 2003.  For PowerPoint 2007 and 2010, the datasheet format is vertical–not horizontal (like you see in the image below). Therefore, you must input your values vertically (i.e. 1s and 2s in the same columns, not rows)


Next, change the line color for both of the data lines to black.  Then, format the chart such that you remove the axis labels and set both the major and minor units to 1.

Your chart should now look like this.  We pretty much have it.


I’m going to do some formatting, including replacing the inner section with a Pentagon AutoShape.

There we have it — a quick and easy powerpointing trick to create a Diamond or Segment Diagram using Radar Charts in PowerPoint.

Here are a couple more Diamond Diagrams with a different number of sides:

You can download the above slides from LearnPPT @ http://learnppt.com/downloads/diamonds/

If you are looking a larger variety of Segment Powerpoint templates, pre-built and ready to use, check out the Relationship, Segment, and Network Diagrams PowerPoint Pack:

http://learnppt.com/powerpoint/13_Relationship%2C-Segment%2C-%26-Network-Diagrams.php

Also, you can download a free PowerPoint plugin called Flevy Tools that creates commonly used consulting diagrams here: http://flevy.com/powerpoint-plugin.  Flevy Tools allows you to dynamically generate Gantt Charts, Harvey Ball diagrams, approach diagrams, and other diagrams.  For the time being, it’s a completely free download.

Questions, thoughts, concerns?  Go to my site (learnppt.com) and shoot me an email.

For pre-made PowerPoint diagrams used in business presentations and other powerpointing needs, browse our library here: learnppt.com/powerpoint/.  These diagrams were professionally designed by management consultants. Give your presentations the look and feel of a final product made by McKinsey, BCG, Bain, Booz Allen, Deloitte, or any of the top consulting firms.

A couple more days and we’re done with 2010.  Hope everyone  has had a memorable and successful year.

This year marked the launch of both this blog and its parent PowerPoint resource site, Learn PowerPoint.  This blog post is a recap of all free ppt downloads that have been made available through both of these sources.

Enjoy!

1-19. Free PowerPoint Templates
In 2010, we created 19 PowerPoint templates made available for free downloads.  These have been our most downloaded free PowerPoints and span across a wide array of industries, including medical, technology, and business, to name a few.

Become a PowerPoint Guru book support materials
Become a PowerPoint Guru is a guide around creating effective business presentations using techniques and methodologies developed by consulting firms, like McKinsey, BCG, and Bain.  The focus is very similar to that of this blog, e.g. powerpointing tricks, slide design, PowerPoint chart usages, etc.

  • 21. Download the Basic Toolkit — this is a collection of pre-built, customizable PowerPoint diagrams.  The eBook comes with a much more comprehensive PowerPoint toolkit (which you can preview here).

Miscellaneous PowerPoint Diagrams and PowerPoint Templates
The links below are to pre-built PowerPoints that have largely been created in supported of our blog posts, many from our powerpointing tutorials.

22. Marketing Strategy PowerPoint Templates
Download – http://learnppt.com/downloads/3prongstrategy/
Tutorial – http://powerpointing-templates.com/2010/07/slide-from-scratch-3-prong-marketing-strategy/

23. Funnel Diagrams in PowerPoint
Download – http://learnppt.com/downloads/funnel_diagrams/
Tutorial – http://powerpointing-templates.com/2010/07/how-to-create-a-funnel-diagram-in-powerpoint/

24. Project Charter PowerPoint Template
Download – http://learnppt.com/downloads/project_charter/
Tutorial – http://powerpointing-templates.com/2010/11/the-blueprint-for-projects-success-a-project-charter/

25. PowerPoint Waterfall Chart Diagrams
Download – http://learnppt.com/downloads/waterfallcharts/
Tutorial – http://powerpointing-templates.com/2010/12/powerpointing-how-to-create-a-waterfall-chart-in-powerpoint/

26. Consulting Presentation Framework Template
Download – http://learnppt.com/downloads/sampletemplate/
Tutorial – http://ezinearticles.com/?The-Management-Consulting-Presentation-Framework&id=4423363

Expect more free PowerPoint diagrams and templates to come in 2011.  Thanks for reading!

Questions, thoughts, concerns?  Go to my site (learnppt.com) and shoot me an email.

For pre-made PowerPoint diagrams used in business presentations and other powerpointing needs, browse our library here: learnppt.com/powerpoint/.  These diagrams were professionally designed by management consultants. Give your presentations the look and feel of a final product made by McKinsey, BCG, Bain, Booz Allen, Deloitte, or any of the top consulting firms.

Strategy in business is about winning and so, any successful business needs to have a well defined, executable strategy.  Unsurprisingly, from both sales trends and customer feedback, at learnppt.com, we have found ourselves adding more and more products around this topic of business strategy.

This weekend, I took the time to compile all of our toolkits and frameworks related to business and strategy.  Browse it here:
Business Strategy

Some of the topics discussed you will find include Growth Strategy, Marketing Strategy, and Management Strategy.

Our most recent PowerPoint in this domain teaches you how organizations can inject Creative Thinking into their Strategy Development processes:
Creative Thinking in Strategy Development
This document discusses the 3 enablers to creativity in strategy formulation:

  • Ensuring the right “conditions” are in place
  • Pushing the limits of conventional thinking
  • Leveraging the power of collaborative thinking

Got a request in PowerPoint product of blog post topic?  Leave a comment or shoot me an email.

Cheers!

Read my guest blog post at Kathy Reiffenstein’s blog, “Professionally Speaking…”

A Different Kind of Presentation
http://andnowpresenting.typepad.com/professionally_speaking/2010/12/a-different-kind-of-powerpoint-presentation.html
This article compares 2 types of presentations: the presentation meant as a work product versus the presentation meant to accompany a live speaking event.

Kathy Reiffenstein’s site (And Now Presenting)  and blog (Professionally Speaking…) are great resources for developing the skills needed to be a confident and persuasive speaker.

—–

Questions, thoughts, concerns?  Go to my site (learnppt.com) and shoot me an email.

For pre-made PowerPoint diagrams used in business presentations, browse our library here: learnppt.com/powerpoint/.  These diagrams were professionally designed by management consultants. Give your presentations the look and feel of a final product made by McKinsey, BCG, Bain, Booz Allen, Deloitte, or any of the top consulting firms.