Wednesday, November 10th, 2010

Microsoft Office columns at SmallBusinessComputing.com

Microsoft Office How to articles smallbusinesscomputing Microsoft Office columns at SmallBusinessComputing.com

I work for some totally cool people and organizations. One of them is SmallBusinessComputing.com. I write a lot of pragmatic Office columns for the site – I love getting down to the tools you most need to use every day and where you can make get the most time saved.

Well my editor loves my stuff so she has created a How To with Helen Bradley page which includes links to all my columns. You can either head over there and browse to find what you want, or read on – I’ve grabbed all the things there and the links to make it super simple for you to read any of the articles on the site. The first link to Time Saving tips for better letters in Word got picked up by one of the NYTimes business blogs:

5 Time-Saving Tips for Better Letters in Microsoft Word

[October 26, 2010] Does your small business software work as hard as you do? Helen Bradley offers five Microsoft Word tips to save you time and help you write great business letters.

Small Business Software: Microsoft Word 2010

[October 21, 2010] Microsoft Office 2010 is packed with changes and cool new features that can help any small business. Let our tour guide show you what’s different so you can make the most of this small business software staple.

How to Make a Small Business Website Banner

[September 20, 2010] Simple touches can make your small business Web design stand out. Helen Bradley explains how to create a great-looking collage banner for your small business website.

Small Business Solution: Manage Your Money in Excel

[August 23, 2010] Helen Bradley explains how any SMB can project and track cash flow with a budget in Excel.

5 Image-Editing Tips to Improve Any Photo

[July 20, 2010] Helen Bradley shows you five ways to make your small business website photos look better using Photoshop or Photoshop Elements.

MS Office Live Brings Small Business Computing Online

[June 21, 2010] Helen Bradley explains how you can leverage your small business software using Microsoft Office Live Workspaces and SkyDrive.

Microsoft Small Business Software: OneNote

[May 20, 2010] Helen Bradley introduces Microsoft’s note-taking and research tool (not to mention unsung hero), OneNote 2003.

Small Business Software: Survey Forms in Word 2007

[April 28, 2010] Surveys are a great way to find out what your customers are thinking. This Word 2007 tutorial will teach you how to create your own survey forms, plus it offers a few tips on writing better surveys.

Customer Databases as Marketing Tools

[April 21, 2010] A strong customer database is a valuable asset and a great small business marketing tool. Are you making the most of yours?

Small Business Software: 7 Tips for Excel Charts

[April 8, 2010] Use small business technology to your advantage. These seven handy Excel charting features make the data in your charts easier to read and comprehend.

Small Business Marketing: How to Create a Web Site

[March 22, 2010] A Web site is one of the most essential Internet marketing tools for a small business. Helen Bradley explains the basics of creating a Web site without spending a fortune.

Multimedia How-To: Producer for PowerPoint 2007

[March 8, 2010] Need a creative boost to your small business marketing materials? Helen Bradley shows how to add multimedia to your presentations with Producer for PowerPoint 2007.

E-mail Marketing: Create a Newsletter in Publisher

[February 19, 2010] Give your small business marketing a boost by making your own custom e-mail newsletter. Helen Bradley shows how easy it is to do in Microsoft Publisher 2003.

How To Make Image Maps in PowerPoint 2003

[January 4, 2010] Helen Bradley explains how to create clickable hotspots, or image maps, that simplify navigating a PowerPoint presentation.

Find Info Fast: How to Create an Index in MS Word

[December 17, 2009] Helen Bradley walks you through Word 2007’s built-in indexing tool and shows how to make document indexes — by hand or automatically.

PowerPoint 2003: How to Animate a Slide Background

[December 10, 2009] Helen Bradley explains how to create a moving picture background that, when used sparingly, makes a more compelling PowerPoint slideshow.

Web Site Design: Simplify with CSS

[November 23, 2009] Whether you’re redesigning your Web site or starting from scratch, consider using CSS — it’ll make future style changes much easier down the road.

Microsoft Tips: How to Make Signs in Word

[November 4, 2009] Ready for do it yourself signage? Our Microsoft tips guru explains the basics of creating professional, functional signs in Word.

Good Web Design Turns Visitors Into Customers

[November 3, 2009] A consistent Web design not only makes visitors more comfortable on your site, it increases your chances of converting them into customers.

How-To: Make a Feedback Quiz in PowerPoint

[October 9, 2009] Helen Bradley shows how you can gather information from someone while they view a Microsoft PowerPoint 2007 presentation.

How to Create Lists in Microsoft Word

[October 8, 2009] Helen Bradley walks you through the steps to create and customize bulleted and numbered lists in Word 2003.

How to Make Charts in Microsoft Access

[September 28, 2009] Helen Bradley explains how you can chart your data without ever leaving Microsoft Access.

Create Custom Functions in Excel 2007

[September 2, 2009] Helen Bradley shows how custom Excel functions save time and effort and how you can use your custom functions in all your workbooks.

How To Design Brochures in Microsoft Publisher

[August 26, 2009] Helen Bradley shares design tips to create great-looking brochures in Microsoft Publisher.

Microsoft Excel: Design Error-Free Worksheets

[July 29, 2009] Helen Bradley looks at simple ways to avoid introducing errors in Excel worksheets.

How To: No-Hands PowerPoint 2007 Presentations

[July 1, 2009] Helen Bradley walks you through building a PowerPoint slide show that can run automatically – a handy promotional tool to use at events or in reception areas.

Working with Word 2003: Add a Professional Look

[May 28, 2009] Helen Bradley shows you how to add finishing touches that make Word documents look polished and professional.

Word 2007: Working with Numbered Elements

[May 15, 2009] Helen Bradley shows how to create duplicate and sequential numbering in Microsoft Word 2007.

How to Create Custom Formatting in Excel

[February 17, 2009] Helen Bradley demonstrates Excel formatting tricks that will help you when things don’t work as planned.

Microsoft Excel 2007: Outlining Worksheets

[February 10, 2009] We show you how to summarize important data in your Excel 2007 worksheets and reduce the data to more manageable levels with the ultra-efficient outline tool.

How To Make Templates in Microsoft Word 2003

[January 27, 2009] Helen Bradley shows you how to create Word document templates to quick start your day-to-day tasks.

How to Use Teamwork Tools in Microsoft Word 2007

[January 7, 2009] When working on documents with other people, tracking changes has the potential to save time and help keep others well informed and on the same page.

Excel 101: Create Worksheets and Charts

[December 19, 2008] Helen Bradley introduces the basics of creating a worksheet and chart in Microsoft Excel.

Link or Embed: How To Add an Excel Chart to a Word Doc

[December 1, 2008] Microsoft maven Helen Bradley explains how to place an object from one Office application inside of another.

Microsoft Access: Customize Forms and Reports

[November 10, 2008] Our Microsoft application guru Helen Bradley explains how to make Access database forms and reports more functional and attractive.

Create a Web Site in Publisher 2003

[September 18, 2008] Helen Bradley shows how to use Microsoft Publisher to build a basic Web site for your business. Bonus: you can use the same design set for your Web site that you use for your print marketing materials.

Basic Formatting in Microsoft Word

[August 28, 2008] Our resident document diva, Helen Bradley takes us on a tour of the rudimentary, but essential, formatting features in Word 2003.

Create Custom Headers and Footers in Word 2007

[August 13, 2008] Tapping into the new document properties and content controls in Word 2007 generates some very sharp-looking professional building blocks.

Create Marketing Materials in Publisher

[August 4, 2008] Our designing diva, Helen Bradley shows you how to create your own sharp, professional marketing materials using Microsoft Publisher.

How-To: Animate Microsoft PowerPoint Presentations

[July 30, 2008] Our application expert Helen Bradley explains ways you can add animation effects to your slide shows.

Office 2007: Keep Excel Data Visible At All Times

[July 3, 2008] With a little imagination and skill you can work on one part of a spreadsheet and see data in other areas at the same time.

Microsoft Word: Working with Field Codes

[June 24, 2008] We look at ways to harness the power of Word Field codes to automate and simplify document production.

Discovering Dashboards in Excel 2007

[June 6, 2008] We step through the process of creating a Dashboard chart and data display in Excel 2007 for more efficient analysis of and quick access to your critical information.

Access 2003: Extracting Data Through Queries

[May 22, 2008] You’ve put in the time and effort to build and populate a database — now what? We take a look at the ways to create queries to find pearls of business wisdom. Plus: watch the video.

Microsoft Word Tips: AutoCorrect and AutoText

[March 10, 2008] Don’t get caught up in repetitive typing and correcting common typos. The AutoCorrect and AutoText tools in Word can help you to increase your efficiency and speed up your day.

Exploring Office 2007: Error-Free Worksheets in Excel 2007

[February 19, 2008] It’s critical to understand the problems that might occur in your Excel worksheets. In this article, we’ll show you how to keep them as error-free as possible.

PowerPoint Tips: Slide and Title Masters

[February 14, 2008] Mastering the art of PowerPoint masters will save you time, repetition and a whole lot of aggravation.

Hand-Drawn Charts in PowerPoint 2007

[January 24, 2008] We take a look at handy new features in PowerPoint 2007 that let you create attractive hand-drawn charts to give a visual boost to your presentations while still getting your message across to your audience.

Build Your First Database with Access

[January 14, 2008] Creating a database in Access can be a bit daunting for the uninitiated. We’ll walk you through how to build your own, plus a report and a query, too.

Exploring Office 2007: Quick and Efficient Data Entry in Excel

[January 4, 2008] There are many times in Excel when you find yourself entering the same data over and over again. In many cases, you can spare your fingers the work of typing and fast-track repetitive data entry. As the latest article in our Exploring Office 2007 series shows, it’s all about working smarter and more effectively.

Exploring Office 2007: Collaboration in Word 2007

[December 11, 2007] Microsoft Word 2007 is a great editing tool to use when you’re working with others on a project. We explore the features in Word 2007 that allow you to manage workgroup changes and contributions to documents.

Working with Action Buttons in PowerPoint 2003

[December 6, 2007] Action buttons let you navigate quickly through a PowerPoint presentation, add sounds or any number of other interactive effects. We’ll show you how easy it is to do.

Working with Images in Word

[November 20, 2007] They say a picture’s worth a thousand words, but wait ’til you see what Word can do with that picture. We take a look at the application’s image tools and how using them lets you add pop to any document.

Working with Tables in Word 2003

[October 22, 2007] Tables let you organize information in a concise, visual way, but working with them in Word can be a bit tricky. We’ll take a look at some of the tools and show you how to make the most of Tables.

Take the Guesswork Out of Printing in Excel 2007

[October 1, 2007] With a little pre-planning and some knowledge of the print options that can be configured to your advantage in Excel, you can turn your next Excel print job from an exercise in frustration to an effortlessly simple and successful procedure.

Learning About Lists in Excel

[September 11, 2007] Excel offers a simple way to manage lists of data without resorting to the complexity of a database. We show you how it works in both Excel 2003 and 2007.

MS Office 2007: Applying and Customizing Themes

[August 24, 2007] One of the new features in Microsoft Office 2007 that has everyone talking is Themes. Discover how this new feature can improve your everyday productivity and efficiency while helping you create attractive, professional-looking documents and presentations with minimal effort.

Analyzing with Excel

[August 23, 2007] Excel makes comparing business decisions a bit easier with its Scenario Manager tool. We take a look at how you can use the spreadsheet to set up different scenarios whether it’s comparing products or budget numbers.

Exploring Office 2007: Top Ten Excel Chart Tips

[August 2, 2007] Excel charts have been given a makeover in Excel 2007 and the Chart Wizard of earlier versions is now gone. Our Exploring Office 2007 series continues with a list of the top tips for creating functional and attractive charts in the new Excel 2007 release.

Three Must-Know Excel Tools

[July 25, 2007] Excel jockeys saddle up. We take a look at how using Reports, Views and Outlining saves you time and simplifies your spreadsheets.

Exploring Office 2007: PowerPoint 2007 Tips and Tricks

[July 3, 2007] PowerPoint 2007 delivers a wealth of new features and enhancements that make it easier to create attractive, professional-looking presentations. Our Exploring Office 2007 series continues with a list of the top tips for getting the most out of the new PowerPoint 2007 release.

Exploring Office 2007: Outlook 2007 Tips and Tricks

[June 15, 2007] While Outlook 2007 may look a lot like older releases, there’s a great deal to like about the upgrade and plenty of new tools to help you be more productive. Our Exploring Office 2007 series continues with a list of ten top tips for using Outlook 2007.

Word Mail Merge: It’s not Just for Letters

[June 11, 2007] Microsoft Word can merge more than just mail. Use the popular app’s mail-merge feature for create lists, nametags and even catalogs with images. We’ll show you how.

Exploring Office 2007: Using SmartArt Graphics

[May 22, 2007] Office 2007 delivers an abundance of new features and enhancements, many of which aren’t exactly obvious at first glance. The first article in our new Exploring Office 2007 series takes a closer look at working with the SmartArt tool to easily create everything from simple diagrams to cutting-edge business graphics.

Take Your Excel Charts Beyond the Basics: Five Cool Tips

[May 3, 2007] Add some life to your spreadsheets and make your data easier to understand. These five tips can make Excel charts sing.

Thursday, September 16th, 2010

Borrowing PowerPoint Image Designs

PowerPoint borrow picture layouts Borrowing PowerPoint Image Designs

This stickytape image border comes from the Solstice Theme and here I’ve added it as a new layout in my Oriel Theme.

I saw a recent post on a blog which referred to one of my earlier posts about creating torn edge image effects in PowerPoint 2007. You can see my original post here: http://www.projectwoman.com/2007/03/powerpoint-2007-torn-photo-edges.html.

Someone who responded to the post asked if there was a way of using the photo edges from a theme but not the theme itself. Their problem was they loved the edges but because their organization had a custom theme that was always used, the person wasn’t allowed to change it. The question got me thinking about a solution and here it is!

To use an image design from a PowerPoint theme first create a new file by choosing File > New > Blank Presentation and then choose the New Slide > Picture with Caption Layout – this is the layout typically used to apply fancy styles to images.

Click on the image locator and add an image to the slide – it doesn’t matter what image you add – you just need something so you can see how the image design looks.

Now go to the Design tab and arrow over each of the Themes in turn to see what the image layout looks like. For example, Solstice has a sticky tape edge to the image, Pushpin adds the image with a pushpin background and Opulent has a layered frame look. Flow has a bent corner on the image, Couture has an interesting beveled edge and Summer has a series of illustrative dots around the image. You may find other interesting designs in other Themes such as those that you download from Office Online.

Select the Theme that has the look you want to borrow.

Now choose View > Slide Master and locate the Picture with Caption Layout. Drag over the elements that create the look that you want such as the Pushpin and frame, the sticky tape frame or the circles. Make sure to include the image placeholder. Right click the selected elements and choose Copy.

Now open a file that uses your corporate Theme – or the Theme you prefer to use. Choose View > Slide Master and locate the Picture with Caption Layout slide layout. Right click it and choose Duplicate layout.

Click the image placeholder on this duplicate layout and delete it. Right click on the layout and choose Paste to paste the elements that you copied from the other layout. Move the design elements into a new position, if desired.

You can now adjust the text and title boxes on the layout so that they don’t encroach over the elements that you’ve just added to the design.

When you’re done, click Close Master View.

To save the Theme with the new Layout, from the Design tab open the Themes dropdown palette and choose Save Current Theme and save it.

In future you can use this Theme for your slideshows and to use the layout you created select it from the Layout list where it appears with all the other layouts from the original theme.

Monday, July 19th, 2010

Format Hyperlinks in PowerPoint 2010

PowerPoint format hyperlinks Format Hyperlinks in PowerPoint 2010If you’ve added an email link or a website URL to a PowerPoint slide, you’ll know that PowerPoint 2007 and PowerPoint 2010 automatically format the hyperlinks for you.

Because PowerPoint doesn’t use styles, it’s not obvious exactly how the formatting gets applied and how you control it.

The first thing to know is that you simply can’t control the underlining, it’s there and it’s there to stay. You can, however, change the colors used.

Click the Design tab > Colors > Create New Theme Colors, locate the Hyperlink color and change it to something different if desired. To control the Followed Hyperlink color, select that option and change it.

You now need to save your changes as a custom color scheme, so type a name for your color scheme and click Save.

Now the chosen hyperlink color and followed hyperlink color will be used to format the hyperlinks in your PowerPoint presentation.

Thursday, July 1st, 2010

Don’t spell check this – Word 2010

Word no poofing Dont spell check this   Word 2010

I write a lot of code in Word documents, Excel spreadsheets and in PowerPoint slide shows. I’m not totally unusual in including macros in my files as well as detailing the macro code within the various documents.

However, as you can imagine, Office applications spit the dummy when they see code and everything gets squiggly lines under it. Which makes your documents look horrible when anyone who has Spell Check as you type enabled opens one of these documents.

In Word 2003, 2007 & 2010 I can stop proofing by selecting the code, double click on the proofing language in the program Status bar and reselect the language to use and click Do not check spelling or grammar. For some reason if you don’t reselect your language in Word 2007 and 2010 the Do not check spelling or grammar option isn’t applied – go figure. It took me a while to work this one out.

In PowerPoint 2010 and 2007 just choose Do  not check spelling and it works fine. In PowerPoint 2003 where I spent this morning, there’s actually a language entry for No Proofing.. so select that and your text won’t be spell checked.

Thursday, December 4th, 2008

Yes Master…

pp minimizer 768817 Yes Master...
I love it when folks call me or email to pose questions. It’s hard when you work with apps every day to remember there are folk out there for whom Word and Excel are a daily challenge and not necessarily in a good way.

Today’s came from my partner, a PowerPoint file with a serious case of bloat. Now, if it were a cow, you’d do something rather disgusting with a knife between the ribs – no it doesn’t kill them, it cures them – lets all the nasty gasses out. In PowerPoint, the solutions are different. One cause in this file was the lack of use of a Slide Master. You see the person (not my partner, she’s better at PP than that) put a wonderful but very large image on all the slides – each one had its own version of the image – instant bloat.

The solution, next time would be to build the file properly and put that image on the background layer of the Slide Master – when you do this it automatically gets added to all slides – if you have 100 slides you still have only one image – instant slimming for your file.

If you need a plain slide – no image, you create two masters – one with an image and one without – use the master you need for the slide you’re creating. Pretty easy stuff and makes a presentation much easier to email – that was the problem here – at 7Mb it was too big for most folk’s email inbox so it bounced right back and something that big doesn’t bounce so much as go splat!

The solution I used on this file was different. I didn’t want to go rebuild someone else’s file at no charge – so I grabbed a great app called PowerPoint Minimizer – it shrinks PP files really really small so folks like me can look good by solving a problem that everyone else has spent hours on in a matter of minutes.

Find PowerPoint Minimizer here for download. Best thing is you can trial it and see how it works.

Friday, March 21st, 2008

What’s in a name? Auto_Open or AutoOpen

Sometimes you wonder if the folks up at Redmond are laughing at us behind our backs. Really, do they deliberately set out to confuse us or are they just that plain disorganised?

Today my quandary involves Auto_Open and AutoOpen. These are two special macro names. The first, Auto_Open is Excel’s special named macro that runs automatically when the workbook containing it is opened. AutoOpen is the Word equivalent. It makes no sense that one has an underscore and the other doesn’t – it just makes life for us VBA folk a little more confusing than it should be.

The other macros Auto_Close and AutoClose work the same way, Auto_Close is the Excel macro name – call a macro by this name and save it in your workbook and it will run whenever you close the workbook. In Word, the name is AutoClose.

To add to the confusion, PowerPoint doesn’t support either of the naming conventions, in fact, you can’t create auto running macros in PowerPoint the same way you do in Word and Excel. The workaround is cumbersome, you need to create a PowerPoint add-in that includes the Auto_Open subroutine. Load the Add-in and PowerPoint will run the code in Auto_Open it loads and ditto for subroutine called Auto_close – it runs when the add-in is unloaded – which happens automatically when you exit PowerPoint. Learn more about how to do this in this KnowledgeBase article.

Thanks Redmond, we are now officially confused!

Wednesday, March 12th, 2008

PowerPoint to Go – on your mobile or iPod

You can put a PowerPoint presentation on almost any mobile device including your iPod.

Provided your mobile device supports JPEG format images – most will – open your presentation in PowerPoint and choose File, Save As and select the JPEG format, choose All Slides and PowerPoint will save the slides as JPEG format files that you can now upload to your mobile device as you do any other photos.

If your mobile lets you play images as a slideshow – voila! PowerPoint to go!

Saturday, March 8th, 2008

No new line in PowerPoint

When you are entering text on a PowerPoint slide if you want to create a new line but not apply a bullet to it press Shift + Enter at the end of the preceding line.

This creates a new line but does not start a new paragraph which is the trigger for the bullet to be created.

This also works in Word – you can create a new line in a numbered paragraph but without adding a new number by pressing Shift + Enter.

Monday, April 30th, 2007

PowerPoint – to fit or not – it’s your choice

autofit 779565 PowerPoint   to fit or not   its your choice

PowerPoint has a handy tool (or a very annoying one – depending on your perspective) for adjusting text on a slide.

In PowerPoint 2003 and earlier choose Tools > AutoCorrect Options > Autoformat as you Type and you will see that there is an option called Autofit body text to placeholder. Enabled this and all the text that you type on a slide is automatically sized to fit the slide – you can type gobs of text and it just keeps getting made smaller and smaller as PowerPoint shoehorns it in so it fits.

If you disable this option, you get to control the slide’s text size yourself – a rough rule of thumb is that if it goes over the edge – it’s too much text for one slide so make another one or edit your text.

Autofit is a tool you can disable or enable as you like – once you know it’s there – it’s your choice what you do with it.

Thursday, April 26th, 2007

PowerPoint Master shortcut

master 726484 PowerPoint Master shortcut

If you’re like me and you use the PowerPoint master view a lot—and you really should because it allows you to control the formatting of all the slides in your presentation from one place—you will know that there’s no quick way to open into master view.

That is unless you read this tip.

To quickly access the slide master view hold Shift and click the Slide View button in the bottom left corner of the PowerPoint screen. This automatically opens master view allowing you to work on the slide master then close it and return to your PowerPoint presentation. Simple, when you know how?

Page 1 of 212